Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Harrison 42 posts 254 karma points
    Feb 02, 2023 @ 16:57
    Harrison
    0

    Customer order successful, but no reference on site/in the database

    Hey,

    Bit of a weird one.

    Been running Vendor for 2 years now and never seen this issue

    A customer placed an order today. The order went through fine to Stripe, and in Stripe I can see the Metadata with the Order Id, the Order Number and the Order Reference.

    The issue is I can't see this order at all in the backoffice or in the database when I query the vendrOrder table (as a cart or finalised order), so now I'm not sure how the order would have gotten through that far, as every step of the checkout has a null check for the order and checks for empty orderlines, and will kick the user out of the checkout flow otherwise.

    I've recently implemented CookieBot on to the site, and conscious of that causing any issues with the order session cookie? Although wouldn't strictly make any sense as I don't think it would have gotten all the way through the checkout if the cookie was being blocked by CookieBot?

  • Matt Brailsford 4125 posts 22222 karma points MVP 9x c-trib
    Feb 03, 2023 @ 08:37
    Matt Brailsford
    0

    Hmm, could it be a test order from a local development machine that could have accidentally been hooked up to the live Stripe API details?

  • Harrison 42 posts 254 karma points
    Feb 03, 2023 @ 13:39
    Harrison
    0

    It's a valid order, as we've had contact with the customer. I asked him some questions about his checkout experience, so waiting to hear back if he noticed anything odd.

    I appreciate it's an awkward question without debugging the code line-by-line, but it was more just a general "how is it possible" question.

    I've had a bunch of orders since then come through absolutely fine.

    I've hammered the checkout flow myself across multiple browsers with cookiebot implemented, and confident that doesn't seem to be causing issues, but will keep an eye out for it happening again.

  • Matt Brailsford 4125 posts 22222 karma points MVP 9x c-trib
    Feb 03, 2023 @ 13:46
    Matt Brailsford
    0

    I can't really see any reason why the order would completely disapear from the database and not even be there as a draft order.

    Best scenarios I can think of are:

    1. Did someone with back office access accidentally delete it? Deleted orders are hard deleted.
    2. Is there any code that performs order deltations that has gone wrong?
    3. Is the solution load balanced and was there a problem with the cache refresher such that the order occured but somehow was never persisted / the DB was put back into a previous state? (I doubt this would happen though without some kind of error)
    4. As per my previous suggestion, it's possible that the order was placed on a test system hooked up to live settings and so it appears in Stripe but not in the live system because it's the test system that ceated it.

    As I say, all other possible scenarios should leave some trace of the order in the database table so I would expect it to be findable via the Order ID

Please Sign in or register to post replies

Write your reply to:

Draft