[SOLVED] Customer ID - minimum length

[anth.payne]

Looking at the database, the customer ID starts at 1 and increments from there. I am just wondering whether it is possible to set this start at a minimum of 6 digits?

I am looking at integrating the customer ID into a members card type system with ID being a barcode.

Thanks, Anthony

[nero_77]

Good question, I also would like to be able to do this for a customer. Any suggestions anybody?

Thanks..

[rocky]

The only way I can think of to do this is to run an SQL query using phpMyAdmin:

ALTER TABLE ps_orders AUTO_INCREMENT = 100000

This will start the next order at 100000.

[nero_77]

Hi Rocky, Thanks for the reply. I did figure this out after researching further and you are indeed correct. Excellent advice! I changed ps_order and started it at a random 6 digit number. I did the same for ps_customer. I tested with new orders and new customers and everything runs perfectly starting from the numbers I put it.

I did want to mention that it is important to check and change the other ps_order variants (I can't remember the names off the top of my head but like ps_order_detail etc, there's about 8 in total) - the ones that have anything 'auto_increment' need to be changed aswell to the same number as ps_order otherwise there will be discrepancies.

I think the person that started the thread can now put [sOLVED].

Just a note to anyone worried about touching the database, yes it can be daunting at first if you are new to it but work slowly and methodically and you will be fine. Also do a database backup first just in case!