Changing all prices to a different currency

09 May 2012, 08:20

#1

Totally Zenned

Join Date:: Jun 2006
Posts:: 947
Plugin Contributions:: 0

Changing all prices to a different currency

Goal: Change all prices from Euro to Pound.

Following advice given on this thread, I used the following sql patch to update prices on a test site:

update products set products_price = products_price * '0.83870798';

And then set the default currency to the UK Pound.

This seems to have worked well, although I noticed that an existing 10% off Salemaker was decreased to 7%. :blink:

I'd like to understand why this occurred before applying this sql patch to my other sites. To view an example of the incident, please visit this url. I have applied the sql patch to this site.

Thanks for your thoughts on this.

09 May 2012, 09:34

#2

rodg

Deceased

Join Date:: Jan 2007
Posts:: 6,263
Plugin Contributions:: 3

Re: Changing all prices to a different currency

Just taking a guess here, but I'm reckoning that when you created your sale prices you used actual amounts rather than % discounts. Then as a result of the change of your currency values (which would have no effect on the discount prices entered) Zencart is calculating the new discounts to be 7%.

If you had specified your discounts to be 10% rather than Euro value I suspect that this wouldn't pose a problem.

As I say, just guess.

Cheers
Rod

09 May 2012, 09:53

#3

meltdown

Totally Zenned

Join Date:: Jun 2006
Posts:: 947
Plugin Contributions:: 0

Re: Changing all prices to a different currency

RodG:
Just taking a guess here, but I'm reckoning that when you created your sale prices you used actual amounts rather than % discounts. Then as a result of the change of your currency values (which would have no effect on the discount prices entered) Zencart is calculating the new discounts to be 7%.

If you had specified your discounts to be 10% rather than Euro value I suspect that this wouldn't pose a problem.

As I say, just guess.

Cheers
Rod

Hi Rod, Thanks for the reply. Yes, I thought that might be the case, as well. However, checking the Salemaker, I see that I did indeed use 10% rather than a fixed amount.

09 May 2012, 10:03

#4

dgent

Totally Zenned

Join Date:: Nov 2009
Posts:: 1,117
Plugin Contributions:: 0

Re: Changing all prices to a different currency

Reset the percentage. Maybe the percentage discount doesnt actually work 'in real time' and writes the discounted value to the database. Even though you have changed the original price via the database, the discounted prices is the same as when it was in euros (You could work out if Im right with a calculator)

Go back into sale maker and re-do the discounts.

09 May 2012, 10:09

#5

rodg

Deceased

Join Date:: Jan 2007
Posts:: 6,263
Plugin Contributions:: 3

Re: Changing all prices to a different currency

" "

09 May 2012, 10:39

#6

meltdown

Totally Zenned

Join Date:: Jun 2006
Posts:: 947
Plugin Contributions:: 0

Re: Changing all prices to a different currency

OK, I see what the problem was: I had previously created a 10% off Salemaker sale, but it wasn't active. Instead, I had used the "Specials" option to individually apply 10% discounts, as these served me more efficiently. Therefore, I needed to go in and reset each of those percentages individually to 10%.

09 May 2012, 10:50

#7

meltdown

Totally Zenned

Join Date:: Jun 2006
Posts:: 947
Plugin Contributions:: 0

Re: Changing all prices to a different currency

Another question: After applying the sql patch to this site, the Pound cost of an item was, for example, £6.71. The Euro price for the same item is €8.65. However, that same product on another of my sites, while also £6.71 in pounds, is only €8.00 in Euro.

The Currency Conversion Ratio is the same on both sites, the only difference being that the site displaying the item for €8.00 has the Euro as the default currency (I haven't yet applied the sql patch and switched to Pounds yet). Why the difference?

Thanks again for your input!!

09 May 2012, 11:00

#8

dgent

Totally Zenned

Join Date:: Nov 2009
Posts:: 1,117
Plugin Contributions:: 0

Re: Changing all prices to a different currency

Probably due to the way you're working out discounts/markup. You took a percentage 'off' a larger value to make the £ value. On the other site the euro value is a multiplication of the lower £ value to make the higher euro value.

Much like when people work out profit/margin and get it wrong, as 20% profit markup is not the same value as 20% margin.

09 May 2012, 11:05

#9

meltdown

Totally Zenned

Join Date:: Jun 2006
Posts:: 947
Plugin Contributions:: 0

Re: Changing all prices to a different currency

Thanks for the reply. I'm a bit confused, though, because in the example I provided in post #7 there were no discounts in play, only the set price. The only variable would be the currency exchange itself, so why the 65 cents difference?

09 May 2012, 11:13

#10

dgent

Totally Zenned

Join Date:: Nov 2009
Posts:: 1,117
Plugin Contributions:: 0

Re: Changing all prices to a different currency

MeltDown:
Thanks for the reply. I'm a bit confused, though, because in the example I provided in post #7 there were no discounts in play, only the set price. The only variable would be the currency exchange itself, so why the 65 cents difference?

I wasnt talking about the special price discounts.

Your original equation is 0.83870798, so a 17% discount.

In Zencart, the currency upscaler is a multiplier, so a euro isnt a 17% upscale of the £, it will be more like 23% to get the same value.

09 May 2012, 11:46

#11

meltdown

Totally Zenned

Join Date:: Jun 2006
Posts:: 947
Plugin Contributions:: 0

Re: Changing all prices to a different currency

Ahhh... OK, thank you for the explanation.

Great, it looks as though I should be able to safely apply the sql patch to my other sites. Thanks for the help!