Imports individually tracked product instances (serialized units) into Sapera. Rows are matched on the instance Identifier; matched instances are updated and new ones are created. Run Compare first to preview the changes.
1. Select the action in the Action field. 2. Point to your data source – a file (CSV or Excel) or a SQL query. 3. Map the source columns to Sapera's fields in the column mapping (see Source fields below). 4. Run Compare to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run Update Sapera to perform the import.
Use the Allow create and Allow update parameters to control whether new rows are created and whether existing ones are updated.
Each row is matched on the instance's identifier (Identifier). Matching instances are updated and new ones created.
Each instance belongs to a product (ProductIdentifier) and can carry a serial number and current owner.
Only the instances in your source are processed. Direction: from file/SQL into Sapera.
Parameter | Explanation |
| When enabled, instances that do not yet exist are created. |
| When enabled, missing catalog/attribute values are created during import. |
| When enabled, existing instances are updated with the imported values. |
| System name of the template used when creating new instances. |
| Name of the stock draft used when stock counts are imported. |
Field | Explanation |
| First address line for the instance. |
| Second address line for the instance. |
| Bar code of the instance. |
| Country of the instance address. |
| Identifier of the actor that currently owns the instance. |
| Discounted sales price of the instance. |
| Name shown for the instance. |
| Unique identifier of the product instance; used to match rows. |
| Whether the instance is used (second-hand). |
| Postal code of the instance address. |
| Postal district of the instance address. |
| Identifier of the product this instance belongs to. |
| Purchase price of the instance. |
| Registration number of the instance (for example a vehicle plate). |
| Free-text remark on the instance. |
| Sales price of the instance. |
| Serial number of the instance. |
| Date and time the instance was sold. |
| Current state of the instance. |
| Date the workflow communication was initiated. |
| Type of workflow communication associated with the instance. |
See also the overview SyncTool – actions.