Product Import: Additional data: Invalid URL key

[Alex-James17]

Actual Result

When performing a product import with a category field which begins with a comma, a General Exception is raised with a spurious error message and no rows are imported.

Preconditions

Running Magento 2.2 on PHP 5.6.28 with MySQL 5.6.34 on MAMP under MacOS 10.12.6

Steps to reproduce

1. System > Import > Products
2. Choose "Add/Update
3. Select a CSV file containing a "categories" column with a comma as the first character
4. Click Check Data then Import

Expected Result

I would expect the error message to indicate an issue with the clearly invalid category field (column 5 in my file) rather than pointing at the url_key field (column 18 in my file).

[misha-kotov]

@Alex-James17 can you attach a sample file please.
And can you clarify - does the column header value have the comma or the values under the header?

[Alex-James17]

File attached, the comma should be in one of the values rows, not the header as per the attachment.

invalid-category.csv.zip

[misha-kotov]

Thanks - internal issue is MAGETWO-72101

[avdb]

I would like to look into this issue

[okorshenko]

@avdb I've sent you an invite to join Magento Team on the GitHub. Please, accept the invite

[avdb]

@okorshenko done

[okorshenko]

@Alex-James17, thank you for your report. The issue is already fixed in 2.2-develop branch (PR: #11049 by @avdb) and will be available in the Magento 2.2.2 release

[magento-team]

Internal ticket to track issue progress: MAGETWO-80229

[magento-engcom-team]

Hi @Alex-James17. Thank you for your report.
The issue has been fixed in magento-engcom/magento2ce#1361 by @magento-engcom-team in 2.3-develop branch
Related commit(s):

• 716f9af
• 595527a
• 8c05a29
• 63958cd
• 78c2c21
• 7f2dc29
• aee7458
• 92f8586
• bf178ca
• ecafa80
• a15208e
• 76716b8
• 490785f
• 6fe6280
• 33e40ec
• 7b1bec8
• dbe5fc7
• 22c6937
• ca7da3f
• b55a5d1
• 65b745f
• b0a5a52
• 97dd9ad
• aa28366
• 0fc86d8
• f11994a
• 04445d0

The fix will be available with the upcoming 2.3.0 release.

[allblued]

magento2.3.0
same problem

[csimby]

Same problem at me too.

[ulukai-ork]

Magento 2.3.1 still buggy :(

[Misco]

i get same error, exportet from shop, import this error 2.3.1

[danieljoeblack]

This issue is also happening when there are two slashes in a category.

ex. Atv/Filters//Fuel

This is on Magento 2.3.1

[Puru2016]

I am still facing this issue in 2.3.2.
I have already created categories and importing the products using CSV.
I am getting same error:-
Additional data: Invalid URL key

Please let me know what is proper fix for this issue.

[luluhAlkhamisi]

do you find the solution or not? it occurs to me

[ame5hca]

Any solution to this issue. I am getting the same issue on my Magento 2.3.4 version.?