Forums / Setting Up Categories, Products, Attributes / Global Item Quantity to Zero

Global Item Quantity to Zero

Locked

Results 1 to 4 of 4

This thread is locked. New replies are disabled.

10 Apr 2009, 4:52 PM

hammerhead

New Zenner

Join Date:: Nov 2008
Posts:: 36
Plugin Contributions:: 0

Global Item Quantity to Zero

Is there a way using either the Zen admin panel or a MySQL command to globally set all product quantities to zero?

I've been using EZP and uploading daily price/quantity updates from my supplier, but the problem for me is that because of how I set up my store, when they no longer carry an item, I don't know, it stays in my database, and I've had customers order items that I can't fulfill.

If I can set all items to zero, then upload a new price/quantity file, then the items that are discontinued will be zero and unorderable, the others will carry on as normal.

Thanks in advance!

10 Apr 2009, 5:39 PM

bunyip

Totally Zenned

Join Date:: Sep 2004
Location:: Western Massachusetts
Posts:: 2,361
Plugin Contributions:: 1

Re: Global Item Quantity to Zero

From Admin > Tools > Install SQL Patches, run this sql query, which will set all product quantities to 0:

update products set products_quantity = '0' where products_id > 0;

11 Apr 2009, 3:35 PM

hammerhead

New Zenner

Join Date:: Nov 2008
Posts:: 36
Plugin Contributions:: 0

Re: Global Item Quantity to Zero

Terrific, thanks!

10 Dec 2009, 5:42 AM

pcrepairshop

New Zenner

Join Date:: Nov 2007
Posts:: 3
Plugin Contributions:: 0

Re: Global Item Quantity to Zero

Thanks! I was looking for that. :clap: