While sales data(customers/orders) keeps growing on the Magento 1 environment, the amount of products in the Magento 2 environment keeps growing as well. Now when I want to migrate the delta, I get errors from the Map step like:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '22883-1' for key 'CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_WEBSITE_ID'

So the delta stumbles upon a duplicate entry MySQL error, because the incremental index on the Magento 2 side has grown faster than the incremental index on the Magento 1 side.

Anyway, I don't need to import products/categories/inventory stock. I tried excluding the Map step by commenting it in the config:

<step title="Customer Attributes Step">
<!-- Exclude this step...
<step title="Map Step">
<!-- -->
<step title="Log Step">

Can I just exclude the Map step(containing the catalog migration) or do I need to do something else?

  • Did you ever try this? – stephen May 3 '17 at 12:03

Please make sure you choose the correct mode node: <steps mode="settings"> or <steps mode="data"> or <steps mode="delta">

Example path to file: vendor/magento/data-migration-tool/etc/opensource-to-opensource/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.