Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    71
    Plugin Contributions
    0

    Default Change currency but keep store prices

    Hi, I need to change the default currency but keep the current store prices the same, for example, if an item is 3.99 in USD and I change it to EURO as default, the price changes to reflect the EURO but I would like all the stores prices to stay as they were. Is there any way at all to keep the prices as they are and change the default currency?

    Thank you.

  2. #2
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Change currency but keep store prices

    The fact that this does not make commercial sense, does not mean it can't be done.

    But I have to ask...

    If I price my goods in UK Sterling, then want to reflect the same numerical value for Zambian Kwatcha... I will surely become backrupt overnight.

    1 UK Pound will buy me about 8,000 Zambian Kwatcha. So I will be making a loss of about 99.99% if I sell a product valued at £1, and the buyer decides to swop to Kwatchas and pay 1 Kwatcha.

    But if you are insistent, all you need do is give all currency values the same value: 1.000000000 in the currencies section of the admin panel, and then to make sure you never do a currency update.
    19 years a Zencart User

  3. #3
    Join Date
    Apr 2008
    Posts
    71
    Plugin Contributions
    0

    Default Re: Change currency but keep store prices

    Ok, thank you very much indeed.

    It's just that our store has been undercharging for some time now and we wanted to change to EUROS and keep the same price for all products in the store, there's far too many to change manually!

  4. #4
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Change currency but keep store prices

    You should not use a screwdriver to hammer in a nail... Don't manipulate the CURRENCY function to effect a PRICE CHANGE.

    You will end up in a mess...

    If you need to globally increase your prices all by the same factor, then a simple SQL command (run through "Install SQL Patches") will achieve this in under 1 second.

    If, for example, you wanted to increase ALL product prices by 15%, then just run the following line in the "Install SQL Patches" feature (ADMIN >>> TOOLS >>> Install SQL Patches).

    UPDATE products SET products_price = products_price * 1.15;

    (This says... "Go into the products table in the database and find the field with prices, then take the existing price and multiply it by 1.15")

    ALL your product prices will then be 15% higher than they are now.
    19 years a Zencart User

  5. #5
    Join Date
    Apr 2008
    Posts
    71
    Plugin Contributions
    0

    Default Re: Change currency but keep store prices

    Thank you very much schoolboy, I will do that then.

    If at any point I wanted to undo the price increase how would I go about reversing it?

    Thanks for your time.

 

 

Similar Threads

  1. v139b When change to some other currency all prices are zero
    By irishshopper in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 2
    Last Post: 12 May 2013, 03:40 PM
  2. Store status 2 but no login or prices
    By Octavious8 in forum General Questions
    Replies: 3
    Last Post: 23 Jan 2011, 02:23 PM
  3. change default currency but still in euro
    By djoel in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 13 May 2010, 03:33 PM
  4. How to change all prices to different currency?
    By DavidVitazka in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 7
    Last Post: 8 Feb 2009, 04:26 PM
  5. Upgrade but keep store in original directory
    By sellis in forum Upgrading from 1.3.x to 1.3.9
    Replies: 7
    Last Post: 9 Aug 2008, 05:00 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