If you need to import or export some kind of entity data in Magento 2, the standard tool is pretty useful. In this case we are going to import/export products.
- For Export:
Log into your backend admin, and go through System > Data Transfer > Export. Select the corresponding entity type, filter or exclude whatever you want, continue, and that’s it!
- For Import:
– Log into your backend admin, and go through System > Data Transfer > Import .
– Select the corresponding entity type (in this case will be “Products”), the import behavior.
– Choose a local file to import, the following example would help you: import_example.csv
Be aware that if you have to import any custom attribute, you will need in case of multiple values, separate them by “|” pipe