The Magento 2 Importer is a simple way to import and update Product Data and many more. Since July 2016, an Import will throw an Exception at the Product Grid. Today, I added a small script as a Workaround, which I want to share.

It is actually simple and based on the Yonn-Trimoreau‘s SQL Query. I setup a bashscript, which enters the working dir and executes the query via n98-magerun2. After that, I added a CronJob to call the Script every Minute(In case someone starts the Import manually).

This is the Bash Script:

#!/usr/bin/env bash
cd to/your/working/dir/ && /usr/local/bin/n98-magerun2.phar db:query 'DELETE FROM cataloginventory_stock_item WHERE product_id IN ( SELECT * FROM( SELECT product_id FROM cataloginventory_stock_item GROUP BY product_id HAVING COUNT( product_id ) >1 )tblTMP WHERE website_id = 1 )'

My CronJob Configuration looks like this:

# Job 1 by David Lambauer <d.lambauer@netz98.de>
# This is a little Workaround for the following Magneto 2 Issue:
# https://github.com/magento/magento2/issues/5418
# This should be removed after the fix was applied.
* * * * * www-data /path/to/your/bash/script/magento2-issue-workarround.sh

It is pretty dirty, but it’ll work until Magento applied a Fix.

David Lambauer