Importing products

<< Click to Display Table of Contents >>

Importing products

» Available only in Dotypos FULL and higher. «

Dotypos Cloud lets you import or export products and their categories. If you have already created products or categories, you can export them to the file and use it for backups or adjustments. If you import this file back via Dotypos Cloud, the products and 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.
If you want to change the VAT for individual products on a mass scale, see this article in our knowledge database.


Each product or 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. The items in the file for import correspond to the product preferences.

You will find the import and export buttons in the page heading at LISTS » PRODUCTS.

If you have not created any products and categories yet and you want to batch import them, download this file and replace the sample data with yours. Then import the file. The procedure is described in this chapter.


Description of import file columns

Product import file


Unique product number (choose a random series of numbers, e.g. 101, 102 and so forth). This product number must be unique. Do not reuse a number that had earlier been assigned for a now-deleted product.


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


Unique category number. A product will be assigned to the corresponding category according to this number. If you leave the category ID blank, the product will be automatically assigned to the common category Import. When you want to put the product in a new category, fill out the categoryId with a random unique number for each new category.


Name of the category to which the product will belong


Name of the product


EAN code of the product


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


Brief description of the product


Full description of the product


Product quantity unit. The default unit is the number of items - pieces. (overview of applicable units)


Measuring unit to be used at price tags. If not entered, the default unit “number of pieces” will be used when generating price tags. This relates to packagingmeasurement, see below.


Product sales price excluding VAT (e.g. 24,00 or 24.00)

You can omit this column if you are filling out the price including VAT priceWithVAT.


VAT rate entered in decimal format with a decimal point or comma (e.g. 1.21 for 21%, 1,15 for 15% or 1 for VAT non-payers)


Product sale price including VAT (e.g. 24,00 or 24.00)

You can omit this column if you are filling out the price without VAT priceWithoutVAT.


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


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


Indicates whether the product is deducted from the warehouse or not. For example, if the sales products are ingredients, they are not deducted (1 or 0 - deducted/not deducted).


List of tags separated by commas without spaces (e.g. tag1,tag2,tag3)


List of fast notes a.k.a. product variants separated by commas without spaces (e.g. rare,medium,well done)


Integer indicating the product sequence in Dotypos. You may use a time series of any kind (not supported yet)


Defines whether the product is being sold at a discount or not (1 or 0 - reduction/no reduction).


Discount in percentages applies to a product when the value of onSale is set to 1 (discount value or 0)


Number of customer points to be added to the customer during the sale (negative value deducts points)


Product PLU code (you may enter several PLU codes for one product by typing the codes into one cell. Each code in one cell has to be on a separate line using the key combination Ctrl + Enter.)


Number of items in the packaging (default value is 1)


Measuring the packaging to be used at price tags. If not entered, the default unit “package of 1 piece” will be used when generating price tags.


Currency used to price the product. For Czech crowns use the abbreviation CZK.


Minimal margin (not used yet, will be implemented in future versions)


Delivery note number (not used yet, will be implemented in future versions)


Subject for sell by proxy


The minimal product margin either in percents "10%" or directly "10" in koruna


Number indicating whether bulk discounts are enabled for this product (1 or 0 - discounts enabled/disabled).


Require price entering (1 or 0 -require/not require)


Require quantity entering (1 or 0 -require/not require)


Calculate the time-based price (1 or 0 - calculate/not calculate)


Specifies whether the product 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.


Supported units

The unit is specified in the columns units, unitsmeasurement, and packaging. Enter in the file to be imported the English format shown below: