changing currency of the BO

[L. Brett Sinclair]

Hello
I was hoping to be able to manage my Back Office in 1 currency and my Front Office in another. This doesn't seem possible.
I now need to change the currency in my BO. Therefore I must apply to my price & purchase price an exchange rate.
Is there other columns in other tables beside ps_product.price and ps_product.wholesale_price so I can run something like :

update `ps_product` set price= price * MYCOEFDHERE , wholesale_price =wholesale_price * MYCOEFDHERE where 1=1 ;

thank you for the help.

[clokwise]

Yes, I need to do the exact same thing! We buy and manage inventory in Euros, but we are targeting US market so we need the front office in USD.

[L. Brett Sinclair]

alright, so those are the only 2 columns to update in the DB correct ?

[hieloiceberg]

Yes, I need to do the exact same thing! We buy and manage inventory in Euros, but we are targeting US market so we need the front office in USD.

Click on Currencies and mark the checkbox of Dollars only

I think that solves your problem

[L. Brett Sinclair]

that doesn't do it for me since I can only have 1 default...and the default is not my BO currency.
Thank you for the suggestion though.

[hieloiceberg]

Ok if I’m not mistaking you buy in Euros and your default at BO is Euros right? But you only want to sell in Dollars am I ok so far?

[L. Brett Sinclair]

that's pretty much it. I do not want to show any EURO in the FO (to the end user)

[hieloiceberg]

Ok when is set the way I show in the picture you will have all the options of any currency that you use even so thru the payment process but only at the end where the client confirms the order to be final in there it will change to dollars

[L. Brett Sinclair]

yes, I noticed that. But unfortunately, I noticed that customers will leave right away the web site because it's not in their currency.
So, I don't even want to show them the option. I will manage my backoffice in the FO currency - not a big deal. I just want to make sure that I update all tables correctly.
Thank you for the help again !

[clokwise]

After seeing this thread, and needing this functionality myself, I wrote a module which does the job. It's 100% functional now, so I'll just test it a bit further and post it here later.

[hieloiceberg]

Nice!!!!!!!

[L. Brett Sinclair]

that would be awesome !

[clokwise]

The module is here: http://www.prestashop.com/forums/viewthread/9473/modules/module_force_currency

Enjoy!

[L. Brett Sinclair]

Thank you Clokwise. I will test it locally first.
Do you happen to know by chance the tables and columns I'm supposed to update in the meantime in the DB?

[Matthieu Biart]

Hi everyone!

L. Brett Sinclair the feature you're speaking about is very interesting, could you please submit a feature request?
(An easy way to manage it could be to disable currencies only for the FO)
Thank you in advance.

[L. Brett Sinclair]

Ok Matthieu - I will ;
In the meantime, here is how I proceeded for those interested in a work around:

1 - backup the DB
2 - I'm not using the EAN13 or the Location field and I could not find where they would be shown in the FO.
Therefore I decided to move the wholesale price to the "EAN13" field and the sell price to the "location" field.
Then I ran the following SQL on my DB to accomplish it:
update `ps_product` set ean13 = wholesale_price , location = price where 1=1 ;
3 - I then changed the default currency of my shop Payment/Currency=> Default currency to Euro (I want to sell in Euro but I buy in USD)
4 - I then deleted the USD currency
5 - I updated my prices in Euro with an exchange rate
update `ps_product` set price= price * MYCOEFDHERE , wholesale_price =wholesale_price * MYCOEFDHERE where 1=1 ;
6 - review all product to make get rid of the rounding ( I do not want prices like 6.66Euro)

In case of error I would update back the prices from EAN13 and Location fields.