Zen Cart Logo
Forums / Managing Customers and Orders / Changing the inital Customer Number generated

Changing the inital Customer Number generated

Locked

Views: 2,444

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
20 Mar 2009, 4:09 PM
#1
bouncerfl avatar

bouncerfl

New Zenner

Join Date:
Mar 2007
Location:
sunny Florida, USA
Posts:
80
Plugin Contributions:
0

Changing the inital Customer Number generated

HI all,
I'm pretty sure this will be an easy one:

How can I make my new ZC 1.3.8 install's customers start with a number other than 1?

Thanks in advance,
-Ray

20 Mar 2009, 4:30 PM
#2
stevesh avatar

stevesh

Black Belt

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

Re: Changing the inital Customer Number generated

Customers, or orders?

20 Mar 2009, 4:34 PM
#3
bouncerfl avatar

bouncerfl

New Zenner

Join Date:
Mar 2007
Location:
sunny Florida, USA
Posts:
80
Plugin Contributions:
0

Re: Changing the inital Customer Number generated

Customers. I do know how to change the order numbers if needed, but its customer's ID that I'd like to start with 1000 or something other than 1

TIA,
-Ray

20 Mar 2009, 10:45 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Changing the inital Customer Number generated

While it is NOT RECOMMENDED TO MESS WITH THESE SETTINGS,
you can go to phpMyAdmin and change the auto_increment value on the customers table to a number you desire, and must be higher than any existing value already in the table.

24 Mar 2009, 3:12 PM
#5
bouncerfl avatar

bouncerfl

New Zenner

Join Date:
Mar 2007
Location:
sunny Florida, USA
Posts:
80
Plugin Contributions:
0

Re: Changing the inital Customer Number generated

DrByte:

While it is NOT RECOMMENDED TO MESS WITH THESE SETTINGS,
you can go to phpMyAdmin and change the auto_increment value on the customers table to a number you desire, and must be higher than any existing value already in the table.

Thanks again, DrByte...I definitely understand your clear warning, but as we're using the customer number for something related to product licensing, I need it to be starting at a certain range.

This is a spanking new install, so there's nothing that I can't undo quickly if it blows up :) Are there specific things to avoid, or is this simply an incrementing field?

Thanks Again,
-Ray

24 Mar 2009, 9:22 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Changing the inital Customer Number generated

It's an incrementing field. You give it a starting number higher than that of any existing record in the table, and new records start from that value ... hence the term "auto_increment".