zupermanzito Posted November 13, 2013 Share Posted November 13, 2013 I have read that its easier to export all products using myphpadmin, however i dont know which tables or how to do it..Got ideas? Link to comment Share on other sites More sharing options...
ExpressTech Posted November 13, 2013 Share Posted November 13, 2013 I think in order to export products directly from the database, you need to properly understand the database schema first and take the backup then. Also, while importing the products back or in a new shop's database it might mess up the ID numbers etc. Theoretically, quite possible. I will let the moderators answer if they can pin-point the tables which you should back up. Link to comment Share on other sites More sharing options...
tuk66 Posted November 13, 2013 Share Posted November 13, 2013 Basic export example of products with descriptions in one language (change ID number after pl.id_lang according to desired language) SELECT * FROM ps_product p INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang = 1) Link to comment Share on other sites More sharing options...
vekia Posted November 13, 2013 Share Posted November 13, 2013 I have read that its easier to export all products using myphpadmin, however i dont know which tables or how to do it.. Got ideas? what kind of data you want to export exactly? only products? or maybe also associations with categories, maybe also attributes? product images too? attachments? features? attributes? price reductions? it will not be as easy as it seems Link to comment Share on other sites More sharing options...
zupermanzito Posted November 13, 2013 Author Share Posted November 13, 2013 Well i better explain my self.the thing is we have 5 stores, and we want a online store, however the online store have some products arround 44k, while the 5 stores got 34k entries, the interesting thing is that the physical stores get the updates from the new products faster than the online one ( our suppliers dont send CVS for their new products, and if they send that be one year later)so i was thinking, why not check which entries i dont have in my online store, and which entries i dont got in my physical ones. so i have to first export all my catalog from the physical one and all my catalog from the online, then delete the entries that are the same and import/export . Link to comment Share on other sites More sharing options...
vekia Posted November 13, 2013 Share Posted November 13, 2013 ok it's a bit more clear now, but what about attributes? your products have got attributes? maybe also some attachments? all of these informations are very important, because after export and import them in the future, you will lose these features! so it is necessary to export them too. Link to comment Share on other sites More sharing options...
zupermanzito Posted November 14, 2013 Author Share Posted November 14, 2013 no there are no attributes or combinations Link to comment Share on other sites More sharing options...
zupermanzito Posted November 19, 2013 Author Share Posted November 19, 2013 no idea guys? Link to comment Share on other sites More sharing options...
Recommended Posts