ORTY

How to import file with ingredients into ORTY

To upload ingredients to the ORTY system, follow these four simple steps:


1. Make a copy of the template.

2. Edit it.

3. Download the finished file.

4. Import it into the system.

1
Copy the template to edit it.

You can find the template following this link.

Copy it to continue the work. To make a copy go to the "File" tab and select "Make a copy" option.
Next, save the file on your Disk by choosing a convenient folder and click "OK" to continue.
2
Edit the downloaded copy of the file.

Enter data, which you would like to import:
Ingredient name*
This field is required to fill in, enter the name of the ingredient here.
Category name
This field is optional, you can specify here the category into which the ingredients are going to be loaded.
For example, "Semi-finished products", "Drinks", etc.

If you have previously created a category in the ORTY system, then by writing its name in this field, you can also load ingredients into it.
Packing*
This parameter is required, specify in this field the packing of the ingredient by choosing one of the three available options:

  • "KILOGRAM", volume in kilograms.
  • "PCS", volume in pieces.
  • "LITER", volume in liters.
Stock threshold
This field is optional, specify the ingredient stock threshold here so you would be able to keep track of which ingredients need to be replenished soon.

If the amount of the ingredient drops below the threshold value, you would see a system warning displayed in the "Stock" tab in the "Leftovers".

More information on how to work with ingredients in the inventory can be found here.
Approx price
This field is optional, here you can indicate the approximate price of the ingredient.

Please note, by default, you set the approximate price for 1 unit of production (KG/L/PC).
Waste, %
This is an optional field where you can indicate the percentage of product lost when refining an ingredient.

Please note that when writing a fractional number, you should use a period "." as a separator sign.
For example, "12.6".
Cooking, %
This is an optional field in which you can indicate the percentage of product lost when cooking an ingredient.

Please note that when writing a fractional number, you should use a period "." as a separator sign.
For example, "12.6".
Frying, %
This is an optional field in which you can indicate the percentage of product lost when frying an ingredient.

Please note that when writing a fractional number, you should use a period "." as a separator sign.
For example, "12.6".
Stewing, %
This is an optional field in which you can indicate the percentage of product lost when stewing an ingredient.

Please note that when writing a fractional number, you should use a period "." as a separator sign.
For example, "12.6".
Roasting, %
This is an optional field in which you can indicate the percentage of product lost when roasting an ingredient.

Please note that when writing a fractional number, you should use a period "." as a separator sign.
For example, "12.6".
3
Download edited file.
After editing, save the file in "Microsoft Excel (XLSX)" format on your device. To do this, go to the "File" tab, select the "Download" option in the required format.
4
Upload the file into ORTY.
Go to the administrative panel in the Inventory section in the Dictionary section in the Ingredients tab and click the "Upload file" button.

Click "Continue" and you will be able to select the edited and saved file on your device for the import.
pay attention

After each attempt to import a file into the ORTY system, you will receive a system message to the e-mail whether the data has been loaded successfully.

The system message informing about successful data import will look like this:
If the "Status" of the reconciliation is COMPLETED, it means that the download was successful and the data was imported.

If there were mistakes in the file, the system is going to send you a notification about errors, in the following format:
pay attention

Click on the "Download file with errors" button, the system will highlight the fields that need editing for making a successful upload into the system.

Thus, in just 4 steps, you can successfully import the user base file into the ORTY system.