9.5.1.0
541 201 9965 Email Website
Contents
Search:

Home > Security and Tech > Starting Order Number

Starting Order Number

Changing the Starting Order Number
 
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 (in admin console use Configuration - Run SQL), where 500000 is the number you want to use:

dbcc checkident(OrderNumbers, reseed, 500000)


Actions
Print This Article
Bookmark
Email This Article
Previous Article
Next Article