Missing orders with odd order IDs

  • Resolved seoenergy

    (@seoenergy)


    5 years, 11 months ago

    Every now and then we have missing orders. WooCommerce sends order notification on email, order gets processed by the payment gateway, but there is no order in the order list and I can’t see it in the database.

    This doesn’t happen with all orders, but only with some of them. The only thing missing orders have in common, that I have noticed, is that they have odd order IDs. What I mean by this is that last recordered orders have IDs 3942, 3944 and the missing orders have numbers that is like 50 numbers behind. Missing order from today was 3890.

    How is it possible that a newer order has smaller ID number then some of the previuos ones?

    A little background:
    Site was developed a few years ago and it hasn’t been updated for about 2 years. I am working on a redesign and update of the site copy right now.

    When company I work for took over, we transfered site to the new hosting. Old host sent us old database file without last 50 orders. Then I impotred missing orders with a plugin. Problem was that in the mean time a few new orders come in so some orders were not imported (plugin thought that they were already in). I’ve added those orders manually.
    A few days later store owner reported that some orders are missing from the order list.

    How can I make sure that every order has a greater number than the previous one?

    Do you have any idea how to fix this problem?

    • This topic was modified 5 years, 11 months ago by seoenergy.

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

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

    (@jessepearson)

    Automattic Happiness Engineer

    @seoenergy The difference in order numbers that you are seeing sounds like the orders are coming from two different sites. Orders are custom post types and go into the same database table as post, pages and products. If the database table is configured correctly, then each new post added should have a sequential ID added to it. It should never use earlier numbers, even if items were deleted.

    We can advise on how to look into that more, if needed. For now, can you confirm that the seemingly random orders are not from a second site? This is usually the case here.

    Plugin Support con

    (@conschneider)

    Engineer

    Hi there,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

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