You do not need to search the booking in the database you can send all sorts of data to WooCommerce via metadata.
In Amelia/setting/payments, if you scroll down when WooCommerce payment gateway is enabled,
you will see the option to Set MetaData and Description:
Just enter the placeholder for the information that you want to be shown there and that is it.
-
Here is our Test example.
Let's say we have this Custom Field 1, that we labeled "Delivery address".
A customer comes to book, fills this address as something random as "Los Angeles street 1",
and if we put this placeholder for custom field 1 , in the Metadata of WooCommerce, it will appear on the Cart and on the Checkout:
-
As you see, when we hover the mouse over each custom_field placeholder, it will reveal the label of the Custom Field, to make it easier to see which ones we need.
I am trying to archive an old wordpress instance that had amelia. I am exporting data directly from the database so we can shut down the instance. In what table is the metadata stored for orders?
Regarding migrating the Amelia installation there is not one table there around 47 tablesso that you don't lose any data;
The easiest way is to clone your website.
You can do that by using the Duplicator plugin. It will generate a couple of files that you can transfer to the new domain and it will create an exact copy of your website.
The Duplicator plugin can export only up to 500MB of data, so if your site is bigger than that, you can use the All-in-One WP Migration plugin.
- Other than cloning your website, there's a way to migrate only Amelia's database tables.
There are around 47 tables with wp_amelia_ prefix that need to be moved. Please note that wp_ is the default database prefix, but on your end, it could be anything, so look for your_prefix_amelia_ tables.
Besides that, you also need to go to wp_options and search for option_name "amelia_settings" - that returns one row, so you need to copy the option_value and paste it in the same field on the other site.
Note that this contains all info from your old website, so you will need to replace the URLs in this cell.
And uf you need to change the domain on the licence,
the easiest way is to log in the 'old site' WP-Admin, go in our Plugin settings/Activation, hit "deactivate" button on the licence there;
And go in the new website, in the Plugin settings/Activation and just paste the Purchase code there;
It will automatically recognize that your licence is now switched/registered to the new domain.
-
You can also do this through the Store Account.
In our store go to "My Licenses" and click on the "Manage Domains" button:
From there, you will be able to deactivate the old domain (while it's still active), and then simply activate the new domain in wpDataTables settings/Activation, once you move the site.
Hi, I am trying to get some data from the database. How do I tie the booking with the orders made in woocommerce? I don't see an Id I can reference.
Hello there,
Thank you for reaching out to us.
You do not need to search the booking in the database you can send all sorts of data to WooCommerce via metadata.
In Amelia/setting/payments, if you scroll down when WooCommerce payment gateway is enabled,
you will see the option to Set MetaData and Description:
Just enter the placeholder for the information that you want to be shown there and that is it.
-
Here is our Test example.
Let's say we have this Custom Field 1, that we labeled "Delivery address".
A customer comes to book, fills this address as something random as "Los Angeles street 1",
and if we put this placeholder for custom field 1 , in the Metadata of WooCommerce, it will appear on the Cart and on the Checkout:
-
As you see, when we hover the mouse over each custom_field placeholder, it will reveal the label of the Custom Field, to make it easier to see which ones we need.
This should help.
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
Hi Marko,
I am trying to archive an old wordpress instance that had amelia. I am exporting data directly from the database so we can shut down the instance. In what table is the metadata stored for orders?
Hello again,
We will take a look at this now and as soon as we have more information we will contact you again on this ticket.
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 again,
Regarding migrating the Amelia installation there is not one table there around 47 tablesso that you don't lose any data;
The easiest way is to clone your website.
You can do that by using the Duplicator plugin. It will generate a couple of files that you can transfer to the new domain and it will create an exact copy of your website.
The Duplicator plugin can export only up to 500MB of data, so if your site is bigger than that, you can use the All-in-One WP Migration plugin.
- Other than cloning your website, there's a way to migrate only Amelia's database tables.
There are around 47 tables with wp_amelia_ prefix that need to be moved. Please note that wp_ is the default database prefix, but on your end, it could be anything, so look for your_prefix_amelia_ tables.
Besides that, you also need to go to wp_options and search for option_name "amelia_settings" - that returns one row, so you need to copy the option_value and paste it in the same field on the other site.
Note that this contains all info from your old website, so you will need to replace the URLs in this cell.
And uf you need to change the domain on the licence,
the easiest way is to log in the 'old site' WP-Admin, go in our Plugin settings/Activation, hit "deactivate" button on the licence there;
And go in the new website, in the Plugin settings/Activation and just paste the Purchase code there;
It will automatically recognize that your licence is now switched/registered to the new domain.
-
You can also do this through the Store Account.
In our store go to "My Licenses" and click on the "Manage Domains" button:
From there, you will be able to deactivate the old domain (while it's still active), and then simply activate the new domain in wpDataTables settings/Activation, once you move the site.
-
Hope this helps.
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