Hello everyone,
Sorry I was little impatient, I should have (everyone in nop community should) search all forums little more in details, there are 99% chances to get the answer what you are looking for?
I must say most of nop community members go through search but some time it is difficult to get to the right post we are looking for...
Summary of what solutions I found here and useful tooo..
To restart the order to the number you like, just after your beta test of the website or if you like to reset to the number of your choice (BECAREFUL, do not reset to 1 or any number for which order is already set and received! You know what I mean..)
There are two ways.. (1 did not work for me, don't know why? anyway there is another way..2nd one worked for me!)
1. Thanks to AndyMcKenna.
https://www.nopcommerce.com/boards/t/14070/database-support-adding-x-to-order-number.aspxAndyMcKenna wrote:In SQL Mgmt Studio:
Right click on the Order table and select Design. With Id highlighted, scroll down to the Identity Specification area.
Identity Increment: How much to increment for each new order
Identity Seed: What value to start out at.
2. Run SQL script. Thanks to linkXperts.
https://www.nopcommerce.com/boards/t/8455/restarting-order-id.aspxlinkXperts wrote:Run the query below on your SQL Server.
Make sure you run it on the correct database and delete all records from the Nop_Order table.
DBCC CHECKIDENT('Nop_Order', RESEED, 1)
Where 1 is the next number to use for the seed.
If you want to set the next number to 201100001, for instance, change the 1 in the query according.