I have seen that we have import/export option for bulk products. My question is what is the difference between 1.import product 2. export product and DataFlow-Profiles.

In Dataflow profiles also, import all products and export all product options are there. Why there are two kind of import/export options available and what is the difference?

enter image description here

Please refer the image,and my question is what is the difference between option 1 and option 2?

when we click the option2 we are getting below window.

enter image description here

1 Answer 1


Option 1: Import Export

when you export products using this option, the header columns name in csv will be same as attribute codes. you cannot change. also when you importing products using this option, you have to use exact attribute code as csv columns which are created in the system.

you can skip or filter product export as per screenshot below, but with option 1 you have to repeat this actions again when you need to export same file in future.

Option 1 only supports csv format for import and export

enter image description here

Option 2: Dataflow profiles

Dataflow provides custom column names in import export. Also it's supports csv, txt and XML formats. You can see more features form below screenshot

enter image description here

  • I can see that in both the cases we need to use exact attribute name, But need why two ways available, Need clarity on this. Sep 18, 2017 at 6:30
  • 1
    In 2nd option you can define your own columns name in csv. E.g. if you are selling your products in Amazon you needs to provide csv in Amazon important format. In Magento you have sku as identifier. Amazon expect 'item id' as your sku. If you will export csv from first option you always needs to do manually work every time. By using option 2 you can map those fields that magento sku = Item id in csv. Also you can export only selected columns. Everytime you just need to click on download. Sep 19, 2017 at 4:26
  • @ManikandanArunachalam : did you found my answer is useful ? Sep 23, 2017 at 6:03
  • useful , but i could not feel why magento keep two ways of importing/exporing bulk product.Maybe explaining the difference between these two will help me. Sep 24, 2017 at 17:01

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.