Imports product bar codes from an external source and attaches each code to an existing product in Sapera.
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 barcode itself (Code). If the code does not exist it is created and linked to the given, existing product; a code can also be deleted.
The product the code is linked to must already exist. Direction: from file/SQL into Sapera.
Parameter | Explanation |
| When enabled, bar codes that do not yet exist are added to their product. |
| When enabled, existing bar codes may be re-linked to the product given in the source. |
Field | Explanation |
| The bar code value to import (the identifier of the row). |
| The identifier of the product the bar code should be attached to. |
See also the overview SyncTool – actions.