Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Join Date
    Oct 2012
    Posts
    3
    Plugin Contributions
    0

    Default Changing price for all items at same time

    How to change product prices at the same time?

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default 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

  3. #3
    Join Date
    Oct 2012
    Posts
    3
    Plugin Contributions
    0

    Default Re: Changing price for all items at same time

    fixed dollar amount

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default 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
    Code:
    UPDATE products SET products_price= products_price + 1.00;
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Oct 2012
    Posts
    3
    Plugin Contributions
    0

    Default Re: Changing price for all items at same time

    Thank you..
    How can I skip one category?

  6. #6
    Join Date
    Jan 2006
    Posts
    1,542
    Plugin Contributions
    0

    Default Re: Changing price for all items at same time

    Quote Originally Posted by minimarket View Post
    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

  7. #7
    Join Date
    Jan 2006
    Posts
    1,542
    Plugin Contributions
    0

    Default 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.
    Last edited by SPH; 12 Oct 2012 at 06:37 AM.
    Steve
    prommart.com

  8. #8
    Join Date
    Oct 2012
    Posts
    4
    Plugin Contributions
    0

    Default 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???

    Quote Originally Posted by SPH View Post
    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.

  9. #9
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: 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!

  10. #10
    Join Date
    Nov 2009
    Location
    Sydney Australia
    Posts
    84
    Plugin Contributions
    0

    Default Re: Changing price for all items at same time

    Quote Originally Posted by kobra View Post
    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

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v151 need to set price for a few items all other items use weight
    By cubmanky in forum Built-in Shipping and Payment Modules
    Replies: 13
    Last Post: 8 Jan 2014, 09:32 PM
  2. Same price for ALL products
    By juukyuu in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 24 Jan 2012, 12:18 AM
  3. Delete all categories at the same time?
    By jgnet in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 21 Jul 2010, 05:22 PM
  4. changing price for multiple items at once?
    By gorie in forum Setting Up Categories, Products, Attributes
    Replies: 5
    Last Post: 5 Jul 2009, 04:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR