How to change starting ORDER ID

[hekg]

Hi al, I just started with whmcs and I don't the first invoices to start with order id 1, etc. I would like to start my order id's with 1000 for example.

Thanks

[hekg]

Hi al, I just started with whmcs and I don't the first invoices to start with order id 1, etc. I would like to start my order id's with 1000 for example.

Thanks

I was wondering why nobody had replied yet and then I noticed how horribly I worded my question

 

So what I'm trying to accomplish is a way to choose what my ORDER ID numbers begin the incremental count with so that they do not start at number 1. Also, how do I do the same for CUSTOMER ID?

 

Cheers

[tripler]

General Settings > Invoices

 

Dont kknow about CID, I dont think there's a time when they can see that.

[wsd]

If you have access to phpMyAdmin then select tblclients and click on Operations

set so AUTO_INCREMENT to the number you want to start with

[othellotech]

So what I'm trying to accomplish is a way to choose what my ORDER ID numbers begin the incremental count with so that they do not start at number 1. Also, how do I do the same for CUSTOMER ID?

Why ? What do you think it will accomplish ?

[wsd]

Now I can't answer what hekg will accomplish.

 

But I've had to do it because there are other systems I use requires a example. invoice ID is at least 4 digits, and there are certainly many other reasons.

 

My clients all have an 8 digit customer number, for it is their phone number, and the people can always remember their phone number

[othellotech]

yes, but what do they want to change the *Order* id for - clients never see it, hence asking what they are trying to accomplish

[hekg]

Hi guys, thanks for all the replies. I was trying to accomplish preventing my clients from seeing the single digit numbers of the order ids and customer ids but I realized that I was looking at admin emails of my test orders and not the actual customer order emails that I was testing with. I now see that actual customer emails only show invoice numbers and not those other numbers that I thought were included too.

 

Thanks again,

[gindo]

# mysql -uroot -pusername

# >use whmcs_database;

# >ALTER TABLE `tblorders` AUTO_INCREMENT =5000;

 

5000 you change it to the number you desired for next order