I have a staging and a production server for my Magento 2.3.1 project. The two databases have different data and configurations, so I can not just dump the mysql db and restore it.

Is there a way to merge only products data from one database to another?

  • 1
    You can use Default Magento Product export, import. Commented Jul 29, 2019 at 4:16
  • @Ranganathan Thanks, this is actually a working solution. if you add this to Anwser. I'll accept it. Commented Jul 31, 2019 at 10:41

1 Answer 1


You can use Magento's default export and import option to merge products from one magento setup to another magento:

Admin->System->Data Transfer->Import/Export

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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