Order Status Transitions Report
rider'sThe "Order Status Transitions Report" is a report for understanding the entire journey of every order. It's like a time-stamped log that helps you measure your operational efficiency, find bottlenecks, and understand the real reasons behind cancellations.
This guide explains each field in the report, helping you track an order's lifecycle and gain valuable insights into your business's performance.
Order Identification & Source
These fields help you identify each order and where it came from.
Order ID
What it is: A unique number for each order in your system.
Why it's useful: It's your main key for tracking and referencing specific orders for internal purposes and troubleshooting.
Brand & Brand ID
What it is: The name and unique internal code for your brand.
Why it's useful: In a multi-brand operation, these fields are essential for segmenting your data and analyzing brand performance.
Channel
What it is: The specific online platform where the order was placed (e.g., "Zomato").
Why it's useful: Shows you which platforms are generating your sales and how efficiently each channel performs.
Store Name
What it is: The name of your restaurant location that fulfilled the order.
Why it's useful: Essential for businesses with multiple locations to track performance per outlet, especially for metrics like preparation time.
Aggregator Order ID
What it is: The unique order number provided by the online platform (aggregator).
Why it's useful: This is crucial for cross-referencing orders with the aggregator's records if you need to talk to their support team.
Fulfillment mode
What it is: How the order was completed (e.g., "delivery," "pickup").
Why it's useful: Helps you understand how customers prefer to receive their orders and segment your operational data based on fulfillment type.
Order Lifecycle & Timings
These fields provide a clear timeline of key events, which are critical for measuring your operational efficiency.
Order Creation Time
What it is: The exact date and time the order was first created in your system.
Why it's useful: This is the starting point for all other time-based metrics.
Placed Time
What it is: The time when the order was successfully placed on the aggregator's platform.
Why it's useful: The time between "Order Creation Time" and "Placed Time" can reveal delays in order processing.
Order Auto-Ack Time
What it is: The time when the order was automatically acknowledged by your system.
Why it's useful: This marks the beginning of the order's journey in your kitchen and is a key metric for measuring system automation.
Order Ack Time
What it is: The time a person manually acknowledged the order.
Why it's useful: If used, this indicates how long it took for a human to review and accept an order.
MFR Time
What it is: The "Made For Rider" or "Made For Ready" time. This is the timestamp when the food was prepared and ready for pickup.
Why it's useful: This is a crucial metric for measuring your kitchen's efficiency and how quickly your team can prepare an order.
Dispatch Time
What it is: The time the delivery rider picked up the order.
Why it's useful: The time between "MFR Time" and "Dispatch Time" shows the rider wait time. A long wait time could indicate operational issues with the delivery partner.
Order Completion Time
What it is: The final timestamp when the order was marked as completed in your system.
Why it's useful: This marks the end of the order's lifecycle and is used to calculate the total time taken for an order.
Cancellation Details
These fields provide important information if an order was cancelled.
Order Cancelled Time
What it is: The specific date and time when the order was cancelled.
Why it's useful: A value here indicates that the order did not complete successfully.
Order Cancelled By
What it is: Indicates who initiated the cancellation (e.g., "customer," "aggregator," "store").
Why it's useful: This helps you understand the root cause of cancellations, which is crucial for reducing them in the future.
Order Cancel Reason
What it is: The reason provided for the cancellation.
Why it's useful: Provides specific insights into why an order was cancelled, allowing you to address issues like long wait times or out-of-stock items.
This "Order Status Transitions Report" gives you a clear picture of how efficiently your business is running. By using these fields, you can pinpoint areas for improvement and ensure a smoother experience for your customers!
Last updated
Was this helpful?