Please enable JavaScript to view this site.

» Available only in Dotypos FULL and higher. «

Ingredient is a kind of product feature not stocked out of the warehouse, but only the product’s ingredients are. This lets you define at the point of sale of a product the exactly defined quantity of other items to be stocked out of the warehouse.

 

Let’s import the ingredients

Description of import file columns

Export receptur

 

Examples of ingredients:
Create coffee, milk and coffee with milk products. When charging coffee with milk, the product itself will not be stocked out of the warehouse, but only the corresponding amount of its ingredients (coffee and milk). You can use ingredients when selling draft beverages or when you stock out 0.3 or 0.5 liter of another common product (barrel). You can also stock out from the warehouse various hair dressing preparations that consist of ingredients in an uneven proportion.

Warehouse ingredients can be set up either directly in the cash register or in Dotypos Cloud. The third option is to perform a batch import of ingredients. However you must have both product ingredients and products to be used as ingredients created in the cash register first. Then, use import to assign ingredients to individual products and to set up the quantity of ingredients that will be deducted during the sale.

In a simplified way, fill the import file with products to be deducted and also with products to be used as ingredients. You can define the deducted products and their ingredients using the product number, which can be found in the properties of each product in the Basic item. Then, in the import file you put this number into the appropriate column depending on whether it is a product that will be deducted or an item that will be used as ingredient.
 

dulezite_sdeleni_icon

To import ingredients, you may only use products and ingredients created in advance. The import of ingredients does not create new products!

 

Let’s import the ingredients

1_icon

Select the products for which you want to set the ingredients. In the ingredients import file, these products are defined based on the fields productId. This number can be found in the product properties or also in the file with exported products. The product number is generated automatically in the Dotypos when the product is created.

So mark down the ID numbers of the created products that will be used for importing ingredients, or just export the products into a file. Then put these numbers into the ingredients import file, into the column parentProductId. When using a product as an ingredient, put it into the column ingredienceProductId. See the description below.

clip0815
clip0622

 

2_icon

Log into Dotypos Cloud and go to Item Management » Products 01. Click the Import button on the top right and select Import ingredients 02.

clip0816

 

3_icon

This will open the page to insert the import file and upload it. Just click in the 03 section and select or drag the file into this section. Next, the procedure is the same as for bulk importing other items. Please refer to this chapter for a sample import procedure. The description of the import file items for recipes can be found below.

clip0625

top

Description of import file columns

Import file for ingredients

parentExtId

Not used for ingredients, use parentProductId.

parentProductId

A unique number of a previously created product that is automatically generated by the system. Based on this number, the cash register will know that it is a product with a recipe (consisting of ingredients). The number of the created product that you add to this column is easiest to find if you export existing products from the cash register or look in the product properties at Product ID.

parentName

The name of the product sold consisting of the raw materials. Under this name you will see the product subtracted in the cash register.

ingredienceExtId

Not used for recipes, use ingredientProductId.

ingredienceProductId

The unique number of the previously created product that will be used as the raw material for the recipe (for the product defined in the parentProductId column). You can add multiple ingredients to this product. Just create additional records (rows) with the corresponding ingredientProductId number. One row, one ingredient. ingredientProductId = Product number as raw material

ingredienceName

The name of the raw material being subtracted

quantity

Quantity subtracted (e.g. 0.5)

units

Unit subtracted (e.g. Liter, see here for a list of units that can be used).

deleted

Number indicating the deleted product with the recipe (1 or 0 - deleted / not deleted). Once deleted, the product will no longer be displayed in the checkout. The default value is 0.

The required items are in the first column of the table and they are marked in bold, while the other items in the first column are optional.

 

poznamka_icon

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.

top

Sample of a correctly prepared file for importing ingredients

In the picture below, there is a sample of a file for import with two products for ingredients - Kofola and Káva Latté. Káva Latté consists of two ingredients - coffee (Káva) and milk (Mléko). The file does not have to contain the names of the products and ingredients (not obligatory items), because they are uniquely defined by their numbers.

clip0626

top

Export receptur

Recipe export is possible on the product list page via the EXPORT button in the header. This will redirect you to the Export ingredients data report. The appearance of the exported data is influenced by the COLUMN SETTINGS on the top right.

clip1415

 

uziv_tip_icon

Remember that products with ingredients should not be stocked outside of the warehouse. On the other hand, in cash registers the ingredients should be hidden so the crew cannot charge them separately. Now, check whether you have correctly set up products used for the import of ingredients.

top

This manual is for information purposes only and does not provide any warranty. The given specifications may be changed without prior notification. Illustrations and schemes are for information purposes only. The appearance and functions of both the device and software may differ based on the current version of the product and applications.

Created with from Dotypos. ©2024 Dotykačka ČR s.r.o.

  

Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC