Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2008
    Posts
    36
    Plugin Contributions
    0

    Default 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!

  2. #2
    Join Date
    Sep 2004
    Location
    Western Massachusetts
    Posts
    2,945
    Plugin Contributions
    5

    Default Re: Global Item Quantity to Zero

    From Admin > Tools > Install SQL Patches, run this sql query, which will set all product quantities to 0:
    Code:
    update products set products_quantity = '0' where products_id > 0;
    Neville
    An assumption is what you arrive at when you get tired of thinking...

  3. #3
    Join Date
    Nov 2008
    Posts
    36
    Plugin Contributions
    0

    Default Re: Global Item Quantity to Zero

    Terrific, thanks!

  4. #4
    Join Date
    Nov 2007
    Posts
    3
    Plugin Contributions
    0

    Default Re: Global Item Quantity to Zero

    Thanks! I was looking for that.

 

 

Similar Threads

  1. Re global quantity discount
    By pageblair in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 17 Mar 2010, 12:03 AM
  2. Global Quantity number change?
    By LadyMorgana in forum General Questions
    Replies: 1
    Last Post: 11 Oct 2008, 06:47 PM
  3. Quick: Add Table: item by item or global?
    By unklchuk in forum General Questions
    Replies: 11
    Last Post: 12 Aug 2008, 09:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR