How to reset ID number?

[lucoral]

Aloha!

 

Is there a way to reset the category, sub category, and product ID numbers which are automatically generated?

 

Thanks! Martin

[ukmacnut]

Hi - Did you ever find an answer to this? I wonder what it does to old orders. I really want to reset my ID numbers on my 1.3.7 Prestashop.

Thanks

 

David

[lucoral]

Aloha, David!

 

No, I haven't got an answer to this yet.

 

best, Martin

[DBMAN]

Well I've already been reminded about the various experience levels here but one way to do this (only way?) is to do it in your SQL table(s).

 

BACK UP YOUR SQL IN TOTAL!!!! (with "drop tables" so you can import right back to where you started) before you do anything like this but you can reset auto incrementing tables with this SQL command:

 

Go to the table and select the auto incrementing field. Select "operations" and you will see "AUTO_INCREMENT" and the next number. Set that to what ever you want to start with and click "go".

 

DO NOT DO THIS IF YOU ARE UNCOMFORTABLE IN ANYWAY but really there is no mystery to it and personally I think all site owners at some time should be comfortable with working within their database as it is very powerful and the heart of your Prestashop.

 

Of course the guts, veins, brain, etc. is Prestashop itself.....Merci' Beucoup! :D

 

Of course even if you forget to back up you can simply do the same procedure and put the old increment number in there to get back to where you were since all you have done is to edit that single table field.

Edited October 24, 2012 by DBMAN (see edit history)

[DBMAN]

Oh, if you have existing number you would want to reset to after the last number so they existing ones aren't overwritten.

[vekia]

ALTER TABLE prefix_category AUTO_INCREMENT=0;

 

or TRUNCATE the table (this mean that you delete all rows from table!)

 

TRUNCATE TABLE prefix_category

 

you must paste and run this code in some SQL managers like PhpMyAdmin etc.

[MaXi32]

Sorry for coming to the old post. I don't want to open the new post since this is related and not so important. Is there any side effects on the existing module functioning that can be found so far when resetting the category table to AUTO_INCREMENT=0 ?

I can see that some posts recommend to put it as AUTO_INCREMENT=3 (maybe due to prestashop default demo data is set to 3):