Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    154
    Plugin Contributions
    0

    Default Product quantity change in database?

    We recently converted from a different shopping cart to zen cart. All of the products in zen cart are showing sold out. They will never be sold out as they are made to order when purchased. Is there a way to go through the database and change ALL product quantities to a high number so we can get zen cart open soon? We are still using the old cart and it is not functioning properly. Changing over 1000 products manually would take days to complete.
    I was hoping there would be a simple method that would update them all at once.. can anyone suggest anything?

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Product quantity change in database?

    Check the options in admin > config > stock
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Sep 2006
    Posts
    154
    Plugin Contributions
    0

    Default Re: Product quantity change in database?

    Thanks, but I dont see in there where I can update the -7 and so on of each product quantity to a large number so that the sold out button is not visible to customers. Do I not have it set correctly? We dont need to use inventory/stock control at all.

    Check stock level false
    Subtract stock false
    Allow Checkout true
    Mark product out of stock false
    Stock Re-order level 5
    Products status in Catalog when out of stock should be set to 0
    Show Sold Out Image in place of Add to Cart 1
    Product Quantity Decimals 0
    Show Shopping Cart - Delete Checkboxes or Delete Button 3
    Show Shopping Cart - Update Cart Button Location 3
    Show New Products on empty Shopping Cart Page 1
    Show Featured Products on empty Shopping Cart Page 2
    Show Special Products on empty Shopping Cart Page 3
    Show Upcoming Products on empty Shopping Cart Page 4
    Show Notice of Combining Shopping Cart on Login

  4. #4
    Join Date
    Sep 2006
    Posts
    154
    Plugin Contributions
    0

    Default Re: Product quantity change in database?

    Nevermind, I think I got it now! :)
    I changed my settings to be:
    Title Value Action
    Check stock level false
    Subtract stock false
    Allow Checkout true
    Mark product out of stock false
    Stock Re-order level 0
    Products status in Catalog when out of stock should be set to 0
    Show Sold Out Image in place of Add to Cart 0
    Product Quantity Decimals 0
    Show Shopping Cart - Delete Checkboxes or Delete Button 3
    Show Shopping Cart - Update Cart Button Location 3
    Show New Products on empty Shopping Cart Page 1
    Show Featured Products on empty Shopping Cart Page 2
    Show Special Products on empty Shopping Cart Page 3
    Show Upcoming Products on empty Shopping Cart Page 4
    Show Notice of Combining Shopping Cart on Login 1

 

 

Similar Threads

  1. How to change product quantity display?
    By alfonso99 in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 30 Jun 2011, 06:53 AM
  2. Change Product Quantity in All Products at once
    By LadyMorgana in forum Customization from the Admin
    Replies: 6
    Last Post: 12 Nov 2010, 07:05 PM
  3. change the quantity of product when i add
    By frenchgirl in forum Customization from the Admin
    Replies: 1
    Last Post: 3 May 2010, 03:10 AM
  4. All product listing - customer unable to change quantity box
    By TJB in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 15 Jul 2008, 02:09 AM
  5. Change Quantity to Add to cart on Product Listing Page
    By sweetie1 in forum General Questions
    Replies: 4
    Last Post: 21 Jan 2008, 04:32 PM

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