ORTY

How to import file with menu into ORTY system

To upload menu 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:
ORTY ID*
This field is required, but you do not need to fill any data in here. The system will automatically generate a unique code for each dish.
Product name*
This field is required, enter the name of the dish here.
Categories name*
This field is required, specify in this field the category into which the dishes will be loaded.
For example, "Salads", "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 dishes into it.
Price*
This field is required, indicate the price for the dish.

For example, "100". If you would like to put down a fractional number use a period "." to separate it, for example "15.25".
Description
This is an optional field where you can add a description of the dish, which in turn will make managing dishes more convenient.
Tags
This is an optional field, you can select one or more of the existing system tags: "vegan", "vegetarian", "no-gluten", "no-sugar", "pork", "beef", "chicken", "duck "," dessert "," soup "," main "," appetizer "," seafood "," spicy "," very-spicy "," non-spicy "," alcohol "," non-alcohol "," hot -drink "," cold-drink "," cocktail "," promotion-1 "," promotion-2 "," promotion-3 "," new ".

You can add several tags to one column using the "//" separation symbols.
For example, "soup//main//vegan".

To add new tags, please write to [email protected]

Read more about displaying tags for Clients here.
Loyalty enabled*
This field is required to fill in, this option allows guests to receive discounts and cashback when buying products.

To activate, enter the value "TRUE" in this field.
To disable this option, enter the value "FALSE".
Cashback enabled*
This field is required, this option allows your Clients to make payments with the accumulated cashback for the bought products.

To activate, enter the value "TRUE" in this field.
To disable this option, enter the value "FALSE".
Not for delivery*
This field is required to fill in, it allows you to prohibit the delivery of the dish.

To activate, enter the value "TRUE" in this field, in this case Customers would not be able to order the delivery of the dish.

To deactivate this option, enter the value "FALSE", in this case Customers would have the ability to order the dish delivery.
Only for delivery*
This field is required to fill in, it will allow Customers to choose one way of receiving the dish, and that is to order "Delivery" only. Thus, Clients would not be able to order such options of receiving the dish as "Takeaway" or "Dine-in".

To activate, enter the value "TRUE" in this field, in this case Customers would be able to order only the delivery of the dish.

To deactivate this option, enter the value "FALSE", in this case, Customers would be able to choose other options for receiving an order, like "Takeaway" or "Dine-in".
1C identifier
This is an optional field, you can set up integration with the 1C system and get a unique dish code there. Then, copy and paste the code into the menu import file for the ORTY system.
Thus, you are getting the integration of dishes in two systems driven by a unique ID.

You can find more details about the 1C system integration setup here.
UKTZ
This is an optional field, here you can specify the UKTVED (Ukrainian Classification of Goods for Foreign Economic Activity) - the classification of goods is made in accordance with the law of Ukraine.
SKU
This field is optional.
The SKU (stock-keeping unit) is a code that you can use to identify and account for your items. It can be any combination of letters, numbers, and symbols.

There is no universal format for creating SKUs (although some formats can be classified as “best practices”). You can use letters of the alphabet or, conversely, use numbers only, as you prefer.
Tax groups
This field is optional, here you can specify a unique tax code, that is the letter of the tax rate which you obtain when setting up the software payment transactions recorder, more on this here.

When installing the software payment transactions recorder, you can choose any letter that will be used to denote the tax in the fiscal receipt.
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 Menu section in the Products 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.