Import product assignments to warehouses
> [HTML Version](import-prirazeni-produktu-ke-skladum.html)
**» Available only in Dotypos FULL and higher. «**
You can import and export rules for [assigning products to warehouses](prirazeniproduktu.md) via Dotypos Cloud[.](prirazeniproduktu.md) 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](import-export-dat.md#kontrola) 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](import-export-dat.md). |
# Description of columns in the import file
| **Import file for assigning products to warehouses** |
|------|------|
| **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](eanpluavazenykod.md) product code, separate multiple codes with a comma or a new line in the cell (ALT+ENTER). |
| plu\* | [PLU](eanpluavazenykod.md) product code, separate multiple codes with a comma or a new line in the cell (ALT+ENTER). |
| externalId\* | Unique user [product](produkty-seznam-vs.md) 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:**
The import file must always containthe product ID (**productid**), the name of the new group (**name**)** **and the Cash register ID (**branchId).** All products in the import file must have the same group name, the same Cash register ID and the same warehouse ID.
**If you need to create a new rule in an existing group:**
The import file must always contain the product ID (**productid**) and the ID of the existing group (**groupId**). The other group parameters cannot be changed in this case. That is, they must either correspond to the given group or the columns with values (group name, Cash register ID, warehouse ID) must be removed from the file or marked with the option **_Don't import_**.
**Update existing rule:**
The rule **Id** must always be specified in the import file. Only the **deleted** column can be updated **,** i.e. the rule can be deleted and the product reassigned to the default warehouse. The other parameters of the rule cannot be changed by importing. |
| | |
|------|------|
| [] | 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. |
top