Import CSV product information for same name product fails

This article provides a patch for the known Adobe Commerce 2.2.3 issue related to getting errors when trying to import a .csv file with products information if there are products with the same name.

Issue

When a .csv file with products information is imported, and there are products with the same name, you get the following error on the Check Data step: "URL Key XYZ was already generated for an item with the SKU %sku%". The issue is caused by rewriting the products’ URLs during import, even when there’s no column for products’ URLs in the imported .csv file.

Steps to reproduce:

  1. Create two configurable products with the same name in the Commerce Admin.
  2. Create a .csv file to import data for those products, which has for example these columns: sku | product_type | name | product_websites | store_view_code
  3. Go to System > Data Transfer > Import and select the .csv file.
  4. 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 Adobe Commerce versions:

The patch was created for:

  • Adobe Commerce on-premises 2.2.3

The patch is also compatible (but might not solve the issue) with the following Adobe Commerce editions and versions:

  • Adobe Commerce on cloud infrastructure from 2.2.0 to 2.2.7, and 2.3.0
  • Adobe Commerce on-premises 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 Adobe Commerce in our support knowledge base for instructions.

Apply custom patches to Adobe Commerce on cloud infrastructure

Attached Files

recommendation-more-help
8bd06ef0-b3d5-4137-b74e-d7b00485808a