> ## Documentation Index
> Fetch the complete documentation index at: https://docs.usebila.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Product Store Reports

> Learn how to monitor your store's sales performance, track top products, and manage low stock alerts using the Bila Reports dashboard.

## Overview

The **Reports** dashboard gives you a real-time view of your store's performance ,revenue, order volumes, average order value, and inventory health  all in one place. Use it to spot trends, identify your best-selling products, and act on stock warnings before they affect your sales.

<Info>
  Only admins with **Merchant Admin** or **View Only** roles can access the Reports dashboard.
</Info>

***

## Watch: How to Read Your Store Reports.

<iframe src="https://www.youtube.com/embed/I6pT_dadAZw" title="YouTube video player" frameborder="0" className="w-full aspect-video rounded-xl" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen />

***

## Step 1: Open Reports

1. Click **Product Store** in the left sidebar.
2. Select the **Reports** tab from the top navigation bar.

***

## Step 2: Read the Summary Cards

The four cards at the top give you an instant snapshot of your store's current performance:

| Card                 | What It Shows                                                                |
| -------------------- | ---------------------------------------------------------------------------- |
| **Revenue**          | Total amount collected from orders in the selected period - displayed in ZMW |
| **Orders**           | Total number of orders placed in the selected period                         |
| **Avg. Order Value** | Average amount per order - Revenue divided by Orders                         |
| **Low Stock Alerts** | Number of products currently at or below their low-stock threshold           |

<Tip>
  Watch the **Low Stock Alerts** card daily - a number above zero means at least one product is close to selling out. Click through to the Low Stock Warnings section to see exactly which items need restocking.
</Tip>

***

## Step 3: Switch the Time Period

Use the toggle above the chart to change the reporting period:

| Period      | What It Shows                                         |
| ----------- | ----------------------------------------------------- |
| **Daily**   | Performance broken down by day for the current week   |
| **Weekly**  | Performance broken down by week for the current month |
| **Monthly** | Performance broken down by month for the current year |

<Info>
  The summary cards at the top always reflect the selected period. Switching from **Daily** to **Monthly** updates all four cards automatically.
</Info>

***

## Step 4: Read the Sales Volume Trend Chart

The **Sales Volume Trend** chart plots two lines across the selected period:

| Line        | Colour | What It Tracks                              |
| ----------- | ------ | ------------------------------------------- |
| **Revenue** | Green  | Total ZMW collected per period interval     |
| **Orders**  | Purple | Number of orders placed per period interval |

Use the chart to:

* Identify your busiest sales periods
* Spot revenue growth trends month over month
* Detect drops in order volume before they show up in your cash flow

<Tip>
  A rising green (Revenue) line with a flat purple (Orders) line means your average order value is increasing - customers are spending more per order. This is a positive trend worth monitoring.
</Tip>

***

## Step 5: Review Top Performing Products

Scroll down to the **Top performing products** section on the left side of the page.

The table ranks your products by revenue generated:

| Column      | What It Shows                                             |
| ----------- | --------------------------------------------------------- |
| **Rank**    | Revenue ranking - 1st is your highest-earning product     |
| **Product** | Product name with a visual bar showing units sold         |
| **Revenue** | Total ZMW earned from this product in the selected period |

Use the **Search products** bar to find a specific item's performance without scrolling.

***

## Step 6: Act on Low Stock Warnings

The **Low stock warnings** panel on the right shows every product approaching zero inventory:

| Column      | What It Shows                                                       |
| ----------- | ------------------------------------------------------------------- |
| **Product** | Product name and SKU                                                |
| **Stock**   | Current unit count vs the low-stock threshold - e.g. `3 of 5`       |
| **Level**   | Visual progress bar showing how close the product is to selling out |

A product appears in this panel when its stock falls at or below its configured threshold. The progress bar turns more critical as stock decreases.

**To restock:**

1. Navigate to **Product Store → Products**
2. Click **`...` → Adjust Stock** on the affected product
3. Add the new inventory quantity and a reason note
4. Click **Confirm Adjustment**

<Warning>
  Products with zero stock but **Active** status can still appear on your storefront. Set them to **Inactive** immediately to prevent customers from attempting to purchase out-of-stock items.
</Warning>

***

## Export Your Data

The Reports dashboard has two export options at the top right:

| Export                     | What It Downloads                                                                             |
| -------------------------- | --------------------------------------------------------------------------------------------- |
| **Export Sales Orders**    | A CSV of all orders in the selected period - includes customer details, amounts, and statuses |
| **Export Product Catalog** | A CSV of your full product list - includes SKUs, prices, and current stock levels             |

The Low Stock Warnings panel also has its own **Export** button - downloads a CSV of only the items currently below their stock threshold.

<Tip>
  Use **Export Sales Orders** at the end of each month for bookkeeping and reconciliation. Use **Export Product Catalog** before a stock audit to have a baseline to compare against.
</Tip>

***

## Reports Reference

| Metric               | How It Is Calculated                                                               |
| -------------------- | ---------------------------------------------------------------------------------- |
| **Revenue**          | Sum of all completed order amounts in the selected period                          |
| **Orders**           | Count of all orders placed in the selected period - includes pending and completed |
| **Avg. Order Value** | Revenue ÷ Orders for the selected period                                           |
| **Low Stock Alerts** | Count of products where current stock ≤ configured low-stock threshold             |

***

## Troubleshooting

| Issue                                                                   | What to Do                                                                                   |
| ----------------------------------------------------------------------- | -------------------------------------------------------------------------------------------- |
| Revenue shows ZMW 0 for a period                                        | Confirm orders were completed - pending or cancelled orders do not count toward revenue      |
| Low Stock Alerts card shows a number but no items in the warnings panel | Refresh the page - the card and panel should always match                                    |
| Top Performing Products list is empty                                   | Confirm at least one order has been completed in the selected period                         |
| Export file is empty                                                    | Check that the selected period has data - switching to **Monthly** will capture more history |
| Chart lines are flat                                                    | This may indicate no orders in the selected period - switch to a broader period to confirm   |

***

## Next Steps

<CardGroup cols={2}>
  <Card title="Update Price and Stock" icon="tag" href="/products/update-price-stock">
    Restock products flagged in your Low Stock Warnings panel.
  </Card>

  <Card title="Manage Orders" icon="list-check" href="/products/manage-orders">
    Review and fulfil the orders contributing to your revenue figures.
  </Card>
</CardGroup>
