Jump to content

How to copy product related information from old prestashop database to New Prestashop database ?


Recommended Posts

Hi everybody.

I need help to copy product database tables ( Not whole database. )

I've one old Prestashop website database and I have created new Prestashop website.
I want to copy all products related information from old site database to new site database.

 

Basically I want to copy mysql database tables from Old site database to New site database.

But I donot have idea which tables should I copy. 

I need all product related information such as [[ Products, product images, Category, Manufacturing  etc. ]] 

 

Can anyone help me for this plz.

 

 

 

 

Link to comment
Share on other sites

ps_attribute*, ps_category*, ps_feature*, ps_image*, ps_manufacturer*, ps_product*, ps_stock_available

 

And that assumes that you have no discounts or other specific prices, no product specific carriers,don't use suppliers,  no ASM or warehousing and that the ps_shop* tables are already correct. It also assumes that the language id's in both shops are the same.

 

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

Edited by musicmaster (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...