Imports relations between products (for example accessories or replacements) into Sapera. Rows are matched on product identifier together with related product identifier. 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 relation is given as product + related product (ProductIdentifier + the related product's number). The action sets the relations on the product.
Both products must already exist. Direction: from file/SQL into Sapera.
Parameter | Explanation |
| When enabled, product relations that do not yet exist are created. |
| When enabled, existing product relations are updated. |
Field | Explanation |
| Whether the related product is added automatically with the main product. |
| Fixed price for the related product when added through the relation. |
| Price for the related product as a percentage of its normal price. |
| Identifier of the product that owns the relation. |
| Quantity of the related product added through the relation. |
| Identifier of the related product. |
| System name of the relation type that classifies the relationship. |
| Whether the related product is printed on the receipt. |
See also the overview SyncTool – actions.
