Zen Cart Logo
Forums / General Questions / Changing prices

Changing prices

Locked

Views: 769

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
11 Mar 2010, 6:32 PM
#1
paul_the_first avatar

paul_the_first

New Zenner

Join Date:
Mar 2010
Posts:
54
Plugin Contributions:
0

Changing prices

**Is there a way to increase all of the prices at once. Either by a % or a set amount.

I have 1000 products listed and to increase them one by one is not really a viable option.**

12 Mar 2010, 1:38 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Changing prices

You can backup your database and use something like:

Change all to $7.79

UPDATE products SET products_price = 7.79;

Add 5% to all prices:

UPDATE products SET products_price = products_price*1.05;

You should then run in the Tools ... Store Manager ... the Update Products Price Sorter ...

The Products Price Sorter is for setting the lowest price of a product to the products_price_sorter field for use on sorting and searches etc.