Page 1 of 3 123 LastLast
Results 1 to 10 of 22
  1. #1
    Join Date
    Dec 2010
    Posts
    45
    Plugin Contributions
    1

    Default mass price change for all products in a specific category

    Can it be done?

    Can I make a 15% price raise on all products in a specific category?




    Please help,
    Chaiavi.

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

    Default Re: mass price change for all products in a specific category

    If all of those Products use that Category's categories_id as their master_categories_id ...

    You can backup your database and then run:

    Code:
    UPDATE products SET products_price = products_price * 1.15 WHERE master_categories_id = XX;
    where XX is the master_categories_id for these Products ...

    Then, go to the Tools ... Store Manager ... and run the:
    Update ALL Products Price Sorter
    to be able to sort by displayed prices: Update
    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!

  3. #3
    Join Date
    Dec 2010
    Posts
    45
    Plugin Contributions
    1

    Default Re: mass price change for all products in a specific category

    Nice hack


    Thanks.

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

    Default Re: mass price change for all products in a specific category

    Thanks for the update that this was able to do the Product Price increase that you needed ...
    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!

  5. #5
    Join Date
    Dec 2010
    Posts
    45
    Plugin Contributions
    1

    Default Re: mass price change for all products in a specific category

    Is there any addon / plugin that does the same thing without manual direct DB access?

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

    Default Re: mass price change for all products in a specific category

    You can run the same command from the Zen Cart Admin in the Tools ... Install SQL Patches ...

    Otherwise, you would need to customize the code to build this in as something more user friendly ...
    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!

  7. #7
    Join Date
    Feb 2010
    Posts
    27
    Plugin Contributions
    0

    Default Re: mass price change for all products in a specific category

    i had to update my hole store buy 11% , i used obisan's code
    PHP Code:
    UPDATE products SET products_price products_price 1.11 
    note this will do ALL products in the store

    tyvm obi for showing me the way :)

  8. #8
    Join Date
    Jan 2011
    Posts
    58
    Plugin Contributions
    0

    Default Re: mass price change for all products in a specific category

    Hi,

    Where to make the modifs in the code?

    Which line more precisely because I need to add a tax on a specific category for particular products??

    Is it in the script 'categories.php'?

    Am a newbie to Zen Cart..

    Thanks

    Liizz

  9. #9
    Join Date
    Sep 2010
    Posts
    12
    Plugin Contributions
    0

    Default Re: mass price change for all products in a specific category

    Quote Originally Posted by liizz View Post
    Hi,

    Where to make the modifs in the code?

    Which line more precisely because I need to add a tax on a specific category for particular products??

    Is it in the script 'categories.php'?

    Am a newbie to Zen Cart..

    Thanks

    Liizz

    Hi Liizz - No to add tax to all your items or items from a category you can do another SQL query on your database - I am not good at SQL, but it would look something like this:

    UPDATE products SET products_tax_class_id = 1 WHERE master_categories_id = XX

    Where xx is the category you want to update all products

    Remember - always backup before doing any SQL queries :)


    Good Luck,

    Ryan

  10. #10
    Join Date
    Sep 2010
    Location
    Cahokia, IL
    Posts
    19
    Plugin Contributions
    0

    Default Re: mass price change for all products in a specific category

    If you use a spreadsheet program like Excel or Open Office you can do it real simple, its called Paste Special - I just learned about it.

    In an empty cell (anywhere on that active sheet is fine) enter the percentage you wish to increase prices by i.e 1.35 for 35% or 1.11 for 11% etc.
    Now Click CTRL C (Copy) over the cell you just created
    Highlight the cells/column you wish to change
    Click on EDIT -> PASTE SPECIAL
    In that screen select MULTIPY
    CLick OK
    Your Done!

    I would suggest trying it out on fresh spreadsheet to get a handle on what you're doing.

    If I can find the link to that forum page I will respond back and post it. Otherwise, you should be able to find it in a google search: Paste Special (open office or excel)

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. Replies: 4
    Last Post: 23 Feb 2014, 09:39 PM
  2. Replies: 7
    Last Post: 29 Jul 2011, 08:37 PM
  3. Replies: 7
    Last Post: 17 May 2011, 02:00 PM
  4. Login for price on specific products
    By 00Goat in forum Templates, Stylesheets, Page Layout
    Replies: 13
    Last Post: 20 May 2009, 05:03 AM
  5. When a specific Attribute is used - change price to "call for price"?
    By PaulRiedel in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 4 Nov 2007, 02:34 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