> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://az.help.clopos.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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:![](https://storage.crisp.chat/users/helpdesk/website/-/7/4/0/e/740e20bde3bec000/image_nuc2la.png)

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

|| 💡 Important: The colors shown in the example are only used to separate the products. Do not use colors when preparing the Excel file.

* ![](https://storage.crisp.chat/users/helpdesk/website/-/7/4/0/e/740e20bde3bec000/image_lm8a0q.png)

* **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.
| 💡 Note: Column names, units, and product types must be written in English.

You can download the sample Excel file from the link below.![](https://storage.crisp.chat/users/helpdesk/website/-/7/4/0/e/740e20bde3bec000/image_11jp59l.png)

[Download the Excel file!
](https://drive.google.com/uc?export=download&id=1sRBCPzcBk-bc_b0GWi0bv1JWRF08M5iA)After completing the **Excel** table, go to the **Back Office** and import the file.![](https://storage.crisp.chat/users/helpdesk/website/-/7/4/0/e/740e20bde3bec000/image_149hosh.png)