Skip to main content

Bulk Management CSV attributes explained

R
Written by Rosie Elizabeth Drew
Updated over 2 weeks ago

This article explains the fields available in Bulk Management templates and what values they accept.

If you are unsure how to use Bulk Management, see How to use Bulk Management in Menu Manager.

If you are seeing an upload error, see Bulk upload errors and how to fix them.

Important rules

  • Do not modify Deliveroo-generated IDs (item_id, category_id)

  • Use only accepted values for each field

  • Prices must not include currency symbols

  • Do not enter negative values unless explicitly allowed

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

Vertical-specific fields

Some attributes apply only to certain partners:

Grocery partners

  • replacement_eligible

  • substitution_eligible

  • is_variable_weight

  • variable_weight_* fields

Variable weight items:

  • Cannot be substituted

  • Cannot be returned

  • Cannot be included in offers

  • May not be supported by all integrations

If unsure whether this applies to you, contact your Account Manager.


Republic of Ireland only

  • irish_drs_deposit_fee

  • irish_drs_items_per_pack

Deposit Return Scheme (DRS) fields apply only to eligible products in Ireland.


Character limits

  • item_name: max 120 characters

  • item_description: max 500 characters

  • internal_name: max 255 characters

If these limits are exceeded, your upload will fail.


For upload troubleshooting, see Bulk upload errors and how to fix them.

Did this answer your question?