1

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.

0

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.

  • 1
    Thanks I have looked at this and it doesn't seem to solve the problem. – Deadulus Oct 3 '17 at 14:12
0

RE: Magento 2.2.5
Well, I am gradually importing 120,000+ stocklines and every day I come across issues.
It turned out somehow I had duplicated some categories and I deleted the extra ones however importing still got an error again on one stockline with 90 categories, a bit OTT and I need to talk with my web data team about that one.

In my EPOS system, I have had to remove commas from various geolocations and edit the categories on Magento to be the same and I finally spotted " Jura Isle de", that I had changed from "Isle de Jura", had a leading space on Magento that I removed thinking all solved, nope.
With a bit more thinking I recalled earlier an issue with the same stockline had a city "Default Category/Browse By Destination/Indian Ocean/Reunion/St. Denis" and at the end was a ton of spaces.
The problem was the import had managed to create "St. Denis " and I had removed the wrong one with no spaces.

I remove the trailing zillion spaces and ran the import, viola, it works.
So leading and trailing spaces can be an issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.