Skipping order id by 1 in Magento 2

Question

In our Magento 2 store suddenly order id has started skipping order id by 1.

Here is the order id example:

000000011
000000013
000000015
000000017
000000019

I went through multiple posts like magento-order-number-issue and magento-order-id-increment-jumps, and they say like due to failed/in-complete payment, or customer doesn't complete all checkout steps this issue might occur.

So my question is, it should happen only in the mentioned scenarios and from next order it should work fine if there isn't any issue, but in my case it always skips 1 order. I have observed this for around 100 orders.

Few posts also suggest due to abandoned cart this issue might occur so I have truncated quote tables using below query, still issue exists.

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;

SET FOREIGN_KEY_CHECKS=1;

How I can fix this?

Answer 1

After digging into the some articles I figured out, there is no other way to make increment by 2 than this:

Magento stores order auto increment id in sequence_order_1 or sequence_order_2 table, based on stores. So it uses only 1 increment id by default. Unless someone change auto_increment_increment value of database like:

SET @@auto_increment_increment=2;

Try this command and see if your auto increment value is fixed:

SET @@auto_increment_increment=1;

I didn't find any other solution.

Note: If you are getting this issue on order increment id and it is occurring due to auto increment value, then it would be occurring on all tables, because it's a global variable

Just wanted to help :)

Answer 2

Do check the value of step column in sales_sequence_profile table for meta_id (5 might be different but you need to check for the order one)