Hi everyone,
Hoping someone can help before I pull all of my hair out! Using latest version of Zencart with Jul07 PayPal patch installed. Problem I am having is that whenever a customer orders by PayPal I get two orders added to the database - the first one is blank (only customer details; no products) and the second (which appears a few seconds later) does have the products on. Someone paid by echeck earlier today and that one only appears once but blank (may be a different problem?). I also don't seem to get any orders at all listed under the Custmers -> PayPal IPN in admin (not sure if I should see the orders there or not, but it's always empty).
No modules installed except a sales report tool downloaded from the contrib section.
Does anyone have any ideas - it's driving me mad. Here are the IPN logs from a sample order (each transaction appears to have 3 log files - not sure if that is relevant):
Sep 29 2007 22:43 -- Keys for submission: Array
(
[bn] => zencart
[cmd] => _ext-enter
[rm] => 2
[mrb] => R-6C7952342H795591R
[pal] => 9E82WJBKKGPLQ
[page_style] => Primary
[lc] => GB
[custom] => zenid=9lb5nd63p1tgps74lf86cj6mk7
[charset] => iso-8859-1
[return] => https://***/index.php?main_page=chec...referer=paypal
[cancel_return] => https://***/index.php?main_page=checkout_payment
[shopping_url] => https://***/index.php?main_page=shopping_cart
[notify_url] => https://***/ipn_main_handler.php
[redirect_cmd] => _xclick
[business] => ***
[first_name] => ***
[last_name] => ***
[address1] => ***
[city] => ***
[state] => 0
[zip] => ***
[country] => GB
[email] => ***
[H_PhoneNumber] => ***
[night_phone_b] => ***
[day_phone_b] => ***
[no_shipping] => 1
[currency_code] => GBP
[paypal_order_id] =>
[item_name] => *** Purchase
[item_number] => Store Receipt
[upload] => 1
[amount] => 4.00
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00
)
Sep 29 2007 22:43 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com
Sep 29 2007 22:43 -- IPN NOTICE :: ipn_application_top -> language files okay
Sep 29 2007 22:43 -- IPN INFO - POST VARS received (sorted):
Array
(
[business] => ***
[charset] => windows-1252
[custom] => zenid=9lb5nd63p1tgps74lf86cj6mk7
[first_name] => ***
[item_name] => *** Purchase
[item_number] => Store Receipt
[last_name] => ***
[mc_currency] => GBP
[mc_fee] => 0.34
[mc_gross] => 4.00
[notify_version] => 2.4
[payer_business_name] => ***
[payer_email] => ***
[payer_id] => 3J858QPYKJ8UW
[payer_status] => unverified
[payment_date] => 14:43:22 Sep 29, 2007 PDT
[payment_fee] =>
[payment_gross] =>
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receiver_email] => ***
[receiver_id] => X4WJWPNH2B3TG
[residence_country] => GB
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 3D7693465T4665109
[txn_type] => web_accept
[verify_sign] => AUkau1FwogE3kL3qo1vGTARqlijQA0MeACrk2sGzjhduw7lx8LQAPG8E
)
Sep 29 2007 22:43 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 739
Connection: close
Array
(
[payment_date] => 14:43:22 Sep 29, 2007 PDT
[txn_type] => web_accept
[last_name] => ***
[residence_country] => GB
[item_name] => *** Purchase
[payment_gross] =>
[mc_currency] => GBP
[business] => ***
[payment_type] => instant
[verify_sign] => AUkau1FwogE3kL3qo1vGTARqlijQA0MeACrk2sGzjhduw7lx8LQAPG8E
[payer_status] => unverified
[tax] => 0.00
[payer_email] => ***
[txn_id] => 3D7693465T4665109
[quantity] => 1
[receiver_email] => ***
[first_name] => ***
[payer_id] => 3J858QPYKJ8UW
[receiver_id] => X4WJWPNH2B3TG
[item_number] => Store Receipt
[payer_business_name] => ***
[payment_status] => Completed
[payment_fee] =>
[mc_fee] => 0.34
[shipping] => 0.00
[mc_gross] => 4.00
[custom] => zenid=9lb5nd63p1tgps74lf86cj6mk7
[charset] => windows-1252
[notify_version] => 2.4
[cmd] => _notify-validate
)
Sep 29 2007 22:43 -- IPN INFO - Confirmation/Validation response
SUCCESS
Sep 29 2007 22:43 -- Breakpoint: 1 - Collected data from PayPal notification
Sep 29 2007 22:43 -- IPN INFO :: Transaction email details.
From IPN = *** | ***
From CONFIG = ***
Sep 29 2007 22:43 -- Breakpoint: 2 - Validated transaction components
Sep 29 2007 22:43 -- Breakpoint: 3 - Communication method verified
Sep 29 2007 22:43 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.
Sep 29 2007 22:43 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0
Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 3D7693465T4665109
Sep 29 2007 22:43 -- Breakpoint: 5 - Transaction type (txn_type) = unique
Sep 29 2007 22:43 -- IPN INFO :: Currency/Amount Details:
PayPal email address = ***
| mc_currency = GBP
| submitted_currency = GBP
| order_currency = GBP
| mc_gross = 4.00
| converted_amount = 4.00
| order_amount = 4
Sep 29 2007 22:44 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 101
Connection: close
Array
(
[cmd] => _notify-sync
[tx] => 3D7693465T4665109
[at] => Rj-31**********bM-mq
)
Sep 29 2007 22:44 -- IPN INFO - Confirmation/Validation response
SUCCESS
Sep 29 2007 22:44 -- PDT Returned Data Array
(
[payment_date] => 14:43:22 Sep 29, 2007 PDT
[txn_type] => web_accept
[last_name] => ***
[residence_country] => GB
[item_name] => *** Purchase
[payment_gross] =>
[mc_currency] => GBP
[business] => ***
[payment_type] => instant
[payer_status] => unverified
[tax] => 0.00
[payer_email] => ***
[txn_id] => 3D7693465T4665109
[quantity] => 1
[receiver_email] => ***
[first_name] => ***
[payer_id] => 3J858QPYKJ8UW
[receiver_id] => X4WJWPNH2B3TG
[item_number] => Store Receipt
[payer_business_name] => ***
[payment_status] => Completed
[payment_fee] =>
[mc_fee] => 0.34
[shipping] => 0.00
[mc_gross] => 4.00
[custom] => zenid=9lb5nd63p1tgps74lf86cj6mk7
[charset] => windows-1252
)
Sep 29 2007 22:44 -- IPN INFO :: Transaction email details.
From IPN = *** | ***
From CONFIG = ***
Sep 29 2007 22:44 -- IPN INFO :: Currency/Amount Details:
PayPal email address = ***
| mc_currency = GBP
| submitted_currency = GBP
| order_currency = GBP
| mc_gross = 4.00
| converted_amount = 4.00
| order_amount = 4
Sep 29 2007 22:44 -- PDT NOTICE :: Order added: 27
PayPal status: Completed @ 14:43:22 Sep 29, 2007 PDT
Trans ID:3D7693465T4665109
Amount: 4.00 GBP
I've had a thorough Google, checked the FAQ's etc and tried everything I have come across (including installing/uninstalling the module, and the Express module as per the patch instructions).
Anyone any ideas?
Thanks in advance!
Bookmarks