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?
Started by minimarket on 11 Oct 2012, 10:13 PM · Views: 1,937
New Zenner
How to change product prices at the same time?
Black Belt
Change all by a fixed dollar amount?
Change all by a percentage?
OR??
Zen-Venom Get Bitten
New Zenner
fixed dollar amount
Black Belt
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
New Zenner
Thank you..
How can I skip one category?
Totally Zenned
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
Totally Zenned
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
New Zenner
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.
Oba-san
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 ...
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!
New Zenner
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
Totally Zenned
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
New Zenner
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
Deceased
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
Tell staff why this post should be reviewed.