Need a list of essential database tables related to orders, products & customers.

[Masteries]

I'm planning to move dev site to production and I need to update outdated database tables in the dev site. I'm gonna be importing tables one by one in order to avoid any errors instead of merging/moving the whole database. So I need a list of all the essential database tables for products, orders and customers. Does anyone have a comprehensive list for this?

[musicmaster]

Did you have a look at copy_shopdata? 

https://www.prestashop.com/forums/topic/445453-copy-shopdata-script-for-copying-shop-content-for-upgrade/

[NemoPS]

all the ones that start with, after the prefix:

 

address
attribute

category

customer

feature

order

product

Bear in mind images will not carry over. If you need them, copy the image_ ones too

[Masteries]

all the ones that start with, after the prefix:

 

address

attribute

category

customer

feature

order

product

 

Bear in mind images will not carry over. If you need them, copy the image_ ones too

 

Thanks Nemo! That's 68 tables in total (without image_x tables), hopefully that's all of 'em.

 

@musicmaster

 

I'm gonna take a look at the source code in yours as well and see what other potential tables I'm gonna need.

Edited August 16, 2017 by Masteries (see edit history)