--- title: "Import Menu Item Rule" slug: "import-menu-item-rule" description: "Import R365 menu item rules with a CSV: create or update depletion rules across menu items and locations, with prerequisites, columns, and error fixes." updated: 2026-10-01T18:19:27Z published: 2026-10-01T18:19:27Z canonical: "docs.restaurant365.com/import-menu-item-rule" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Import Menu Item Rule Menu item depletion rules are imported on the Import page in the Admin application. Use this import to create or update rules for many menu items or multiple locations at once using a CSV file, instead of configuring each rule manually. --- ## Import Prerequisites > [!WARNING] > These prerequisites are required before import. Before running this import, confirm that: - Menu items referenced in the file **already exist in R365.** - Each item in the **Item** column is a **recipe-type inventory item**. - The **Modifier Rules feature is enabled** for the account. If **Menu Item Rules** does not appear in the import list, contact an administrator to enable the feature. --- ## Security Users must have the following permission(s) to import menu item rules: - Food → Menu Items → Edit Menu Items - Admin → System Setup → Use Import Tool These permissions can be added to [custom user roles](https://restaurant365.us.document360.io/doc/docs/custom-user-roles) or [individual users](https://restaurant365.us.document360.io/doc/docs/users-overview-and-security). The [Permission Access report](https://restaurant365.us.document360.io/doc/docs/generating-a-permissions-access-report) can be used to determine which user roles or users already have these permissions assigned. For more information, see [User Setup and Security](/doc/docs/user-setup-security-and-location-access). --- ## Import Menu Item Rules Follow these steps to import menu item rules: *Click steps to expand for additional information and images.* ****1)** Navigate to the **Import** page: open the **Admin** application, expand **Import** in the left navigation, and select **Import**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-OSKBWDBI.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) ****2)** Select **Menu Item Rule** as the import option.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-Y0PHL1GB.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) ****3)** Select **Update Existing** as the type.** > [!NOTE] > With **Update Existing** selected, R365 creates a rule when the rule name does not yet exist for the menu item, and replaces the rule when it does. Rules not included in the file are left unchanged. The same file can be run again without creating duplicate rules. > [!WARNING] > **Important Note About Including Existing Modifier Rules** > > **Update Existing** replaces the entire matched rule, not just the conditions and depletions in your file. Any existing conditions or depletions for that rule that are not included in the file are removed, and this cannot be undone. Include *every condition and depletion you want the rule to keep*. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-3DSUY6FW.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) ****4)** Click **Download Template** to get the CSV template.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-GMDHUYOV.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) ****5)** Open the template file, complete it, and **save it as a CSV file.**** See [CSV Column Reference](/docs/import-menu-item-rule#csv-column-reference) below for column definitions, required values, and rule structure examples. The columns available may vary based on account configuration. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-PTVZ5UXI.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) ****6)** Back in the Import tool, click **Upload File,** then **Next**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-FLXGZQKN.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) ****7)** Review the column mapping. If using the template, column mapping should map appropriately. Then, click **Next**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-IPNV86CL.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) ****8)** Click **Import** to import the data.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-TKNYPTNH.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) ****9)** Review the results and correct any rows with errors.** For errors, the import tool will provide a downloadable corrections list. The import reports the row number and field that needs attention for each error. Valid rows in the same file can still be processed when another row has an error. **All Entered Successfully** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-7EOA6MNZ.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) **With Corrections** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-YJ3OK1PP.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) **Corrections List File** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-PAWTVA3U.png?sv=2026-02-06&spr=https&st=2026-11-01T16%3A32%3A16Z&se=2026-11-01T17%3A32%3A16Z&sr=c&sp=r&sig=CgSIdkrBzxUwxP%2BJevS1%2BFwQ9a2ZPfs9rlKfxND1NLE%3D) To make corrections, address the issues listed in the **Problem** column. Then, follow the above steps to reimport the file. Once imported successfully, the imported rules will appear in the Rule section of the menu item. --- ## CSV Column Reference The columns available may vary based on account configuration. | Column | Required | What to enter | | --- | --- | --- | | Menu Item | Yes | The name of the menu item the rule belongs to. This becomes the rule's primary condition. | | Rule Name | Yes | A unique name for the rule. Use the same name on multiple rows (with the same Menu Item) when building one multi-row rule in advanced mode. | | Condition Type | No | The type of condition: Modifier, Menu Item, Sales Category, Modifier Group, Service Type, or Location Group. Modifier Group may require separate enablement for the account. | | Condition Operator | No | `is` or `is not`. | | Condition Value | No | The name matching the selected condition type — a modifier name, sales category, service type, location group, or modifier group. | | Item | Yes, for each depletion | The recipe-type inventory item to deplete when the rule applies. A rule must contain at least one depletion item. A condition-only row may leave this blank when another row for the same rule supplies the depletion. Adding the same item twice in a rule depletes that recipe twice. | > [!NOTE] > **Condition columns must be used together.** If any value is entered in Condition Type, Condition Operator, or Condition Value, all three must be completed. Leave all three blank when no condition is needed. A row with only one or two condition values is rejected. --- ## Rule Structure ### Simple Rules A simple rule uses one row in the CSV and contains one condition (the menu item) and one depletion item. Use simple rules when a menu item always depletes the same recipe item with no additional conditions. ```plaintext Menu Item,Rule Name,Condition Type,Condition Operator,Condition Value,Item Burger,Rule 1,,,,Burger Recipe ``` ### Advanced Rules Advanced rules allow multiple conditions, multiple depletion items, or both. Use the same **Menu Item** and **Rule Name** on every row that belongs to the same rule. Each row contributes one condition, one depletion item, or both. Example — multiple conditions and multiple depletions: ```plaintext Menu Item,Rule Name,Condition Type,Condition Operator,Condition Value,Item Burger,Dine-in No Bun,Modifier,is,No Bun,Bun Recipe Burger,Dine-in No Bun,Service type,is,Dine-in,Patty Recipe Burger,Dine-in No Bun,,,,Cheese Recipe ``` This creates one Dine-in No Bun rule for Burger with two conditions (Modifier is No Bun and Service Type is Dine-in) and three depletions (Bun Recipe, Patty Recipe, and Cheese Recipe). ### Advanced Rule Limits Within one rule: - The menu item condition is set automatically and appears only once. - Service Type can appear only once. - Location Group can appear only once. - Modifier, Sales Category, and Modifier Group conditions can appear multiple times when supported by the account. - The same condition type and value combination cannot appear more than once in a rule. > [!WARNING] > **Important Note About Multi-Row Rules** > > When one row in a multi-row advanced rule is invalid, the entire rule is not saved. All rows belonging to that rule show an error indicating another row in the rule failed. --- ## Common Import Errors The import reports the row number and field that needs attention for each error. Valid, unrelated rows can still be processed when another row has an error. | Error | What to check | | --- | --- | | Menu item is required | Enter an existing menu item name. | | Rule name is required | Enter a rule name. | | A rule must have at least one action | Add at least one Item/depletion to the rule. | | Invalid Menu Item | Confirm the menu item name matches an existing R365 record. | | Invalid Item | Confirm the depletion target is an existing recipe-type inventory item. | | Condition type, operator, or value is missing | Complete all three condition columns or clear all three. | | Invalid condition value | Confirm the value exists for the selected condition type. | | Duplicate condition | Remove the repeated condition type and value from the rule. | | More than one Service Type or Location Group condition | Keep only one condition of that type per rule. | | Only one rule is allowed; advanced rules are not enabled | Use one row per rule. Contact an administrator if advanced rules are needed for the account. | | Only one condition and one action are allowed; advanced rules are not enabled | Reduce the rule to one condition and one depletion. | | Brand-managed menu item cannot be updated | Brand-controlled menu items cannot be modified through this import. |