Andrew Watson Posted October 1, 2014 Share Posted October 1, 2014 (edited) OK. I want the customer ID to start at 100,000 because it is sycning with an accounting package and will otehrwise overwrite exisitng customers. I saw that in Prestashop 1.5 I could change the "AUTO-INCREMENT" value in "ps_customers". But his doesn't seam to help. I can see in phpmyadmin the ?????????customer (where ???? is the randomly generated prefix) and can see the toggle of auto increment - but not how I can set the default value. What am I missing? Edited October 2, 2014 by nadie Moderation forum: Add word "Solved" the title of the topic (see edit history) Link to comment Share on other sites More sharing options...
Rolige Posted October 1, 2014 Share Posted October 1, 2014 You have the answer, just change the AUTO INCREMENT value of the customer table, set it to 100000, but if currently you have more than 100,000 DON'T do this. Link to comment Share on other sites More sharing options...
rafaelamargo Posted October 1, 2014 Share Posted October 1, 2014 ALTER TABLE name_table AUTO_INCREMENT = XXX; Link to comment Share on other sites More sharing options...
Andrew Watson Posted October 1, 2014 Author Share Posted October 1, 2014 I acn't see a table named "AUTO_INCREMENT" (thats probably the problem lol) - all I can se is A_I which is swithed ticked. I think I can't see the wood for the trees.... Link to comment Share on other sites More sharing options...
Andrew Watson Posted October 1, 2014 Author Share Posted October 1, 2014 If I list the columns in the customer table, I can see in the row "id_customer" under the column "Extra" it says "AUTO_INCREMENT" ... so I click "change" and it brings up a structur view, but I cant se where to change it... Link to comment Share on other sites More sharing options...
Rolige Posted October 1, 2014 Share Posted October 1, 2014 If I list the columns in the customer table, I can see in the row "id_customer" under the column "Extra" it says "AUTO_INCREMENT" ... so I click "change" and it brings up a structur view, but I cant se where to change it... You can do this in your phpMyAdmin, please see this screenshot: http://s30.postimg.org/bhseqd06p/auto_increment.jpg 1 Link to comment Share on other sites More sharing options...
jetx Posted October 1, 2014 Share Posted October 1, 2014 (edited) Or you can grab this mod: http://www.silbersaiten.de/prestashop/en/prestashop-modules/80-noumerique-bestellungs-und-kundennummer-manager.html Numerique is the name of it. Edited October 1, 2014 by jetx (see edit history) Link to comment Share on other sites More sharing options...
Andrew Watson Posted October 2, 2014 Author Share Posted October 2, 2014 Thanks very much EVERYONE who posted, it was the screeenshot I needed (I'm not exactly unfamiliar with phpmyadmin but I just couldn't see it). You were all correct and I was down the right path - now it's solved. I'm sure this thread will be valuable to others who want to increase the customer id number through phpmyamin. 1 Link to comment Share on other sites More sharing options...
Recommended Posts