Viral.w3nuts Posted June 7, 2017 Share Posted June 7, 2017 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 More sharing options...
NemoPS Posted June 7, 2017 Share Posted June 7, 2017 What was the previous version, and what is the new one? Link to comment Share on other sites More sharing options...
Viral.w3nuts Posted June 7, 2017 Author Share Posted June 7, 2017 Thank you for your reply. Both are same prestashop version 1.6.1.12 I have old website database and images with me. So if i know exact table name then I can update images path before coping them to new site. Link to comment Share on other sites More sharing options...
musicmaster Posted June 7, 2017 Share Posted June 7, 2017 (edited) 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 June 7, 2017 by musicmaster (see edit history) Link to comment Share on other sites More sharing options...
Viral.w3nuts Posted June 8, 2017 Author Share Posted June 8, 2017 Hi musicmaster thanks for your reply.I've gone through your PDF and I'm considering to do that that if coping database table donot work. I'll try with database table you have mention. If all goes well then I'll update you here. thanks again. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now