Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2009
    Location
    France
    Posts
    158
    Plugin Contributions
    0

    help question Updating all products to show quantity box

    Dear all,

    I would like to know if there is a sql command that enable to update all products so they show the quantity box.

    Thanks

    And, by the way, is there a guide on this sql codes for zencart ?

    Aka

  2. #2
    Join Date
    Mar 2009
    Location
    France
    Posts
    158
    Plugin Contributions
    0

    Default Re: Updating all products to show quantity box

    no reply ?

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Updating all products to show quantity box

    Providing the issue is with the field setting of products_qty_box_status in the products table, you can backup your database and run the SQL command:
    Code:
    UPDATE products SET products_qty_box_status = 1;
    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: v1.5.5]
    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!

  4. #4
    Join Date
    Mar 2009
    Location
    France
    Posts
    158
    Plugin Contributions
    0

    Default Re: Updating all products to show quantity box

    thank you Oba san !

  5. #5
    Join Date
    Apr 2010
    Posts
    897
    Plugin Contributions
    0

    Default Re: Updating all products to show quantity box

    Good stuff, thanks Ajeh! I too benefited from your answer.

    But I have a follow on question. After running your script, all of the qty boxes say...
    Min: 0 Units: 0

    This is because Product Qty Minimum and Product Qty Units are defaulting to zero instead of 1.

    Can you give us a script that will input 1's into those two slots?

    Thanks,
    Mike

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Updating all products to show quantity box

    You cannot use:
    Minimum 0
    Units 0

    as there is no such thing ...

    Code:
    UPDATE products SET products_quantity_order_min = 1;
    Code:
    UPDATE products SET products_quantity_order_units = 1;
    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: v1.5.5]
    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!

  7. #7
    Join Date
    Apr 2010
    Posts
    897
    Plugin Contributions
    0

    Default Re: Updating all products to show quantity box

    Ajeh,

    Has anybody told you lately that you are
    AWESOME!

    Thank you so much!

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Updating all products to show quantity box

    You are most welcome ... thanks for the update that this is working for you ...
    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: v1.5.5]
    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!

 

 

Similar Threads

  1. Replies: 1
    Last Post: 5 Aug 2015, 01:11 PM
  2. All Products in Category Do Not Show Quantity Box
    By MVIP in forum Templates, Stylesheets, Page Layout
    Replies: 8
    Last Post: 24 Jan 2012, 11:25 PM
  3. Products Quantity Box Show vs Easy Populate
    By LilleyPadGifts in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 20 Feb 2010, 10:18 PM
  4. Products Quantity? Updating all vs showing Sold Out
    By rooisnor in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 13 Jul 2008, 09:58 PM
  5. Quantity Box in All Products Listing
    By mdegeiso in forum Basic Configuration
    Replies: 2
    Last Post: 21 Mar 2007, 02:53 AM

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