I want to update products on my Magento 2 Website with csv bulk import. I have downloaded the export file but it has too many columns.

I will only update the Product name, Quantity & Price. Nothing else.

I want to remove the unnecessary columns as much as possible.

I want to know what are the necessary columns which should be there to upload?

2 Answers 2


For creating new products the following fields are required as part of the import csv

sku, name, price, product_type, attribute_set_code, product_websites, qty, additional_attributes

If you are updating products the following fields are required but always recommended to include

sku, price, name, qty, product_websites
  • Great Dava, it seems fine, let me finish import and see.
    – Thowzif
    Commented Aug 22, 2019 at 7:04

Following 4 fields are required in your case (provided you are using default stores).

  • Thank you Amite. Am testing now.
    – Thowzif
    Commented Aug 22, 2019 at 7:05

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.