lipdesign Posted May 31, 2015 Share Posted May 31, 2015 (edited) I was wondering if it is possible to Import an entire category with products, directly from SQL database file, to maybe a csv file or something.. I need this because i wasn`t able to install locally a previous shop that i only have the backup zip files.. its a category with 250 products, images, prices, descriptions, and keywords.. it can save me 2 weeks of hard work doing it all over again.. Thanks for your insights! Edited May 31, 2015 by lipdesign (see edit history) Link to comment Share on other sites More sharing options...
shri Posted June 1, 2015 Share Posted June 1, 2015 The SQL database you are talking about is it having prestashop tables or your custom tables? When you say import categories from a SQL database to a csv, I feel like you want to Export categories from SQL to CSV. Something like this image from my Cpanel myPhpAdmin Link to comment Share on other sites More sharing options...
lipdesign Posted June 1, 2015 Author Share Posted June 1, 2015 yes, that's exactly what i want to do. all i have is the backed up sql file from the previous shop. But my concern is that to make things work, i have to import several tables, am i right? too many ps_tables to do it manually! the tree is as follows: root category, 250 products divided in 10 subcategorys. Is there any "automated" way to do this!? Link to comment Share on other sites More sharing options...
shri Posted June 11, 2015 Share Posted June 11, 2015 (edited) Yes you will have to import tables that are co-related. I have sent you a message for information about the tables that you need. Do check it and tell me if that is what you are looking for. Edited June 11, 2015 by shri (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts