payment_method, currency, zero prices

[JWCravers]

A user processes a payment and suddenly the prices, including item prices on the order go to zero for that user. It's happening to all orders now. It seems a big hint as to what is going on is in the orders table. The problem transactions show bad entries in the following 3 fields ...

 

payment_method .. it should be "credit cards" or "check/money order". In it's broken state it reads "0.00"

 

currency .. It should be USD but in it's broken state it reads "US"

 

currency_value .. it should read "1" but in it's broken state reads "0". This is related to the currency not being USD, IMO.

 

I was thinking that the currency variable that was coming back from plugnpay (my payment provider) were not "USD" and so would not match up with the US dollars. They say they've checked and we are getting USD returned to us, in lower case. The payment _method could be causing this too. I believe that's internal to OSC but am not sure. It's seems like it would be one of these two things.

 

I've been working to identify this problem for a few days now. I sure would welcome any tips that anyone has.

 

BTW, the order process emails show zero dollars too, but the purchase confirmation emails show the correct total price.

 

Thanks for any tips anyone can offer.

[♥Vger]

They say they've checked and we are getting USD returned to us, in lower case.

 

osCommerce recognises USD in upper case. Not sure that it would recognise USD in lower case, but you can try editing includes/languages/english.php, and where you see 'USD' change it to 'usd' and see if it works.

 

Vger

[JWCravers]

Rhea,

 

Thanks for the thoughts. I'll give this a try and report back.