avionicom Posted May 22, 2014 Share Posted May 22, 2014 I'd like to import a CSV file to update actual quantities in product combinations. The problem is that in this case I've to provide also required fields that are not necessary (attibute, values). For quantity updates is only necessary Product ID, Reference and Quantity. Do you know a workaround or a solution for it? Link to comment Share on other sites More sharing options...
avionicom Posted May 23, 2014 Author Share Posted May 23, 2014 Noone with the same problem? Link to comment Share on other sites More sharing options...
mickeyboy1 Posted May 23, 2014 Share Posted May 23, 2014 Wouldnt it be easier to write a sql statement ? Link to comment Share on other sites More sharing options...
avionicom Posted May 24, 2014 Author Share Posted May 24, 2014 Yes, you're right. How to create a PHP script to connect with MySQL DB considering the Combination Reference as a unique key? Link to comment Share on other sites More sharing options...
Iryna Posted May 27, 2014 Share Posted May 27, 2014 I'd like to import a CSV file to update actual quantities in product combinations. The problem is that in this case I've to provide also required fields that are not necessary (attibute, values). For quantity updates is only necessary Product ID, Reference and Quantity. Do you know a workaround or a solution for it? There is an application called Store Manager for PrestaShop using which you can update quantities for combinations via import. Like you indicated in your post, it is not necessarily to include all the required fields into your import file. If you need to change combination quantity, you should have product identifier, combination identifier (ID) and combination quantity in the file. You can find detais in this article - http://www.prestashopmanager.com/useful-articles/tips-tricks/update-stock-for-prestashop-combinations-in-bulk/ Link to comment Share on other sites More sharing options...
avionicom Posted May 28, 2014 Author Share Posted May 28, 2014 Hello Iryna and thank you for your message. I already seen this application, and I agree that is a very useful application. But our actual budget do not let us to buy it, because it is expensive. This is the reason why I'm trying to solve myself this problem. Thank you Link to comment Share on other sites More sharing options...
Iryna Posted June 2, 2014 Share Posted June 2, 2014 I understand you, but we have Standard and Professional Editions. Store Manager for PrestaShop Standard edition is not so expensive though it has some limitations. You can check comparison table here - http://www.prestashopmanager.com/order/ We also offer some promotions, which you can check here - http://www.prestashopmanager.com/useful-articles/about-prestashop/store-manager-for-prestashop-discounts/ Link to comment Share on other sites More sharing options...
Recommended Posts