Order ID changes after Migration

[steelvintage]

Hi,

I just did a migration from M1 to M2.

In order for new orders not to start from 000000001 I added the last order Id (100022443) to the 'sequence_order_1' table. After making few purchases the order IDs were indeed correct.

However after making a third purchase the ID suddenly jumped to 2000000001.

Do you guys now how to fix it?

Thanks

Yuan

[linh_ng]

I think the main reason why the ID is significantly increased is that your clients bought products on store_id = 2. You can consult this document for details information: https://www.classyllama.com/blog/m2-incrementid