Jump to content

PrestaShop™ 1.4.5.1 "available to order"


Recommended Posts

In my naivety I went through 750 products on my customers prestashop site and manually clicked "available to order" so that when the website was working as a catalogue showing prices but products couldnt actually be ordered.

 

Of course my customer now wants to reverse this and I have 750 products that I need to manually open and click "available to order". Is there any genius out there who could tell me how to do this to all products with one click, or even if there is an SQL command I could use ?

Link to comment
Share on other sites

Please try this, depending on what you want:

 

Set available_for_order to 0 for all available_for_order that have 1

UPDATE ps_product SET available_for_order=0 where available_for_order=1

 

Set available_for_order to 1 for all available_for_order that have 0

UPDATE ps_product SET available_for_order=1 where available_for_order=0

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...