Duplicate [wp_cart_id] prevents sale from showing up in Cart Orders list

  • Resolved GAP Webmasters

    (@gapwebmasters)


    2 years, 7 months ago

    Hi–thanks for a great and simple plugin! We have had the following issue a few times (twice very recently): the ID issued automatically to each sale (I presume) by WP Simple Cart accidentally got used simultaneously for two different sales (within about an hour of each other), and as a result one did not show up in the Cart Orders on our site dashboard. We got email notices of the sale, and it went through Paypal fine, but only looking through the Log File ( ipn_handle_debug.txt ) allowed me to see that.

    Is there any way of preventing this in future? It has really messed us up a few times, because I compile a list of workshop participants using the Cart Orders list to tell me who has registered.

    Thanks for any tips on how to stop the duplication of the ID numbers (or eliminate ID numbers altogether; we don’t really use them systematically).

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi,

    We have had the following issue a few times (twice very recently): the ID issued automatically to each sale (I presume) by WP Simple Cart accidentally got used simultaneously for two different sales (within about an hour of each other), and as a result one did not show up in the Cart Orders on our site dashboard.

    This could happen if the shopper clicks twice the cart button by accident. It could also occur because of a glitch in PayPal services. A cache intermittence if any could also cause this issue. However it is not easy to pin point the cause of this issue because it has only happened a couple of times and you are the only person who has reported this issue so far.

    Please keep checking the log files and report back if it happens on a regular basis.

    Kind regards.

    We had it happen a few more times. The weblog looks like this–the wp_cart_id number for this sale was 10474, but then the subsequent sale (which is also in the weblog) says ITS number was 10474; the result from our end was that the FIRST payment (from Jennifer)) was never “noticed” and we never got a notification email for it – the second one, we did. But THIS FIRST one SAYS it successfully sent a notification email (but no one seems to have gotten it):

    [05/20/2022 7:55 PM] - SUCCESS :Paypal Class Initiated by 173.0.81.65
[05/20/2022 7:55 PM] - SUCCESS :Post string : mc_gross=... &first_name=Jennifer&mc_fee=1.19&address_country_code=US&address_name=Jennifer+&...&payer_email=XXXX%40gmail.com...&residence_country=US&shipping_method=Default&transaction_subject=&payment_gross=35.00&ipn_track_id=f4366348b5fb8&
[05/20/2022 7:55 PM] - SUCCESS :Checking if PayPal IPN response is valid
[05/20/2022 7:55 PM] - SUCCESS :Connecting to: https://www.paypal.com/cgi-bin/webscr
[05/20/2022 7:55 PM] - SUCCESS :IPN successfully verified.
[05/20/2022 7:55 PM] - SUCCESS :Creating product Information to send.
[05/20/2022 7:55 PM] - SUCCESS :Executing validate_and_dispatch_product()
[05/20/2022 7:55 PM] - SUCCESS :Custom field value in the IPN: wp_cart_id=10474&ip=75.172.86.193
[05/20/2022 7:55 PM] - SUCCESS :Payment Status: Completed
[05/20/2022 7:55 PM] - SUCCESS :Transaction Type: Shopping Cart
[05/20/2022 7:55 PM] - SUCCESS :Number of Cart Items: 1
[05/20/2022 7:55 PM] - SUCCESS :[[{"item_number":"","item_name":"Dreamy Paper Sculpture Landscape with Tiffany","quantity":"1","mc_gross":"35.00","mc_currency":"USD"}]]
[05/20/2022 7:55 PM] - SUCCESS :Item Number: 
[05/20/2022 7:55 PM] - SUCCESS :Item Name: Dreamy Paper Sculpture Landscape with Tiffany
[05/20/2022 7:55 PM] - SUCCESS :Item Quantity: 1
[05/20/2022 7:55 PM] - SUCCESS :Item Total: 35.00
[05/20/2022 7:55 PM] - SUCCESS :Item Currency: USD
[05/20/2022 7:55 PM] - SUCCESS :Custom values
[05/20/2022 7:55 PM] - SUCCESS :
Array
(
    [wp_cart_id] => 10474
    [ip] => 75.172.86.193
)
[05/20/2022 7:55 PM] - SUCCESS :Order post id: 10474
[05/20/2022 7:55 PM] - SUCCESS :Checking price. Original price: 35. Paid price: 35
[05/20/2022 7:55 PM] - SUCCESS :Applying filter - wspsc_buyer_notification_email_body
[05/20/2022 7:55 PM] - SUCCESS :Product Email successfully sent to [email protected]
[05/20/2022 7:55 PM] - SUCCESS :Applying filter - wspsc_seller_notification_email_body
[05/20/2022 7:55 PM] - SUCCESS :Notify Email successfully sent to [email protected], [email protected],[email protected],[email protected],[email protected]
[05/20/2022 7:55 PM] - SUCCESS :Updating Affiliate Database Table with Sales Data if Using the WP Affiliate Platform Plugin.
[05/20/2022 7:55 PM] - SUCCESS :Not Using the WP Affiliate Platform Plugin.
[05/20/2022 7:55 PM] - SUCCESS :Paypal class finished.

    In a related (?) series of incidents, we’ve sometimes been having payments go through Paypal with ALSO no notification coming at all through the Shopping Cart; I found the purchases in the weblog except for one recent one, which is not even there, just in Paypal.
    I’m looking into the Paypal settings.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    @jerrythemouse, please start a new support thread.

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Duplicate [wp_cart_id] prevents sale from showing up in Cart Orders list’ is closed to new replies.