First order number

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Prolly easy, I'm sure...
We are migrating from one site to another...hopefully propogating this weekend.  If I want to start off with another order number other then one, where would I change that?  I'd like to start semi close to where we left off.

Thanks!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ISTNC Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-June-2006 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote ISTNC Report Post Thanks(0) Quote Reply Topic: First order number Posted: 27-June-2006 at 4:43pm
	Prolly easy, I'm sure... We are migrating from one site to another...hopefully propogating this weekend. If I want to start off with another order number other then one, where would I change that? I'd like to start semi close to where we left off. Thanks!
	Gwen Roberts Integrated System Technologies, Inc. http://8.7.225.154/storefront.htm (til live)

anna42 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-March-2006 Status: Offline Points: 0	Post Options Post Reply Quote anna42 Report Post Thanks(0) Quote Reply Posted: 27-June-2006 at 4:48pm
	Hi ISTNC! Adjust this under Store Management Tools, General Settings, Store Settings --> Order Number Increase --> choose whatever number you want to start with. Best wishes, Anna, Sweden

ISTNC Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-June-2006 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote ISTNC Report Post Thanks(0) Quote Reply Posted: 27-June-2006 at 4:51pm
	Couldn't be any easier then that. I was in there, but missed that part. Thank you.
	Gwen Roberts Integrated System Technologies, Inc. http://8.7.225.154/storefront.htm (til live)

netprofits Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 05-January-2006 Location: United States Status: Offline Points: 22	Post Options Post Reply Quote netprofits Report Post Thanks(0) Quote Reply Posted: 27-June-2006 at 5:02pm
	Just a note. If you are copying an exsiting SQL database, the Order Number Increase will only add to whatever the current sequential ID # is in the orders table. For example, if you have been testing and already placed 10 orders, and you set your Order Number increase to be 1000, then the next order placed will show as 1011. Even if you clear out your old orders, SQL retains the next available sequential ID. If you want to reset the identity value for a SQL table, check out the DBCC CHECKIDENT function in "SQL Server books online".
	NetProfits Internet Consulting Certified ProductCart Developer Our Site

ISTNC Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-June-2006 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote ISTNC Report Post Thanks(0) Quote Reply Posted: 27-June-2006 at 5:03pm
	Okay, thanks! I didn't know that, but it isn't a problem for me. I just wanted to differentiate from one site to the next.
	Gwen Roberts Integrated System Technologies, Inc. http://8.7.225.154/storefront.htm (til live)

BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply Posted: 16-September-2010 at 9:14am
	But note that the Order Number Increase doesn't REALLY change the idOrder in the database tables. It just adds the number to the actual order number for display in the control panel and in the e-mails/reports. If you're going to do any direct access of the database, or importing a file of exported order data into a warehouse management system, be aware of this.