Importing Recipes Using Excel

In the Clopos system, you can import technical cards (recipes) in bulk.
For this, you need to create a new Excel file and enter the names of the technical cards, measurement units, categories, and other necessary information in a table.
To import a menu item with its ingredients into the system, enter the information in Excel as follows:

• Name → First, enter the name of the product that will be sold, and then enter the names of the ingredients, products, or semi-finished products used in its recipe.
• Type → Enter the product type: GOODS, DISH, INGREDIENT, or PREPARATION.

All product types must be written in English and capital letters.

• If a purchased product is sold without any changes, write GOODS.
• If it is a product with ingredients, write DISH.
• If it is used as an ingredient, write INGREDIENT.
• If it is a semi-finished product, write PREPARATION.

For example, Coca-Cola can be created both as a finished product and as an ingredient. In the first case, its type should be GOODS. In the second case, its type should be INGREDIENT.
Category → Select the category of the products, dishes, and ingredients.

• 
• Station → Station means the place where the products are prepared.

Note: Station should be added only to products and dishes. Do not add a station to ingredients.

• Price → Enter the selling price of the product. For example: 10, 20, 25.

Note: Price should be entered only for products and dishes.

• Cost Price → Enter the cost of one unit of the ingredient based on its weight or quantity. For example, if 5 kg of flour costs 2.5 AZN, the cost of 1 kg is 0.5 AZN.
• GROSS → Enter the quantity of the ingredients used in the recipe. This field should be empty for the technical card itself.
• Unit → Enter the measurement unit of the ingredient, such as kg, l, pcs, m, g.
• Sold by weight → If the product or dish is sold by weight, enter "1" in the relevant column.

It is not recommended to add technical cards without ingredients to the Excel file where recipes are being entered. Otherwise, the system may create the technical card as an ingredient.

You can download the sample Excel file from the link below.

Download the Excel file!
After completing the Excel table, go to the Back Office and import the file.

Updated on: 07/09/2026