Guest Posted October 25, 2014 Share Posted October 25, 2014 If we buy our products in US currency, the exchange rates fluctuate, and then so does our wholesale prices. Is there any way to do this via built in functionality or modular capability (free or paid) that the conversion could occur based on current rates? Link to comment Share on other sites More sharing options...
Tung at RockPOS.com Posted October 25, 2014 Share Posted October 25, 2014 (edited) Hi, You totally can do that using a built-in feature. Just set up a cron job for that. Refer to the screenshot for further details. Hope this helps! Edited October 25, 2014 by TungCEO (see edit history) Link to comment Share on other sites More sharing options...
Guest Posted October 25, 2014 Share Posted October 25, 2014 Thanks for the response! So since we sell in CAD.. we would input the wholesale price and specify that it is in USD and then call a cronjob to convert that to USD every day? How would we specify that the wholesale price is initially in USD and have it be updated to reflect the USD price based on the currency everyday? Link to comment Share on other sites More sharing options...
Tung at RockPOS.com Posted October 29, 2014 Share Posted October 29, 2014 I'm not quite sure I got your idea very well, man. Basically, you should have 2 currencies enabled: USD and CAD. You might set CAD is the default currency if you don't want your users to change it by your self. Also you might need to use module Block Currencies to give your users the chance to change it. Now, put all prices in USD. Run the cron job every day to update the exchange rate. Is that true? Is there any specific issue you are dealing with? Hope I can help you out. Tung Link to comment Share on other sites More sharing options...
Guest Posted October 29, 2014 Share Posted October 29, 2014 Thanks for your help Tung. I was mainly wondering if it possible to submit the wholesale price in USD and have it update to CAD in the BO. It is because my client buys their products in USD so their wholesale price changes all the time based on the exchange rate (we are in Canada). eggo Link to comment Share on other sites More sharing options...
Tung at RockPOS.com Posted October 30, 2014 Share Posted October 30, 2014 In your last reply, it seems, you are confusing between USD and CAD at frontend. As far as I understand: - You bought products in USD - You sell your products in CAD If so, it's totally possible to do that. What you need to do are: - Enable 2 currencies. - Install module Block currencies, so your customers can choose their own currency. If you don't want them to change currency ( but set to CAD all the times), I'm afraid that, you should not install this module. then, ask someone to customize the code and always set currency to CAD. We can not change default currency in Back office to CAD, as after that, you will have to enter CAD prices, instead of USD. But 1 thing, wholesale price, this is a hidden info to your customers. It's only helpful when you want to calculate profit, margin... internally. It means, you will have to enter your prices into the field "Pre-tax retail price" Link to comment Share on other sites More sharing options...
Guest Posted November 2, 2014 Share Posted November 2, 2014 Hi Tung, Thank you for the explanation. Is it possible to have pre-tax wholesale price in US and then converted to CAD based on exchange rate in backoffice if we want to view reports in only CAD or will this require custom functionality? Link to comment Share on other sites More sharing options...
Tung at RockPOS.com Posted November 4, 2014 Share Posted November 4, 2014 Hello Eggo, I'm afraid NO. It requires customization. Link to comment Share on other sites More sharing options...
quimbaya Posted December 11, 2014 Share Posted December 11, 2014 Well, I support roflmyeggo's requirement. I import merchandise and pay in USD or EUR, and sell in my country using the local currency. So my 'pre-tax wholesale price' is fixed only in USD or EUR, and it will fluctuate daily in my local currency according to the exchange rates between USD/EUR and the local currency. To be able to calculate correct profit margin I would have to adjust continually the pre-tax wholesale prices of all products; or at least with every importation. Would be great if I could indicate the pre-tax wholesale price in the currency the merchandise was bought in. Link to comment Share on other sites More sharing options...
vansrv7 Posted March 24, 2015 Share Posted March 24, 2015 I have the same need. I buy in USD and sell in EURO. Did you found a solution to automatically update selling prices? Link to comment Share on other sites More sharing options...
linneas Posted May 9, 2015 Share Posted May 9, 2015 Hey.I buy in Dollars and sell in pounds so i convert to price before and i enter it in my default price. That way its works great for invoices. I am a novice at web designing so i find a solution instead. Wrong but it works. But my biggest problem is how the price is displayed in my shop i have 4.99 £ and need £4.99 silly ive changed it before but cannot remember where and how. ha ha Link to comment Share on other sites More sharing options...
Paulito Posted May 9, 2015 Share Posted May 9, 2015 Hello Does going to: Back office > Localization > Currencies > Currency format help you http://screencast.com/t/tf8NvhH6 Paul 1 Link to comment Share on other sites More sharing options...
porky Posted May 9, 2015 Share Posted May 9, 2015 Hi paul. Thanks Link to comment Share on other sites More sharing options...
BZZYBI Posted September 2, 2015 Share Posted September 2, 2015 I am in favour of these feature. We buy in GBP and sell in Yen. It would be great if the BO can handle wholesale prices in GBP and have the system covert the wholesale price into Yen according to the daily exchange rate. Link to comment Share on other sites More sharing options...
Recommended Posts