Cart Total not carrying over to Paypal

[Guest]

This has been bugging me for a while. Using osCommerce 2.2 with latest Paypal IPN module.

When I try to confirm a checkout and go to paypal, the total is not brought over to the Pyapl page, it just shows $0.

 

I have tried to reinstall the entire oscommerce as well as the Paypal IPN. I have changed the currencies to match that of my paypal account (both USD and CAD on account). Neither USD or CAD seem to bring a total across to Paypal.

 

Looking at the HTML source during my checkout shows:

 

<form name="checkout_confirmation" action="https://secure.paypal.com/cgi-bin/webscr" method="post">

<input type="hidden" name="cmd" value="_xclick">

<input type="hidden" name="business" value="[email protected]">

<input type="hidden" name="item_name" value="XXX.com">

<input type="hidden" name="amount" value="0">

<input type="hidden" name="shipping" value="0">

<input type="hidden" name="currency_code" value="CAD">

<input type="hidden" name="return" value="http://www.xxx.com/catalog/checkout_process.php">

<input type="hidden" name="cancel_return" value="http://www.xxx.com/catalog/checkout_payment.php">

<input type="image" src="includes/languages/english/images/buttons/button_confirm_order.gif" border="0" alt="Confirm Order" title=" Confirm Order ">

</form>

 

Even in the source, the amounts and shipping are not being carried over from the OsCommerce Payment Information Page

or even the previous delivery option page, etc...

 

Does anyone know what might be going on here. I have tried multiple installations on multiple

servers at this point. It has to be something I overlooked in the config? but I can't figure it out.

 

Thanks in advance

 

Paul

[Guest]

OK, I think I have figured out the problem, I was using CDN for canadian dollar as opposed to CAD which paypal uses. However, not when I change the currency code in oscommerce from CDN to CAD all my product prices disappear. It's like they are expecting the old CDN code. I checked the products table, and I don't see any column for currency_id in there. The price is there...where is the currency specified for products?

 

Paul

 

 

This has been bugging me for a while. Using osCommerce 2.2 with latest Paypal IPN module.

When I try to confirm a checkout and go to paypal, the total is not brought over to the Pyapl page, it just shows $0.

 

I have tried to reinstall the entire oscommerce as well as the Paypal IPN. I have changed the currencies to match that of my paypal account (both USD and CAD on account). Neither USD or CAD seem to bring a total across to Paypal.

 

Looking at the HTML source during my checkout shows:

 

<form name="checkout_confirmation" action="https://secure.paypal.com/cgi-bin/webscr" method="post">

<input type="hidden" name="cmd" value="_xclick">

<input type="hidden" name="business" value="[email protected]">

<input type="hidden" name="item_name" value="XXX.com">

<input type="hidden" name="amount" value="0">

<input type="hidden" name="shipping" value="0">

<input type="hidden" name="currency_code" value="CAD">

<input type="hidden" name="return" value="http://www.xxx.com/catalog/checkout_process.php">

<input type="hidden" name="cancel_return" value="http://www.xxx.com/catalog/checkout_payment.php">

<input type="image" src="includes/languages/english/images/buttons/button_confirm_order.gif" border="0" alt="Confirm Order" title=" Confirm Order ">

</form>

 

Even in the source, the amounts and shipping are not being carried over from the OsCommerce Payment Information Page

or even the previous delivery option page, etc...

 

Does anyone know what might be going on here. I have tried multiple installations on multiple

servers at this point. It has to be something I overlooked in the config? but I can't figure it out.

 

Thanks in advance

 

Paul

[Guest]

I didn't think I'd ever get this one figured out by alas, all is fixed. For some reason once I changed the currency from CDN to CAD all the products lost their pricing with the different current. Not being able to find an attribute for currency for each product, I backed up the database to SQL, and vi'd the sql file changing all CDN to CAD. Restored the SQL file and voila...al is workinng even the Paypal totals are there now.

 

Is there an easier way to change currency code on products? I'd really like to know?

 

Thanks

 

Paul

 

OK, I think I have figured out the problem, I was using CDN for canadian dollar as opposed to CAD which paypal uses. However, not when I change the currency code in oscommerce from CDN to CAD all my product prices disappear. It's like they are expecting the old CDN code. I checked the products table, and I don't see any column for currency_id in there. The price is there...where is the currency specified for products?

 

Paul