How to delete product id?

[williamtlhor]

I have 5 products listed on my website and i wanted to delete all of them. When i tried to create a new product, my product ID did not starts with product ID 1 but instead starts with product id 6. How to i make the product ID starts with 1 again?

[Peter]

Hi,

This is normal behaviour and is happening because the product ID field in the database is set to “AUTO_INCREMENT”.

This should have no negative effect on any new products you create.

Why do you want to reset this value?

Resetting it can be achieved by dropping the table using phpMyAdmin but I wouldn’t recommend jumping in and doing it since this can get tricky because the table which contains the product ID will most probably be referenced by other tables.

[Author]

Posts