Import of categories

<< Click to Display Table of Contents >>

Import of categories

» Available only in Dotypos FULL and higher. «

Dotypos Cloud lets you import or export products and their categories. If you have already created categories, you can export them to the file and use it for backups or adjustments. If you import this file back in Dotypos Cloud, the categories will be automatically updated or newly created.  You may import just one .csv file. Before importing the .xls file, you have to save it in .csv format first.



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


Each category has its own ID number. If you modify an item in the .csv file, the item with the same ID number will be adjusted in Dotypos Cloud after the import and also in the touch cash register after synchronization.

You can find the import and export buttons in the page heading at LISTS » CATEGORIES.

If you have not created any categories yet and you want to batch import them, download the .csv template from Dotypos Cloud and replace the sample data with your own. Then import the file. The sample procedure is described in this chapter.


Description of import file columns

Category import file


Unique number of the category (choose a random series of numbers, e.g. 101, 102 etc.). Each category number must be unique. Do not reuse a number that had been earlier assigned to a now-deleted category.


Do not fill this column out, but leave it with empty values. It is used to identify record updates internally.


Name of category


The default VAT rate (valid for VAT payers when using fast names during an immediate sale)


Number defining whether the category is displayed in the overview on the main screen or not (1 or 0 - displayed/hidden).


Color code in HEX format (e.g. #EED5D2). Codes for individual colors can be found here.


Number indicating a deleted category (1 or 0 - deleted/not deleted). Once a category has been deleted, it no longer appears on the cash register. The default value is 0.


Internal ID of the ERS subject


The minimal margin applied when the margin for a specific product is not set (can be set proportionally at 10% or at absolute 10, which means 10 CZK).


Specifies whether products in the category will be recorded (fiscalized) or not (1 or 0 - do not fiscalize/fiscalize).

Required fields are marked in bold, while all other items (data) are optional.