CSV Product Import - Permanantly hanging on "Please wait.."

[gammyduck]

Steps to reproduce:

I uploaded a 1.5MB CSV of 1000 products successfully this morning after using this fix #3862

However, I wanted to change the contents for all products under one of the headers and tried to reupload. I tried another file and no luck.

Now it hangs forever like this:

[gammyduck]

After researching it appears to happen due to one of the columns data been changed from 1 to 0. I'll find the problematic header(s) tomorrow.

[Microstudioweb]

I have the same problem after migrate from magento 1.9 to magento 2.
I had follow the fix #3862, but I have truncate table.
Now I can see the product list on web site, but in admin area I have the please wait...forever page for product and costumer.

[gammyduck]

Hello
I have fixed the issue. Please add a check for duplicate headers.
@Microstudioweb make sure your CSV file is under 10MB as well

[Microstudioweb]

Hi @gammyduck , thanks
My issue was a litle bit different.
My folder group was wrong. I set the user's server to use the right group.

[kevando]

I get the same error and I see a 503 in the browser console log

validation.js:168 POST https://mymagento2store.com/admin/admin/import/validate/key/7c3d2a6d77a544f23394e62945bebd6a2f68fe828eac30ce4ad4581c7c9fe9cb/?form_key=gb1G71Sb3uFLmW2e 503 (Service Unavailable)

[Microstudioweb]

Hello.
Unfortunately the issue come back again and this time persist.
I had tried the previous method, truncate table, but this time don't get any result.

[gammyduck]

Check your headers

[kevando]

For me it was the end line encoding. Opening the CSV in the text editor and changing that setting worked for me. Would be nice if there was at least some error output here. Extremely annoying that it just hangs.

[tseven]

I agree with @kevando , a hung spinning loader is not helpful at all.

[tseven]

Discovered one culprit (Excel on Mac) and solution.

Steps to reproduce:

1. Export products using the admin UI.
2. Edit anything in the .csv in excel on a Mac.
3. Save .csv.
4. Import into Magento

This will cause the import to hang. Browser console shows the post failed with 503.

Solution/Workaround

In excel save as "Windows Comma Separated (.csv)"

[fhennessy]

Folder group wasn't set to be writable for the correct group! fixed my issue

[veloraven]

@gammyduck thank you for your report.
Please, provide the used Magento version. Please also provide information if it was clear install or upgrade from some previous version.