The Bulk Management tool enables you to efficiently make large-scale changes to catalogs via Menu/Catalogue Manager, simplifying the management of extensive menus with its bulk management features.
Managing your inventory effectively is crucial for maintaining an organised and efficient system. This guide will walk you through the processes of adding, updating, and deleting items, as well as updating stock availability, item-category mapping, and language settings.
How do I get started?
In Menu Manager click on “Bulk Management”
You will then be taken to the next stage. Select an option from this list. Below you will find the step by step guide for each option:
Adding Items
1. Access the Add Items Operation
- Navigate to the "Add Items" section in your dashboard.
2. Download the Template
- Click on "Download Template."
- Select the item attributes you wish to include.
- Click "Download Template" again to obtain the CSV file.
3. Fill in the Template
- The template includes selected attributes as columns, along with category IDs and names.
- Fill in the CSV template with your new items. Refer to the attribute list below.
- To add items to existing categories, use the correct category ID.
- To create a new category, leave the category ID blank and enter just the category name.
- Remove unused category IDs and names.
- Do not modify existing category IDs.
4. Upload the File
- Upload the file from either the Bulk Management screen or the Template Download screen.
- Click "Upload File" and select your prepared CSV.
- Confirm the file name and click "Upload File" if correct.
5. Review and Confirm
- If there are issues, you'll be prompted to review them.
- Warnings highlight potential issues but won’t block the upload.
- Errors can include general issues (e.g., changed column headers) or row-specific issues (e.g., negative prices).
- A complete list of errors and how to resolve them is available below.
- If there are no errors, review the proposed changes.
- Check a sample of your items or attributes to confirm accuracy.
- Use item attribute filters in the review screen if necessary.
- Tick the checkbox to confirm and click "Upload" to complete the process.
Note: You cannot revert back once you click on upload, so ensure thorough checking before proceeding.
Updating Items
1. Access the Update Items Operation
- Navigate to the "Update Items" section in your dashboard.
2. Download the Template
- Click on "Download Template."
- Select the attributes you wish to update.
- Click "Download Template" again to obtain the CSV file.
3. Edit the Template
- The template includes selected attributes as columns, with optional PLU and barcode for identification.
- Edit the relevant attributes for each item.
- You can update multiple attributes at once.
- Delete rows for items you're not updating.
- Do not change the item ID.
4. Upload and Confirm
- Follow the same upload and confirmation process as outlined in the Add Items section.
Deleting Items
1. Access the Delete Items Operation
- Navigate to the "Delete Items" section in your dashboard.
2. Download the Template
- Click on "Download Template" to obtain the CSV file.
3. Prepare the Template
- The template includes Item ID, Item Name, PLU, and Barcode.
- Keep only the rows for items you want to delete.
- Remove all other rows.
4. Upload and Confirm
- Follow the same upload and confirmation process as outlined in the Add Items section.
Updating Stock Availability
1. Access the Update Stock Availability Operation
- Navigate to the "Update Stock Availability" section.
2. Download the Template
- Click "Download Template."
- Select the sites where stock needs updating (max 10 sites allowed at a time).
- Click "Export Stock Availability."
3. Edit the Template
- The template includes a stock status column per site (‘available’, ‘unavailable’, ‘hidden’).
- Update the stock status in the last column.
- Do not edit other attributes.
4. Upload and Confirm
- Follow the same upload and confirmation process as outlined in the Add Items section.
Updating Item-Category Mapping
1. Access the Item-Category Mapping Operation
- Navigate to the "Item-Category Mapping" section.
2. Download the Template
- Click "Download Template."
3. Edit the Template
- The template includes Category ID, Category Name, Item ID, Item Name, PLU, and Barcode.
- To assign an item to an existing category, ensure the correct category ID and name are filled.
- To assign it to a new category, leave the category ID blank and provide the category name.
- Do not modify existing category IDs.
4. Upload and Confirm
- Follow the same upload and confirmation process as outlined in the Add Items section.
Updating Item Languages
1. Access the Update Additional Languages of Items Operation
- Navigate to the "Update Additional Languages of Items" section.
2. Download the Template
- Click "Next," then "Download Template." Supported language codes will be displayed.
3. Edit the Template
- The template includes Item ID, Item Name and Description, Locale Code, PLU, and Barcode.
- Duplicate a row for each language version.
- Update name/description for each language.
- Use the following locale codes: en (English), fr (French), it (Italian), ar (Arabic), zh (Chinese).
4. Upload and Confirm
- Follow the same upload and confirmation process as outlined in the Add Items section.
Updating Category Languages
1. Access the Update Additional Languages of Categories Operation
- Navigate to the "Update Additional Languages of Categories" section.
2. Download the Template
- Click "Next," then "Download Template." Supported language codes will be displayed.
3. Edit the Template
- The template includes Category ID, Category Name, Description, and Locale Code.
- Duplicate each row per language.
- Update name and description fields in each language.
- Use the following locale codes: en (English), fr (French), it (Italian), ar (Arabic), zh (Chinese).
4. Upload and Confirm
- Follow the same upload and confirmation process as outlined in the Add Items section.
By following these steps, you can efficiently manage your inventory, ensuring that your items, categories, and language settings are up-to-date. If you encounter any issues or need further assistance, please contact our support team.
List of attributes supported
Field | Description | Supported input |
category_id | Deliveroo generated ID of the category. Never modify this id. | Text value. |
category_name | This is the category the item will be assigned to. | Text value. |
item_id | Deliveroo generated ID of the item. Never modify this id.
| Text value |
item_name | This is the name of the item. | Text value.
Accepted formats: max. 120 characters |
item_description | This is the description of the item.
| Text value.
Accepted formats: max 500 characters |
delivery_price | This is the price the customer will be charged for a delivery order.
| Non-negative decimal number with a maximum number of decimals based on the market (no currency symbol). In most cases, maximum number of decimals can be 2 |
instore_price | This is the price the customer will be charged for a pick-up order.
| Non-negative decimal number with a maximum number of decimals based on the market. In most cases, the maximum number of decimals can be 2. |
tax_rate | This is the tax rate that should be applied to the item.
| 0, 5, 12.5, 20 |
allergens | These are the allergens that should be applied to the item or option. | A comma separated list of allergen codes. Supported codes: See below. |
calories | This is the kilocalorie value of an item or option. | Non-negative whole number. |
hfss | This marks an item as high in saturated fat, salt and sugar (HFSS). Relevant to some grocery partners in England and Wales only. | TRUE/FALSE.
Enter “TRUE” to mark the item as high in fat, sugar or salt and “FALSE” as not high in fat, sugar or salt.
If you leave this field empty it will be marked as FALSE by default. |
max_quantity | This is the maximum quantity of an item that a customer can place an order for.
| Non-negative whole number. |
age_restricted | This marks an item as age-restricted or not.
| TRUE/FALSE. Default value is FALSE
Enter “TRUE” to mark the item as age-restricted and “FALSE” as not age-restricted.
If you leave this field empty it will be marked as FALSE by default.
|
PLU | This is the Price Look-Up Code for an item for POS integrated partners. Also used by partners to add their own internal id of items (partner SKU ID)
| Text value. |
barcodes | Barcodes allow you to assign multiple barcodes to an item, up to a maximum of 10 barcodes per item.
A barcode should not contain any spaces and should only contain numbers. The following barcode formats are accepted: EAN-8, UPC-A, EAN-12, EAN-13, GTIN-14.
All barcodes for an item should correspond to the correct pack size for that item. For example, a barcode for a singular item should not be added to the barcodes for a 6-pack of the same item. | A comma separated list of barcodes |
Classifications | This marks an item to ensure age, marketing or quantity restrictions are applied. in line with local legislation and enables better identification of highly regulated items. Please note that this must be used in addition to the age_restricted field where items require an age verification check at delivery.
Only whitelisted partners can add over the counter (OTC) Medication. | A comma separated list of classification codes. Supported codes: See below. |
replacement_eligible | Used in Item Substitutions in Grocery. Indicates whether this item can act as replacement for any other unavailable item (Relevant for Grocery Partners). | TRUE/FALSE
Enter “TRUE” to mark the item as eligible as replacement and “FALSE” as not eligible as replacement.
If you leave this field empty it will be marked as TRUE by default.
|
substitution_eligible | Used in Item Substitutions in Grocery. Indicates whether this item can be substituted by another item when this item is unavailable (Relevant for Grocery Partners). | TRUE/FALSE
Enter “TRUE” to mark the item as eligible for substitution and “FALSE” as not eligible for substitution.
If you leave this field empty it will be marked as TRUE by default.
|
Internal Name | This is the item name that will be displayed in the Deliveroo provided device and on printed tickets to site staff (not in the Deliveroo app to customers).
| Text value.
Accepted formats: max 255 characters |
dietary_information | Help consumers with dietary information by providing an up-to-date description of any dietary category (or categories) a specific item complies with.
This information helps customers to easily identify the items that more closely match with their requirements | A comma separated list of dietary information codes. Supported codes: See below. |
returnable | This attribute allows the item to be returnable by the customers through the Deliveroo portal.
This is applicable to non-food items only. | TRUE/FALSE
Enter “TRUE” to mark the item as returnable and “FALSE” as not returnable.
If you leave this field empty it will be marked as FALSE by default.
|
is_variable_weight | This attribute is used for items sold by variable measurements, such as weight or volume (e.g., counter or deli items like tabbouleh or olives).
Feature only available for selected partners. For these items, please contact your account manager. Note that variable measurement items cannot be substituted, returned, or included in offers. Additionally, the Picking API does not support these items, and picking partners must use the "Grocery Order Picker" app.
If a variable measurement item has a specified max_quantity, it will have a limit on the number of increments that can be purchased. | TRUE/FALSE
Enter “TRUE” to mark the item as a variable weight item and “FALSE” as not a variable weight item.
If you leave this field empty it will be marked as FALSE by default. |
variable_weight_sold_by | How the item is sold, either by count or by a measurement. e.g. you may wish to sell 150g burgers by COUNT. However olives would typically be sold by MEASUREMENT | COUNT or MEASUREMENT |
variable_weight_unit_of_measurement | The unit of measurement for the item if it’s a variable weight item | GRAMS or KILOGRAMS |
variable_weight_increment | The increment of the unit of measurement customers are allowed to order.
For example: If the unit is GRAMS and increment is 100 then this would represent increments of 100g. This would permit orders of 100g, 200g, 300g etc. | Number |
irish_drs_deposit_fee | Deposit fee value for items that are eligible for Deposit Return Scheme in Ireland
Only items with the Re-turn logo and barcode on the label are eligible. (In Republic of Ireland only) | 0.15 For bottles/cans of 150 to 500ml
OR
0.25 For bottles/cans of 501ml to 3 litres |
irish_drs_items_per_pack | Items per pack. Used in the deposit fee setup. (In Republic of Ireland only) | Non negative whole number |
Valid allergens by country
Valid allergens list available here
Valid classifications by country
Valid classification list available here
Valid dietary information by country
Valid dietary information available here
Errors and how to resolve them
Errors and warnings have been designed to be self explanatory. We recommend exporting the issues which will give you visibility into each issue per row.
Note that you won’t be able to proceed with the upload if there are errors in the file. Warnings are designed when you are trying to make unusual changes, but you can still proceed with Warnings.
# | Issue name | Issue severity | Issue type | How to fix it? |
1 | Category creation limit (100) | Error | General: Operation | Combine categories to ensure that the category count is less than 100 |
2 | Empty file | Error | Generic | Upload the correct file |
3 | File too big | Error | Generic | Ensure that the file size is less than 8MB |
4 | Invalid file type | Error | Generic | Only CSV is supported |
5 | Character limit
Example description error: Cannot be more than 500 characters | Error | Row Specific | Ensure that item name, internal item name and descriptions are within character limit detailed in the error message. See list of attributes for more details. |
6 | Incorrect type
Example price error: string is not the right format for this attribute. Enter in number format instead. | Error | Row Specific | Ensure that you enter only support values. For example, price needs to be a number and not text value. See list of attributes for more details. |
7 | Invalid attribute value
Example Tax rate error: 2 is not an accepted value. Accepted values are 0, 5, 12.5, 20 | Error | Row Specific | Ensure that you only provide allowed values for attributes such as allergens, tax rates, dietary information. See list of attributes for more details on allowed values. |
8 | Non-negative numeric value required | Error | Row Specific | Ensure that the entered value for the attribute is not a negative number. |
9 | Decimal place limit | Error | Row Specific | Ensure that the decimal place supported for price attribute is not more than 2. |
10 | Missing required attribute | Error | Row Specific | Ensure that the required columns are filled in |
11 | Missing attribute from group | Error | Row Specific | Attributes such as variable weight and DRS require a group of columns to be field. Ensure that you’ve filled all required columns. See list of attributes for more details on how to fill Variable weight and Deposit Return Scheme (DRS) attributes. |
12 | Deposit return scheme (DRS) error | Error | Row Specific | Deposit Returns Scheme (DRS) is only allowed in Ireland. |
13 | ID not found | Error | Row Specific | Ensure that you are not modifying or creating your own Item ID or Category ID. |
14 | Missing header(s)/ column(s) | Error | Row Specific | Ensure that you include all the required columns in the upload |
15 | Item-category limit (1999) | Error | General: Attribute | Ensure that maximum items in one category are not more than 1999. |
16 | More than 10 site IDs | Error | General: Attribute | You can only update the stock of a maximum of 10 sites at a time. |
17 | Invalid barcode | Error | Row Specific | Ensure you provide a valid barcode. See list of attributes for more details |
18 | Duplicate rows | Error | Row Specific | Ensure that you’re not duplicating rows while editing item attributes |