I am using Magento CE My Store product catalog have 1245 products with last product id 1245.

Yesterday I uploaded new 5 products using Magmi which create new products with product ids 1246 to 1250. All these products were disabled so no order placed for these new products. Now due to some reason I need to delete these 5 products and upload (using Magmi) new 5 products.

How I can reset product id so new product ids start again from 1246?


Hy, you can do it directly from the mysql or phpAdmin,

ALTER TABLE catalog_product_entity AUTO_INCREMENT = 1246;

please check che spellingo of the table name and look for any db_prefix you may use

| improve this answer | |

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.