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. – Biren Patel 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 – Biren Patel 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:

| improve this answer | |
  • there is no commerce to opensource option in the migration tool? – paj Jan 16 at 19:29
  • there is all explanation. I already did from commerce to opensource with the help of official tool. – Jai Jan 16 at 19:56

There are 2 options for you:

| improve this answer | |
  • we can not migrate commerce to open source using this the info from devdocs link – Biren Patel Jan 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. – LitExtension Magento Migration Jan 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
| improve this answer | |

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.