adding a client with prefix client ID

[LemonBarley]

i have 3 questions. sorry i am very new to WHMCS

 

1) how can i add a client into the client database with a prefixed client ID.

 

2) how can i make whmcs start the client number from a specific number like 5000.

 

 

3) can i make the customer number start with a C like the invoice number which start from from INV{NUMBER}

 

thanks for all your help.

[LemonBarley]

anyone there that can help? really need to know how to add a client with a pre assigned ID..

[LemonBarley]

anyone knows how? been waiting for 12 hours for an answer

[sharpora]

Bump - Can anyone / Staff answer these questions?..... I'm Interested to know this also.....

 

Thanks

[bullfrog3459]

i have 3 questions. sorry i am very new to WHMCS

 

1) how can i add a client into the client database with a prefixed client ID.

 

2) how can i make whmcs start the client number from a specific number like 5000.

 

 

3) can i make the customer number start with a C like the invoice number which start from from INV{NUMBER}

 

thanks for all your help.

 

1) dont believe you can

2) change the database in which number it starts from

3) No, not to my knowledge

 

Thanks

[othellotech]

First, a word of warning

IF YOU DONT KNOW WHAT YOU ARE DOING WITH SQL AND DATAASES YOU *WILL* SCREW UP YOUR SYSTEM AND LOSE ALL YOUR DATA

 

>1) how can i add a client into the client database with a prefixed client ID.

 

Add the client using WHMCS, and *BEFORE ADDING ANYTHING ELSE* use SQL to change the id

- refer to the 'word of warning' above for specific advice

 

>2) how can i make whmcs start the client number from a specific number like 5000.

Alter the auto-increment fieldon the table using SQL

 

>3) can i make the customer number start with a C like the invoice number which start from from INV{NUMBER}

No