Inventory Feed

The Inventory Feed file represents a store-level data export that contains all of the pricing and availability information for each sellable item. This data is used to create or update the store’s menu on DoorDash Marketplace and dictate the visible items and their associated prices & taxes.

This information is shared with DoorDash at least daily (max 3x per day). When a new file is detected, the ETL transformation will begin automatically to align the file with our processor’s standard format. Once the ETL process completes, a webhook is sent to our internal processor that kicks off the Menu update. This process generally takes 2-4 hours to complete but can extend depending on the amount of data received.

Sample File Requirements

To kickoff an Integration build, DoorDash requires a sample of the file that will be used as the Inventory Feed. Ideally inventory data will be sent in the format outlined under ‘Inventory Feed Setup’, however these are not strict requirements. If you are unable to meet these requirements, please work with your Technical Account Manager to align on a path forward. We will build the ETL logic based on this sample, so ensure that the production file you intend to send matches this format.

Inventory Feed Setup

Once your sample file has been approved, DoorDash requires a daily, automated transfer of the file to our SFTP server. The following expectations are in place for Inventory Feeds:

• File Type: Flat file (CSV)
• File Naming Convention: inventory_{yyyy}{mm}{dd}{hh}{MM}.csv
• Transfer Path: daily_feed/v1/{yyyy}{mm}{dd}
• File Cadence: Minimum daily refresh of Inventory Feed data (availability & pricing). This process should be automated and occur on a set scheduled time.

Inventory File Fields

Field Name	Description	Required/Optional	Format
store_id	Merchant Store ID	Required	string
sku_id	Merchant SKU ID	Required	string
upc	Universal Product Code of SKU (preferrably in GTIN-14 format)	Optional	string
category	Item Category (may be different than DD Marketplace)	Optional	string
name	Item Name (may be different than DD Marketplace)	Required	string
description	Item Description (may be different than DD Marketplace)	Optional	string
price	Item price per sellable unit	Required	number w/ 2 decimal
sale_price	Item sale or promotional price	Required*	number w/ 2 decimal
loyalty_price	Item price for loyalty club members	Required*	number w/ 2 decimal
bottle_deposit_fee	CRV fee amount	Required*	number w/ 2 decimal
tax_rate	Local tax rate for item	Required	number w/ 4 decimal
is_active	Item is in stock at store	Required	True/False
balance_on_hand	Quantity of available items in store	Optional	number
last_sold_date_data	Date item was last sold in store	Optional	string
is_alcohol	Item is alcoholic	Required*	True/False
is_weighted_item	Identifies if item is sold by weight in stores	Required*	string
approximate_sold_as _quantity	For Items sold by weight - Approx. weight of a single sellable item	Required*	string (decimal)
item_location	Text field with some location identifier	Optional	string

Required* = Required in certain situations depending on integration

Inventory Sample File

store_id	sku_id	upc	category	name	description	price	sale_price	loyalty_price	bottle_deposit_fee	tax_rate	is_active	last_sold_date	is_alcohol	is_weighted_item	approximate_sold_as _quantity	item_location	bottle_deposit_fee	promotion_type	promotion_purchase_quantity	promotion_quantity	promotion_total_price	promotion_percentage	promotion_price_off	promotion_quantity_limit_per_cart	promotion_start_time	promotion_end_time
Required	Required	Optional	Optional	Required	Optional	Required	Optional	Optional	Optional	Required	Required	Optional	Required	Required	Optional	Optional	Optional	Optional	Optional	Optional	Optional	Optional	Optional	Optional	Optional	Optional
2705977	012000001291-0		Drinks	Pepsi Soft Drink Cola Bottle (20 oz)	Pepsi Soft Drink Cola Bottle (20 oz)	2.55	1.99	1.99		7.5000	TRUE	1/5/2024	FALSE	FALSE				Buy X for Y		2	5				1/20/2024	1/25/2024
2705977	044500201819-0		Produce	Bananas (Bunch)	Bananas (Bunch)	2.75				4.0000	FALSE	1/5/2024	FALSE	TRUE	3.5			Buy X Get Y Z% Off	1	1		100		1	1/20/2024	1/25/2024
2705977	012332434235-0		Produce	Bananas (Each)	Bananas (Each)	3				4.0000	TRUE	1/2/2024	FALSE	FALSE	1			Buy X Save $Y	3				2		1/20/2024	1/25/2024