How to start with a different customer ID

Submitted by deeperdata - 2 years ago

Another helpful database trick. I was looking for the best way to start a new series of customer IDs at a set increment. This method worked most effectively and involved a single query in MySQL. Here is the original source:

// Let's say you wanted to start with 5001
ALTER TABLE customer_entity AUTO_INCREMENT = 5001;

// That's it!!
Learn PHP
comments powered by Disqus
Proudly hosted on Digital Ocean