» Available only in Dotypos FULL and higher. «

You can import and export pricing plans for products and Happy Hours 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 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.

poznamka_icon

To find out how to import / export see the parent chapter.

Description of columns in the import file

Import file for price plan

Import file for Happy Hours

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 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 product 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 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 product 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.

dulezite_sdeleni_icon

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 rule Id must always be specified in the import file. Only the columns newPriceWithVat or percentualPriceChange and deleted can be updated. The other rule parameters cannot be changed by importing.

poznamka_icon

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

This Info:	ALT+q
Page Header:	ALT+h
Topic Header:	ALT+t
Topic Body:	ALT+b
Contents:	ALT+c
Search:	ALT+s
Exit Menu/Up:	ESC

Please enable JavaScript to view this site.

Description of columns in the import file

Keyboard Navigation