Product
Store demo
Showcase
Features
Why for developers
Why for store owners
Industries
Fashion
Health & Beauty
Food & Beverage
Automotive
Industrial & Scientific
Furniture
B2B eCommerce
International
Downloads
Download nopCommerce
Marketplace
Translations
Copyright removal key
Mobile application
Web API
Support & services
Training
Documentation
Community forums
Premium support services
Request a quote
Contact us
Partners
English
English
Español
Deutsch
Russian
Français
Italiano
Português
Türkçe
简体中文
日本語
Tiếng Việt
Get started
Shopping cart
My account
Log in
Register
Home
>
Forums
>
General
>
General Support
>
Order ID increased by 1000
Order ID increased by 1000
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
leodemario
Total Posts:
271
Karma:
3003
Joined:
12/22/2009
Location:
Brazil
Posted:
7 years ago
Suddenly my Order ID increasing by one thousand each time.
I started in 1100 and go fine till 1532.
Then 1532 => 2533 => 3533 => 4534-4538 => 5538
What's going on?
kava
Total Posts:
276
Karma:
2101
Joined:
9/28/2012
Location:
Italy
Posted:
7 years ago
read here:
https://www.nopcommerce.com/boards/t/39419/order-id-problems.aspx
nayanpatel
Total Posts:
14
Karma:
116
Joined:
11/22/2016
Location:
India
Posted:
7 years ago
This Error mostly occurs when SQL server 2012 loses its pre-allocated sequence numbers.
Thus, the option is to use a sequence (with no caching)
In SQL instead of identity:
CREATE SEQUENCE MySeq AS
int
START WITH 1
INCREMENT BY 1
NO CACHE;
Thanks
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Still have questions or need help?
.
Premium support services
.
Get dedicated support from the nopCommerce team with a guaranteed response within 24 hours.
.
Online course for developers
.
Get the practical and technical skills you need to run and customize nopCommerce websites.