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

# Checkout Transactions

> See sales so far, filter orders, export CSV, and open order details.

> [!WARNING]
>
> 9Pic Checkout is a **Business plan** feature (in test mode on Trial). See the [Checkout overview](https://docs.9pic.ai/products/checkout/overview.md).

## Overview

The **Transactions** tab shows how your event's checkout is performing: a **Sales so far** strip and a searchable list of every order. Click any row to open the [order detail](https://docs.9pic.ai/products/checkout/transaction-detail.md) page.

## Sales so far

| Figure | What it shows |
| - | - |
| **Revenue** | Total revenue, plus the average order value |
| **Paid orders** | Completed orders, plus the share of online checkouts that were paid |
| **Not claimed** | Paid pre-event passes still owed photos (only when passes were sold) |
| **Unfinished** | Checkouts started but not paid: awaiting payment, failed, or abandoned |

Choose **Paid orders**, **Not claimed**, or **Unfinished** to show those orders in the list. To see orders per payment gateway, use the gateway option in **Filters** or add the **Gateway** column.

> [!NOTE]
>
> **Test purchases** made while your organisation is on Trial show a **Test** badge next to their status. Nobody was charged, so they are left out of **Paid orders**, **Revenue**, and the paid share; the strip says how many test purchases aren't counted. Offline buyers are also left out of the paid share because they never went through checkout. The CSV export marks test purchases in the `test_purchase` column.

## Order list

By default each row shows:

| Column | Content |
| - | - |
| **Buyer** | Name from the buyer's sign-in profile at checkout, with their email underneath. Only the email shows when the buyer gave no name. |
| **Order** | Order number and when the order was created |
| **Purchase** | Item count, or claim progress for a pre-event pass |
| **Amount** | Order total in the order's currency |
| **Status** | Payment status badge, plus **Test** or **Offline** badges where they apply |

Click a row, or the arrow at its end, to open that order's detail page. Ctrl- or Cmd-click the arrow to open it in a new tab.

Select a column header such as **Buyer**, **Order**, or **Amount** to sort by it. Select it again to reverse the order, and a third time to return to newest first. Orders without a value stay at the end.

## Views, search, and filters

The views above the table show counts for **Paid** (the default), **Not claimed** (when pre-event passes were sold), **Unfinished**, **Refunded** (when present), and **All**. Beside them you see how many orders are shown and how much was paid for them.

Narrow the list with:

* **Search** — buyer first or last name, email, order number, payment ID, coupon, or sale phase
* **Filters** — payment gateway, sale phase, **Used a coupon**, and **Hide test purchases**. Each option appears only when it applies to your orders. Active filters show as chips under the search box; select the **×** on a chip to remove it, or **Clear filters** to remove them all.

## Actions

* **⋯ → Refresh statuses** fetches the latest payment status for every order.
* **⋯ → Download CSV** exports the orders in the current view, search, and filters. It always includes every field, including first and last name, whichever columns are visible.
* **⋯ → Table preferences** sets up the table your way (see below).
* **Add buyers → Add offline buyer** or **Import offline buyers** gives photos to buyers who paid you directly. See [Offline buyers](https://docs.9pic.ai/products/checkout/offline-buyers.md).

## Table preferences

Choose **⋯ → Table preferences**:

* **Page size** — 25, 50, 100, or 200 orders per page. Use **Previous** and **Next** below the table to move between pages.
* **Wrap lines** — show long emails and IDs in full instead of cutting them off.
* **Compact rows** — reduce row spacing to fit more orders on screen.
* **Columns** — turn columns on or off and drag them (or use the arrows) to change their order. Optional columns are **First name**, **Last name**, **Email**, **Gateway**, **Phase**, **Search type**, **Coupon**, **Created**, **Paid at**, **Payment ID**, and **User ID**. At least one column always stays visible.

Choose **Confirm** to apply, **Cancel** to discard, or **Reset to defaults** to restore the standard layout. Preferences are saved in your current browser and apply to every event; another browser or device starts with the defaults.

> [!NOTE]
>
> Amounts display in each order's own currency (set by the package and gateway used). Paid and created timestamps show in your local time.

## Common Questions

> [accordion] No transactions are showing.
>
> Either checkout hasn't made a sale yet, or your filters are too narrow. Choose the **All** view, choose **Clear filters** in **Filters**, and clear the search box.

> [accordion] Why is a buyer's name blank?
>
> Names come from the buyer's sign-in profile at checkout. Buyers who signed in with only an email, and some older orders, have no name saved, so the **Buyer** column shows only their email.

> [accordion] How are refunds handled?
>
> Refunds are processed through your payment gateway and reflected in the transaction's status. Contact [support@9pic.ai](mailto:support@9pic.ai) if you need help reconciling an order.

> [accordion] Does CSV export include filtered rows only?
>
> Yes. **Download CSV** exports the orders matching your current view, search, and filters, across all pages. Hidden columns are still included in the file.

## Next Steps

> [card] [Order detail](https://docs.9pic.ai/products/checkout/transaction-detail.md)
>
> What they bought, activity, resend email, and downloads.

> [card] [Checkout Configuration](https://docs.9pic.ai/products/checkout/configuration.md)
>
> Adjust packages and pricing.

> [card] [Analytics](https://docs.9pic.ai/products/analytics.md)
>
> Engagement and usage metrics for the event.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.