Connect DoorDash to Fishbowl

Important: Weekly data depends on the DoorDash representative completing the manual file upload. 

1. Confirm Weekly DoorDash File Delivery

Before setting up the integration in Fishbowl, confirm that your DoorDash representative can:

• Provide the required weekly export for all participating locations.
• Manually upload the file to the designated Fishbowl SFTP each week.
• Provide the brand name, DoorDash location name, and DOORDASH_STORE_ID for every participating location.

Important: The DoorDash representative must be able to support the manual weekly export and SFTP upload. If they cannot, the integration cannot be set up.

Email Template

Subject: Request to Enable Weekly DoorDash Data Export to Fishbowl

Hi [DoorDash Representative Name],

We would like to enable our DoorDash data integration with Fishbowl for [Client/Restaurant Group Name].

The integration requires a DoorDash representative to manually generate and upload a DoorDash order, guest, and member data export to a Fishbowl SFTP account each week.

Please confirm that:

1. You can provide the required weekly export for all participating locations.
2. You can upload the file to the designated Fishbowl SFTP each week.
3. You can provide the brand name, DoorDash location name, and DOORDASH_STORE_ID for every participating location so each store can be mapped under the correct brand in Fishbowl.

Once confirmed, Fishbowl will provide the SFTP connection details.

Thank you,
[Client Contact Name]
[Client/Restaurant Group]

Create the SFTP connection once at the client level.

1. Sign in to Fishbowl Connect at the client level.
2. Go to Integrations → DoorDash.
3. Navigate to Connection.
4. Click New Connection.
5. Enter:
• Integration Name
• FTP Username
• FTP Password
6. Click Add.

Important: The SFTP connection is client-level. Do not create a separate SFTP connection for each brand.

Once the client-level connection is created, configure the DoorDash locations under each participating brand.

1. Use the brand selector to select the brand.
2. Go to Integrations → DoorDash.
3. Open Setup.
4. Under Store Configuration, enter the exact DOORDASH_STORE_ID in DoorDash Store Code.
5. Under Select a Store, select the corresponding Fishbowl location.
6. Click Add.
7. Repeat for each location within the brand.
8. Click Save.
9. Review the saved mappings to confirm each DoorDash Store Code is paired with the correct Fishbowl Store Name.
10. Repeat for each participating brand.

Important: Each DoorDash Store ID should map to exactly one Fishbowl location.

Connection: Client level
Store mappings: Brand level

Once the integration is live, clients can add or update their own DoorDash store mappings in production.

1. Select the appropriate brand.
2. Go to Integrations → DoorDash → Setup.
3. Enter the DOORDASH_STORE_ID in DoorDash Store Code.
4. Select the corresponding Fishbowl location.
5. Click Add and Save.

Required CSV Headers

• ACTIVE_DATE_UTC

• ACTUAL_ORDER_PLACE_TIME_UTC

• FIRST_NAME

• LAST_NAME

• PHONE_NUMBER

• EMAIL

• CX_FORMATTED_ADDRESS

• CX_ADDRESS_SUBPREMISE

• BUSINESS_NAME

• STORE_NAME

• STOREFRONT_SUBTOTAL

• TIP

• DELIVERY_FEE

• SERVICE_FEE

• ORDER_TYPE

• ORDER_STATUS

• BUSINESS_ID

• DELIVERY_ID

• ORDER_ID

• DOORDASH_STORE_ID

• EMAIL_OPT_IN

All headers must be included in every file, even when a value is unavailable. Leave unavailable values blank.

DoorDash

• Generate the complete weekly export.
• Upload the file to the designated Fishbowl SFTP each week.

Client

• Keep Fishbowl informed of brand or location changes.
• Provide new or changed DoorDash Store IDs.
• Add or update DoorDash store mappings in production as needed.

Fishbowl

• Maintain the client-level SFTP connection.
• Support the integration as needed.