Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Changing prices of an entire category

Changing prices of an entire category

Locked

Views: 577

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
10 Sep 2010, 1:30 PM
#1
commdiver avatar

commdiver

Zen Follower

Join Date:
May 2010
Posts:
222
Plugin Contributions:
0

Changing prices of an entire category

Is there any way to change the prices of an entire category, assuming all products in said category are the same price? There are no subcategories either.

10 Sep 2010, 3:47 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Changing prices of an entire category

If all of the Products in the Category use the same master_categories_id ... you could use:

UPDATE products SET products_price = XX.XX WHERE master_categories_id = YY;

NOTE: Backup your database before running these changes

NOTE: after you are done adjusting all of your prices manually, you should run in the Store Manager the Update Price Sorter ...

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