Option-wise Order Transactions Report

The "Option-wise Order Transactions Report" is a highly detailed report that gives you a breakdown of every single customization, add-on/Variant, and option chosen for each item in an online order.

By using this report, you can analyze customer preferences, track the performance of your add-ons/variant, and optimize your menu and pricing. This guide will help you gain granular insights into what your customers truly love and are willing to pay extra for.


General Order Information

These fields provide the essential context for the entire order, just like in your other reports.

Order ID

  • What it is: The unique number for each order. All options and items belonging to the same order share this ID.

  • Why it's useful: It's your primary key for finding all associated details for a specific order.

Order date-time

  • What it is: The exact date and time the order was placed.

  • Why it's useful: Crucial for analyzing daily sales trends, finding peak ordering times, and managing preparation timelines.

Order State

  • What it is: The current status of the order (e.g., "Completed," "Cancelled").

  • Why it's useful: Helps you filter out incomplete or cancelled orders for accurate sales analysis.

Order Channel

  • What it is: The online platform where the order was placed (e.g., "zomato").

  • Why it's useful: Shows which platforms are driving your business and helps you compare performance across channels.

Store ID & Store Name

  • What it is: The unique code and name of the store that fulfilled the order.

  • Why it's useful: This allows you to analyze sales and popular options for each of your restaurant locations.

Item Details

These fields provide information about the main menu item that was customized.

Item ID & Item Title

  • What it is: The unique code and name of the main menu item (e.g., "Keema Pav (Mutton)").

  • Why it's useful: This tells you which core product the customer is customizing.

Item Quantity & Item Price

  • What it is: The number of units of the main item ordered and its base price before any options were added.

  • Why it's useful: This is the starting point for calculating the total cost of the item.

Option Details

This is the most important section of the report, giving you the detailed breakdown of each customization.

Option Ref ID & Option ID

  • What it is: The unique code for the option on the aggregator's system and within your own system.

  • Why it's useful: These allow you to track which individual customizations are the most popular and profitable.

Option Title

  • What it is: The name of the customization or add-on (e.g., "Mango Lassi (200 ML)," "1 PC Extra Bhatura," "No Achaar").

  • Why it's useful: This clearly shows what the customer chose to add or modify.

Option Price

  • What it is: The cost of a single unit of the option.

  • Why it's useful: Helps you understand which options generate additional revenue and which are simple modifications with no added cost.

Option Quantity

  • What it is: The number of units of this specific option that were selected.

  • Why it's useful: Crucial for calculating the total cost of all options for an item.

Option Group ID

  • What it is: The unique code for the category of options this customization belongs to (e.g., a group for sauces, drinks, or spice levels).

  • Why it's useful: Allows you to analyze which categories of options are the most popular with your customers.

This "Option-wise Order Transactions Report" is a treasure trove of information about your customers' preferences. By using these fields, you can make informed decisions to refine your menu and improve the customer experience!

Last updated

Was this helpful?