Skip to content

Order number sequence

I’ve followed some online article to adjust the order number by editing the database table “sales_sequence_profile”. As I’ve got 2 different websites, I’ve make it into 3 different start_value: 10301, 30301, 70301, and setup the step as 7

I was expecting the number will be starting from 30301, then the next number will be 30308 for site 1. But in reality, the first order was numbered 00181799, the next order is numbered 00181792.

Can anymore can let me know why the starting value is not as set in the database. And the step why its going smaller but not getting a larger number each time? Thank you very much.