while importing products in magento2 given feature,my csv has empty values for some columns like gender which are not required case which has to be updated to empty value if empty value exists in CSV file.
can anyone suggest me how do this with default magento2 import feature.
Magento – allow to save empty value for dropdown attribute while importing products through csv in magento2 import
importmagento2
Related Solutions
The simplest way is probably to use Magmi:
http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Main_Page
This will let you update only the attributes you need to, and you can skip the ones you don't want to update or enter. So for example, if you are updating existing product, you need to only enter SKU and then at least 1 other attribute that you want updated. I think this is what you need if I understand your question correctly. If this isn't your answer, please re-word your question detailing the problem specifically.
You do not need these columns, the only required columns you need are the attributes that are required in the backend.
So in a base install of Magento, you need "description", "name", "price", "sku", "status", "tax_class_id", "visibility", and "weight". Below is a picture of the required options in a clean install of Magento EE 1.14 (so there are a few additional required fields as you can see).
Many developers, will delete these columns from the CSV if we are not using them.
I would suggest using OpenOffice to create your CSV and make sure you select the option to "quote all text fields". Microsoft Excel can work, however I have noticed a lot of formatting issues that can screw up data (especially if you use Office for Mac).
Best Answer
found the solution commented the below line in abstractype file in the model catalog product import. //$rowData = $productTypeModel->clearEmptyData($rowData);
hope this helps other anyone facing the same problem