How to change product prices at the same time?
How to change product prices at the same time?
Change all by a fixed dollar amount?
Change all by a percentage?
OR??
Zen-Venom Get Bitten
fixed dollar amount
Backup database before doing this
Enter this sql through your admin > tools > sql
Adjust for what dollar amount you want
Code:UPDATE products SET products_price= products_price + 1.00;
Zen-Venom Get Bitten
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.
Last edited by SPH; 12 Oct 2012 at 06:13 AM.
Steve
prommart.com
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.
Last edited by SPH; 12 Oct 2012 at 06:37 AM.
Steve
prommart.com
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???
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: v1.5.5]
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!
Sean M - Sydney, Australia
Bookmarks