If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Not display out of stock products

Not display out of stock products

Locked

Started by heimskr75 on 25 Nov 2007, 4:52 PM · Views: 1,044

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
25 Nov 2007, 4:52 PM
#1
heimskr75 avatar

heimskr75

Zen Follower

Join Date:
Apr 2007
Posts:
106
Plugin Contributions:
3

Not display out of stock products

Is there an extension or simple way to turn off/not display out of stock products on a large scale? My store has 19,000 items in it and I just dont have the time or patience to turn on and off that many products.
Thanks

25 Nov 2007, 5:00 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Not display out of stock products

You could run a single command in the Tools ... Insert SQL Patches ...

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

NOTE: be sure that you backup your database before running this command ...

All Products marked as products_status = 0 will not show in the Catalog ...

Check your settings in the Configuration ... Stock ... to configure the Catalog on how to manage the Products in stock based on when the Orders are processed ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

25 Nov 2007, 5:59 PM
#3
heimskr75 avatar

heimskr75

Zen Follower

Join Date:
Apr 2007
Posts:
106
Plugin Contributions:
3

Re: Not display out of stock products

:clap::clap::clap: Thank You!!!!!! It worked beautifully!
You wouldn't happen to know how to do something like that for the display quantity box would ya? I used easy populate to load all the products and it set all the products to where the quantity box doesn't display. As you can tell I'm smart like a brick when it comes to SQL statements.

Thanks again