How to Re-use Deleted Product IDs?

[jessesmithproductions]

Can you refresh the list of used and unused Product ID numbers? That is, I’ve deleted products with the ID’s of 1, 2, 3, and 4, but when I add new products, they keep being assigned higher and higher ID numbers, instead of re-using 1, 2, 3 and 4.

Thanks

[Peter]

The plugin is designed to programatically “AUTO_INCREMENT” the product ID DB field number each time a new product is created.

Therefore there is no administrative way to reset this number.

The only way to reset this number to start from 1 is to drop the table but I wouldn’t recommend this because that would mean you would lose the products you already have and also you would probably need to drop all eStore tables due to the dependencies they have on one another.

This number is mainly used for internal use so I don’t really see why you would need to reuse the numbers?

You could manually log into your PHP MyAdmin and change a product ID value there if you really really need it. This video tutorial might help:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[jessesmithproductions]

Thanks!

[Author]

Posts