Zero prices issue
Today one of our valued customers has reported an interesting problem with their osCommerce web site. It happens only when an online store supports multiple currencies, and seems to be present in all osCommerce online stores.
For example an osCommerce online store supports $ and €. And those two currencies are specified in the Administration panel, and their currency codes are set as USD and EUR correspondingly.
If a customer types currency=usd or currency=eur in the URL, all prices on the web site will turn into 0 (zero). At the same time, typing something like currency=zzz will make the online store choose default currency. So we can say the problem only appears when somebody is trying to mess around the case of the currency code.
As we said above, the problem is present in almost all osCommerce - based online stores. These two are probably the most known ones:
http://www.google-store.com/index.php?currency=usd
http://demo.oscommerce.com/index.php?currency=usd
The issue affects not only product prices in osCommerce, but shipping and surcharge prices as well.
Fortunately, it’s not a major problem as everyone can identify an order with zero order total and contact the customer to get this sorted. There is also a straight-forward fix for this problem. It can be seen at http://forums.oscommerce.com/index.php?showtopic=145918&st=0 (scroll down to post #7 or #8).
Should you experience issues in having this fixed in your online store - just let us know and Holbi will be glad to be of help!
April 27th, 2007 at 12:39 pm
Hi,
I’m from Realex Payments and we currently have a module for OSCommerce which works fine except when “Select Currency” is used in the admin payment section.
Once this option is selected, the customer can select the currency they want to use and this changes the amount on the website. When they continue on with the payment and they are redirected out to our payment page, the currecy doesn’t pick up the session currency and the amount comes across to us as 0. Do you know if this is a known issue with OSCommerce or is there something we can implement in our module that will resolve it?
Thanks
Anne
April 30th, 2007 at 8:46 am
Hi Anne,
Thanks for your comments.
It may be an issue, which is specific to how your payment module is implemented. We can review the module if you send it to us - you may want to open our web site www.holbi.co.uk and submit your contact details and we will be in touch shortly.
Best regards,
Vadym Gurevych