» Available only in Dotypos FULL and higher. « |
|---|
You can import and export rules for assigning products to warehouses via Dotypos Cloud. If you have already created warehouse product assignment rules, exporting them to a file allows you to back them up and edit them. When you import this file back into Dotypos Cloud, new rules are automatically created or existing rules are updated. You can import files in .xls, .xlsx, and .csv formats.
•Before the file is actually uploaded to the cash register, its contents are displayed and a data check is performed. If you include a column in the import, it should always contain a value. You can exclude a column from the import by selecting the Don't import option in the drop-down menu for a specific column during the import (data check).
•Each price change record is represented by its own ID number (column Id). If you make a change in the import file, the price plan with the same ID number will be changed in Dotypos Cloud and, after synchronization, in the cash register.
•Buttons for import or export can be found in the header of the page on the tab Warehouses » Products assignment.
•If you have not yet created the rules for assigning products to warehouses and want to import them in bulk, download the import template from Dotypos Cloud and replace the sample data with your own. Then import the file.
|
To find out how to import / export see the parent chapter. |
Description of columns in the import file
groupId |
Internal group number with rules for assigning products to warehouses. The existing rule group will be modified according to this number if necessary. If you leave the group ID blank, a new group will be created. You can omit this column if you fill in the checkout ID number branchId. |
Id |
Internal record number for assigning products to warehouses. The existing rule will be modified according to this number if necessary. If you leave the record ID blank, a new record will be created with the stock allocation rules. |
name |
Group name with rules for assigning products to warehouses (required to create a new group). |
ean* |
EAN product code, separate multiple codes with a comma or a new line in the cell (ALT+ENTER). |
plu* |
PLU product code, separate multiple codes with a comma or a new line in the cell (ALT+ENTER). |
externalId* |
Unique user product number for custom product identification (choose any number range e.g. 101, 102 and onwards). Each product must have this unique number. You cannot reuse a number that has been previously used for a deleted product. |
productid* |
The ID number of the product to be assigned to the warehouse (not necessary if there is a value in the ean, plu or externalId columns). |
productName |
Product name |
branchId |
Cash register ID number. You can omit this column if you fill in the group ID number groupId. |
branchName |
Name of Cash register |
warehouseId |
The ID number of the selected warehouse to which the product will be assigned. |
warehouseName |
The name of the selected warehouse to which the product will be assigned. |
deleted |
The number indicating the deleted rule for assigning the product to the warehouse (1 or 0 - deleted / not deleted). After deletion, the product will be visible at the checkout. The default value is 0. |
Required items are in bold in the first column of the table, other items (data) are optional. The required columns refer to the import of a new assignment and must always contain a value!
*One or more of these items must always be defined, as the corresponding product is searched for the matching product to the product to warehouse matching rule based on this data (data).
|
If you need to create a new rule for a new group: If you need to create a new rule in an existing group: Update existing rule: |
|
Are supported .xls, .xlsx and csv files with delimiter ; (semicolon) and , (comma). If semicolon is used, it is possible to separate decimal places by commas and periods. If you use a comma as a data separator, you must use a period to separate the decimal places. |
