» Available only in Dotypos FULL and higher. « |
|---|
It is possible to import and export rules for hiding products at individual cash registers via Dotypos Cloud. If you have already created product hide rules, exporting them to a file allows you to back them up and edit them. When you reimport this file in 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 Item Management » Products » Hide products.
•If you don't have price change rules created 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 hiding products. This number will be used to modify the existing Product Hide Rules group 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 |
The internal number of the product hide record. The existing rule will be modified according to this number if necessary. If you leave the record ID blank, a new product hide record will be created. |
name |
The name of the group with the product hiding rules |
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 hidden (not necessary to specify 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 groupId ID number. |
branchName |
Cash register name |
deleted |
A number indicating the deleted rule to hide the product (1 or 0 - deleted/not deleted). After deletion, the product will be visible on 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 are related to the import of product hiding rules and must always contain a value!
*One or more of these items must always be defined, as this data (data) is used to find the corresponding product to assign to the product hiding rule.
|
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 of the 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. |
