Customer client id

[patrmich]

Hi,

My Prestashop version is 1.4.7.0

By default, Prestashop gives an id to each customer by incrementing of one unit the previous client id.

When the previous client id is 12845, the next client will have 12846 as id.

For various internal reason, we would like to have an id client in the following shape :

AAdddd, where d is a digit.

So one client could have an id as AA8230 and Prestashop should give to the next client an id of AA8231

So, how would it be possible to reach this goal ?

Thank You in advance for any help in this matter.

Patrick

[vekia]

hello

 

it isn't possible to do this, because ID field is based on INT (integer) with AUTO_INCREMENT value (auto increase value of ID for each new entry)

it mean that mysql database will not be able to increase non-integer values.

 

it's not bug of prestashop, this is how mysql database works