nihavai Posted January 6, 2014 Share Posted January 6, 2014 Hi,We need a solution to update our shop daily by csv or excel file.We have 5000 products and we need something better than csv import in prestashop.All products have a ID and REFERENCE #. The REFERENCE number is unique for everyone product.We want to create a file with REFERENCE number and QUANTITY.We read a lot and see we can create sql query but we are not familiar with SQL.Our hosting company gives access to SQL only by phpADMIN (for security reasons). Link to comment Share on other sites More sharing options...
NemoPS Posted January 6, 2014 Share Posted January 6, 2014 Are you using multistore? Or advanced stock management? Do you have at least a basic knowledge of sql? I'd personally create a script with a bulk update, disabling autocommit and committing the statements every, say, 500 entries or so. Also, are you using product combinations? Link to comment Share on other sites More sharing options...
nihavai Posted January 6, 2014 Author Share Posted January 6, 2014 Hi, We use single store not multi and advanced stock managment is turned off and we use product combinations. Link to comment Share on other sites More sharing options...
NemoPS Posted January 6, 2014 Share Posted January 6, 2014 If so, you must edit the combinations quantities at of ps_product_attribute Link to comment Share on other sites More sharing options...
nihavai Posted January 6, 2014 Author Share Posted January 6, 2014 Quantity of the products are in ps_stock_available.We must create a JOIN function in sql query to connect REFERENCE number in ps_product_attribute with ps_stock_available, because in ps_stock_available we didn't have REFERENCE number. Link to comment Share on other sites More sharing options...
eve_rafter Posted January 29, 2014 Share Posted January 29, 2014 Hi, I've just posted this on my blog about this issue. It's in spanish, but it could be useful for you: http://evamariamontero.com/blog/como-actualizar-un-stock-con-combinaciones-en-prestashop-1-5-6-a-partir-de-un-excel/ Hope it helps you! Eva Link to comment Share on other sites More sharing options...
nihavai Posted January 30, 2014 Author Share Posted January 30, 2014 Hi and thanks emon1077,Now we use other method. We export ps_stock_available and update quantity of products with Excel. Then we import again new ps_stock_available.This work very well at this time. Link to comment Share on other sites More sharing options...
MSingh Posted January 15, 2016 Share Posted January 15, 2016 Hi NIhavai, I am also facing the similar issue with my prestashop store (1.6) and tried the export/import option on ps_stock_available table, but its doesn't seem to work. Please suggest Thanks for help Manu Link to comment Share on other sites More sharing options...
NemoPS Posted January 15, 2016 Share Posted January 15, 2016 are you using advanced stock management? You can try changing that table manually and see if things reflect. If not, try ps_product_shop Link to comment Share on other sites More sharing options...
Recommended Posts