Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2008
    Posts
    3
    Plugin Contributions
    0

    Default is there an easy way to change all the prices on my website by a percentage?

    hi there,

    Due to world currencies falling so badly I have no option but to raise the prices of all my products by a certain percentage. Is there a tool or way of doing this in one step or do I have to go through 100s of items changing them one at a time.

    please let me know as I would like to do this asap.

    Many thanks,

    Kish

  2. #2
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: is there an easy way to change all the prices on my website by a percentage?

    If you want to increase the price of all your products paid for by customers in a different currency, you could do this by increasing the currency conversion factor (Admin > Configuration > My Store).

    Or if you simply want to increase the price of all products by the same percentage, then you could run a SQL script, such as
    UPDATE products SET products_price = products_price * 1.05;
    through the Admin > Tools > Install SQL Patches utility. This would increase all prices by 5%, but would not take account of any attribute pricing. And of course, you should backup your database first.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  3. #3
    Join Date
    Feb 2006
    Location
    Bexhill, UK
    Posts
    46
    Plugin Contributions
    0

    Default Re: is there an easy way to change all the prices on my website by a percentage?

    is there any way to make this work for only one category (that includes sub-categories)?
    one of my suppliers has just put their prices up by 2.5%

  4. #4
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: is there an easy way to change all the prices on my website by a percentage?

    Yes, but how would depend upon your category structure. Are you using linked categories or just the inititial category into which each product is allocated when first entered (the "master" category)?
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  5. #5
    Join Date
    Feb 2006
    Location
    Bexhill, UK
    Posts
    46
    Plugin Contributions
    0

    Default Re: is there an easy way to change all the prices on my website by a percentage?

    thanks for your quick reply!

    there are no linked categories... the structure is:

    Categories / Products - Parts & Accessories > Huggers & Screens > (then 10 sub categories)

    it's everything in Huggers & Screens and sub cats that i need to change

  6. #6
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: is there an easy way to change all the prices on my website by a percentage?

    You will need a list of those sub category IDs. If they are categories 2,3, ..., 11 for example, you could run something like the following:
    UPDATE products SET products_price = products_price * 1.05 WHERE master_categories_id IN (2,3,4,5,6,7,8,9,10,11);
    After backuping up your database, of course.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  7. #7
    Join Date
    Feb 2006
    Location
    Bexhill, UK
    Posts
    46
    Plugin Contributions
    0

    Default Re: is there an easy way to change all the prices on my website by a percentage?

    cool... thanks for that,
    i've just about got the hang of butchering php but sql still scares me!!! :)

  8. #8
    Join Date
    Jan 2006
    Location
    Downunder - QLD - Gold Coast
    Posts
    964
    Plugin Contributions
    0

    Default Re: is there an easy way to change all the prices on my website by a percentage?

    Quote Originally Posted by kishcm View Post
    hi there,

    Due to world currencies falling so badly I have no option but to raise the prices of all my products by a certain percentage. Is there a tool or way of doing this in one step or do I have to go through 100s of items changing them one at a time.

    please let me know as I would like to do this asap.

    Many thanks,

    Kish
    There is an easy way..very easy and flexible module you can download. I am using it and it's great . Called "sitewide_markup_v1.1"
    Downunder QLD

 

 

Similar Threads

  1. Is there a easy way to customize the homepage ?
    By mybiz9999 in forum Templates, Stylesheets, Page Layout
    Replies: 8
    Last Post: 1 Jul 2010, 07:27 PM
  2. any easy way to change all products to free shipping?
    By hungrytazman in forum Setting Up Categories, Products, Attributes
    Replies: 5
    Last Post: 8 Apr 2010, 10:59 PM
  3. Is there a way to change the order/invoice #?
    By jayequeue in forum Basic Configuration
    Replies: 2
    Last Post: 23 Mar 2010, 06:30 PM
  4. All my prices have gone up by a certain percentage?!
    By nonfinite in forum General Questions
    Replies: 0
    Last Post: 24 Feb 2010, 10:02 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