Comments 3Ofek started the conversationMarch 25, 2023 at 1:42pmHello,I'd like to write a code so I'll be able to use woocommerce subscription with amelia.To do so, I need to add package via mysql but when I'm trying to do that I don't see the package in the website.I'm using the table "wp_amelia_packages_to_customers", if I change some data from existing package it works, but not new one.Please help me understand how I can add package with mysql,Thanks. 1,623Marko repliedMarch 27, 2023 at 7:46amHello Ofek, We have forwarded your ticket to our level 2 agents and as soon as we get some feedback from them we will contact you immediately. Kind Regards, Marko Davidovic [email protected] Rate my support Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/ wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables 1,623Marko repliedMarch 28, 2023 at 5:58amHello Ofek,We just got the feedback from our colleagues and they have told us thatIf you are adding an empty package (with no bookings) you need to also insert data into the wp_amelia_payments table. Here is an example of data sent: $params = [ 'customerBookingId' => null, 'packageCustomerId' => 2, 'parentId' => null, 'amount' => 100, 'dateTime' => '2023-04-04 12:30:00', 'status' => 'paid', 'gateway' => 'wc', 'gatewayTitle' => 'Cash on delivery', 'data' => null, 'entity' => 'package', 'created' => '2023-04-04 12:30:00', 'wcOrderId' => 3, ]; If the you are adding a package with bookings, you will also need to add the data into wp_amelia_packages_customers_to_services table.If you have any more questions please open a new separate ticket for each question and we will gladly help you there. We wish you all the best. Have a nice day. Kind Regards, Marko Davidovic [email protected] Rate my support Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/ wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables Sign in to reply ...
Hello,
I'd like to write a code so I'll be able to use woocommerce subscription with amelia.
To do so, I need to add package via mysql but when I'm trying to do that I don't see the package in the website.
I'm using the table "wp_amelia_packages_to_customers", if I change some data from existing package it works, but not new one.
Please help me understand how I can add package with mysql,
Thanks.
Hello Ofek,
We have forwarded your ticket to our level 2 agents and as soon as we get some feedback from them we will contact you immediately.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello Ofek,
We just got the feedback from our colleagues and they have told us that
If you are adding an empty package (with no bookings) you need to also insert data into the wp_amelia_payments table. Here is an example of data sent:
If the you are adding a package with bookings, you will also need to add the data into wp_amelia_packages_customers_to_services table.
If you have any more questions please open a new separate ticket for each question and we will gladly help you there.
We wish you all the best.
Have a nice day.
Kind Regards,
Marko Davidovic [email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, floor plans, choropleth maps, and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables