Improved Import & Export major update - full Google Sheets & Drive integration. Fixed price Magento 1 > Magento 2 migration service! EXPLORE

"duplicate url_keys"

How to solve Specified URL key already exists error during Magento 2 import

- E-Commerce, Magento 2

When creating or importing categories and products some may encounter Magento 2 error message ‘URL key for specified store already exists’. It may be the URL rewrites, database issue or other things not considered.

Anyways, if there is an error there will also be a solution. In this article we will talk about how to solve Magento 2 ‘URL key for specified store already exists’ error when importing products and categories to your store.

Continue Reading

Magento URL reindex (core_url_rewrite) duplicates patch

How to fix Magento URL reindex (core_url_rewrite) duplicates bug

There is one annoying problem in Magento – the url rewrite indexer creates tons of unnecessary custom rewrites for products with duplicate url_keys. This happens during every indexer run. As a result, the size of the core_url_rewrite table grows to enormous sizes. Please note that the problem is typical for Magento 1.7 – 1.9 and its above versions. Below, I will explain how to fix this bug with the help of our patch. But first of all let’s start with one real world example. Continue Reading