Easystore - how to reset products ID after deleting all products - Forum | JoomShaper
Solved EasyStore

Easystore - how to reset products ID after deleting all products

Asked by NiroC 11 months ago Last activity 11 months ago

hi

please let me know how i can reset the ID number after deleting all products.

see below screenshot.

i do not have 255 products shows in the ss. it shows 255 because i deleted products multiple times..
may i know how i can reset?

Accepted answer

Marked as the solution
Ziaul Kabir Staff
11 months ago

Hi,

Thank you for reaching out.

In EasyStore, product IDs are auto-incremented in the database, so even if you delete products, the next product added will continue from the last highest ID. That’s why you’re seeing 255 even though there are no products.

Currently, there’s no built-in option in the EasyStore admin panel to reset product IDs. Resetting the ID sequence would require direct database access and running an SQL command to reset the auto-increment counter.

⚠️ Important: Modifying the database directly can cause issues if not done carefully. Make sure to back up your store before attempting this.

Best regards,

2 more replies

Oldest first Newest first Most helpful
NiroC Asked this
11 months ago

please consider add feature to resetting counter when a user delete items ,in your next version.

thanks

NiroC Asked this
11 months ago

ok?

Ziaul Kabir Staff
11 months ago

I will forward this to our feature list.

Thank you for your understanding.

Best regards,

Log in to reply.