How to View Kitchen Delay in Sales Order Export CSV?

How to View Kitchen Delay in Sales Order Export CSV?

Alert
This feature is only applicable for merchants who are subscribed to the Applova Kitchen Display system

What is the Delay Duration (Minutes)?

The Delay Duration (Minutes) is a new column included in the Sales Order Export CSV that helps merchants measure how long an order was delayed in the kitchen compared to the average preparation time defined in the Merchant Portal. The delay duration is calculated using the following formula:

Notes
Delay Duration = Actual Preparation Time – Average Preparation Time
  1. The Actual Preparation Time: How long it takes from when the order is accepted until it’s marked as ready.
  2. The Average Preparation Time: The amount of time the merchant sets as an estimate for how long an order usually takes to be ready.

Info
Use Case Scenario

At Fresh Squeeze Juice Bar, the operations manager exports the Sales Order CSV at the end of each day to review performance. The juice bar follows a fast-serve policy, aiming to prepare each order quickly and efficiently. With the new Delay Duration (Minutes) column:

  • Orders that finished on time show 0 in the column.

  • Orders delayed beyond the average preparation time show the exact number of minutes delayed.

  • Orders that were rejected or voided display N/A.

This helps the manager identify which juice orders take longer than expected to prepare, so adjustments can be made to maintain the bar’s quick-service standard.

How to View Delay Duration (Minutes)?

Step 1 
Login to "Applova Merchant Portal". 

Step 2 
Navigate to "Sales Orders".


Step 3 
Click on the "Settings" Icon.

Image link

Step 4 
Select "Export Orders as CSV".

Image Link

Step 5 
Choose the product items to be "Grouped Together".
Notes
The Column will only appear in the "Grouped Together" option of the sales order CSV since the value will be duplicating in "In Seperate Rows" option.



Step 6
Then, open the downloaded CSV file which will display the "Delay Duration (Minutes)" column is next to the Total Amount column.

    • Related Articles

    • Download an Enhanced Sales Order CSV with Gross and Net Sales Columns

      Supported Domains: Standalone This feature enhances the Sales Order CSV Export by introducing an additional checkbox that allows merchants to include detailed financial insights such as Gross Sales, Net Sales, and Refunds breakdown. With this update, ...

    • How to View Summary Reports via Merchant Web Portal?

      This feature allows merchants to view summary reports. There are two categories of summary reports that can be viewed via the Merchant Web Portal. Real-Time Reports Daily Payment Method Summary Report - Summarizes the total sales earned for the day ...

    • Enhanced Item Sales Report on Merchant Web

      Do not share this guide with merchants This report displays items sold with their quantity. The data displayed on the report can be filtered by date and a CSV file can be downloaded as well. Items in this report can be sorted either; Alphabetically ...

    • Enhanced Sales by Payment Methods Report on Merchant Web

      Do not share this guide with merchants This report displays sales by different payment methods such as cash, discover, AMEX, VISA, Mastercard and other cards that have not been specified. Total amount of sales displayed at the bottom right hand ...

    • Enhanced Sales Summary Report on Merchant Web

      Do not share this guide with merchants There are three types of Sales Summary Reports. The data displayed on the report can be filtered by date and a CSV file can be downloaded. 1. Sales Summary for Paid Orders 2. Sales Summary for Unpaid Orders 3. ...