Imports the link between products and their suppliers into Sapera. Rows are matched on product identifier together with supplier identifier; new links are created and existing ones updated. 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 combination product + supplier (ProductIdentifier + SupplierIdentifier). If the link does not exist it is created; otherwise the cost price, the supplier's own item number and the main-supplier flag are updated.
Both the product and the supplier must already exist in Sapera – otherwise the row is skipped with an error.
Mark a row for deletion to remove the link between product and supplier. Direction: from file/SQL into Sapera.
Parameter | Explanation |
| When enabled, product-supplier links that do not yet exist are created. |
| When enabled, existing product-supplier links are updated. |
Field | Explanation |
| Cost price the supplier charges for the product. |
| When set, the product-supplier link is removed instead of created or updated. |
| Whether this supplier is the primary (main) supplier for the product. |
| Identifier of the product; part of the match key. |
| The supplier's own item number for the product. |
| Identifier of the supplier; part of the match key. |
See also the overview SyncTool – actions.
