Select the search type
 
  • Site
  • Web
Search

DotNetNuke Knowledge Base

DotNetNuke Ecommerce FAQ

License Key Request

DNN Module Downloads

Smith Cart change log

Dotnetnuke Store Roadmap

DNN Support

 
Community Forum
Free Community Support

Please note - this is a Community Forum and is intended mainly as a community resource rather than an official method of contacting support but responses will be given whenever possible. For Urgent Support, refer to our Priority Support Page.
HomeHome Product Discus... Product Discus...Smith CartSmith CartSetting order idSetting order id
Previous
 
Next
New Post
7/21/2010 4:33 AM
 
Nathan Wright
10th Level Poster

Joined: 6/3/2010
Posts: 54

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 9:28 AM
 
Ricky Jones
10th Level Poster

Joined: 12/15/2009
Posts: 55

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 11:27 AM
 
Scott Kelly
1st Level Poster

Joined: 3/11/2010
Posts: 1674

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
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...Smith CartSmith CartSetting order idSetting order id