Currently running OPC 2.3.9, bootstrap 3.15., Zen 1.5.7c
I have had a weird "error" of sorts, and I'm not sure if it is something caused by OPC, or if it is an error with PayPal.
Yesterday I had a duplicate order that came through 2 seconds after the first. The below CURL log came through at the same exact time as the first order (personal information redacted by me with XXXX);
Could this be caused by a poor mobile connection? Or possibly the customer refreshing the page during payment processing?Code:2021-11-10 02:46:50 ------------------- (live transaction) --> https://api-3t.paypal.com/nvp Request Headers: Array ( [0] => Content-Type: text/namevalue [1] => X-VPS-Timeout: 90 [2] => X-VPS-VIT-Client-Type: PHP/cURL [3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(R) - PayPal/NVP [4] => X-VPS-VIT-Integration-Version: 1.5.7 ) Request Parameters: {DoDirectPayment} Array ( [ACCT] => ************XXXXX [AMT] => 99.79 [BUTTONSOURCE] => ZenCart-DP_us [CARDISSUE] => [CITY] => Portland [COUNTRYCODE] => US [CREDITCARDTYPE] => Visa [CUSTOM] => DP-23021-1636577207 [CVV2] => *** [EMAIL] => XXXXX [EXPDATE] => XXXXX [FIRSTNAME] => XXXXX [INVNUM] => 23021-1636577207-[sicassracingcom] [IPADDRESS] => 76.27.207.119 [ITEMAMT] => 84.9 [LASTNAME] => XXXXX [L_AMT0] => 44.95 [L_AMT1] => 39.95 [L_NAME0] => KTM Bar Mounted Hi/Lo/Off Headlight switch [316] Switch Type: 2005-20 KTM Factory Headlight *NOT 2007-20 EXC [L_NAME1] => KTM/HQV Front Brake Switch Kit - M10x1.00 [167] [L_NUMBER0] => 26-030T [L_NUMBER1] => 26-036 [L_QTY0] => 1 [L_QTY1] => 1 [NOTIFYURL] => https://sicassracing.com/store/ipn_main_handler.php [PAYMENTACTION] => Sale [PAYMENTREQUEST_0_PAYMENTACTION] => Sale [PHONENUM] => XXXXX [SHIPPINGAMT] => 14.89 [SHIPTOCITY] => Portland [SHIPTOCOUNTRYCODE] => US [SHIPTONAME] => XXXXX [SHIPTOSTATE] => XXXXX [SHIPTOSTREET] => XXXXX [SHIPTOZIP] => XXXXX [STATE] => XXXXX [STREET] => XXXXX [ZIP] => XXXXX [METHOD] => DoDirectPayment [CURRENCYCODE] => USD [USER] => XXXXXXXXXXXXXX [PWD] => **************** [VERSION] => 124.0 [SIGNATURE] => ****************************************************Nui4 ) Response: Array ( [TIMESTAMP] => 2021-11-10T20:46:50Z [CORRELATIONID] => 5a8445f99fbf3 [ACK] => Failure [VERSION] => 124.0 [BUILD] => 56068150 [L_ERRORCODE0] => 10536 [L_SHORTMESSAGE0] => Invalid Data [L_LONGMESSAGE0] => The transaction was refused as a result of a duplicate invoice ID supplied. Attempt with a new invoice ID [L_SEVERITYCODE0] => Error [AMT] => 99.79 [CURRENCYCODE] => USD [CURL_ERRORS] => ) DoDirectPayment, Elapsed: 2840ms -- Failure TIMESTAMP=2021%2d11%2d10T20%3a46%3a50Z&CORRELATIONID=5a8445f99fbf3&ACK=Failure&VERSION=124%2e0&BUILD=56068150&L_ERRORCODE0=10536&L_SHORTMESSAGE0=Invalid%20Data&L_LONGMESSAGE0=The%20transaction%20was%20refused%20as%20a%20result%20of%20a%20duplicate%20invoice%20ID%20supplied%2e%20%20Attempt%20with%20a%20new%20invoice%20ID&L_SEVERITYCODE0=Error&AMT=99%2e79&CURRENCYCODE=USD&CURL_ERRORS=
This has happened once before a few weeks back (on OPC 2.3.8), and 3 orders were processed through. All 1 second apart. Any insight would be greatly appreciated.
That could have been either of the conditions you listed. If you've got access to your site's "Raw Access Logs" (usually available via cPanel), you could search that log for the customer's IP address to see how they traversed through the site. That would also provide indication regarding the possibility of a "page refresh" during the checkout-process step.
Shoot... the server deletes the raw access logs every 24hrs. I made a change so it will archive them from now on. Thanks for the tip on how to look up what could be happening.
I have added additional payment method COD and it now allows to choose a payment method, but when clicking CONFIRM order, it recycles back to the cart with the message " Your order's details have changed. Please review the current values and re-submit."
No error log, no debug file.
webmaster tools - debugger displays no errors....
I'll PM you. May need some eyes on help.
Assuming that you've got a version of OPC later than v2.3.5 installed, this (https://github.com/lat9/one_page_che...ng_redirect.md) online document will guide you through the use of the developer-only admin tool that will identify the source of the redirect issue.
Thank you for the direction to the tool... here are my reports findings:
2021-11-11 23:41:22: Found a redirection back to checkout_one, difference follows.
'securityToken' => 'c80301d8585d8a00e171ae396fbf86b4', 'customers_host_address' => 'XXXXXXXXX', 'opc' => OnePageCheckout::__set_state(array( 'isGuestCheckoutEnabled' => false, 'registeredAccounts' => false, 'guestIsActive' => false, 'isEnabled' => true, 'tempAddressValues' => array ( 'ship' => array ( 'gender' => '', 'company' => '', 'firstname' => '', 'lastname' => '', 'street_address' => '', 'suburb' => '', 'city' => '', 'postcode' => '', 'state' => '', 'country' => 223, 'country_id' => 223, 'zone_id' => 23, 'zone_name' => 'Illinois', 'address_book_id' => 0, 'selected_country' => 223, 'country_has_zones' => true, 'state_field_label' => '', 'show_pulldown_states' => true, 'error' => false, 'error_state_input' => false, 'validated' => false, ), 'bill' => array ( 'gender' => '', 'company' => '', 'firstname' => '', 'lastname' => '', 'street_address' => '', 'suburb' => '', 'city' => '', 'postcode' => '', 'state' => '', 'country' => 223, 'country_id' => 223, 'zone_id' => 23, 'zone_name' => 'Illinois', 'address_book_id' => 0, 'selected_country' => 223, 'country_has_zones' => true, 'state_field_label' => '', 'show_pulldown_states' => true, 'error' => false, 'error_state_input' => false, 'validated' => false, ), ), 'guestCustomerInfo' => NULL, 'guestCustomerId' => 387, 'tempBilltoAddressBookId' => 409, 'tempSendtoAddressBookId' => 410, 'dbStringType' => 'stringIgnoreNull', 'customerInfoOk' => NULL, 'billtoTempAddrOk' => NULL, 'sendtoTempAddrOk' => NULL, 'isVirtualOrder' => false, 'billtoAddressChangeable' => true, 'sendtoAddressChangeable' => true, 'observerAliases' => array ( 'NOTIFIY_ORDER_CART_SUBTOTAL_CALCULATE' => 'NOTIFY_ORDER_CART_SUBTOTAL_CALCULATE', ), 'label_params' => ' class="inputLabel"', )), 'cartID' => '03036', 'cart' => shoppingCart::__set_state(array( 'contents' => array ( '388:02ceb4e351ae54ea1a80576b1c568b42' => array ( 'qty' => '1', 'attributes' => array ( 5 => '13', 2 => '6', ), ), ), 'total' => 9.5, 'weight' => 0, 'cartID' => '03036', 'content_type' => 'physical', 'free_shipping_item' => 0, 'free_shipping_weight' => 0, 'free_shipping_price' => 0.0, 'download_count' => 0, 'total_before_discounts' => 9.5, 'display_debug_messages' => false, 'flag_duplicate_msgs_set' => false, 'flag_duplicate_quantity_msgs_set' => array ( ), 'observerAliases' => array ( 'NOTIFIY_ORDER_CART_SUBTOTAL_CALCULATE' => 'NOTIFY_ORDER_CART_SUBTOTAL_CALCULATE', ), )), 'check_valid_prod' => true, 'language' => 'english', 'languages_id' => 1, 'languages_code' => 'en', 'layoutType' => 'legacy', 'currency' => 'USD', 'today_is' => '2021-11-11', 'updateExpirations' => true, 'antispam_fieldname' => 'M1Lwj46n2U', 'session_counter' => true, 'customers_ip_address' => '184.170.174.172', 'valid_to_checkout' => true, 'cart_errors' => '', 'emp_admin_login' => true, 'emp_admin_id' => 1, 'emp_customer_email_address' => 'XXXXX', 'customer_id' => '1', 'customers_email_address' => 'XXXXX', 'customer_default_address_id' => '1', 'customers_authorization' => '0', 'customer_first_name' => 'Kevin', 'customer_last_name' => 'XXXXX', 'customer_country_id' => '223', 'customer_zone_id' => '23', 'billto' => '1', 'sendto' => '1', 'shipping_weight' => 3.0, 'shipping' => array ( 'id' => 'storepickup_storepickup0', 'title' => 'Store Pickup (Store Pickup (Oak Park Temple - 1235 N Harlem Ave - Oak Park))', 'cost' => '0.00', ), 'cot_gv' => '0.00', 'order_current_total' => '0', ) '$9.50', )
Report completed.