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 mode.
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

Coming soon

Additional column modes

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.