Skipping order id by 1 in Magento 2
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 :)
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)