Allow product import from csv to delete fields/values
The new built in product csv export/import is great except for 1 thing – you cannot delete a value.
If the csv has an empty value (i.e. 2 commas), the merge on import ignores the value and does not overwrite existing data of the product. So if you want to delete a value (such as removing all images) it cannot be done via the import.
I would suggest that if csv contains an empty string in quotes, then it is taken as delete existing value. Or make it configurable – so on import you could say configure a value to mean delete (e.g. Have a ‘If column value equals this, merge and delete’ input field that user could configure how they want, then user could set this to say
and put that string in the csv at points where they want to delete the value. Having it configurable would allow user to use Excel to edit csv file easily.
Last updated: October 26, 2017