4127 replies to this topic

[Soundloop]

Soundloop, on Apr 1 2005, 02:14 AM, said:

PAYPAL IPN Canadian Currency Code Problem

<{POST_SNAPBACK}>

I've managed to get this working.. changed the default currency in english.php, and
set everything to CAN.

Cheers,

TC

[Soundloop]

DISABLE PAYPAL TAXING THE SHIPPING AMOUNT?

Hi everyone,

I am running into a problem with the PayPal totals on orders.

I notice that with PP IPN module, Paypal is taxing on the shipping amount on the final payment screen. Is this normal? It seems to me that you wouldn't normally want to charge tax on shipping.

When customers use the option of sending a check/money order, there is no tax on the shipping amount..

Is there a way to disable this?

Cheers,

TC

[cirieh]

Hi all!
I have same problems with margin report 2.56 contrib both paypal IPN 3.0a.The contrib(margin report 2.56) work perfect with all kind of payment modules excluding Paypal.
For all orders made via paypal the "cost" of the products ordered will not be pass in the table:
Example:

Quote

Order ID Items Tot sells Cost Income
1647 1 35.90EUR 0.00EUR 35.90EUR  Paid via Paypal
1648 2 122.70EUR 0.00EUR 122.70EUR Paid via Paypal
1649 22 297.05EUR 114.60EUR 182.45EUR  Not Paid via Paypal
1650 2 20.99EUR 10.00EUR 10.99EUR Not Paid via Paypal

I just tried to mod the paypal_ipn.php(as suggested) adding the

'products_cost' => $order->products[$i]['cost'],

here

$sql_data_array = array('orders_id' => $insert_id,
                                  'products_id' =>tep_get_prid($order->products[$i]['id']),
                                  'products_model' => $order->products[$i]['model'],
                                  'products_name' => $order->products[$i]['name'],
                                  'products_price' => $order->products[$i]['price'],
                                  'products_cost' => $order->products[$i]['cost'],
                                  'final_price' => $order->products[$i]['final_price'],
                                  'products_tax' => $order->products[$i]['tax'],
                                  'products_quantity' => $order->products[$i]['qty']);

without any results.

where is the problem?

[Soundloop]

Soundloop, on Apr 1 2005, 06:58 AM, said:

I've managed to get this working.. changed the default currency in english.php, and
set everything to CAN.

Cheers,

TC

<{POST_SNAPBACK}>

I've figured out that my problem was within the Canada Post Shipping Module. I had it set to apply the tax zone to the shipping amount.. which was being passed to Paypal.

Cheers,

TC

[ExtraB]

Hello Everyone,

I was wondering if anyone is having the same problem as me. I am testing out the contribution in PayPal's Sandbox.

When PayPal sends out emails to me the PayPal account holder and to the customer. The total amount of the order is correct (shipping, taxes, item price, and tax on shipping for Canada where I am located)

However, When a breakdown of prices is shown the shipping cost is missing from the emails.... although the total amount charged by paypal is correct. I am worried that this will confuse customers.

Does anyone know what is going on or is anyone having the same problem?

Thanks
Eric B

[ifccnb]

Hello,
I'm having an issue with Encrypted Web Payments. I am using version:
OSC v2.2MS2 along with
12 Jan 2005 - osCommerce PayPal IPN Module v1.1 For 2.2MS2

I have read all 19 pages of this thread and have tried many suggestions that were posted.

This contrib installed fine and is working great with both the sandbox and live servers when "Enable Encrypted Web Payments" is set to false. But things get sticky when I set it to true... not sure where I'm going wrong.

Here is a quick check list of what I have done so far:
1)I have 2 test accts setup in my sandbox. One buisness acct. and one personal acct. both are confirmed and verified.
2)In the buisness acct. profile I have an API Test Certificate installed and downloaded the "cert_key_pem.txt" file.
3)I opened the "cert_key_pem.txt" file and noticed that both my private key and public cert are in there. So I followed some advice from another thread and split the file into 2 individual files. One named "my_private_key.pem" and the other "my_public_cert.pem"
4)Back in the sandbox buisness acct. profile/Encrypted Payment Settings/ I downloaded the PayPal Public Certificate "paypal_cert_pem.txt" I also went ahead and uploaded my public cert. "my_public_cert.pem" and wrote down the cert ID#
5)I uploaded the 3 files "my_private_key.pem", "my_public_cert.pem" and "paypal_cert_pem.txt" into a folder (CHMOD 700)
6)created a working directory (CHMOD 777)
7)used absolute paths and changed my openssl location (I confirmed this with my host) in the paypal IPN configuration.

Now when I go to order confirmation I don't get any php errors on screen as discribed in some previous posts. I just get an order confirmation page with no billing info. No "confirm order" button is showing up either. The order never makes it to the paypal sandbox server, but it does get recorder in the database. Also if it means anything, I do get files generating into my working directory named "***encrypted.txt" and "***signed.txt" but they don't get automatically deleted.

I believe I covered most, if not all, the steps. I also repeated steps 2-5 a few times.

Perhaps the problem is that I'm using the cert&key combo provided by paypal? I've read that could be an issue. RikR's suggested generating your own cert&key combo but my host doesn't have a cert manager in the control panel. Not sure how I can generate my own at this point.

Thanks in advance to whomever can point me in the right direction. Sorry for the long winded post... just wanted to explain myself as thoroughly as possible.

P.S. Hey RikR, how did ya manage to upload your "twowayradiodirectory.com.crt" file? Did you just have to change the extension to .pem? Paypal won't allow me to upload any other file type except for .pem
[img]http://ifccnb.home.comcast.net/example1.jpg[/img]
Here is how my paypal IPN is configured.

PayPal IPN 

Enable PayPal IPN Module
True

E-Mail Address
xxxxxxxx

Transaction Currency
Only USD

Payment Zone
--none--

Set Preparing Order Status
Preparing [PayPal IPN]

Set PayPal Acknowledged Order Status
Acknowledged [PayPal IPN]

Gateway Server
Testing

Transaction Type
Aggregate

Page Style


Debug E-Mail Address
debug@xxxxxxxx

Sort order of display.
1

Enable Encrypted Web Payments
True

Your Private Key
/home/xxxxxxxx/public_html/ztest/catalog/paypal_keys/my_private_key.pem

Your Public Certificate
/home/xxxxxxxx/public_html/ztest/catalog/paypal_keys/my_public_cert.pem

PayPals Public Certificate
/home/xxxxxxxx/public_html/ztest/catalog/paypal_keys/paypal_cert_pem.txt

Your PayPal Public Certificate ID
xxxxxxxx

Working Directory
/home/xxxxxxxx/public_html/ztest/catalog/paypal_temp/ 

OpenSSL Location
/usr/local/ssl

[colin272363]

Hi i have just installed paypal shopping cart IPN 3.1.5 and everything seems to be going smoothly only when the customer is directed to the secure paypal payment screen (with the login or checkout facility) the amount box is showing blank. Thus meaning the customer will have to remember the total from checkout then enter it to proceed.... Is there anyway to overcome this and have the total amount display automatically (carry it over from osc to paypal).

If any one out there has an idea i would be delighted to know -Colin

[Alpha Ray]

colin272363, on Apr 6 2005, 12:14 AM, said:

Hi i have just installed paypal shopping cart IPN 3.1.5 and everything seems to be going smoothly only when the customer is directed to the secure paypal payment screen (with the login or checkout facility) the amount box is showing blank. Thus meaning the customer will have to remember the total from checkout then enter it to proceed.... Is there anyway to overcome this and have the total amount display automatically (carry it over from osc to paypal).

If any one out there has an idea i would be delighted to know -Colin

<{POST_SNAPBACK}>

Hi Colin,

You might want to post your question in this thread: http://forums.oscommerce.com/index.php?sho...=116656&st=1600

I know, it's a little confusing sometimes.

Thanks.

Edited by Alpha Ray, 06 April 2005, 00:45.

[colin272363]

Alpha Ray, on Apr 6 2005, 12:44 AM, said:

Hi Colin,

You might want to post your question in this thread: http://forums.oscommerce.com/index.php?sho...=116656&st=1600

I know, it's a little confusing sometimes.

Thanks.

<{POST_SNAPBACK}>

---------------

Alpha Ray thank you very much for replying, however I just cracked it. If any one else has this problem ensure:

1) You have IPN enabled on your business paypal account

2) You have auto-returns enabled on your business paypal account

3) You admin currency codes are correct

4) Your payment module sorting codes are different (i.e paypal '1' PSIgate '2')

I dont know if all four steps are required however worked for myself using IPN 3.1.5.

Kind regards -Colin

[ExtraB]

Hi

Has anyone been able to answer my above post? When using the PayPal IPN Mod with the PayPal SandBox the emails sent out by PayPal are showing the correct totals for the orders ( price + tax + shipping) but on an individual break down it only shows the price and tax but the shipping amount is missing. Any ideas?

Does the fact that I have tax zones set for shipping have anything to with this... In Canada we have to charge tax on shipping.

Also, in the ADMIN area of OSC for Payment Mods... Under the PayPal IPN it says for my private key and certificate to use the extension *.pem

However, my host has sent me the keys and certificate and they have different file extensions....

Furthermore, they didn't tell me where on the server they are located... I am using a shared / virtual server.. .but I bought a SSL Certificate...

Do I need to know the path to these or can I just upload what then sent me into a directory in my OSC install and use those paths for settings in the config for this mod?

Please help as I am not very good with this and I have been spinnin my wheels for weeks

Thanks
Eric B

[ExtraB]

ifccnb, on Apr 5 2005, 08:11 AM, said:

3)I opened the "cert_key_pem.txt" file and noticed that both my private key and public cert are in there. So I followed some advice from another thread and split the file into 2 individual files. One named "my_private_key.pem" and the other "my_public_cert.pem"

ifccnb

I am not sure if this helps or not, as I am stumbling through all this myself... but I just asked for my private key and certificate from my host they gave me the following....

2 different certificates... the code or whatever that is.. sorry I don't know the term for it yet... but both certificates appear to be in one file... the file extension for this is mydomain.com.bundle

(So in answer to your question, I am not sure if you should be splitting the certificates apart or not... maybe someone in here can tell us...)

Second, I was given another certificate.. all by itself... called
mydomain.com.crt

and I was given one key
mydomain.com.key

The thing that confuses me is that the files sent by my host don't have the .pem file extension....

My host told me the certificates and key are already on the server... but I don't see them anywhere on the server... probably because I am using a shared server and they are in an area I can't access... could this be true?

In order to get this IPN Mod to work should I take each file above and rename the extension to .pem and then upload them to mydomain.com/catalog ?

I am trying to figure out what extensions to use.... and what paths... for the configuration in the ADMIN...

Any help would be GREATLY APPREACIATED...

Thank you
Eric B

[ExtraB]

ExtraB, on Apr 6 2005, 03:04 AM, said:

Hi

Has anyone been able to answer my above post? When using the PayPal IPN Mod with the PayPal SandBox the emails sent out by PayPal are showing the correct totals for the orders ( price + tax + shipping) but on an individual break down it only shows the price and tax but the shipping amount is missing. Any ideas?

Does the fact that I have tax zones set for shipping have anything to with this... In Canada we have to charge tax on shipping.

Also, in the ADMIN area of OSC for Payment Mods... Under the PayPal IPN it says for my private key and certificate to use the extension *.pem

However, my host has sent me the keys and certificate and they have different file extensions....

Furthermore, they didn't tell me where on the server they are located... I am using a shared / virtual server.. .but I bought a SSL Certificate...

Do I need to know the path to these or can I just upload what then sent me into a directory in my OSC install and use those paths for settings in the config for this mod?

Please help as I am not very good with this and I have been spinnin my wheels for weeks

Thanks
Eric B

<{POST_SNAPBACK}>

I just noticed that not only is the Tax not showing up in the PayPal emails but on the paypal sandbox site, when you are confirming your order... the taxes charged are not being displayed to the customer.. but they are added into the total amount charged....

IS this a problem with PayPals side, or OSC... if OSC is it this mod's coding or the way it is configured or is it something else?

sorry for all the questions.. like I said I am stumbling through it all and any help would be appreaciated.. thanks so much for your time

Eric B

[JERRY JULIANO]

Hi, I have a problem with my order status updating. What happens is some of my orders show up in OSC's admin panel but I never recieve payment for them in paypal.

It's only on certain orders, and I cannot find a common thread within them (some of the orders are from the US, some are international). For the most part orders come through fine.

I do not recieve the IPN email and never have. Long ago I decided to check my orders manually because I was wasting too much time trying to get the emails to work.

Can anybody provide me with some insight as to what might be happening here? At least, could someone tell me what I need tell my customers to do?

At first I thought this problem was due to customers not completing the order on paypal but i read that's exactly what this contrib was designed to prevent.

Any help is greatly appreciated. I've read all 19 pages of this thread and similar problems have arised with no answer...

[Soundloop]

JERRY JULIANO, on Apr 11 2005, 02:31 PM, said:

Hi, I have a problem with my order status updating.  What happens is some of my orders show up in OSC's admin panel but I never recieve payment for them in paypal.

It's only on certain orders, and I cannot find a common thread within them (some of the orders are from the US, some are international). For the most part orders come through fine.

I do not recieve the IPN email and never have. Long ago I decided to check my orders manually because I was wasting too much time trying to get the emails to work.

Can anybody provide me with some insight as to what might be happening here? At least, could someone tell me what I need tell my customers to do?

At first I thought this problem was due to customers not completing the order on paypal but i read that's exactly what this contrib was designed to prevent.

Any help is greatly appreciated. I've read all 19 pages of this thread and similar problems have arised with no answer...

<{POST_SNAPBACK}>

I am in the same boat, but I notice that if you take the transaction up to the Paypal login page, then don't complete the Paypal payment, it still shows up in the OSC orders list.

I am hoping that these are just uncompleted orders as the orders are not showing in the Paypal account on those.

Cheers,

TC

[JERRY JULIANO]

Hi TC - yeah this sucks! LOL.

That could be it, but it seems like most people know to log in, etc etc.
But, that very well could be what is happening.

Does anybody out there know???? Like maybe people get that far and they think the order is complete? Without even logging into their paypal accounts?

[ronr1999]

JERRY JULIANO, on Apr 11 2005, 09:34 AM, said:

Hi TC - yeah this sucks! LOL.

That could be it, but it seems like most people know to log in, etc etc.
But, that very well could be what is happening.

Does anybody out there know???? Like maybe people get that far and they think the order is complete? Without even logging into their paypal accounts?

<{POST_SNAPBACK}>

It's these issues and that the addresses are not being sent back to osC that I gave up on PayPal. Too much room for errors and confusion.

RR

[ExtraB]

Hi Soundloop and Jerry

I am actually working on installing this mod myself. I am not 100% sure but I think I have read either in this thread somewhere or in the documentation for this mod that if an order is filled out on your OSC site and continues to PayPal.. then the order is logged in OSC....

But if the customer abandons the transaction before paying through PayPal the order will remain in OSC. I think the only way around this is to manually check both OSC and PayPal to see that the order shows up in both.

If it is not in PayPal then I don't think you were paid.... and the order was not completed.

I hope someone else can confirm this as I am still testing and installing this mod and don't have enough knowledge to give a final answer.

I hope this has helped

Eric B

[Soundloop]

If it is not in PayPal then I don't think you were paid.... and the order was not completed.

I hope someone else can confirm this as I am still testing and installing this mod and don't have enough knowledge to give a final answer.

I hope this has helped

Eric B
[right]<{POST_SNAPBACK}>[/right]
[/quote]


Hi Eric,

That is my understanding from what I have found when testing (this is easy to test yourself).

If that isn't the case, then we have big problems and orders aren't going through..

Cheers,

TC

[sajiepaj]

Hello again

I am still having problems with the Paypal module: when I process an order, the payment goes through fine, and the order shows up in admin, but the cart is not emptied when coming back to the checkout_success page. There is no IPN information available in admin either, and the order is set to pending. If I pay using cheque everything works fine.

I'm trying to get this sorted for someone else and I'm going nuts trying to figure it out.

I have other contributions installed: STS Template system and the Option Type Feature - don't even know if these are affecting anything or not

Hey, if someone can fix this I'll even sign up as a sponsor

URL: TLC Favours
Username: user
Password: password


Sara

[PaulSymondsGolf]

Just a quick note to ask:

1. Where I can find my Private Key and my Certificate and the same for PayPal's Private Key and Certificate ID?
2. How long is the Certificate ID?
3. Do the certificates and Private Key have to be on your server or can they be remotely linked?
4. The .pem files - are they originally .pem files or do you have to rename them manually?

Many thanks for your help but I must stress that I need a response ASAP.

Cheers

Rob