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 <email@example.com> # 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.