Missing orders

  • I have orders missing on this customers site.
    It’s not a payment plugin’s fault, because it only supports payment to bank account.
    Customers have payed, referring to order numbers, but the webshop owner has not received an e-mail, and in the WooCommerce order list the orders are not present. It simply jumps numbers “9453-9454-9455-9458-9461”.
    On his bank statement there are payments referring to numbers that doesn’t exist, and customers can’t be aware of that number without finishing the order.
    I can’t get my head around this.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Rynald0s

    (@rynald0s)

    Automattic Happiness Engineer

    Hi @guerrillainc!

    Customers have payed, referring to order numbers, but the webshop owner has not received an e-mail, and in the WooCommerce order list the orders are not present.

    Order numbers are really just the post IDs that exist in the wp_posts table so what you can do is to find the order number from the email or where ever and search for it in the wp_posts table using a plugin like Adminer, to make sure the “post_type” is indeed “shop_order”

    If it is “shop_order” then it could be that the “post_status” is corrupt and in which case you can change it to wc-processing for it to become visible again in your order page.

    It simply jumps numbers “9453-9454-9455-9458-9461”.

    By default the order numbers are based on post ID. This is a unique number that WordPress uses for many things, such as posts, pages, categories, tags, products, product categories, comments and so on — WordPress will use the next available post ID for the next item it has to create.

    Order numbers are rarely sequential as other things are happening in WordPress which uses up the next ID. So an order will be assigned the next available post ID.

    If you prefer them to be sequential, you can use something like https://www.woocommerce.com/products/sequential-order-numbers-pro/

    Cheers!

    Thread Starter rebelinc

    (@guerrillainc)

    Thank you very much for taking your time to reply on this.
    Two problems arise, however:

    The plugin Adminer is no longer available, and I can’t seem to find an alternative.
    I’ve tried to peek into the Database (MySQL admin), to locate the numbers, but unfortunately I’m not smart enough to locate them.
    Now I have updated a lot of plugins, themes, etc., because my customer never took the time to do that. After that I’ve been placing test orders again, and the gab is more than 80 ID numbers.
    That says you’re right about how the gabs occure.

    But: Customers refer to order numbers that are in the gabs, when they call to ask “wtf is happening to my order”…?!?!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Missing orders’ is closed to new replies.