Magento – Category has not been created. URL key for specified store already exists

admincsvfile uploadmagento2product

I am trying to upload my stock through the Magento 2 admin panel via CSV.
I am getting the following error:

Category "Default Category/Aftermarket and Parts/Spare Parts/ Fasteners/Screws and Bolts/603-25008" has not been created. URL key for the specified store already exists. in row(s): 1076, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085

I have tried the following SQL queries to remove any potential duplicates:

delete FROM cataloginventory_stock_item 
where product_id not in(SELECT entity_id FROM catalog_product_entity);

But I still cannot upload my complete CSV file.

Best Answer

I faced the same issue. It was due to category name in the different cases like:

Aftermarket Or aftermarket

URL key for both these categories will be same. So double check category name, it can be same with case sensitive, which Magento does not allow.