cant turn off sold out

Hi all
Cant turn off sold out settind

Admin-> Stocking setting dosnt help
http://www.czbeads.eu/czech-seed-beads-rocailles-c-1_2.html

you can see sold out products

Products status in Catalog when out of stock should be set to = 0

But it dosnt help
where I need to check something ?

Products status in Catalog when out of stock should be set to = 0

you can find this under CONFIGURATION>>STOCK

hope that helps

Is that how you have it set in the Stock settings?

Note: Changing this setting to take the Product to products_status = 0 will not occure unless the Product is checked out and then during the checkout_process the stock falls to < 1 or 0 ...

If you just set the products_quantity to 0 you need to manually set the products_status to 0 ...

If you need to update you database to have all products_quantity <= 0 set to products_status 0 then you could run a SQL command to do this for you ...

First backup your database ...

Did you back up your database? :unsure:

Next, in your Zen Cart Admin ... Tools ... Insert SQL Patch ...

You can type in:

UPDATE products SET products_status=0 where products_quantity <=0;

This will take all Products with products_quantity <= 0 out of stock and hide them from the Catalog ...

NOTE: Backup your database first ...

I see

If Im turn on product with 0 items on stock - I cant changet it if I simple turn it in off Admin -> Stock setting

Im stupid. Damn... 8)

Thank you for explain

Not stupid ... sometimes it is just hard to see the implications of a switch setting that controls how things run but does not alter the existing data ...

Now you know ... and so does everyone else ... :smile: