Skip to main content

Marketplace Merchant Pick Reports

Avoidable Wait

Report Type - AVOIDABLE_WAIT

Description

This report outputs a list of orders that have merchant avoidable wait

Example Report

Column NameData TypeDefinitionExampleSince Report Version
business_idnumberDoorDash Business ID1851
store_idnumberDoorDash Store ID247251
order_delivered_datedateDate when order was delivered2022-08-03 0:00:001
order_delivered_timevarcharTimestamp of order delivery11:54:481
dd_order_idvarcharDoordash Order IDfae261ba1
client_order_idvarcharClient Order IDcef4d65b-09cc-427a-a4e4-efb3115c9e3e-doordash1
merchant_supplied_idvarcharThe merchant's store identifier123-01
store_namevarcharStore nameMetro Pizza Main Street1
was_asapvarcharThis flag is used to identify scheduled deliveries. e.g. was_flag = False, will give you future deliveriesTRUE1
confirmed_food_ready_timebooleanEstimated time that store took to prepare food2022-08-03 11:43:201
dasher_arrival_timetimestampLocal time when dasher arrived at store2022-08-03 11:42:561
order_pickup_timetimestampTime when dasher picked up the order2022-08-03 11:49:271
minutes_latetimestampTime difference between when food was ready and food pickup time61
delivered_atnumberTime when order was delivered2022-08-03 11:54:481
total_delivery_timetimestampTime difference between when order was placed and when order was delivered241
order_subtotalnumberOrder Subtotal351
net_payoutnumberOrder payout261
currencyvarcharThe currency used for transactions in this storeUSD1
order_place_datedateOrder place date2022-08-032
order_place_timetimeOrder place time11:43:202

Canceled Orders

Report Type - CANCELLED_ORDERS

Description

This report outputs a list of all canceled orders and the reason for cancellation

Example Report

Column NameData TypeDefinitionExample
business_idnumberDoorDash Business ID185
store_idnumberDoorDash Store ID24725
order_place_datetimestampDate when order was placed2022-08-02 0:00:00
order_place_timetimestampTime when order was placed21:49:56
store_namevarcharInternal DoorDash Store NameMetro Pizza Main Street
order_idvarcharThis value is unique to the order.ed74e64e
client_order_idvarcharClient order ID from POS (Merchant-facing ID from POS system) If not POS, then this will be empty69f2ccf2-5a51-4d7f-bdb2-5ae865454c15-doordash
merchant_supplied_idvarcharThe merchant's store identifier123-0
channelvarcharIt shows the channel where order was placed and contain following values: marketplace storefront driveMARKETPLACE
was_asapbooleanThis flag is used to identify scheduled deliveries. e.g. was_flag = False, will give you future deliveriesTRUE
cancelled_attimestampTimestamp when order was canceled2022-08-02 22:12:24
cancellation_categoryvarcharCategory of cancellationAvoidable Store Operations
cancellation_category_descvarcharDetailed description of the category of cancellationStore closed
is_paidbooleanFlag to show whether order was paid or notFALSE
mx_friendly_non_payment_reasonvarcharIt shows the reason why order was canceled and have different values like: Wrong Order Handed to Dasher Order Not Prepared Mx Did Not Confirm etc.NULL
order_confirmation_timetimestampTimestamp when order was placed2022-08-02 21:50:04
minutes_to_confirmnumberMinutes it took to confirm the order1
minutes_to_cancelnumberMinutes it took to cancel the order22.47
order_subtotalnumberOrder Subtotal40
net_payoutnumberOrder payout0
currencyvarcharThe currency used for transactions in this storeUSD

Consumer Feedback

Report Type - CONSUMER_FEEDBACK

Description

This report outputs all customer feedback that has been received (food_quality, menu_quality, order_quality, public_review)

Example Report

Column NameData typeDefinitionExampleSince Report Version
created_at_date_localtimestampDate of Feedback in Local time2022-10-301
business_idnumberDoorDash Business ID1851
store_idnumberDoorDash Store ID247251
categories_listvarcharThe type of menu item that had an error (ie Main, Side)There are about 100 categories, some of the are: Bad quality of items Blank / Missing Menu Good quality Good quality, Good value Good quality, Good value, Wide selection1
commentsvarcharCustomer provided feedback textadded no cheese to our salads, the spicy italian didn't have hardly any meat, and they forgot our chips.1
review_typevarchar4 possible options food_quality, menu_quality, order_quality, public_reviewpublic_review1
freq_tagvarcharIt has 3 values of New, Frequent or Occasional. If Customer first order data is within last month then it’s ‘New’, If there are more than 2 orders in last 90 days then it’s ‘Frequent’, Else it’s ‘Occasional’Occasional1
merchant_ratingnumber1-552

Report Type - MENU_ITEM_ERROR

Description

This report outputs a list of orders that had either a missing or incorrect item along with the specific item that was flagged

Example Report

Column NameData TypeDefinitionExample
business_idnumberDoorDash Business ID185
store_idnumberDoorDash Store ID24725
timestamp_local_datetimestampTime of transaction in Local time2022-08-03 0:00:00
timestamp_local_timetimestampDate of transaction in Local time2022-08-03 14:26:17
timestamp_utc_datetimestampTime of transaction in UTC time2022-08-03 0:00:00
timestamp_utc_timetimestampDate of transaction in UTC time2022-08-03 18:26:17
dd_order_idvarcharThis value is unique to the order.f3706751
merchant_order_idvarcharClient order ID from POS (Merchant-facing ID from POS system) If not POS, then this will be empty800ec4b8-1cee-46c5-b20d-ef4accfd16ce-doordash
merchant_supplied_idnumberThe merchant's store identifier123-0
store_namevarcharInternal DoorDash Store NameMetro Pizza Main Street
error_categoryvarcharMissing Item or Incorrect Item categoryingredient_error
menu_categoryvarcharThe type of menu item that had an error (ie Main, Side)BIGWAY® Series
item_namevarcharName of impacted menu item#10 All-American Club®
quantitynumberQuantity of impacted menu items1
error_chargenumberThe total error charge170
customer_commentsvarcharCustomer entered comment on menu item errorNULL
modifier_detailjsonIt contains the order item details like menu item extra option{"item_extra_option":[{"name":"Artisan Flatbread (220 Cals)","quantity":"1"}]}
order_linkvarcharURL of the Orderhttps://www.doordash.com/merchant/deliveries/0179a57f-bedb-4689-8b6e-8caff3706751?store_id=256263

Report Type - MENU_OPEN_HOURS

Description

This report outputs the menu hours for all stores

Example Report

Column NameData TypeDefinitionExample
business_idnumberDoorDash Business ID185
store_idnumberDoorDash Store ID24725
menu_idnumberDoorDash Menu ID12669534
menu_namevarcharMenu NameMetro Pizza - [ALL DAY][Metro Pizza 123-0][2.16.2025]
day_of_weekvarcharDay of the week like Monday, Tuesday and so onSun
day_indexnumberIt is index of the week. Where 0 represents 'Mon', 1 'Tuesday' and so on.6
start_timetimestampStart time when menu is available9:00:00 AM
end_timetimestampEnd time when menu will not be available8:00:00 PM

Report Type - MENU_SPECIAL_HOURS

Description

This report outputs all the upcoming special hours that have been set for all stores

Example Report

Column NameData TypeDefinitionExample
business_idnumberDoorDash Business ID185
store_idnumberDoorDash Store ID24725
menu_idnumberDoorDash Menu ID12669534
menu_namevarcharMenu NameMetro Pizza - [ALL DAY][Metro Pizza 123-0][2.16.2025]
dayvarcharDate of the menu special hoursSun
start_timetimestampStart time when menu is available6
end_timetimestampEnd time when menu will not be available9:00:00 AM
is_closedbooleanis_closed should dictate what kind of special hours it represents, whether it's to make it available/unavailable8:00:00 PM

Order Details

Report Type - ORDER_DETAIL

Description

This report includes all orders along with the items and modifiers associated with the order as well as the order subtotal and whether a Dashpass was used on the order. If applicable a merchant order number (Merchant POS Order ID) is supplied as well

Example Report

Column NameData TypeDefinitionExampleSince Report Version
business_idnumberDoorDash Business ID1851
store_idnumberDoorDash Store ID247251
active_datetimestampDate of when order was submitted UTC2022-08-03 0:00:001
active_date_utctimestampDate of when order was submitted UTC2022-08-03 0:00:001
dd_order_numbernumberDoordash delivery UUID1df0588a-711d-4fb6-8899-a49882e8822d1
mx_order_numbernumberMerchant's external order identifier. This is only relevant if orders are integrated to Merchant's POS system. This field may be null when the report is generated.ab9ebc86-df9b-4c2b-a4f4-6570f52886a0-doordash1
external_order_idnumberMerchant's external order identifier. This is only relevant if orders are integrated to Merchant's POS system. This field may be null when the report is generated.ab9ebc86-df9b-4c2b-a4f4-6570f52886a01
business_namevarcharBusiness nameMetro Pizza1
store_namevarcharStore nameMetro Pizza Main Street1
merchant_store_idnumberThe merchant's store identifier1231
item_merchant_supplied_idnumberItem Id supplied by the Merchant402461
order_item_idnumberID for Item within Order30000030589970731
dd_item_idnumberDD item Id24071180911
item_namevarcharItem NameChocolate Chip (210 Cals)1
category_namevarcharItem CategorySides1
menu_namevarcharMenu NameMetro Pizza - [ALL DAY][Metro Pizza 123-0][2.01.2025]1
timezonevarcharTimezone of merchantUS/Central1
is_consumer_pickupbooleanIs pickup orderFALSE1
dashpassbooleanAre order/customer eligible for dashpass discountTRUE1
original_item_pricenumberItem Price11
unit_pricenumberItem Price11
order_item_quantitynumberItem quantity21
subtotalnumbercart subtotal11
order_place_datedateorder place date2022-08-032
order_place_timevarcharorder place time0:00:002
order_cart_idnumberorder cart ID300000970732
created_attimestamporder created at2022-08-03 0:00:002
updated_attimestamporder updated at2022-08-03 1:00:002

Payout Summary

Report Type - PAYOUT_SUMMARY

Description

This report outputs a summary all payouts that have been completed within the requested report time frame for report version 2 or earlier

Example Report

Column NameData TypeDefinitionExampleSince Report Version
business_idnumberDoorDash Business ID1851
store_idnumberDoorDash Store ID247251
transaction_start_local_datetimestampBeginning date of transactions included the payout period in local time2022-08-03 0:00:001
transaction_end_local_datetimestampEnd date of transactions included the payout period in local time2022-08-03 0:00:001
transaction_start_utc_datetimestampBeginning date of transactions included the payout period in UTC2022-08-03 0:00:001
transaction_end_utc_datetimestampEnd date of transactions included the payout period in UTC2022-08-03 0:00:001
store_namevarcharInternal DoorDash Store NameMetro Pizza Main Street1
merchant_store_idvarcharThe merchant's store identifier1231
payout_datevarcharThe date the payout was completed2/20/251
currencyvarcharThe currency used for transactions in this storeUSD1
subtotalnumberThe total price of an order before taxes, commissions, fees, error charges, and tips155.461
tax_subtotalnumberSubtotal tax passed to Merchant based on adjusted subtotal. DoorDash will use the item level tax rate overrides if provided by Merchant. If the store is in a marketplace facilitator state, the column value will be 0. You should refer to the column named “Tax Remitted by DoorDash to State”.12.471
commissionvarcharAmount in commission charged, collected by DoorDash.27.541
commission_taxvarcharAmount in taxes on the commission charged for the payout period0.681
drive_chargevarcharFee for Drive On-Demand deliveries01
marketing_feenumberAny marketing fees charged or implemented as part of active campaigns such as Marketing (see Run Your Own Marketing on DoorDash on DoorDash for more details) or Customer promotions (see What is the Customer Feedback in the Merchant Portal? for more details)6.991
tipsnumberAmount in staff tips collected and remitted to the Merchant01
error_chargesnumberTotal error charges to cover reimbursements issued to customers for missing or incorrect items01
adjustmentsnumberModifications made to an already completed order to incorporate a refunded error charge from DoorDash, and a one-off payment or charge made to the store. The reasons can be reimbursement, rebates, or rewards.201.81
total_before_adjustmentsnumberThe vaule of the net_payout inclusive of adjustments131.521
net_payoutnumberThe amount included in your DoorDash payment deposit, which includes total earnings minus commission, fees, error charges, and plus or minus adjustments.334.321
payout_idnumberDoorDash unique ID for each payout. Each payout can include the payout for deliveries, one-time store payments, etc lumped into one Payout_ID4621234931
payout_statusvarcharThe status of the payout, indicating whether the funds have been processed, completed, or if there are any issue (PAID)PAID1
tax_remitted_by_doordash_to_statevarcharTotal taxes collected on orders that DoorDash has remitted directly to tax authorities on behalf of the merchant01
discountsnumberIn store order discountNULL2

Report Type - PAYOUT_SUMMARY

Description

This report outputs a summary all payouts that have been completed within the requested report time frame for report version 3 and later

Example Report

Column NameData TypeDefinitionExampleSince Report Version
business_idnumberDoorDash Business ID1853
store_idnumberDoorDash Store ID247253
transaction_start_local_datetimestampBeginning date of transactions included the payout period in local time2022-08-03 0:00:003
transaction_end_local_datetimestampEnd date of transactions included the payout period in local time2022-08-03 0:00:003
transaction_start_utc_datetimestampBeginning date of transactions included the payout period in UTC2022-08-03 0:00:003
transaction_end_utc_datetimestampEnd date of transactions included the payout period in UTC2022-08-03 0:00:003
store_namevarcharInternal DoorDash Store NameMetro Pizza Main Street3
merchant_store_idvarcharThe merchant's store identifier1233
payout_datedateThe date the payout was completed2/20/253
currencyvarcharThe currency used for transactions in this storeUSD3
subtotalnumberThe total price of an order before taxes, commissions, fees, error charges, and tips2878.853
tax_subtotalnumberSubtotal tax passed to Merchant based on adjusted subtotal. DoorDash will use the item level tax rate overrides if provided by Merchant. If the store is in a marketplace facilitator state, the column value will be 0. You should refer to the column named “Tax Remitted by DoorDash to State”.03
subtotal_tax_passed_to_merchant_federal_harmonizednumberThe subtotal GST/HST (as applicable) that DoorDash collected from the customer and passed to the Merchant (Canada)03
subtotal_tax_passed_to_merchant_provincialnumberThe subtotal PST/RST/QST (as applicable) that DoorDash collected from the customer and passed to the Merchant (Canada)03
customer_delivery_feenumberFee you collect from customers for delivery services.03
customer_delivery_fee_taxnumberTotal taxes on delivery fees based on your store’s location.03
customer_small_order_feenumberFee you collect from customers for small orders, which DoorDash collects from customers and then passes on to you.03
customer_small_order_fee_taxnumberTaxes on small order fees03
staff_tipnumberTotal amount that customers tipped your staff, which DoorDash collects and then passes on to you.03
courier_tipnumberTotal amount that customers tipped your driver, which DoorDash collects and then passes on to you for self delivery orders03
bag_feenumberFee you collect from customers for providing bags.03
bag_fee_taxnumberTaxes on bag fees03
cup_feenumberFee you collect from customers for specific beverages.03
cup_fee_taxnumberTaxes on cup fee03
bottle_deposit_feenumberFee you collect from customers for specific beverages.03
bottle_deposit_fee_taxnumberTaxes on bottle fee03
commissionnumberAmount in commission charged, collected by DoorDash.327.943
commission_taxnumberAmount in taxes on the commission charged for the payout period03
alcohol_flat_feenumberFlat fee on alcohol sales03
alcohol_flat_fee_taxnumberTaxes on alcohol fee03
flexible_fulfillment_flat_feenumberFlat fee for flexible fulfillment options03
flexible_fulfillment_flat_fee_taxnumberTaxes for fulfIllment flat fee03
printer_feenumberMonthly fee for a DoorDash printer03
printer_fee_taxnumberTaxes on printer fee03
tablet_feenumberMonthly fee for a DoorDash Tablet03
tablet_fee_taxnumberTaxes on tablet fee03
customer_discounts_from_marketing_funded_by_younumberThe amount covered by you to give customers a reduction in price for their food. This field will be populated as 'NULL' for any transactions before 3/11/2025.-333
customer_discounts_from_marketing_funded_by_doordashnumberThe amount covered by DoorDash to give customers a reduction in price for their food. This field will be populated as 'NULL' for any transactions before 3/11/2025.-84.173
customer_discounts_from_marketing_funded_by_a_third_partynumberThe amount covered by any third party to give customers a reduction in price for their food. This field will be populated as 'NULL' for any transactions before 3/11/2025.03
marketing_fees_including_any_applicable_taxesnumberThe amount a merchant pays to run marketing on DoorDash. This field will be populated as 'NULL' for any transactions before 3/11/2025.-14.143
doordash_marketing_creditnumberThe total amount funded by DoorDash to offset your marketing costs. This field will be populated as 'NULL' for any transactions before 3/11/2025.144.173
third_party_contributionnumberThe total amount funded by a third party such as a franchise partner, franchise group, or brand to offset your marketing costs. This field will be populated as 'NULL' for any transactions before 3/11/2025.03
error_chargesnumberTotal error charges to cover reimbursements issued to customers for missing or incorrect items.23.23
adjustmentsnumberThe total amount of additions or corrections applied to your earnings. This field will be populated as 'NULL' for any transactions before 11/1/2024.03
discountsnumberIn store order discount03
snap_ebt_discountnumberThe total SNAP/EBT payout that you will receive from Fiserv at a later time.03
total_before_adjustmentsnumberThe value of the net_payout inclusive of adjustments2420.573
net_payoutnumberThe amount included in your DoorDash payment deposit, which includes total earnings minus commission, fees, error charges, and plus or minus adjustments.2480.573
payout_idnumberDoorDash unique ID for each payout. Each payout can include the payout for deliveries, one-time store payments, etc lumped into one Payout_ID4708251143
payout_statusvarcharThe status of the payout, indicating whether the funds have been processed, completed, or if there are any issue (PAID)PAID3
subtotal_tax_remitted_by_doordash_to_tax_authoritiesvarcharThe total taxes applicable to order subtotal that were collected by DoorDash from the customer and remitted directly to the tax authorities, pursuant to relevant marketplace facilitator laws.172.93
customer_fee_tax_remitted_by_doordash_to_tax_authoritiesnumberThe total taxes applicable to customer fees that were collected by DoorDash from the customer and remitted directly to the tax authorities, pursuant to relevant marketplace facilitator laws.03
marketing_fee_all_discounts_and_fees_for_historical_reference_onlynumberHistorical reference data for the amount a merchant pays to run marketing on DoorDash, not inclusive of taxes333
adjustments_for_historical_reference_onlynumberHistorical reference data for the total amount of additions or corrections applied to your earnings.603

Store Temporary Deactivations

Report Type - TEMPORARY_DEACTIVATION

Description

This report outputs a list of all stores that are currently temporary deactivated.

Example Report

Column NameData TypeDefinitionExample
business_idnumberDoorDash Business ID185
store_idnumberDoorDash Store ID24725
created_at_timetimestampTimestamp that the deactivation was created8/11/2022 2:30:00
end_timetimestampTimestamp that the deactivation ended8/11/2022 8:59:59
notesvarcharDetailed notes on the deactivation reason and how to resolve the deactivationYour store has been temporarily deactivated because multiple Dashers reported your store as closed. If your store is actually closed, please update your DoorDash store hours. If your store is not closed, you can reactivate the store via the Merchant Portal or your Tablet. If you would like to learn more about Dashers reporting your store as closed, please click here: https://help.doordash.com/merchants/s/article/Dasher-Reports-Store-Closed-DRSC?language=en_US##
reasonvarcharReason of the deactivationMultiple Dashers reported your store as closed
scheduled_end_timetimestampTimestamp of the scheduled endtime of the deactivation8/11/2022 8:59:59

Store Information

Report Type - STORE_INFORMATION

Description

This report outputs a list of stores and their associated integration and merchant supplied tied to your reporting API account.

Example Report

Column NameData TypeDefinitionExample
business_idnumberDoorDash Business ID185
store_idnumberDoorDash Store ID24725
store_namevarcharStore nameMetro Pizza Main Street
integration_location_idvarcharParters integration location id123-0
merchant_supplied_idvarcharThe merchant's store identifier123
store_addressvarcharStore address303 2nd St, San Francisco, CA 94107, USA
store_latitudevarcharStore location latitude45.45975
store_longitudevarcharStore location longitude-73.31065
store_statusBooleanStore available on DoorDash for orderingTRUE

Transaction Details

Report Type - TRANSACTION_DETAIL

Description

This report outputs payout and transaction data on an order by order basis. The below example report is for report version 3 and prior

Example Report

Column NameData TypeDefinitionExampleSince Report Version
business_idnumberDoorDash Business ID1851
store_idnumberDoorDash Store ID247251
transaction_date_localtimestampDate of transaction in Local time8/2/2022 0:00:001
transaction_timestamp_localtimestampTime of transaction in Local time8/2/2022 14:34:411
transaction_date_utctimestampDate of transaction in UTC time8/2/2022 0:00:001
transaction_timestamp_utctimestampTime of transaction in UTC time8/2/2022 19:34:411
payout_datetimestampDate in which the payout was paid to your bank account8/11/2022 0:00:001
payout_timetimestampTime in which the payout was paid to your bank account8/11/2022 10:07:321
store_namevarcharInternal DoorDash Store NameMetro Pizza Main Street1
merchant_store_idvarcharThe merchant's store identifier1231
transaction_typevarcharThe Transaction Type denotes if the transaction line item reflects a delivery, adjustment, error charge, payout or store payment. DELIVERY - delivery or transaction level details for orders that are fulfilled ADJUSTMENT - order cart adjustments that can be a +/- value; a common example is when a Customer places order but changes it afterwards (i.e. by removing/adding an item) For adjustments, you can review further details in the “Description” column, such as customer refunds for order cart adjustments and requested items being unavailable. ERROR_CHARGE - missing and incorrect adjustments For error charges, the “Description” column identifies the item and reasoning that was the cause of the error charge. Payout - regular payouts sent to the Merchant to pay for deliveries they fulfilled within a given time frame; equivalent of what is seen on the Payment Summary page Store Payment - one off payments or charges to the Merchant. Examples could be a reimbursement for a dispute and Tablet subscription fee List of possible entries ADJUSTMENT, DELIVERY, DEMANDGEN_DELIVERY, DRIVE_DASHER_REGULATORY_FEE, DRIVE_DELIVERY, DRIVE_PROMOTION, DRIVE_REFUND, ERROR_CHARGE, AD_FEE, STORE_PAYMENT_AD_FREE_TRIAL, STORE_PAYMENT_PROMOTION_FREE_TRIALDELIVERY1
transaction_idnumberUnique DoorDash ID for each transaction1509754242531
doordash_order_idvarcharSame Order ID as shown in the Orders tab and what you reference to our support team if you have any questions. If there are multiple transactions associated with an order (i.e., original order, subsequent error charge, later adjustment), they all share the same original Order ID. This value is unique to the order.308774f11
merchant_delivery_idvarcharClient order ID from POS (Merchant-facing ID from POS system) If not POS, then this will be emptyf19abe56-9251-4032-8454-a96a67f684e3-doordash1
external_idvarcharExternal ID generated from the POS systemf19abe56-9251-4032-8454-a96a67f684e31
descriptionvarcharAdditional details for the transaction type (i.e. what the error charge is for - “1 chicken”)Issue: 1 7. Steamed or Fried Dumpling (8) missing1
final_order_statusvarcharIndicates if orders were delivered, picked up, or canceled. For canceled orders, this will also share the cancellation reason. Cancellation reason - For any unpaid canceled orders, this indicates payout status along with a cancellation reason (e.g., “Item Out of Stock”) Possible Values: 1. Picked Up 2. Delivered 3. CanceledDelivered1
currencyvarcharThe currency used for transactions in this storeUSD1
subtotalnumberPre-tax amount of the delivery251
tax_subtotalnumberTax collected and remitted to the Merchant. DoorDash will use the item level tax rate overrides if it is provided by Merchant. If you operate in a marketplace facilitator state, this column will show up as 0. You should refer to the column named “Tax Remitted by DoorDash to State”.21
commissionnumberAmount in commission charged per order; collected by DoorDash41
commission_taxnumberAmount in taxes on the commission charged per order01
marketing_feenumberAny marketing fees charged or implemented as part of active campaigns such as Marketing (see Run Your Own Marketing on DoorDash on DoorDash for more details) or Customer promotions (see What is the Customer Feedback in the Merchant Portal? for more details)81
tipsnumberAmount in staff tips collected and remitted to the Merchant01
creditnumberAmount paid to your bank account per transaction. Credit = Subtotal + Tax - Marketing Fees - Commissions - Error Charges +/- Adjustments161
debitnumberAmount deducted from payouts, commonly due to error charges and adjustments01
doordash_transaction_idvarcharUnique DoorDash ID for each transaction that is used by DoorDash internally. Different from Transaction ID.49941204631
payout_idnumberDoorDash unique ID for each payout. Each payout can include the payout for deliveries, one-time store payments, etc lumped into one Payout_ID2398102391
tax_remitted_by_doordash_to_statenumberTax collected and remitted by DoorDash if you operate in a marketplace facilitator state.01
subtotal_for_taxnumberTax will be calculated based on this subtotal amount01
doordash_funded_subtotal_discount_amountnumberThis will show if there is a DoorDash - funded promotion. The discount amount is the amount that DoorDash is paying for the Customer.01
merchant_funded_subtotal_discount_amountnumberThis will show if there is a Merchant- funded promotion. The discount amount is the amount that the Merchant is paying for the Customer, excluding any marketing fees that DoorDash is collecting81
consumer_delivery_feenumberDelivery fee at an order level01
consumer_service_feenumberService fee at an order level1271
consumer_small_order_feenumberAdditional fee applied to small orders01
consumer_legislative_feenumberAdditional fee at an order level due to local regulations01
consumer_tipnumberConsumer tip3001
order_cart_idnumberorder cart ID300000970732
discountsnumberIn store order discountNULL3

Report Type - TRANSACTION_DETAIL

Description

This report outputs payout and transaction data on an order by order basis. The below example report is for report version 4

Example Report

Column NameData TypeDefinitionExampleSince Report Version
business_idnumberDoorDash Business ID1854
store_idnumberDoorDash Store ID247254
timestamp_local_datetimestampDate of transaction in Local time8/2/2022 0:00:004
timestamp_local_timetimestampTime of transaction in Local time8/2/2022 14:34:414
timestamp_utc_datetimestampDate of transaction in UTC time8/2/2022 0:00:004
transaction_utc_timetimestampTime of transaction in UTC time8/2/2022 19:34:414
payout_datetimestampDate in which the payout was paid to your bank account8/11/2022 0:00:004
payout_timetimestampTime in which the payout was paid to your bank account8/11/2022 10:07:324
store_namevarcharInternal DoorDash Store NameMetro Pizza Main Street4
merchant_store_idvarcharThe merchant's store identifier1234
transaction_typevarcharThe Transaction Type denotes if the transaction line item reflects a delivery, adjustment, error charge, payout or store payment. DELIVERY - delivery or transaction level details for orders that are fulfilled ADJUSTMENT - order cart adjustments that can be a +/- value; a common example is when a Customer places order but changes it afterwards (i.e. by removing/adding an item) For adjustments, you can review further details in the “Description” column, such as customer refunds for order cart adjustments and requested items being unavailable. ERROR_CHARGE - missing and incorrect adjustments For error charges, the “Description” column identifies the item and reasoning that was the cause of the error charge. Payout - regular payouts sent to the Merchant to pay for deliveries they fulfilled within a given time frame; equivalent of what is seen on the Payment Summary page Store Payment - one off payments or charges to the Merchant. Examples could be a reimbursement for a dispute and Tablet subscription fee List of possible entries ADJUSTMENT, DELIVERY, DEMANDGEN_DELIVERY, DRIVE_DASHER_REGULATORY_FEE, DRIVE_DELIVERY, DRIVE_PROMOTION, DRIVE_REFUND, ERROR_CHARGE, AD_FEE, STORE_PAYMENT_AD_FREE_TRIAL, STORE_PAYMENT_PROMOTION_FREE_TRIALDELIVERY4
transaction_idnumberUnique DoorDash ID for each transaction1509754242534
doordash_order_idvarcharSame Order ID as shown in the Orders tab and what you reference to our support team if you have any questions. If there are multiple transactions associated with an order (i.e., original order, subsequent error charge, later adjustment), they all share the same original Order ID. This value is unique to the order.308774f14
doordash_transaction_idvarcharUnique DoorDash ID for each transaction that is used by DoorDash internally. Different from Transaction ID.129520967284
order_cart_idnumberOrder cart ID300000970734
merchant_delivery_idvarcharClient order ID from POS (Merchant-facing ID from POS system). If the store is not on POS order protocol, this will be empty.f19abe56-9251-4032-8454-a96a67f684e3-doordash4
external_idvarcharDoorDash external order ID sent to the POS systemf19abe56-9251-4032-8454-a96a67f684e34
descriptionvarcharAdditional details for the transaction type (i.e. what the error charge is for - “1 chicken”)Issue: 1 7. Steamed or Fried Dumpling (8) missing4
final_order_statusvarcharIndicates if orders were delivered, picked up, or canceled. For canceled orders, this will also share the cancellation reason. Cancellation reason - For any unpaid canceled orders, this indicates payout status along with a cancellation reason (e.g., “Item Out of Stock”) Possible Values: 1. Picked Up 2. Delivered 3. CanceledDelivered4
currencyvarcharThe currency used for transactions in this storeUSD4
subtotalnumberPre-tax amount of the delivery16.704
tax_subtotalnumberTax collected and remitted to the Merchant. DoorDash will use the item level tax rate overrides if it is provided by Merchant. If you operate in a marketplace facilitator state, this column will show up as 0. You should refer to the column named “Tax Remitted by DoorDash to State”.04
subtotal_tax_passed_to_merchant_federal_harmonizednumberThe subtotal GST/HST (as applicable) that DoorDash collected from the customer and passed to the Merchant (Canada)04
subtotal_tax_passed_to_merchant_provincialnumberThe subtotal PST/RST/QST (as applicable) that DoorDash collected from the customer and passed to the Merchant (Canada)04
customer_delivery_feenumberFee you collect from customers for delivery services.04
customer_delivery_fee_taxnumberTotal taxes on delivery fees based on your store’s location.04
customer_small_order_feenumberFee you collect from customers for small orders, which DoorDash collects from customers and then passes on to you.04
customer_small_order_fee_taxnumberTaxes on small order fees04
staff_tipnumberTotal amount that customers tipped your staff, which DoorDash collects and then passes on to you.04
courier_tipnumberTotal amount that customers tipped your driver, which DoorDash collects and then passes on to you for self delivery orders.04
bag_feenumberFee you collect from customers for providing bags.04
bag_fee_taxnumberTaxes on bag fees04
cup_feenumberFee you collect from customers for specific beverages.04
cup_fee_taxnumberTaxes on cup fee04
bottle_deposit_feenumberFee you collect from customers for specific beverages.04
bottle_deposit_fee_taxnumberTaxes on bottle fee04
commissionnumberAmount in commission charged per order; collected by DoorDash2.514
commission_taxnumberAmount in taxes on the commission charged per order04
alcohol_flat_feenumberFlat fee on alcohol sales04
alcohol_flat_fee_taxnumberTaxes on alcohol fee04
flexible_fulfillment_flat_feenumberFlat fee for flexible fulfillment options04
flexible_fulfillment_flat_fee_taxnumberTaxes for fulfIllment flat fee04
printer_feenumberMonthly fee for a DoorDash printer04
printer_fee_taxnumberTaxes on printer fee04
tablet_feenumberMonthly fee for a DoorDash tablet04
tablet_fee_taxnumberTaxes on tablet fee04
customer_discounts_from_marketing_funded_by_younumberThe amount covered by you to give customers a reduction in price for their food. This field will be populated as 'NULL' for any transactions before 3/11/2025.04
customer_discounts_from_marketing_funded_by_doordashnumberThe amount covered by DoorDash to give customers a reduction in price for their food. This field will be populated as 'NULL' for any transactions before 3/11/2025.04
customer_discounts_from_marketing_funded_by_a_third_partynumberThe amount covered by any third party to give customers a reduction in price for their food. This field will be populated as 'NULL' for any transactions before 3/11/2025.04
marketing_fees_including_any_applicable_taxesnumberThe amount a merchant pays to run marketing on DoorDash. This field will be populated as 'NULL' for any transactions before 3/11/2025.04
doordash_marketing_creditnumberThe total amount funded by DoorDash to offset your marketing costs. This field will be populated as 'NULL' for any transactions before 3/11/2025.04
third_party_contributionnumberThe total amount funded by a third party such as a franchise partner, franchise group, or brand to offset your marketing costs. This field will be populated as 'NULL' for any transactions before 3/11/2025.04
error_chargesnumberTotal error charges to cover reimbursements issued to customers for missing or incorrect items.04
adjustmentsnumberThe total amount of additions or corrections applied to your earnings. This field will be populated as 'NULL' for any transactions before 11/1/2024.04
discountsnumberIn store order discount04
snap_ebt_discountnumberThe total SNAP/EBT payout that you will receive from Fiserv at a later time.04
creditnumberAmount paid to your bank account per transaction. Credit = Subtotal + Tax - Marketing Fees - Commissions - Error Charges +/- Adjustments14.194
debitnumberAmount deducted from payouts, commonly due to error charges and adjustments04
payout_idnumberDoorDash unique ID for each payout. Each payout can include the payout for deliveries, one-time store payments, etc lumped into one Payout_ID2398102394
total_tax_remitted_by_doordash_to_tax_authoritiesnumberThe total taxes that were collected by DoorDash from the customer and remitted directly to the tax authorities, pursuant to relevant marketplace facilitator laws.1.014
subtotal_tax_remitted_by_doordash_to_tax_authoritiesnumberThe total taxes applicable to order subtotal that were collected by DoorDash from the customer and remitted directly to the tax authorities, pursuant to relevant marketplace facilitator laws.1.014
customer_fee_tax_remitted_by_doordash_to_tax_authoritiesnumberThe total taxes applicable to customer fees that were collected by DoorDash from the customer and remitted directly to the tax authorities, pursuant to relevant marketplace facilitator laws.04
subtotal_for_taxnumberTax will be calculated based on this subtotal amount16.704
preadjusted_subtotalnumberSubtotal before applying the inflation/deflation rate14.504
preadjusted_subtotal_taxnumberTax calculated using the subtotal before applying the inflation/deflation rate0.874
marketing_fee_all_discounts_and_fees_for_historical_reference_onlynumberHistorical reference data for the amount a merchant pays to run marketing on DoorDash, not inclusive of taxes.04
doordash_funded_subtotal_discount_amount_for_historical_reference_onlynumberHistorical reference data for the amount covered by DoorDash to give customers a reduction in price for their food at the subtotal.04
merchant_funded_subtotal_discount_amount_for_historical_reference_onlynumberHistorical reference data for the amount covered by you to give customers a reduction in price for their food at the subtotal.04
adjustments_for_historical_referencenumberHistorical reference data for the total amount of additions or corrections applied to your earnings.04
consumer_delivery_feenumberDelivery fee at an order level (California Stores Only)04
consumer_service_feenumberService fee at an order level (California Stores Only)04
consumer_small_order_feenumberAdditional fee applied to small orders (California Stores Only)04
consumer_legislative_feenumberAdditional fee at an order level due to local regulations (California Stores Only)04
consumer_tipnumberThe total tip the Customer paid (California Stores Only)04