Zen Cart Logo
Forums / General Questions / Product quantity change in database?

Product quantity change in database?

Locked

Views: 1,732

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
1 Jul 2008, 1:27 AM
#1
countingsheep avatar

countingsheep

Zen Follower

Join Date:
Sep 2006
Posts:
154
Plugin Contributions:
0

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?

1 Jul 2008, 2:42 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Product quantity change in database?

Check the options in admin > config > stock

1 Jul 2008, 11:44 PM
#3
countingsheep avatar

countingsheep

Zen Follower

Join Date:
Sep 2006
Posts:
154
Plugin Contributions:
0

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

2 Jul 2008, 12:26 AM
#4
countingsheep avatar

countingsheep

Zen Follower

Join Date:
Sep 2006
Posts:
154
Plugin Contributions:
0

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