Change the starting "Order Number" Prior to Launch

3 Sep 2007, 8:19 PM

#1

New Zenner

Join Date:: Aug 2007
Posts:: 94
Plugin Contributions:: 0

Change the starting "Order Number" Prior to Launch

... Title pretty much sums this one up. I want to change the beginning order number so that my customer doesn't get something like "Congratulations, you are Order #1!"

I'd rather select my own number, such as "0501" or something.

Anyone know how to do this? Thanks!!!

Alex

3 Sep 2007, 8:43 PM

#2

yellow1912

Totally Zenned

Join Date:: Oct 2006
Posts:: 5,422
Plugin Contributions:: 0

Re: Change the starting "Order Number" Prior to Launch

You will have to mess with mysql database.
Run this query:

ALTER TABLE tbl AUTO_INCREMENT = 51;

Where tb1 is the name of the order table (I cant remember its name)

5 Sep 2007, 1:15 AM

#3

bahnstoermer

New Zenner

Join Date:: Aug 2007
Posts:: 94
Plugin Contributions:: 0

Re: Change the starting "Order Number" Prior to Launch

Thanks!

9 Apr 2009, 3:40 PM

#4

zipperplug

New Zenner

Join Date:: Apr 2009
Posts:: 2
Plugin Contributions:: 0

Re: Change the starting "Order Number" Prior to Launch

Can someone explain to a non-techie how to do this?

I had a webdesigner set this up for me and I am now left on my own.

Is there a web-based solution to this issue, or do I have to buy some kind of software?

I don't even know where this "database" is stored. With my host?

ZP

9 Apr 2009, 4:15 PM

#5

stevesh

Black Belt

Join Date:: Feb 2005
Location:: Lansing, Michigan USA
Posts:: 19,793
Plugin Contributions:: 2

Re: Change the starting "Order Number" Prior to Launch

It's easier now. Check Admin - Tools - Store Manager

And yes, your database is stored on your hosting account.