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
Printable View
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
Customers, or orders?
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
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
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".