Update products using csv import but dont update url_key

Question

I have products on magento 2.4.0 now when I use product import (Add/Update & also replace) to update product data, it throws below error

Url key: 'this-is-product-url-key' was already generated for an item with the SKU: 'this-is-sku'. You need to specify the unique URL key manually in row(s):

In short I dont want to update url_key

I have tried adding field url_key with data in it(url_key which is already generated previously)

Also tried removing url_key field completely which is then throwing below error

The value specified in the URL Key field would generate a URL that already exists

& also tried adding field url_key with blank data

Can anyone please help looking into it.

Answer 1

Remove the url_key column from your CSV file and try the import again.

Answer 2

The check, that triggers this validation is in \Magento\CatalogImportExport\Model\Import\Product::isNeedToValidateUrlKey:

    /**
     * Check if need to validate url key.
     *
     * @param array $rowData
     * @return bool
     */
    private function isNeedToValidateUrlKey($rowData)
    {
        if (!empty($rowData[self::COL_SKU]) && empty($rowData[self::URL_KEY])
            && $this->getBehavior() === Import::BEHAVIOR_APPEND
            && $this->isSkuExist($rowData[self::COL_SKU])) {
            return false;
        }

        return (!empty($rowData[self::URL_KEY]) || !empty($rowData[self::COL_NAME]))
            && (empty($rowData[self::COL_VISIBILITY])
                || $rowData[self::COL_VISIBILITY]
                !== (string)Visibility::getOptionArray()[Visibility::VISIBILITY_NOT_VISIBLE]);
    }

So, if your CSV file contains name field the check will be triggered if item is visible or there is no visibility column.

To bypass this validation you could follow the first condition: CSV file should contain sku column, import behaviour should be append and product should be existed.

If you don't need to update product's name attribute try to remove this field from CSV file. This should help as well.