The sequence of indexation of orders goes down like this: orders are from 1-20 in order, then jumps to 40 and further in order for some time. And periodically this happens. Tell me, if someone came across a similar or knows the principle on which this index is affixed.

WooCommerce - Inconsistent Indexing


That's right, it should be. The order number is the record ID in the database. ID is an auto-increment surrogate key. "Missed" IDs can belong to revisions, drafts, media files, etc.


The order IDs are out of order as WordPress saves everything as a post. For example, each pages are posts, media files are posts, products are posts, orders are posts, and posts are posts. Each post is assigned a post_id. All of these posts (media, pages, posts, etc) use the same database table and because of that they can't share the same post ID.

If you want to have consecutive order numbers then I would recommend the following plugins:

Using the free version will allow you to start your order numbers from your last highest order number. For example, if your last order number was #4861, using this plugin will start your next order at #4862.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.