I'm importing products from 1.7 into 1.9 but the product id #s have changed. How do I fix this?

  • From csv ? in csv check entity_id column because csv use sku Nov 10, 2015 at 18:31
  • is it a new version of 1.9 or are you importing to an existing version? Nov 10, 2015 at 18:55
  • ver. @brentwpeterson
    – yldziner
    Nov 10, 2015 at 19:19
  • @yldziner so you have an existing version of 1.9.1 with orders, products and customers that you already have in production... is this correct? Nov 10, 2015 at 19:20
  • @brentwpeterson The 1.9 install is dev mode. I imported the products from the LIVE 1.7 site and the product id #s changed. I tried to change the entity_id in the database but then the product's html page gets a 404 error, so that does not seem to work.
    – yldziner
    Nov 10, 2015 at 19:50

1 Answer 1


You just don't change the product id's. Those are PRIMARY KEY values from the Magento database.

If you hardcoded product id's somewhere in the code, change it to SKU.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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