I truncate all products tables but still product id not starting from 1. which query i'll run ? i want to start product id from 1. i'm working on localhost.

enter image description here


First run this query to delete all products

DELETE FROM `catalog_product_entity`;

then run below query to start product id from 1

ALTER TABLE `catalog_product_entity` AUTO_INCREMENT =1

and then create product. Id will be start from 1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.