Importing products

<< Click to Display Table of Contents >>

Importing products

Navigation:  Dotypos Cloud > Batch import/export >

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


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

You will find the import and export buttons in the page heading at Item management » Products.

If you have not created any products or categories yet and you want to batch import them, download base template 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 number product (choose any 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.


The unique number of category. 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. If you want to assign the product to a new category, enter categoryId as a random unique number for each new category.


Name of category to which the product will belong


Name product


EAN code of the product (More codes can be separated by a comma or new line in the cell (ALT+ENTER))


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


Brief description product


Complete note product


Product quantity unit. The default setting is Piece (overview of suitable 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. It 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 determining whether the product is displayed in the product 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, in the case of ingredients, the sales products are not deducted, only their raw materials (1 or 0 - deducted / not deducted).


List of tags separated by commas without spaces (e.g. tag1, tag2, tag3). For product assignment use the tag with the prefix
-ac- (e.g. -ac-P0001).


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 is applied to a product when onSale is set to 1 (sale value or 0)


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


PLU product code, separate multiple codes with a comma or a new line in the cell (ALT+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 number for sale by proxy. The numbers of the created subjects can be found in Dotypos Cloud in the item Item management » EET subjects after clicking on subject’s detail.


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


The number defining whether the product allows bulk discounts (1 or 0 - discounts allowed / not allowed).


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


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


Calculate time based value (1 or 0 - calculate / do not calculate)


Specifies whether the product in the category will be recorded (fiscalized) or not (1 or 0 - do not fiscalize / fiscalize). It does not apply to countries without mandatory electronic sales records, so it does not depend on the option you set.


Enables (1) or disables (0) the option for takeaway sales for the appropriate product.


Defines the sale overrunning quantity in stock for the appropriate product. The possible values are: ALLOW (allow), WARN (notify) and DISABLE (disable). The default value is ALLOW.


Indicates a joint sale. If the joint sale for the item is active (value 1), Dotypos also adds the ingredient items during the sale to the order. The joint sale is used e.g. for returnable containers.


Indicates manufactured products. The standard value is 0, for the manufactured product the value 1 will be here.


Indicates Special products. The default value is 0. Only for previously created special products will it be 1.


Indicates the ID number of the default course to which the product will be assigned. The ID number of the course can be obtained from the courses management.


Price in bonus points for the special product Points usage. This field is for internal purposes only. Do not modify it in any way.


An optional product name that (if filled in) is printed on receipts or kitchen orders instead of the standard name. To print on orders, you must edit the corresponding print job. Optionally, its use on generated documents such as invoices can be activated in the POS settings. The alternative name will also be displayed on the customer display and written into the external order services.


Individual price levels with VAT of the product (e.g. 24.00 or 24.00).


Indicates whether the product uses Combinations. This field is for internal purposes only. Do not modify it in any way.


Date of product creation. This item is for internal use only and is ignored during import.

The required items are marked in bold, other items (data) are optional. The obligatory columns must always contain some values!



Are supported .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.



Supported units

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