# 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!