MatejL Posted March 25, 2017 Share Posted March 25, 2017 Hello, could any body help me with my problem. I spent my whole day looking for solution but with not success. I have one database from my previus prestashop with all my products and destripcions of products and so on... Now i have new shop and i want to transfer products from previous one to the new one: the name of the products, prices, meta tags,.. and so on. My previous version of Prestashop i think it was 1.6.1.5, now i have 1.6.1.12. What i must to type in sql querry or something other? I don't know. Please help me, Thanks! Link to comment Share on other sites More sharing options...
Mohamadou Ndiaye Posted March 25, 2017 Share Posted March 25, 2017 You want to migrate the whole database or just products and related tables ? Link to comment Share on other sites More sharing options...
MatejL Posted March 25, 2017 Author Share Posted March 25, 2017 (edited) Thanks for your quick response. Only products. Names, descriptions... everything that belong to the product. Edited March 25, 2017 by MatejL (see edit history) Link to comment Share on other sites More sharing options...
Mohamadou Ndiaye Posted March 25, 2017 Share Posted March 25, 2017 Okay to transfer the products, the quick way is to connect to your PhpMyAdmin and make an Export of all products' table. You will have a sql file with all the tables. You have arround 15 tables related to the products. Once the export is done. Go to the PhpMyAdmin of your new database and make an import of the sql file you exported from the old database. And it's done ! Hope this will help you. Link to comment Share on other sites More sharing options...
El Patron Posted March 25, 2017 Share Posted March 25, 2017 We offer service just for this. https://www.prestaheroes.com/en-us/services/marketing/heroic-prestashop-catalog-import-services Mohamadou may have answer as well. 1 Link to comment Share on other sites More sharing options...
MatejL Posted March 25, 2017 Author Share Posted March 25, 2017 I did it like you say. Nov i have all my products but without name, description,... Only prices, id, ean codes,... Any idea? Thanks. Link to comment Share on other sites More sharing options...
Mohamadou Ndiaye Posted March 25, 2017 Share Posted March 25, 2017 For name,description,... you should export product_lang table too. Link to comment Share on other sites More sharing options...
MatejL Posted March 25, 2017 Author Share Posted March 25, 2017 I did. I export all product tabels. But still not working. Link to comment Share on other sites More sharing options...
MatejL Posted March 25, 2017 Author Share Posted March 25, 2017 I see all description in phpmyadmin. But in BO of prestashop don't... Link to comment Share on other sites More sharing options...
MatejL Posted March 25, 2017 Author Share Posted March 25, 2017 I have done it. id_lang was diferent so i change it and it work. Thank you for helping me out! Link to comment Share on other sites More sharing options...
Mohamadou Ndiaye Posted March 25, 2017 Share Posted March 25, 2017 Okay happy to hear that!! You are welcome . If it's fine don't forget to set the subject as Resolve. 3 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