Skip to main content

Menu / Catalogue manager

L
Written by Laura Porter
Updated this week

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

Did this answer your question?