Item-wise Order Transactions Report

The "Item-wise Order Transactions Report" is a powerful report that gives you a detailed look at every single item sold in your online orders. By understanding each column, you can unlock valuable insights to optimize your menu, track bestsellers, and improve your business.

This guide will walk you through each field, explaining its purpose and how you can use the data to make smarter business decisions.

---

Order and Item Identification

These fields are your keys to tracking every transaction.

Order ID

• What it is: A unique number for each order in your system. All items from the same order will share this ID.

• Why it's useful: This is your primary way to internally track and manage a specific order from start to finish.

Order ref ID & Aggregator Order ID

• What it is: The unique order numbers assigned by the online platforms (like Swiggy or Zomato).

• Why it's useful: Use these IDs whenever you need to talk to the aggregator's support team about a specific order.

Item ID & Item ref ID

• What it is: The unique codes for your specific menu item within your system and on the aggregator's platform.

• Why it's useful: These allow you to track the performance of individual products, identify bestsellers, and manage your inventory.

Item Name

• What it is: The name of the product that was ordered by the customer.

• Why it's useful: Gives you a clear, at-a-glance view of what's being sold.

General Order Information

These fields provide a high-level overview of the entire order.

Brand & Brand ID

• What it is: The name and internal code of your brand.

• Why it's useful: If you have multiple brands, this helps you analyze performance for each one separately. (For single-brand reports, these may show as "None.")

Channel

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

• Why it's useful: Helps you understand which platforms are driving the most sales for your restaurant.

Order State

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

• Why it's useful: Essential for filtering your sales data to only see successfully completed orders.

Store

• What it is: The name of your restaurant location that fulfilled the order.

• Why it's useful: Crucial for businesses with multiple locations to see which store is performing best.

Order date-time

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

• Why it's useful: Perfect for analyzing sales trends over time, like finding your busiest days or peak hours.

City

• What it is: The city where the order was placed.

• Why it's useful: Helps you understand your sales by geographic location.

Financials and Item Details

This is where you get into the numbers for each item.

Quantity

• What it is: How many units of this specific item were ordered.

• Why it's useful: Allows you to calculate the subtotal for each item and see popular ordering patterns.

Unit Price

• What it is: The base price of one unit of the item before any taxes or discounts.

• Why it's useful: Provides the foundation for all financial calculations.

Total Taxes

• What it is: The total tax amount applied specifically to this item.

• Why it's useful: For tax reconciliation and understanding your tax liabilities.

Total Charges

• What it is: Any extra fees applied to this item (e.g., packaging or customization charges).

• Why it's useful: Helps you track additional revenue from specific item charges.

Total Price

• What it is: The final amount the customer paid for this single item, including discounts, taxes, and charges.

• Why it's useful: This is the bottom-line revenue you made from this item in the order.

• Total Price = Quantity × Unit Price + Total Taxes + Total Charges − Coupon Value

Liability On

• What it is: This field indicates who is financially responsible for remitting a specific amount (like taxes).

• Why it's useful: It's a key detail for your accounting, confirming whether you or the aggregator are responsible for paying certain amounts to the government.

Options & option_ids

• What it is: The customizations or add-ons chosen by the customer (e.g., "extra cheese," "no onions") and their unique codes.

• Why it's useful: Gives you valuable insight into customer preferences and can help you create new menu items or promotions based on popular add-ons.

Coupon applied & Coupon value

• What it is: The name and monetary value of any coupon applied to this item.

• Why it's useful: Helps you measure the direct cost and effectiveness of your promotions on a per-item basis.

This "Item-wise Order Transactions Report" is a powerful tool for gaining granular insights into your online business. By understanding each field, you can make more informed decisions to optimize your menu, promotions, and operations!