If this is your first visit, check our documentation. To post, register or login.
Forums / PayPal Express Checkout support / Blank order in Zen, but Paypal saying money received

Blank order in Zen, but Paypal saying money received

Locked

Started by nigelt74 on 28 Oct 2015, 6:28 AM · Views: 1,487

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
28 Oct 2015, 6:28 AM
#1
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Location:
Waikato, New Zealand
Posts:
1,558
Plugin Contributions:
1

Blank order in Zen, but Paypal saying money received

Using Paypal Express

Had a blank order in Zencart, no items no shipping no total etc, but received an email with money from paypal

I do have logging turned on, but only seem to be getting logs with an ipn prefix

as below

Oct 28 2015 8:41 -- IPN PROCESSING INITIATED. 
*** Originating IP: 173.0.81.1  notify.paypal.com
*** Browser/User Agent: PayPal IPN ( https://www.paypal.com/ipn )

Oct 28 2015 8:41 -- Breakpoint: 0 - Initializing debugging.

Oct 28 2015 8:41 -- Breakpoint: Flag Status:
isECtransaction = 1
isDPtransaction = 0

Oct 28 2015 8:41 -- IPN INFO - POST VARS received (sorted):
Array
(
    [address_city] => Christchurch
    [address_country] => New Zealand
    [address_country_code] => NZ
    [address_name] => Zaphod Beeblebrox
    [address_state] => NOTPROVIDED
    [address_status] => confirmed
    [address_street] => 242 Rigel Road
Belfast
    [address_zip] => 8051
    [business] => [email protected]
    [charset] => windows-1252
    [custom] => EC-1688-1445992865
    [first_name] => zaphod
    [handling_amount] => 0.00
    [invoice] => 1688-1445992865-[MarvellousBarneys]
    [ipn_track_id] => 851a1a8faeb95
    [item_name] => 
    [item_number] => 
    [last_name] => beeblebrox
    [mc_currency] => NZD
    [mc_gross] => 157.95
    [notify_version] => 3.8
    [payer_email] => [email protected]
    [payer_id] => ZA2TPRA9HGXRG
    [payer_status] => unverified
    [payment_date] => 17:41:06 Oct 27, 2015 PDT
    [payment_gross] => 
    [payment_status] => Pending
    [payment_type] => instant
    [pending_reason] => multi_currency
    [protection_eligibility] => Ineligible
    [quantity] => 1
    [receiver_email] => [email protected]
    [receiver_id] => FJ39UCZH8WWEG
    [residence_country] => NZ
    [shipping] => 0.00
    [tax] => 0.00
    [transaction_subject] => 
    [txn_id] => 97E82984FJ533554H
    [txn_type] => express_checkout
    [verify_sign] => A.xwtm3dnXMJVD3Bkoxlt-UQlqnNA8H.aXIWHjqm3DHTdwFG21zAinwE
)


Oct 28 2015 8:41 -- IPN INFO - POST VARS to be sent back (unsorted) for validation (using CURL): 
To: www.paypal.com:80
Array
(
    [cmd] => _notify-validate
    [mc_gross] => 157.95
    [invoice] => 1688-1445992865-[MarvellousBarneys]
    [protection_eligibility] => Ineligible
    [address_status] => confirmed
    [payer_id] => ZA2TPRA9HGXRG
    [tax] => 0.00
    [address_street] => 242 Rigel Road
Belfast
    [payment_date] => 17:41:06 Oct 27, 2015 PDT
    [payment_status] => Pending
    [charset] => windows-1252
    [address_zip] => 8051
    [first_name] => zaphod
    [address_country_code] => NZ
    [address_name] => Zaphod Beeblebrox
    [notify_version] => 3.8
    [custom] => EC-1688-1445992865
    [payer_status] => unverified
    [business] => [email protected]
    [address_country] => New Zealand
    [address_city] => Christchurch
    [quantity] => 1
    [verify_sign] => A.xwtm3dnXMJVD3Bkoxlt-UQlqnNA8H.aXIWHjqm3DHTdwFG21zAinwE
    [payer_email] => [email protected]
    [txn_id] => 97E82984FJ533554H
    [payment_type] => instant
    [last_name] => beeblebrox
    [address_state] => NOTPROVIDED
    [receiver_email] => [email protected]
    [receiver_id] => FJ39UCZH8WWEG
    [pending_reason] => multi_currency
    [txn_type] => express_checkout
    [item_name] => 
    [mc_currency] => NZD
    [item_number] => 
    [residence_country] => NZ
    [handling_amount] => 0.00
    [transaction_subject] => 
    [payment_gross] => 
    [shipping] => 0.00
    [ipn_track_id] => 851a1a8faeb95
)


Oct 28 2015 8:41 -- CURL OPTS: Array
(
    [10002] => https://www.paypal.com/cgi-bin/webscr
    [47] => 1
    [10015] => cmd=_notify-validate&mc_gross=157.95&invoice=1688-1445992865-%5BMarvellousBarneys%5D&protection_eligibility=Ineligible&address_status=confirmed&payer_id=ZA2TPRA9HGXRG&tax=0.00&address_street=242+Rigel+Road%0D%0ABelfast&payment_date=17%3A41%3A06+Oct+27%2C+2015+PDT&payment_status=Pending&charset=windows-1252&address_zip=8051&first_name=zaphod&address_country_code=NZ&address_name=zaphod+beeblebrox&notify_version=3.8&custom=EC-1688-1445992865&payer_status=unverified&business=lita%40marvellousbarneys.com.au&address_country=New+Zealand&address_city=Christchurch&quantity=1&verify_sign=A.xwtm3dnXMJVD3Bkoxlt-UQlqnNA8H.aXIWHjqm3DHTdwFG21zAinwE&payer_email=zaphod.beeblebrox%40ispboogaloo.nz&txn_id=97E82984FJ533554H&payment_type=instant&last_name=beeblebrox&address_state=NOTPROVIDED&receiver_email=lita%40marvellousbarneys.com.au&receiver_id=FJ39UCZH8WWEG&pending_reason=multi_currency&txn_type=express_checkout&item_name=&mc_currency=NZD&item_number=&residence_country=NZ&handling_amount=0.00&transaction_subject=&payment_gross=&shipping=0.00&ipn_track_id=851a1a8faeb95
    [13] => 45
    [78] => 30
    [41] => 0
    [42] => 0
    [52] => 0
    [19913] => 1
    [64] => 0
    [81] => 2
    [75] => 1
    [74] => 1
    [84] => 2
    [10018] => Zen Cart(R) - IPN Postback
)


Oct 28 2015 8:41 -- CURL response: VERIFIED

Oct 28 2015 8:41 -- IPN INFO (cl) - Confirmation/Validation response VERIFIED

Oct 28 2015 8:41 -- Breakpoint: 1 - Collected data from PayPal notification

Oct 28 2015 8:41 -- Breakpoint: 2 - Validated transaction components

Oct 28 2015 8:41 -- Breakpoint: 3 - Communication method verified

Oct 28 2015 8:41 -- Breakpoint: 4 - Details:  txn_type=unknown    ordersID = 0  IPN_id=0

   Relevant data from POST:
     txn_type = unknown
     parent_txn_id = None
     txn_id = 97E82984FJ533554H

Oct 28 2015 8:41 -- Breakpoint: 5 - Transaction type (txn_type) = pending-multicurrency   [parentLookup=unknown]

Oct 28 2015 8:41 -- Breakpoint: 5 - midstream checkpoint

Oct 28 2015 8:41 -- IPN NOTICE :: This is a detailed-cart transaction

Oct 28 2015 8:41 -- IPN NOTICE :: This is a detailed-cart transaction (i)

Oct 28 2015 8:41 -- IPN WARNING :: Currency/Amount Mismatch.  Details: 
PayPal email address = [email protected]
 | mc_currency = NZD
 | submitted_currency = USD
 | order_currency = AUD
 | mc_gross = 157.95
 | converted_amount = 0.00
 | order_amount = 0

Oct 28 2015 8:41 -- Breakpoint: 5a - built order -- OID: 1630

Oct 28 2015 8:41 -- Breakpoint: 5b - PP table OID: Array
(
    [order_id] => 1630
    [txn_type] => pending-multicurrency
    [module_name] => paypal (ipn-handler)
    [module_mode] => IPN
    [reason_code] => 
    [payment_type] => instant
    [payment_status] => Pending
    [pending_reason] => multi_currency
    [invoice] => 1688-1445992865-[MarvellousBarneys]
    [mc_currency] => NZD
    [first_name] => zaphod
    [last_name] => beeblebrox
    [payer_business_name] => 
    [address_name] => Zaphod Beeblebrox
    [address_street] => 242 Rigel Road
Belfast
    [address_city] => Christchurch
    [address_state] => NOTPROVIDED
    [address_zip] => 8051
    [address_country] => New Zealand
    [address_status] => confirmed
    [payer_email] => [email protected]
    [payer_id] => ZA2TPRA9HGXRG
    [payer_status] => unverified
    [payment_date] => 2015-10-27 17:41:06
    [business] => [email protected]
    [receiver_email] => [email protected]
    [receiver_id] => FJ39UCZH8WWEG
    [txn_id] => 97E82984FJ533554H
    [parent_txn_id] => 
    [num_cart_items] => 1
    [mc_gross] => 157.95
    [mc_fee] => 
    [settle_amount] => 0
    [settle_currency] => 
    [exchange_rate] => 1
    [notify_version] => 3.8
    [verify_sign] => A.xwtm3dnXMJVD3Bkoxlt-UQlqnNA8H.aXIWHjqm3DHTdwFG21zAinwE
    [date_added] => now()
    [memo] => {Record generated by IPN} [ProtectionEligibility:Ineligible]
)


Oct 28 2015 8:41 -- Breakpoint: 5c - PP table OID saved

Oct 28 2015 8:41 -- Breakpoint: 5d - PP hist ID: 1283

Oct 28 2015 8:41 -- Breakpoint: 5e - PP hist_data:Array
(
    [paypal_ipn_id] => 1283
    [txn_id] => 97E82984FJ533554H
    [parent_txn_id] => 
    [payment_status] => Pending
    [pending_reason] => multi_currency
    [date_added] => now()
)


Oct 28 2015 8:41 -- Breakpoint: 5f - PP hist saved

Oct 28 2015 8:41 -- Breakpoint: 5g - new status code: MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID

Oct 28 2015 8:41 -- Breakpoint: 5h - newer status code: 2

Oct 28 2015 8:41 -- Breakpoint: 5i - order table updated

Oct 28 2015 8:41 -- Breakpoint: 5j - order stat hist update:Array
(
    [orders_id] => 1630
    [orders_status_id] => 2
    [date_added] => now()
    [comments] => PayPal status: Pending multi_currency @ 17:41:06 Oct 27, 2015 PDT
 Trans ID:97E82984FJ533554H
 Amount: 157.95 NZD
    [customer_notified] => 0
)


Oct 28 2015 8:41 -- Breakpoint: 5k - OSH update done

Oct 28 2015 8:41 -- Breakpoint: 5L - adding products

Oct 28 2015 8:41 -- Breakpoint: 5m - emailing customer

Oct 28 2015 8:41 -- Breakpoint: 5n - emptying cart

Oct 28 2015 8:41 -- Breakpoint: 6 - Completed IPN order add.    ordersID = 1630  IPN tracking record = 1283

Oct 28 2015 8:41 -- IPN NOTICE :: Pending multicurrency transaction for existing order. No action required. Waiting for merchant to "accept" the order via PayPal account console.

Webzings Design
Semi retired from Web Design

28 Oct 2015, 6:29 AM
#2
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Location:
Waikato, New Zealand
Posts:
1,558
Plugin Contributions:
1

Re: Blank order in Zen, but Paypal saying money received

should add

I have made two test orders since using paypal and both worked flawlessly

As you can see from the above its missing the item details

[item_name] =>
[item_number] =>

The logs for previous purchases and the subsequent ones all have the items where they should be, however just in this order it is blank

Webzings Design
Semi retired from Web Design

28 Oct 2015, 11:51 AM
#3
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Blank order in Zen, but Paypal saying money received

only seem to be getting logs with an ipn prefix
There should be four log files for each order

Zen-Venom Get Bitten

28 Oct 2015, 12:28 PM
#4
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,140
Plugin Contributions:
56

Re: Blank order in Zen, but Paypal saying money received

There were a couple of fragments in the log you posted that caught my eye:

Oct 28 2015 8:41 -- IPN WARNING :: Currency/Amount Mismatch.  Details: 
PayPal email address = [email protected]
 | mc_currency = NZD
 | submitted_currency = USD
 | order_currency = AUD
 | mc_gross = 157.95
 | converted_amount = 0.00
 | order_amount = 0

and

Oct 28 2015 8:41 -- IPN NOTICE :: Pending multicurrency transaction for existing order. No action required. Waiting for merchant to "accept" the order via PayPal account console.

What currencies have you configured PayPal to accept?

29 Oct 2015, 6:48 AM
#5
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Location:
Waikato, New Zealand
Posts:
1,558
Plugin Contributions:
1

Re: Blank order in Zen, but Paypal saying money received

kobra:

There should be four log files for each order

Where would i find these? as I am only finding one log file per order?

Webzings Design
Semi retired from Web Design

29 Oct 2015, 6:50 AM
#6
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Location:
Waikato, New Zealand
Posts:
1,558
Plugin Contributions:
1

Re: Blank order in Zen, but Paypal saying money received

lat9:

There were a couple of fragments in the log you posted that caught my eye:

Oct 28 2015 8:41 -- IPN WARNING :: Currency/Amount Mismatch. Details:
PayPal email address = [email protected]
| mc_currency = NZD
| submitted_currency = USD
| order_currency = AUD
| mc_gross = 157.95
| converted_amount = 0.00
| order_amount = 0

> and
> ```
Oct 28 2015 8:41 -- IPN NOTICE :: Pending multicurrency transaction for existing order. No action required. Waiting for merchant to "accept" the order via PayPal account console.

What currencies have you configured PayPal to accept?

Not sure will have to check, although we do regularly get clients from NZ (Its an Aussie site), but I assumed paypal automatically converted to the relevant currency

Webzings Design
Semi retired from Web Design

29 Oct 2015, 7:56 AM
#7
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: Blank order in Zen, but Paypal saying money received

Did a whois for 'marvellousbarneys.com.au' and 'ispboogaloo.nz' on my Linux box:

frank@Andromeda ~ $ whois marvellousbarneys.com.au
No Data Found
frank@Andromeda ~ $ whois ispboogaloo.nz
% NZRS Limited
% Users confirm on submission their agreement to all published Terms
%
version: 5.00
query_datetime: 2015-10-29T20:43:33+13:00
domain_name: ispboogaloo.nz
query_status: 220 Available
%
%

Both, Firefox and Chrome are unable to find that site either.

Then did a Google search for "marvellous barneys" - to no avail.

Next search was for the address 'rigel road christchurch 8051' - does not seem to exist.

Nigel, I reckon someone was playing dirty tricks.

Can you check the server log entries for the time of that order and trace the associated IP?

NOTE: We are sorry that Frank is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

30 Oct 2015, 5:15 AM
#8
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Location:
Waikato, New Zealand
Posts:
1,558
Plugin Contributions:
1

Re: Blank order in Zen, but Paypal saying money received

Whoops, Sorry those were me removing the site details and replacing them with bogus ones, i should have mentioned that etc

Webzings Design
Semi retired from Web Design

30 Oct 2015, 5:23 AM
#9
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: Blank order in Zen, but Paypal saying money received

nigelt74:

Whoops, Sorry those were me removing the site details and replacing them with bogus ones, i should have mentioned that etc

Makes sense.

Do you use PayPal Standard or PayPal Express?

If you set **Transaction Currency **in PayPal configuration to Only AUD or Only NZD then the whole order should go through with only the selected currency, regardless of the customer's choice when buying.

NOTE: We are sorry that Frank is no longer with us.
We are grateful for all his contributions to the Zen Cart community.