Treat blank cells as deletions

By default, Shift ignores blank or empty cells in import files. This is to ensure that no data is accidentally deleted or unset.

The Treat blank cells as deletions option is available when you explicitly want Shift to consider any blank cell as an instruction to delete or set the field to an empty value.

For example, with this option set:

• A blank cell in a product custom field column will delete the custom field.
• A blank cell in a product description will empty the description field.

Ignored on sub-resources

Even with this setting enabled, blank cells will be ignored on sub-resources that have been included in the import, e.g. product variants, and product images.

To delete sub-resources, you would need to replace the entire product using import modes.

Ignored on Required fields

Even with this setting enabled, it will be ignored on required fields, e.g. price.