Saltar al contenido principal

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

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
discountnumberIn store order discountNULL2

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

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