Are you running SQL server 2012?
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/3d256650-0e94-4d0f-8b52-0ba6e1903215
order id jupt form 940 to 1940
- 9
- 61
- 2012/10/22
- Australia
[quote=eadameg]can i set my order id back to 941
will it remmber to jump over the number that are already there?
Yes you can, BUT you will have a problem with the orders higher than 941 that already exist when the order id reaches them.[/quote
Can you tell me SQL table this settings are stored in? by mistake I set order id 10004 in admin but now it wont let me go back.. I had one order after that set in admin area, that order was cancelled and deleted from SQL table [dbo.order]...
Are there any other tables where Order id info stored?
Thanks for your help,
will it remmber to jump over the number that are already there?
Yes you can, BUT you will have a problem with the orders higher than 941 that already exist when the order id reaches them.[/quote
Can you tell me SQL table this settings are stored in? by mistake I set order id 10004 in admin but now it wont let me go back.. I had one order after that set in admin area, that order was cancelled and deleted from SQL table [dbo.order]...
Are there any other tables where Order id info stored?
Thanks for your help,
- 9
- 61
- 2012/10/22
- Australia
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.aspx
AndyMcKenna wrote:
2. Run SQL script. Thanks to linkXperts.
https://www.nopcommerce.com/boards/t/8455/restarting-order-id.aspx
linkXperts wrote:
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.aspx
AndyMcKenna 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.
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.aspx
linkXperts 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.
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.