Français Italiano Português do Brasil

[Restaurants] Product Catalog Best Practices

Follow

When you create your product catalog file, note the following requirements and comments to ensure your catalog is optimal and functions correctly. 

Mandatory fields

Field name Field type Comments
sku String (Product ID)
name String  
group_id String  
group_name String  
categories String
(separated by pipes with no spaces)		  
price Float If the customer has a store-level price and will use store-aware recommendations, we'll use the price from the store feed, and this column should contain an average price, as it's used only for conditioning for core experiences.
in_stock Boolean A product must be recommendable in at least one channel to be considered in stock.
url String
(must be a valid URL, starting with HTTP/HTTPS)

Needed for Experience Email and VisualML. If you aren't using these features, this field can contain a dummy URL.
image_url String
(must be a valid URL, starting with HTTP/HTTPS)

Needed for Experience Email and VisualML. If you aren't using these features, this field can contain a dummy URL.
odmb_recommendable Boolean

For the Drive Thru channel.

If you aren't using this channel, use TRUE.
kiosk_recommendable Boolean If you aren't using this channel, use TRUE.
mobile_recommendable Boolean If you aren't using this channel, use TRUE.
web_recommendable Boolean If you aren't using this channel, use TRUE.
breakfast Boolean  
restofday Boolean  
mdp_breakfast Boolean  
mdp_lunch Boolean  
mdp_dinner Boolean  
mdp_latenight Boolean  
mdp_morningtea
/overnight/afternoontea		 Boolean  
meal Boolean  

Optional fields

Field name Field type Comments
order_fullfilment

String

(separate multiple values with commas)

Possible values:

DELIVERY, PICKUP, DINEIN, CURBSIDE, ALL
upsell_target Number Upsell Feature
upsell_type String Upsell Feature
upsell_category_2 String Upsell Feature
mobile_expiration_date

String

(YYYY-MM-DD)

 LTO Feature
kiosk_expiration_date

String

(YYYY-MM-DD)

 LTO Feature
odmb_expiration_date

String

(YYYY-MM-DD)

 LTO Feature
Add_on

Boolean

 Add-on widget Feature
profit_margin

Double

 Margin (weight profit margin) Feature

Custom fields

Field name Field type Comments
Float
(up to 1000 characters)

Number

<"column_name">

Any custom product attribute with numeric values. Must be ≥ 0. 
For example, "special_price" or "margin".

Date

(yyyy-mm-ddThh:mm:ss)

 

String 

<"column_name">

Any custom product attribute with date values. 
For example, "date_added" or "sale_end_date".

String

(up to 1000 characters)

 <"column_name"> Any custom product attribute with string values.For example, "brand" or "badge title".
Boolean <"column_name"> Any custom product attribute with Boolean values. 
For example, "true" or "false".