Synopsis
Some sites want to start with a different order number than the default (10000)
Procedure
WARNING: This can have adverse effects on your data!! Back up all data before proceeding and test thoroughly afterwards.
The procedure is very simple, however there are a a few things to take into account. Your new seed (starting number) must either be higher than the highest existing order number, or you must take steps to remove all currently existing orders from within the store.
If you do not do this properly, there is the very real possibility that you could run into data consistency errors in the future. We recommend only performing this if there is a genuine need (such as integration with other software).
Run the following command against your ASPDNSF database, where 500000 is the number you want to use:
dbcc checkident(OrderNumbers, reseed, 500000)
|