Magento 2.3 - How to update Migrated Data?

[Aveeva]

@Nishu Jindal  Reindex :

[root@crmserver giri]# php bin/magento indexer:reindex
Design Config Grid index is locked by another reindex process. Skipping.
Customer Grid index has been rebuilt successfully in 00:00:54
Category Flat Data index has been rebuilt successfully in 00:00:04
Category Products index has been rebuilt successfully in 00:00:16
Product Categories index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:07
Product EAV index has been rebuilt successfully in 00:00:33
Stock index has been rebuilt successfully in 00:00:39
Inventory index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:00:17
Google Product Removal Feed index has been rebuilt successfully in 00:00:00
Google Product Feed index has been rebuilt successfully in 00:00:00
Catalog Search index has been rebuilt successfully in 00:00:28

[Nishu Jindal]

Hi @Aveeva,

Can you try delta migration now.

Thanks!

[Aveeva]

@Nishu Jindal  Getting the same error. What i need to do further?

[Nishu Jindal]

Hi @Aveeva,

Do we have duplicate entry in 

cataloginventory_stock_item

Table for the product_id = 4799.  Please share the table entries regarding this product_id.

Thanks!

[Aveeva]

@Nishu Jindal If i run following commnd,

select * from cataloginventory_stock_item where product_id = "4799";

return Null values.

Screenshot : https://snipboard.io/IUcDVq.jpg

[Aveeva]

@Nishu Jindal  Product Id = 47990 (1062 Duplicate entry '47990-1' for key 'CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID)

If i run following command 

select * from cataloginventory_stock_item where product_id = "47990";

Screenshot : 

[Aveeva]

@Nishu Jindal  If delete Duplicate entry 47990 then a new error will generate Duplicate entry 47991 it will keep continuing, my id up to 50036, how to solve this issue

[Nishu Jindal]

Hi @Aveeva,

When you last migrated data from magento 1 to magento 2.

can you please mention last product I'd which you migrated and it seems you got these issues because you have added/removed some entries in products.

https://github.com/magento/data-migration-tool/issues/228

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solurion!

[Aveeva]

@Nishu Jindal One month before i migrated from Magento 1 to Magento 2, is possible sync only Magento 1 orders? 

[Nishu Jindal]

Hi @Aveeva ,

Can you please try the below solution for migrating only orders in Delta Migration.. ?

vendor/magento/data-migration-tool/etc/opensource-to-opensource/{your_version}/config.xml

Comment out extra lines and we will left with Order Data only.

<steps mode="delta">
       <!-- <step title="Customer Attributes Step">
            <delta>Migration\Step\Customer\Delta</delta>
            <volume>Migration\Step\Customer\Volume</volume>
        </step> -->
     <!--  <step title="Map Step">
            <delta>Migration\Step\Map\Delta</delta>
            <volume>Migration\Step\Map\Volume</volume>
        </step> -->
      <!--  <step title="Log Step">
            <delta>Migration\Step\Log\Delta</delta>
            <volume>Migration\Step\Log\Volume</volume>
        </step> -->
        <step title="OrderGrids Step">
            <delta>Migration\Step\OrderGrids\Delta</delta>
            <volume>Migration\Step\OrderGrids\Volume</volume>
        </step>
        <step title="SalesIncrement Step">
            <delta>Migration\Step\SalesIncrement\Delta</delta>
            <volume>Migration\Step\SalesIncrement\Volume</volume>
        </step>
</steps>

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!