Imports product categories into Sapera. Rows are matched on the category Identifier; matched categories are updated and new ones are created. Run Compare first to preview which categories will be created or changed.
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 category's identifier (Identifier). Matching categories are updated and new ones created.
A hierarchy is built by setting ParentCategoryIdentifier (the identifier of the parent category).
Only the categories in your source are processed. Direction: from file/SQL into Sapera.
Parameter | Explanation |
| When enabled, categories that do not yet exist are created. |
| When enabled, existing categories are updated with the imported values. |
| Imports the stock accounts exactly as supplied without remapping them one-to-one. |
| System name of the product template assigned to categories that do not specify one. |
Field | Explanation |
| Account number used when stock is added. |
| Whether a custom name may be entered for a product at sale time. |
| Whether products may be assigned directly to this category. |
| Whether stock movements are booked automatically for the category. |
| Whether the cost price of products is updated automatically on purchase. |
| Account number used for cost of goods sold. |
| Account number used for discounts given on the category. |
| Name of the category shown in Sapera. |
| Unique identifier of the category; used to match rows against existing categories. |
| System name of the template used for product instances in the category. |
| Whether a customer must be specified when selling products in the category. |
| Whether the financial accounts may be changed for products in the category. |
| Whether the price may be changed at sale time. |
| Identifier of the parent category, placing this category in the hierarchy. |
| Account number used when products in the category are sold. |
| Sales account number used when the sale is without VAT. |
| Whether products in the category are purchased without VAT. |
| Whether products in the category are sold without VAT. |
| Account number used when stock is subtracted. |
| Whether the category supports composed (bundled) products. |
| Whether the category supports individually tracked product instances. |
| Whether products in the category may have variants. |
| System name of the product template used for products in the category. |
| Stock addition account number used for used (second-hand) goods. |
| Cost-of-sales account number used for used (second-hand) goods. |
| Sales account number used for used (second-hand) goods. |
| Stock subtraction account number used for used (second-hand) goods. |
| System name of the template used for product variants in the category. |
See also the overview SyncTool – actions.
