Title: Missing orders
Last modified: April 22, 2020

---

# Missing orders

 *  [rebelinc](https://wordpress.org/support/users/guerrillainc/)
 * (@guerrillainc)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/missing-orders-7/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fmissing-orders-7%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  [Rynald0s](https://wordpress.org/support/users/rynald0s/)
 * (@rynald0s)
 * Automattic Happiness Engineer
 * [6 years, 1 month ago](https://wordpress.org/support/topic/missing-orders-7/#post-12716388)
 * Hi [@guerrillainc](https://wordpress.org/support/users/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/](https://www.woocommerce.com/products/sequential-order-numbers-pro/)
 * Cheers!
 *  Thread Starter [rebelinc](https://wordpress.org/support/users/guerrillainc/)
 * (@guerrillainc)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/missing-orders-7/#post-12719462)
 * 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.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [rebelinc](https://wordpress.org/support/users/guerrillainc/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/missing-orders-7/#post-12719462)
 * Status: not resolved