It is possible to import and export products and their categories via Dotypos Cloud. If you have already created products or categories, the export allows you to back them up and edit them. In fact, if you back-import this file in 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 adjusted in Dotypos Cloud after the import and also in the cash register after synchronization. The items in the file for import correspond to the product properties.
•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.
•You will find the import and export buttons in the page heading at Item management » Products.
|
To find out how to import / export, see the parent chapter. |
Description of import file columns
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 product number for self-identification of the product (choose any range of numbers e.g. 101, 102 and onwards). Each product must have this unique number. You cannot reuse a number that has been previously used for a deleted product. |
ean |
EAN productcode, separate multiple codes with a comma or a new line in the cell (ALT+ENTER). |
plu |
PLU productcode, 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 |
|
subtitle |
|
hexColor |
Colour 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,ltag3). Use a label with the prefix -ac- (e.g. -ac-P0001) to prefix the product. |
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 on 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 in percentage "10%" or fixed "10" in crowns. |
jointsale |
Indicates a joint sale. If the joint sale for an item is active (value 1), Touch will add the deducted items to the account when the sale is made. The joint sale is used, for example, for returnable packaging. |
assembleditem |
Indicates manufactured products. The default value is 0, in the case of a manufactured product there will be 1. |
eetsubjectId |
Entity number for the sale in the mandate. The numbers of the entities created can be found in the Remote Administration 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 |
The individual price levels with VAT of the product (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 properties 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 the Touch. You can use any number series. If not specified, the order of products in the checkout is determined by the lines 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 for the product price. The abbreviation CZK should be used for the currency 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 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!
|
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. |
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:
•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
