In what files are the orders saved

The orders are not saved as files, there are saved as entries in various tables in the database.

Can you please specify in which tables in the database ?
Thanks in advance.

Orders are a custom post type so they are in the posts table with type shop_order. There is also a CPT called order_refund or similar. Billing etc addresses are in postmeta. Order items are in the order_items table with supplementary info in the order_items_meta table.

Hi lorro, thank for your answers, but i think it would be easier for me to copy all the tables that it shows and can you tell me from those which ones to leave as not checked in my staging tool so it wont delete anything from the orders.

Files:
wp-content/uploads/wpo_wcpdf/attachments/invoice-45.pdf
wp-content/aiowps_backups/.htaccess.backup
wp-content/uploads/wpo_wcpdf/attachments/invoice-41.pdf
.htaccess
wp-content/uploads/wpo_wcpdf/dompdf/log.htm
wp-content/debug.log

Database:
wpdx_usermeta
wpdx_woocommerce_sessions
wpdx_posts
wpdx_rsrecordpoints
wpdx_options
wpdx_woocommerce_order_itemmeta
wpdx_woocommerce_order_items
wpdx_comments
wpdx_wcpdf_invoice_number
wpdx_yoast_seo_meta
wpdx_aiowps_login_activity
wpdx_postmeta
wpdx_users
wpdx_aiowps_failed_logins

Thanks in advance.

All the tables are interconnected with a series of id numbers, so copying some tables and not others or parts of tables is going to be incredibly difficult.

Consider using the plugin All in one migration, or similar, to copy the whole site. 10 minute job. Then go into the copy and delete your test orders from the admin screen.

Hi lorro, probably i didn’t explained my self very well i will try to do that now so if you didn’t understand something pls ask.

I am still working on the website so its not live yet but it will be very soon.
So i have a staging tool in my cPanel from my hosting providers siteground.com.
And i am still adding some products in my store so i want to test it now so when it goes live i wont have problem and here is what i need:
When i add around 100 products it takes me 2-3 days, and i will have even more products in the future so when the website is live and there are people buying i dont want to add or to make categories on the live site because i am adding prices and setting where the categories will appear, and that wouldn’t be ok to take 2-3 days on the live site for some products to appear but they are not finished yet.
So i need some tool like this and i asked my hosting providers and they said thats exactly what the tool is used for:
I need it for example in between those 2-3 days when im adding the products and setting categories and testing the images or anything else, there will be some orders made on the live site, so when i am finished i want to transfer only the changes made for example: i am adding the categories in my header and my sidebar, also i there might be new attributes and variations for my variable products.
So i want to transfer only those changes and to keep my orders on the live site so i wont lose any detail about any order.
Because i will not work with a private card i have a company and everything will go on the company’s transaction and ill need every single detail from every single order and to lose absolutely anything because those are my country’s laws, and im still making contracts with other company’s and i will have a lot more in the future.

Thanks in advance.

With the products, you could do a CSV export from the device site, remove the products that you have already migrated using a spreadsheet, then import the remaining csv into the live site.

Regarding the other features, it sounds like you are looking for an incremental migration plugin which will allow you to choose what you want to migrate. I don’t know of such a plugin. Someone else on here might, or have a look at the plugins directory and codecanyon.net.

However you incrementally migrate, it sounds like a recipe for getting the site mixed up.

After the initial migration to live, I would add new content to the live site. You can use WP tools to keep it hidden until it’s complete and approved.

Hi lorro, thats why i keep pointing to this tool that i have, i talked to my hosting support and they told me that that is exactly what this tool is used for, the only thing i need is some one to tell me the exact database tables (as u said) i need to leave out when it transfer all the changes to the live site.
I might forgot to explain how this tool works:
It has a button – push to live site and when u click it u have 2 options easy push and advance push, when you click advance push it compares the live site and the staging site and tells you all the files and databases that there is difference in them from the staging and live site and all i need is for someone to tell me the exact database tables to leave out when i click on the push to live to not change the orders in the live site because on the staging site there were not any orders.

I will leave a link from the staging tool if it makes it more clear or if there is something i dont understand sorry.

https://www.siteground.com/tutorials/staging/

Thanks in advance.

Hi guys, is there any update on this ?

I’m not familiar with the software that you describe. As I said, all the WordPress tables are connected by ID numbers, so moving content will not be as simple as moving tables, the record iD numbers would need to be reconfigured. I can’t see an incremental migration working by just copying the tables.

Hi there,

We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.