cant turn off sold out

[maxus]

Hi all
Cant turn off sold out settind

Admin-> Stocking setting dosnt help
http://www.czbeads.eu/czech-seed-bea...les-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 ?

[wickedklown]

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

you can find this under CONFIGURATION>>STOCK

hope that helps

[Ajeh]

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?

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 ...

[maxus]

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

[Ajeh]

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 ...