fullmetrixDocs

Orders

Find any order, filter the list, choose columns, open an order's detail page and export the result.

The Orders report is the list of every order from your stores, one row per order. It is the report behind every figure in Fullmetrix. When a total surprises you, this is where you find the orders that make it up.

Use it to find the order of a customer who writes to you, check what a customer bought and how they reached your site, isolate a group of orders with filters, or export a list to a spreadsheet.

Before you start

You need a connected store whose historical import is finished. See the E-commerce page.

Open the list of orders

Expand the E-commerce section

In the left sidebar, in the Data group, click E-commerce.

Choose Orders

Click Orders. The page shows the Orders title and the sentence "All orders synced from your e-commerce stores."

Which orders appear in the list

The list shows all your counted orders, from the oldest imported order onwards. It has no date picker. The most recent orders are at the top.

A counted order follows the same rule as in every report. Its status is not in Excluded order statuses, its amount is greater than zero if that option is on, and its customer is not in Ignored customers. Drafts and orders moved to the trash never appear. These options are set in Settings, Reports tab. See Report settings.

An order with an excluded status therefore doesn't appear in the list. To see it anyway, add a filter on Status. As soon as you filter on status, the list stops removing excluded statuses and shows exactly the statuses you chose.

At the top right, the All sources selector picks which stores are shown when you have several. See Choosing stores.

Find an order

Type in the Search for an order... field at the top right of the list. The search runs as you type and looks in this information.

  • The order number and the order's ID in your store
  • The customer's email address
  • The customer's phone number
  • The customer's name
  • The billing city and country
  • The payment method

The closest matches come first. An exact order number therefore ranks above an order where only the city looks like your search.

If nothing matches, the list shows No results for this search. Check the spelling, try the full email address or remove active filters.

Filter the list and load a segment

Below the title, the Filters button opens the filter bar. Click Add a filter, choose a field, a condition and a value, then click Apply. You can combine several filters.

The available fields cover the whole order. Here are some of the most useful ones.

You wantField to use
Orders from a periodOrder date
Orders from one countryBilling country
Orders placed with a discount codeCoupon code
Orders containing a productProduct title
Orders above 100Total amount
Your customers' first ordersFirst or returning
Orders that came from a campaignUTM Source
Orders with a specific statusStatus

The Load a segment button applies an order segment you already saved. The Create with AI button lets you describe the orders you are looking for in one sentence, then suggests the matching filters. You can edit them before applying.

To learn everything about filters, conditions and saving a segment, read Filters and segments and Segments.

Read the list

By default, the list shows six columns.

ColumnContent
Order numberThe order number, preceded by a dot colored by status. Below it, how long ago the order was placed, for example "3 days ago".
CustomerThe customer's name and, below it, their email address. An order with no name shows a dash.
StatusThe order's status, in a colored label.
TotalThe total amount paid, taxes and shipping included.
Item countThe quantity of items in the order, for example "3 items".
Order dateThe date and time the order was created.

The status label and color come from Settings, Statuses tab. If you haven't set anything, we show standard labels such as Processing, Completed, On hold, Cancelled, Refunded or Failed. Statuses specific to your store keep their original name. See Order statuses.

An order's Total is the store's amount, before any refund. It doesn't apply the deductions set for revenue.

Sort the list

Click a column header to sort the list by that column. Click again to reverse the order. For example, sort by Total to see your largest orders. Columns without arrows in their header can't be sorted.

Total and pagination

The Total row at the bottom of the table adds up the Total and Item count of every order matching your search and filters, not just those on the current page.

The list shows 100 orders per page. Below the table, you read the range shown and the overall count, for example "1-100 of 3,210 orders". Use the page buttons to move forward.

Choose columns

The Columns button, above the table on the right, changes the information shown.

  • Default goes back to the six columns described above.
  • All fields shows every available column, such as discount, shipping, taxes, currency, payment method, billing city and country, payment date or store.
  • Customize opens the column set editor. You pick the columns, their order and whether the set is just for you or for the whole team.

Saved sets then appear under Custom sets. Details are in Columns.

Export orders

The Export button, on the left above the table, shows how many orders are concerned, for example Export 3,210 orders. It exports every order matching your search, filters and stores, in the chosen sort order. It isn't limited to the current page. The columns offered at first are the ones shown in the table.

The export window lets you pick columns, download a CSV file, send it by email, to Slack or to Google Sheets, or schedule a recurring export. A large export is prepared in the background and you find it on the Exports page. See Exports.

Exports contain personal data

An order export can contain names, email addresses, phone numbers and postal addresses. Only export the columns you need and only share the file with authorized people.

An order's detail page

Click a row to open the order's detail page. At the top, the Orders breadcrumb followed by the number takes you back to the list in one click. To learn more about detail pages, read Detail pages.

The header

The header shows the order number, its status, its date, the source store and the number of product lines. On the right, you read the total amount.

If the order was paid in a currency other than your organization's, a Paid line shows the amount actually paid in the original currency and the conversion rate used. If the store sent a payment date, the Paid on line shows it.

Items

The Items section lists each product in the order with its image, name, reference (SKU), unit price times quantity and line total. A badge on the image shows the quantity when it is above one.

Click a product to open its product page. The small export button at the top of the section downloads the item list as a CSV file with product, reference, quantity, unit price and total.

Summary and order details

The Summary section shows the items' subtotal, the Discount if there is one, Shipping (or Free when it costs nothing), Taxes and Total.

The Order details section appears when the store provides the order's line detail. It lists shipping methods with carrier and tracking number, added fees, each tax with its rate and each coupon used with the discount granted.

Payment

The Payment section shows the payment Method, the Payment date when there is one, the Order date and the Store.

Source & session

The Source & session section explains how the customer reached your site before ordering. It shows the Attribution (source, medium, campaign and keyword of the visit), the Landing page, the Referrer, the Device (type, system and browser) and the Customer IP.

This section only appears if we could link the order to a visit, thanks to the Fullmetrix tracking script installed on your store. See Site tracking.

Customer note, customer and addresses

If the customer left a message with their order, it appears in Customer note.

On the right, the customer card shows their name, email address and phone. It also shows their total number of Orders and their LTV, meaning everything they have spent with you since their first order. When the customer exists in your contacts, click the card to open their contact page. An order with no name shows Anonymous customer.

The Addresses section shows the Billing address and the Shipping address.

If the order has since been deleted from your store, the page shows Order not found. Go back to the list with the breadcrumb.

Example questions

  • A customer writes about their order. What did it contain and when was it paid? Search their email, then open the detail page.
  • Which orders used the code "XMAS20"? Add a Coupon code filter.
  • What are my 20 largest orders of the year? Filter on Order date, then sort by Total.
  • Where do customers who buy after a newsletter come from? Filter on UTM Source, then open a few orders to read Source & session.
  • I want the list of this month's orders for my accountant. Filter on the date, then click Export.

Frequently asked questions

Going further

  • Order analysis to see orders grouped by status, payment, shipping and customer type.
  • Revenue for totals by period.
  • Customers for a customer's full history.

On this page