Can osCommerce remember a user's chosen currency?

[raddygast]

Simple question. User can switch from default currency to a non-default one, like CAD, AUD, GBP, EUR, whatever. Prices are shown in that currency, checkout can happen in that currency, it's all great.

 

But the next time the user returns, the currency is back at default. Is there a way to force osC to remember the last-used-currency?

 

My problem is between USD and CAD. Lots of users can *forget* that CAD is displayed with a C$ prefix, and the next time they log in, might assume "whoa, prices have been reduced across the board... let me buy this, and that, and this..."

 

Only to have a rude shock when they realize (perhaps too late) that they're going to be billed in USD.

[MarcoZorro]

Yes this can be done...

 

The easiest way is to add an extra field to the customer table where you can store the customers preference for the currency when they log in.

[raddygast]

Yes this can be done...

 

The easiest way is to add an extra field to the customer table where you can store the customers preference for the currency when they log in.

<{POST_SNAPBACK}>

 

I don't know much about SQL and php. I could probably look it up and figure out how to do it, but I wouldn't know how to force the site to actually use this value.

[boxtel]

Simple question. User can switch from default currency to a non-default one, like CAD, AUD, GBP, EUR, whatever. Prices are shown in that currency, checkout can happen in that currency, it's all great.

 

But the next time the user returns, the currency is back at default. Is there a way to force osC to remember the last-used-currency?

 

My problem is between USD and CAD. Lots of users can *forget* that CAD is displayed with a C$ prefix, and the next time they log in, might assume "whoa, prices have been reduced across the board... let me buy this, and that, and this..."

 

Only to have a rude shock when they realize (perhaps too late) that they're going to be billed in USD.

<{POST_SNAPBACK}>

 

I simply use a cookie for all.