1000 record increase in order number sequence??

Hey everybody-

This isn't a big thing, but I'm scratching my head trying to figure out how it happened.
Today, our order number sequence jumped from 472232 to 473232 in the subsequent order.

Has anybody ever seen this happen? What causes it??

Thanks,
Steve

Hello,

Yes I had same problem few days ago.

At that time I just stop ii's and start again after suddenly jump this.

Still didn't understand why this happened.

V4.0

If you found than post here.!!

embryo wrote:

Hello, I've faced this issue in past. Actually this is not issue with nopCommerce code or anything.
It is something which is because of SQL Server.

Please refer URLs here and I am sure you must be able to fix it.

https://blog.sqlauthority.com/2018/01/24/sql-server-identity-jumping-1000-identity_cache/
https://blog.sqlauthority.com/2017/03/24/sql-server-jump-identity-column-restart/
https://stackoverflow.com/questions/17587094/identity-column-value-suddenly-jumps-to-1001-in-sql-server

Thanks

ajaysolanki wrote:

Thanks so much!

This has also been mentioned in the forums - e.g.

https://www.nopcommerce.com/boards/t/45480/order-id-increased-by-1000.aspx