HOW TO: Set the Initial Order Number and Set a different Increment Value

Hi,

I have read much of the posts about setting Order Numbers, and thought it might help those struggling to solve this really simply problem.

OBJECTIVE
1) Launch your NopCommerce shop with an initial Order Number higher than 1.
2) Increment each Order Number by a value other than 1 (I use a low prime number).

REQUIREMENT
To obscure the number of orders being processed from your shopperts.

SOLUTION
Open the NopCommerce database and edit the Nop_Order table.
Edit the OrderId column and:
1) Set the Identity Seed value = whatever your want your Order Numbers to begin at.
2) Set the Identity Increment value = whatever value you want your Order Numbers to increase by.

I hope that helps.
Best Regards
Steve

When I open the database and select Nop_Order form the tables and then under action select edit only some of the
columes become open to edit.  The ID Inr and ID Seed do not allow me to edit them.  Any ideas.

I'm working on version 1.6

you need to 'open table definition' rather than 'show table data'


In VS (or VWD)

click 'orderID'

and find 'identity Specification'   in the 'column properties' window

you will see here where to edit

-hayden