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
    Dec 29 '19 at 10:52
  • No, because there are huge data with row_is and entity_id difference in product , category and other tables. Dec 29 '19 at 11:14
  • please try steps given in tutorial once, it think it should work.
    – Pawan
    Dec 29 '19 at 11:29
  • I already tried but its not working for me regarding data migration Dec 29 '19 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
    Dec 29 '19 at 12:53

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
    Jan 16 '20 at 19:29
  • there is all explanation. I already did from commerce to opensource with the help of official tool.
    – Jarnail S
    Jan 16 '20 at 19:56

There are 2 options for you:

  • we can not migrate commerce to open source using this the info from devdocs link Jan 20 '20 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. Jan 20 '20 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, privacy policy and cookie policy

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