I want to migrate my commerce website to an open-source.

I want to migrate the database from EE to CE.

I referred to the below link.


  • refereed link provided in question is not working for you ?
    – Pawan
    Commented Dec 29, 2019 at 10:52
  • No, because there are huge data with row_is and entity_id difference in product , category and other tables. Commented Dec 29, 2019 at 11:14
  • please try steps given in tutorial once, it think it should work.
    – Pawan
    Commented Dec 29, 2019 at 11:29
  • I already tried but its not working for me regarding data migration Commented Dec 29, 2019 at 12:13
  • if you really need to understand whats going on, create diff between default EE and CE tables, you will get an idea where it all goes. do you understand that some data will be gone? and you will have to accept this loss.
    – MagenX
    Commented Dec 29, 2019 at 12:53

3 Answers 3


I suggest to use magento's official tool for migration. You need to do little efforts there but you can do it easily.

You can check these questions from MSE:

  • there is no commerce to opensource option in the migration tool?
    – paj
    Commented Jan 16, 2020 at 19:29
  • there is all explanation. I already did from commerce to opensource with the help of official tool.
    – Jarnail S
    Commented Jan 16, 2020 at 19:56
  • @JarnailS Did you migrate the database from Magento 2.X EE to Magento 2.X CE using data migration tool? If yes, can you please share some key points? Commented Jan 10, 2022 at 13:35
  • No but it can be done as magento2 documentation.
    – Jarnail S
    Commented Jan 19, 2022 at 5:55

There are 2 options for you:

  • we can not migrate commerce to open source using this the info from devdocs link Commented Jan 20, 2020 at 9:11
  • @BirenPatel There is only one dev document from Magento. You might not migrate commerce to open source because DB structures and codes of EE version is much more different from those of CE version. You can contact Magento support team or find a data migration tool to helps you solve this problem. Commented Jan 20, 2020 at 9:28

you wont be able to downgrade while keeping 100% data. be prepared to lose 20%. while your orders, products and customers will be migrated or exported, other minor data in-between will be lost.

few options available:

  1. downgrade with simple drop-in replacement
  2. or export data you need from EE and then import to CE

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.