If this is your first visit, check our documentation. To post, register or login.
Forums / Setting Up Categories, Products, Attributes / Changing price for all items at same time

Changing price for all items at same time

Started by minimarket on 11 Oct 2012, 10:13 PM · Views: 1,937

Results 1 to 13 of 13
11 Oct 2012, 10:13 PM
#1
minimarket avatar

minimarket

New Zenner

Join Date:
Oct 2012
Posts:
3
Plugin Contributions:
0

Changing price for all items at same time

How to change product prices at the same time?

11 Oct 2012, 10:24 PM
#2
kobra avatar

kobra

Black Belt

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

Re: Changing price for all items at same time

Change all by a fixed dollar amount?
Change all by a percentage?
OR??

Zen-Venom Get Bitten

11 Oct 2012, 10:34 PM
#3
minimarket avatar

minimarket

New Zenner

Join Date:
Oct 2012
Posts:
3
Plugin Contributions:
0

Re: Changing price for all items at same time

fixed dollar amount

11 Oct 2012, 10:44 PM
#4
kobra avatar

kobra

Black Belt

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

Re: Changing price for all items at same time

Backup database before doing this
Enter this sql through your admin > tools > sql
Adjust for what dollar amount you want

UPDATE products SET products_price= products_price + 1.00;

Zen-Venom Get Bitten

11 Oct 2012, 11:55 PM
#5
minimarket avatar

minimarket

New Zenner

Join Date:
Oct 2012
Posts:
3
Plugin Contributions:
0

Re: Changing price for all items at same time

Thank you..
How can I skip one category?

12 Oct 2012, 5:08 AM
#6
sph avatar

sph

Totally Zenned

Join Date:
Jan 2006
Posts:
1,556
Plugin Contributions:
0

Re: Changing price for all items at same time

minimarket:

Thank you..
How can I skip one category?

That's not what you initially asked and now things look to be a little more complicated.

Are all your prices going to be changed by the same amount? Perhaps Kobra's solution might work; change them all and then go back to that one category and re-set those back. Or perhaps someone will have a solution to skip one category via Kobra's method.

Is your site very large, with too many products to change price by something like one of the Easy Populates? But even there, perhaps a spread sheet expert would know how to change the entire price column at once by a fixed amount (and you remove the products from the exempted category). Don't know...but my sis might if it's possible...she's our "Spreadsheet Queen" when it comes to Easy Populates.

Steve
prommart.com

12 Oct 2012, 5:34 AM
#7
sph avatar

sph

Totally Zenned

Join Date:
Jan 2006
Posts:
1,556
Plugin Contributions:
0

Re: Changing price for all items at same time

Come to think of it, I now recall once having to change all of the prices for one of our manufacturers (categories) by a fixed amount. We did this on our various sites via Easy Populate spreadsheet and the price column all at once. Even if you have an Easy Populate installed, unfortunately I don't recall how we did it.

Steve
prommart.com

12 Oct 2012, 6:19 AM
#8
cry1978 avatar

cry1978

New Zenner

Join Date:
Oct 2012
Posts:
4
Plugin Contributions:
0

Re: Changing price for all items at same time

how about that sql statement above with more keywords like

products >= $$$ or == $$$

Products greater > or equal = to an amount

or

products equal equal to an amount

will only be changed???

I am no expert but if you study up on the sql books, like an sql bible book, we can figure this out...

someone here knows what I am talking about???

SPH:

Come to think of it, I now recall once having to change all of the prices for one of our manufacturers (categories) by a fixed amount. We did this on our various sites via Easy Populate spreadsheet and the price column all at once. Even if you have an Easy Populate installed, unfortunately I don't recall how we did it.

12 Oct 2012, 1:27 PM
#9
ajeh avatar

ajeh

Oba-san

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

Re: Changing price for all items at same time

Do all the Products in the one category that should not be used use that category's categories_id as their master_categories_id?

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!

7 Mar 2013, 2:41 AM
#10
smcelligott avatar

smcelligott

New Zenner

Join Date:
Nov 2009
Location:
Sydney Australia
Posts:
84
Plugin Contributions:
0

Re: Changing price for all items at same time

kobra:

Change all by a fixed dollar amount?
Change all by a percentage?
OR??

I'd like to change by a percentage . . . can I use:

UPDATE products SET products_price= products_price x .90909;

I want to change prices to 10/11 of what they are now, just not sure how to do that in SQL

Thanks, Sean

Sean M - Sydney, Australia

7 Mar 2013, 8:10 AM
#11
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Changing price for all items at same time

smcelligott:

I'd like to change by a percentage . . . can I use:

UPDATE products SET products_price= products_price x .90909;

I want to change prices to 10/11 of what they are now, just not sure how to do that in SQL

Thanks, Sean

That should be OK. Use * not x for "multiply". It will change ALL prices.

20 years a Zencart User

8 Mar 2013, 1:18 AM
#12
smcelligott avatar

smcelligott

New Zenner

Join Date:
Nov 2009
Location:
Sydney Australia
Posts:
84
Plugin Contributions:
0

Re: Changing price for all items at same time

schoolboy:

That should be OK. Use * not x for "multiply". It will change ALL prices.

Schoolboy, yep tried "x" yesterday and it failed, then tried * and it worked just fine. On a related issue, I had some rounding issues. Is there a SQL statement that can modify a product price of $126.36364 to just $126.36?

Sean M - Sydney, Australia

8 Mar 2013, 6:54 AM
#13
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Changing price for all items at same time

smcelligott:

Schoolboy, yep tried "x" yesterday and it failed, then tried * and it worked just fine. On a related issue, I had some rounding issues. Is there a SQL statement that can modify a product price of $126.36364 to just $126.36?

http://www.w3resource.com/mysql/mathematical-functions/mysql-round-function.php

Cheers
Rod

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.