[Solved] How to change the counter used for Customer's IDs?

[PariGupta]

Hi,

 

I want to change all the customer's id. For eg. it starts with 1, 2,3....... but i want that it start with 1001 or something else. I can change the auto increment value but the problem is that i want to change all my old customer's id and want that they all starts with 1001, 1002,1003......

 

Any one can tell me.. how to do this????

[Bruno Leveque]

Hi PariGupta,

 

This can be done easily by editing the AUTO_INCREMENT value of the ps_customer table in your database (This will be applied only for new customers).

 

 

Regards,

[PariGupta]

thanks!! Done it already.