Import Price Plan and Happy Hours
> [HTML Version](import-planu-cen-a-happy-hours.html)
**» Available only in Dotypos FULL and higher. «**
You can import and export [pricing plans for products and Happy Hours](ceny.md) via Dotypos Cloud. If you have already created price change rules, exporting to a file allows you to back them up and edit them. When you back-import this file in Dotypos Cloud, new rules are automatically created or existing rules are updated. You can import files in .xls, .xlsx and .csv format.
- 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 **Item Management **»** Products **»** Prices**.
- 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](import-export-dat.md). |
# Description of columns in the import file
[Import file for price plan](#pc)
[Import file for Happy Hours](#hh)
| **Import file for price plan** |
|------|------|
| **groupId** | Internal group number with rules for price changes. The existing group will be adjusted 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 cashier ID number **branchId**. |
| **Id** | The internal number of the price change rule. The existing price change rule will be modified according to this number if necessary. If you leave the rule ID blank, a new rule will be created. |
| name | Name of the price change rule 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 [product](produkty-seznam-vs.md) user number for self-identification (choose any number range e.g. 101, 102 and so on). Each product must have this unique number. You cannot reuse a number that was previously used for a deleted product. |
| **productid\*** | The ID number of the product to which the price change will be applied (it is not necessary to specify if there is a value in the **ean**, **plu** or **externalId** columns). |
| productName | Product name |
| **newPriceWithtVat** | The new selling price including VAT (e.g. 24.00 or 24.00). You can omit this column if you fill in the percentage price change in the **percentPriceChange** column. |
| **percentualPriceChange** | Percentage change in selling price (e.g. -20). You can omit this column if you fill in the price without tax **newPriceWithVAT**. |
| **branchId** | Cash register ID number. You can omit this column if you fill in the group ID number **groupId**. |
| branchName | Cash register name |
| **startDate** | The date and time from which the price change is applied (YYYY-MM-DD hh:mm:ss). |
| **endDate** | Date and time to which the price change is applied (YYYY-MM-DD hh:mm:ss). |
| deleted | Number indicating the deleted price change rule (1 or 0 - deleted/not deleted). Once deleted, the price change will no longer be applied. 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 relate to the import of the price plan 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 price change rule.
| **Import file for Happy Hours** |
|------|------|
| **groupId** | Internal group number with rules for price changes. The existing group will be adjusted 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 cashier ID number **branchId**. |
| **Id** | The internal number of the price change rule. The existing rule will be modified according to this number if necessary. If you leave the record ID blank, a new rule will be created. |
| name | Name of the price change rule 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 [product](produkty-seznam-vs.md) user number for self-identification (choose any number range e.g. 101, 102 and so on). Each product must have this unique number. You cannot reuse a number that was previously used for a deleted product. |
| **productid\*** | The ID number of the product to which the price change will be applied (it is not necessary to specify if there is a value in the **ean**, **plu** or **externalId** columns). |
| productName | Product name |
| **newPriceWithtVat** | The new selling price including VAT (e.g. 24.00 or 24.00). You can omit this column if you fill in a percentage price change **percentPriceChange**. |
| **percentualPriceChange** | The percentage change in the selling price (e.g. -20). You can omit this column if you fill in the price without tax **newPriceWithVAT**. |
| **branchId** | Cash register ID number. You can omit this column if you fill in the group ID number **groupId**. |
| branchName | Cash register name |
| startDate | The date from which the price change is applied (YYYY-MM-DD). |
| endDate | The date until which the price change is applied (YYYY-MM-DD). |
| **monday - sunday\*** | The day of the week for which the price change is applied must be active for at least one day (1 = apply, 0 = not apply). |
| **startTime** | Time from which the price change is applied (HH:MM:SS). |
| **endTime** | Time until which the price change is applied (HH:MM:SS). |
| deleted | Number indicating the deleted price change rule (1 or 0 - deleted/not deleted). Once deleted, the price change will no longer be applied. 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 relate to the import of the price plan 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 price change rule.
| | |
|------|------|
| [] | **If you need to create a new rule for a new group:**
The import file must always contain the 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 checkout ID and other parameters (date for price plan, days and time for Happy Hours).
**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) must be removed from the file or marked with the option **_Don't import_**.
**Updating an existing rule:**
The import file must always include the **Id** of the rule. You can update either the new sales price (**newPriceWithVat**) or the percentage price change (**percentualPriceChange**), or delete the rule (**deleted**). Other parameters of the rule cannot be changed via import. |
| | |
|------|------|
| [] | 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