lateral Posted April 29, 2015 Share Posted April 29, 2015 Hi guys, My shop has over 1,500 products and at the moment the "Available for Order" field is set to "No". I want to activate the Shopping Cart functionality and need to set the "Available for Order" field to "Yes". Can somebody please tell me how to do this quickly? Regards Greg Link to comment Share on other sites More sharing options...
Guest Posted April 29, 2015 Share Posted April 29, 2015 CSV upload should do it Link to comment Share on other sites More sharing options...
lateral Posted April 29, 2015 Author Share Posted April 29, 2015 Thanks but what do you mean by "CSV upload"? Are you saying that Prestashop has a CSV download and upload function for products? I was thinking more along the line of an Sql command to do it via the Mysql backend. Link to comment Share on other sites More sharing options...
Guest Posted April 30, 2015 Share Posted April 30, 2015 Yes prestashop products can be downloaded from the products page, and uploaded from Advanced Parameters > CSV upload Link to comment Share on other sites More sharing options...
lateral Posted April 30, 2015 Author Share Posted April 30, 2015 Thanks Ron, I found this query that did the trick! UPDATE `ps_product_shop` SET available_for_order =1 UPDATE `ps_product` SET available_for_order =1 Regards Greg Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now