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,655
    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.
    See and test drive Zen Cart's free templates at zencarttemplates.info

    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,655
    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)?
    See and test drive Zen Cart's free templates at zencarttemplates.info

    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,655
    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.
    See and test drive Zen Cart's free templates at zencarttemplates.info

    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
    722
    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. Easy integration to a ready built website?
    By finestimaginary in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 25 Feb 2008, 07:02 PM
  2. easy populate all my prices show 0.00
    By Dichroic in forum All Other Contributions/Addons
    Replies: 31
    Last Post: 14 Jan 2008, 02:43 AM
  3. Percentage discount on product prices
    By lbooth in forum General Questions
    Replies: 1
    Last Post: 7 Dec 2007, 05:36 PM
  4. Replies: 2
    Last Post: 17 Jul 2007, 04:18 AM
  5. Easy Populate Map Prices ?
    By admcompa in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 15 Jun 2007, 09:16 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
  •