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:
Code:
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.
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
Re: Changing all prices to a different currency
Quote:
Originally Posted by
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.
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.
Re: Changing all prices to a different currency
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%.
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!!
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.
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?
Re: Changing all prices to a different currency
Quote:
Originally Posted by
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.