Using import modes

The Mode column on import is used to determine what kind of update action is performed for each row.

The supported options are:

Mode	Action
`Merge`	Existing items are updated. New items are created. Missing columns or empty column values are ignored. This is the default functionality.
`Update`	Existing items are updated. New items are ignored. Missing columns or empty column values are ignored
`Create`	New items are created. Existing items are ignored.
`Replace`	Existing items are deleted and recreated. New items are created. This is the same as a `Delete` followed by a `Merge` .
`Delete`	Existing items are deleted.
`Skip`	This item is ignored

Additional Column Modes

Coming soon

For some import types, additional modes will be added to give finer grain control over some of the related fields. This will give the ability to control the update action, e.g. merge, replace, delete, for specific fields, e.g. product custom fields, images, etc.