• 10.0.0 - 10.0.24
    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