Maury Markowitz Posted February 7, 2013 Share Posted February 7, 2013 Import is great, but often you want to change only certain fields, say in a product list. And the format is very difficult to get Excel to create. It would be much easier if I could first export a file from Presta, then edit it, then upload it again. So am I missing something, or is there no way to export? Link to comment Share on other sites More sharing options...
parsifal Posted February 8, 2013 Share Posted February 8, 2013 https://www.google.gr/search?q=csv+export+site:prestashop.com Link to comment Share on other sites More sharing options...
Vinum Posted February 8, 2013 Share Posted February 8, 2013 http://addons.prestashop.com/en/export/6253-export-products-for-prestashop-15.html Link to comment Share on other sites More sharing options...
Maury Markowitz Posted February 11, 2013 Author Share Posted February 11, 2013 https://www.google.gr/search?q=csv+export+site:prestashop.com a) broken only does products Presta really needs to be able to export all the same things it can export. It also needs to have about a buzzilion other import types, like prices, attachments, etc. Link to comment Share on other sites More sharing options...
Arnel Posted February 13, 2013 Share Posted February 13, 2013 Hello Maury, Are you looking for ALL product data? Or a set of specfic data. The Add-on definitely handles the export for you (at a cost). Otherwise, this is basically SQL query work, but I'd need to know precisely what you're looking to export to see if there's a quick resolution to your problem. Also, what version of Prestashop are you using? Arnel C. Web Hosting Hub Link to comment Share on other sites More sharing options...
Maury Markowitz Posted February 13, 2013 Author Share Posted February 13, 2013 Are you looking for ALL product data? Or a set of specific data… Also, what version of Prestashop are you using? V.1.5.whatever.is.the.latest My concern is that many of the data items one would want to import are buried in the product upload. For instance, if I want to update pricing on 150 items, I either have to do that manually, or use the product import. It would be much much easier if there was a "price import" feature dedicated to this. Or alternately, if one could leave columns in the product upload blank, I would simply empty out my existing upload and put in just the prices. Sadly this blanks out those fields in Product. So then the worst workable option is to first export the products, change the 150 prices, and re-upload the file. That way you're sure you're working on the latest data, and unless you seriously screw something up, that the formatting is correct. But it seems I can't even do *that* out of the box. What's funny is that writing export code is almost always easier than import code. With imports you have to do sanity checking, exports not so much. Link to comment Share on other sites More sharing options...
Arnel Posted February 14, 2013 Share Posted February 14, 2013 Hello Maury, Thanks for the reply and explanation. Basically, the out-of-the-box solution that you're seeking would update the price for the object for any instance of it in the tables. I'll look and see how difficult it would be to run the query to pull out the data and then present in a CSV or XLS format. And also the re-import. One more question on your issue - I know we have documentation (using MySQL) on a bulk price update where the prices on ALL inventory is increased/reduced by a single percentage/amount that we can provide. Are you trying to do this type of change? Or were you changing individual groups (e.g. groups of 10 or 20 products - not just individual products) of products in your inventory? Regards, Arnel C. Web Hosting Hub Link to comment Share on other sites More sharing options...
Maury Markowitz Posted February 15, 2013 Author Share Posted February 15, 2013 Thanks for the reply and explanation. Basically, the out-of-the-box solution that you're seeking would update the price for the object for any instance of it in the tables. I'll look and see how difficult it would be to run the query to pull out the data and then present in a CSV or XLS format. And also the re-import. Indeed. That's not as good as Presta having a "price upload", but it is workable. One more question on your issue - I know we have documentation (using MySQL) on a bulk price update where the prices on ALL inventory is increased/reduced by a single percentage/amount that we can provide. Are you trying to do this type of change? Or were you changing individual groups (e.g. groups of 10 or 20 products - not just individual products) of products in your inventory? The second of those two cases. What's happening is that one of our suppliers sends us a new price list, with perhaps 30 to 50 products in it. All of these have to be updated at once. Now that might not sound too bad, but what normally happens is that three or four of these come out within a few days of the start of the month… Link to comment Share on other sites More sharing options...
Arnel Posted February 15, 2013 Share Posted February 15, 2013 Okay - thanks for the specifics, Maury! I work with a Web Hosting company where we have been developing a community support team to help on a variety of topics. My team mate and I have been working with PrestaShop as one of the softwares that we provide and support. We develop documentation and share it with whomever. We both participate and look for isues on the forums so that we can both increase our knowledge and help others. At the same time this helps us create a good library for our own customers (and hopefully attract new ones). I'm going to discuss the topic of the selective updates today and we'll see what we can come up with that may help! I'll get back with you soon with an update and hopefully a solution! Regards, Arnel C. Web Hosting Hub Link to comment Share on other sites More sharing options...
Dolke Posted May 6, 2013 Share Posted May 6, 2013 Hi to all, I believe that I have the same issue when it comes to changing some of the fields for lets say products. I have over 2000 products so that is 2000 entries in my product_import CSV file. So first I pull out all necessary data and fill out this import CSV file. Then I import this CSV file into my Prestashop store. So far so good... After a while, I need to import 20 new products, and lets say I need to completely delete 5, then I need to change some description, prices and other stuff on other 200 products. Headache starts. As PS still lacks CSV export tool in 1.5.4.1 which Im using atm, where can I even start with this? OK, I saw someone posted a link to paid solution for the export function and lets say that I bought this module, what then? I will get my products exported in CSV file, and I will make all these changes. Then I will try to upload new file, but Im not sure what can I expect to happen? Will PS handle all these changes as it is suppose to handle? Thanks Dean Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts