Order Numbers Missing From Posts Table

  • Resolved webmuppet

    (@webmuppet)


    7 years, 7 months ago

    We’re using Woocommerce and noticed that the order numbers were not sequential and had some missing. On Googling we can see that the order numbers are derived from IDs from the Posts table, however, there is also nothing in the posts table for the missing IDs. Is this anything to be concerned about? Being an Ecommerce site we’re always wary.

Viewing 1 replies (of 1 total)
  • Peter Lawrenson

    (@lorro)

    7 years, 7 months ago

    The post object is used for lots of things – pages, posts, products, order, order refunds, attachments/images and others. Have a look at the post_type field in the posts table.

    If a post ID is missing in the posts table it means the relevant object has been deleted.

    It could mean one of your admins has deleted an order, so ensure you trust everyone who has the admin role.

Viewing 1 replies (of 1 total)

The topic ‘Order Numbers Missing From Posts Table’ is closed to new replies.