When you create your product feed 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 | |
| meal | Boolean |
Advanced fields
| Field name | Field type | Comments |
|---|---|---|
| order_fullfilment |
String (separate multiple values with commas) |
Possible values: DELIVERY, PICKUP, DINEIN, CURBSIDE, ALL |
| upsell_target | Number | Defines products for upgrade recommendations. Required for the Upsell feature. |
| is_add_on | Boolean |
Marks complementary products. Required for the Add-On widget. |
| profit_margin | Double | Indicates product profitability. Used for margin-based weighting and rules. |
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". |