This article provides a patch for the known Magento 2.2.3 issue related to getting errors when trying to import a
.csv file with products information, if there are products with same name.
.csv file with products information is imported, and there are products with same name, you get the the following error on the Check Data step: "URL Key XYZ was already generated for an item with the SKU %sku%" . The issued is cause by rewriting the products URL's during import, even there's no column for products' URLs in the imported
Steps to reproduce:
- Create two configurable products with the same name in Magento Admin.
- Create a
.csvfile to import data for those products, which has for example these columns:
- Go to System > Data Transfer > Import and select the
- Click Check Data.
No issues found, you can import the
.csv file successfully.
The following error message is displayed: "URL Key XYZ was already generated for an item with the SKU %sku%", it is not possible to import the file.
The patch is attached to this article. To download it, scroll down to the end of the article and click the file name, or click the following link:
Compatible Magento versions:
The patch was created for:
- Magento Commerce 2.2.3
The patch is also compatible (but might not solve the issue) with the following Magento editions and versions:
- Magento Commerce (Cloud) from 2.2.0 to 2.2.7, and 2.3.0
- Magento Commerce from 2.2.0 to 2.2.2, from 2.2.4 to 2.2.7, and 2.3.0
How to apply the patch
See How to apply a composer patch provided by Magento for instructions.