Imports product locations (stock placements) into Sapera. Rows are matched on the location DisplayName; new locations are created when they do not exist. 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 location's name (DisplayName). If the name does not exist, the location is created.
Locations cannot be updated – the name is the key. They can be deleted; if a location is in use, it is first removed automatically from the products on it and then deleted.
Only the locations in your source are processed. Direction: from file/SQL into Sapera.
Parameter | Explanation |
AllowCreate | When enabled, locations that do not yet exist are created. |
AllowUpdate | When enabled, existing locations are updated. |
Field | Explanation |
DisplayName | Name of the product location; used to match rows against existing locations. |
See also the overview SyncTool – actions.
Want to know more?
Read more in these related articles:
Standard parameters for all actions
The general parameters available on most SyncTool actions: step control, error handling, timeout, etc.
