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 |
Additional import modes
Some resources like products have additional modes that allow finer grain control over bulk updates.
These give the ability to control the update action, e.g. merge, replace, delete, for specific fields, e.g. product custom fields, images, videos, etc.
See the resource specific documentation for more information.