Magento 2 Import Error

The following article is based on a StackExchange question by Stax. He is asking for help since the standard import process leads to the same error every time the author of the question is trying to import the product database into Magento 2.

The following error occurs when pressing “Check Data”: “General system exception happened”. The image file directory is pub/media/import/images.

User3572565 also faced the same issue doing random 1 line imports. The problem was caused by characters in the descriptions.

To fix it, you should open the data file in the editor of your choice, convert it to UTF-8-BOM, and save it as a copy. Now, the export should work well.

According to User40367, you may even face the problem using «”» instead of «“» in the description.

By using the Improved Import & Export Magento 2 extension instead of the default Magento 2 import, you can prevent the problem above by configuring a Validation Strategy for every import process.

The module lets you ‘Stop on Error’ or ‘Skip error entries’ during the import process. Note that you can even specify the allowed error quantity. For any additional details about the Improved Import & Export Magento 2 extension, follow the link below:

Download/Buy Improved Import & Export Magento 2 Extension

We hope the article was useful. For other useful Magento 2 tips, check out our Cookbook.