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.
Issue
When a .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 .csv file.
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:
sku|product_type|name|product_websites|store_view_code - Go to System > Data Transfer > Import and select the
.csvfile. - Click Check Data.
Expected result:
No issues found, you can import the .csv file successfully.
Actual result:
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.
Patch
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:
Download MDVA-12899_EE_2.2.3_COMPOSER_v2.patch
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.
Useful links
Apply custom patches to Magento Commerce (Cloud)