Via the Dotypos cloud, you can import and export products and their categories. If you have already created products or categories, exporting them to a file allows you to back them up and edit them. When you import this file back into the Dotypos cloud, new products and categories are automatically created or existing ones 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 product or category has its own ID number (column productId). If you modify an item in the import file, the item with the same ID number will be changed in the Dotypos cloud after the import and also in the cash register after synchronization. The items in the import file correspond to the product properties.

•If you have not created any products or categories yet and want to import them in bulk, download the import template and replace the sample data with your own. Then import the file. The procedure is described in this chapter.

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

Note

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

Warning

If you want to import previously deleted products, for example with modified properties, you must set the deleted field to 0 for each such product. During the import, the deleted products will first be restored, and their properties will then be updated according to the data in the import file.

top

Description of columns in the import file

Import file for products
Column	Description
categoryId	Unique category number. According to this number, the product will be assigned to the corresponding existing category. If you leave the category ID blank, the product will automatically be assigned to the general Import category. If you want to assign the product to a new or existing category, just enter the name of the new or existing category in the categoryName column.
categoryName	The name of the category to which the product belongs.
productId	Do not change, always leave this column with the original values. It is used to internally identify the update of the product record. If this value is not present for a product, a new product will be created automatically.
name	Product name
externalId	Unique user number of the product for your own identification of the product (choose any number series, e.g. 101, 102 and onwards). Each product must have a unique number. You cannot reuse a number that has previously been used for a deleted product. It can be used instead of productId.
ean	Product EAN code, separate multiple codes with a comma or a new line in the cell (ALT+ENTER).
plu	Product PLU code, separate multiple codes with a comma or a new line in the cell (ALT+ENTER).
priceWithoutVAT	Selling price of the product without VAT (e.g. 24,00 or 24.00). You can omit this column if you fill in the price with priceWithVAT.
vat	VAT rate entered in percentage format (e.g. 21%, 12% or 0 for non-VAT payers i.e. 0% rate)
priceWithVAT	The selling price of the product with VAT (e.g. 24,00 or 24.00) You can omit this column if you fill in priceWithoutVAT.
units	The unit of quantity of the product, the default is Piece (a list of units that can be used).
unitsmeasurement	Unit of measure for use on price tags. If not specified, the default unit of 1 piece is used when generating price tags. Related to packagingmeasurement, see below.
description	Long description of the product
subtitle	Short description of the product
hexColor	Color code in HEX format (e.g. #EED5D2). For individual color codes, please click here. The default value is #F32C24.
display	The number that determines whether or not the product is displayed here in the product overviews on the main screen (1 or 0 - shown/hidden). The default value is 1.
stockDeduct	Specifies whether the product is subtracted from the stock or not. For example, in the case of Ingredients, sales products are not subtracted from the stock, only their raw materials (1 or 0 - subtracted / not subtracted). The default value is 0.
tagsList	Comma-separated list of tags without spaces (e.g. tag1,tag2,tag3). For pre-assignment of accounting codes to the product, use a tag with the prefix -ac- (e.g. -ac-P0001).
onSale	Indicates whether the product is discounted or not (1 or 0 - discounted/not discounted). The default value is 0.
discountPercent	The discount percentage is applied to the product if onSale is set to 1 (discount value or 0). The default value is 0.
packaging	Number of pieces in the package (default value is 1)
packagingmeasurement	The package unit of measure for use on price tags. If not specified, it is counted as a pack of 1 when generating price tags. The default value is Piece.
points	The number of customer points that will be credited to the customer at the time of sale (a negative value subtracts points). The default value is 0.
notesList	List of quick notes or product variants, separated by commas without spaces (e.g. rare,medium,well done)
disableDiscounts	A number indicating whether discounts are allowed for the product (1 or 0 - discounts allowed / not allowed).
requiresPriceEntry	Require price input (1 or 0 - require / not require)
requiresQuantityEntry	Require quantity entry (1 or 0 - require / not require)
timeable	Calculate value on time (1 or 0 - calculate / do not calculate)
takeawayitem	Enables (1) or disables (0) the takeaway option for the product. The default value is 0.
stockoverdraft	Defines sales below the stock quantity for the product. Possible values are: ALLOW, WARN and DISABLE. The default value is ALLOW.
margin	Minimum margin on the product, either as a percentage, e.g. "10%", or as a fixed amount, e.g. "10".
jointsale	If Joint sale is active for the item (value 1), Dotypos also adds the deducted items to the order when the item is sold.
assembleditem	Indicates manufactured products. The default value is 0, for a manufactured product the value will be 1.
eetsubjectId	Entity number for the sale in the mandate. The numbers of the entities created can be found in the Dotypos cloud under the tab Item management » Sales at authorization by clicking on the entity detail.
defaultcourseid	Indicates the ID number of the initial course to which the product will belong. You can find the ID number of the course in the Courses management.
priceinpoints	Price in bonus points for the special product Points usage. This field is for internal purposes only. Do not modify it in any way.
alternativename	Optional product name, which (if filled in) is printed on receipts or kitchen orders instead of the standard name. To print on purchase orders, you must edit the corresponding print job. Optionally, you can activate its use on generated documents such as invoices in the payment settings. The alternative name will also be displayed on the customer display and written into the external order services.
pricewithvatb / pricewithvatc / pricewithvatd / pricewithvate	Individual price levels of the given product including VAT (e.g. 24,00 or 24.00).
packagingpricewithvat	Price per package with VAT for ordering services (e.g. 15,00 or 15.00).
features	Product features for ordering services, separated by commas without spaces. Possible values are "vegan,vegetarian,gluten_free,lactose_free,children,alco,kosher,halal".
spiciness	Hotness designation for ordering services - 0 spicy to 3 most spicy.
allergens	Numerical list of allergens separated by a comma without spaces (e.g. 12,13).
preparationDuration	Preparation time (for kitchen display only)
exemptedVat	Indicates whether the product is exempt (1 or 0 - exempt/non-exempt). The default value is 0.
created	The date the product was created. This item is for internal use only and is ignored on import.
sortOrder	An integer that determines the order of the products in Dotypos. You can use any number series. If not specified, the order of the products in the cash register is determined by the rows in the import file.
deleted	A number indicating the deleted product (1 or 0 - deleted/not deleted). After deletion, the product will no longer be displayed in the cash register. The default value is 0. Deletion will not occur if the product has Ingredients set or is itself a recipe. In this case, an error message will be displayed.
currency	Currency of the product price. Use the ISO abbreviation of the currency, e.g. EUR or CZK.
dnids	Delivery note number
fiscalizationdisabled	Determines whether the product will be registered (fiscalised) or not (1 or 0 - do not fiscalise / fiscalise). It is not applicable for the Czech Republic, so it does not depend on the set option.
special	Indicates special products. The default value is 0. Only for previously created special products there will be 1.
withCustomization	Indicates whether the product uses customizations. The default value is 0. This field is for internal purposes only. Do not modify it in any way.

Required items are marked in bold in the first column of the table, other items (data) are optional. The required columns refer to the import of new products and must always contain a value!

Note

Supported formats are .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

Supported units

The unit is specified in the columns units, unitsmeasurement and packaging. In the import file, it must be entered in the English format shown below:

•Piece

•Deciliter

•Milliliter

•Centiliter

•Liter

•UsGallon (for US)

•UkGallon (for UK)

•Hectoliter

•CubicMeter

•CubicFoot

•Milligram

•Decagram

•Gram

•Kilogram

•Quintal

•Tonne

•Pound

•Ounce

•Millimeter

•Centimeter

•Meter

•Kilometer

•Inch

•Mile

•SquareMeter

•SquareFoot

•Second

•Minute

•Hour

•Day

top