Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2005
    Location
    Waikato, New Zealand
    Posts
    1,539
    Plugin Contributions
    3

    Default 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

    Code:
    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

  2. #2
    Join Date
    Sep 2005
    Location
    Waikato, New Zealand
    Posts
    1,539
    Plugin Contributions
    3

    Default 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
    Last edited by nigelt74; 28 Oct 2015 at 07:32 AM.
    Webzings Design
    Semi retired from Web Design

  3. #3
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default 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

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,475
    Plugin Contributions
    88

    Default 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:
    Code:
    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
    Code:
    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?

  5. #5
    Join Date
    Sep 2005
    Location
    Waikato, New Zealand
    Posts
    1,539
    Plugin Contributions
    3

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

    Quote Originally Posted by kobra View Post
    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

  6. #6
    Join Date
    Sep 2005
    Location
    Waikato, New Zealand
    Posts
    1,539
    Plugin Contributions
    3

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

    Quote Originally Posted by lat9 View Post
    There were a couple of fragments in the log you posted that caught my eye:
    Code:
    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
    Code:
    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

  7. #7
    Join Date
    Nov 2007
    Location
    Sunny Coast, Australia
    Posts
    3,379
    Plugin Contributions
    9

    Default 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?

  8. #8
    Join Date
    Sep 2005
    Location
    Waikato, New Zealand
    Posts
    1,539
    Plugin Contributions
    3

    Default 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

  9. #9
    Join Date
    Nov 2007
    Location
    Sunny Coast, Australia
    Posts
    3,379
    Plugin Contributions
    9

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

    Quote Originally Posted by nigelt74 View Post
    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.

 

 

Similar Threads

  1. Received Paypal confirmation, but no order...
    By cariclaire in forum Built-in Shipping and Payment Modules
    Replies: 37
    Last Post: 9 May 2007, 12:25 PM
  2. order received but notification of paypal payment is not received
    By b18cya in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 16 Apr 2007, 08:03 AM
  3. PayPal received but no order in system
    By martinr in forum General Questions
    Replies: 63
    Last Post: 14 Apr 2007, 03:59 PM
  4. WorldPay Issues - No record of order but received money
    By AndrewClarke in forum Addon Payment Modules
    Replies: 1
    Last Post: 9 Jul 2006, 12:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR