M 2.3.1

We are importing via Firebear. When I import I am getting success.. the product imports but I get this error:

URL key for the specified store already exists.

Whenever I try and SAVE products...

We had previously deleted products from the table with "delete from catalog_product_entity;"

If I change the URL key in the feed.. the import works ok and I can save the product...

How can I "clean up" my database so I can import the original feed with the original URL key and have it allow me to save the product.. without "URL key for specified store already exists" error?

  • Roughly how many products? – Dominic Xigen Aug 16 '19 at 20:11
  • Original feed was a few thousand.... Now after deleting them all am just trying to import one product to test the import and its giving me the error – Matt Ayres Aug 16 '19 at 20:14
  • If this is on a dev store may be worth truncating url rewrite table and letting magento index process regenerate url keys and then see what happens. I believe there have been a few issues resolved in journey up to version you are currently using so there could be an underlying issue github.com/magento/magento2/issues/7298 – Dominic Xigen Aug 16 '19 at 21:06
  • Delete the WHOLE table? Won't that break other things? Yer is dev site..... – Matt Ayres Aug 16 '19 at 21:12
  • Try to truncate catalog_url_rewrite table. – Anas Mansuri Aug 16 '19 at 23:51

Yep removing the product url rewrites fixed it for me.

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.