HomeHome Product Discus... Product Discus...SmithCartSmithCartSetting order idSetting order id
Previous
 
Next
New Post
7/21/2010 3:33 AM
 

I am about to put my site live but I dont want the order id starting at 11 (I have put through some tests) I would like it to start with a number around 2000 because our old shopping system finished near this number and it would be far easier for our accounts to have the next number not being a number already issued. Can you provide me with some SQL to specifify the next order id. Thanks.

 
New Post
7/21/2010 8:28 AM
 

In the table Smith_StoreOrders there is a field called OrderID which has a seed value of 1. I think if you change that seed value then your Order numbers will increment from the value that you input. I would wait to hear from Scott or Dave to make sure about this, but that might be the solution.

-Ricky

 
New Post
7/21/2010 10:27 AM
 

Yes you can change the seed for the order id see the following forum post:

https://www.smith-consulting.com/foru...

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartSetting order idSetting order id