Skip to main content

Reports - All Store Order Items

This guide explains how to use the All Store Order Items report to see which products are selling best, filter and group your data, and download the results.

Written by Costa Bontioti

šŸ“ Overview

The All Store Order Items report lists all the individual store items sold on your account, including unpaid and undelivered ones.

Because it is based on products rather than orders, it is the report to use when you want to see which items are selling best.

This guide walks you through the report, the filters you can apply, and how to download your data.

šŸ’” If you would rather look at whole customer orders, including their payment and delivery status, see the Store Orders report here.


šŸ“Š Using the All Store Order Items Report

To open the report, go to Reports āžœ Store āžœ All Store Order Items, then choose All Store Order Items - Full Report.

Best Selling Products

Alongside the full report, you will find a quick link to Best Selling Products, a pre-filtered view showing your best-selling items without you having to set up any filters.

Opening the Best Selling Products view

Click the arrow to learn more about using this report

Widgets

The first thing you will see on this page is a set of widgets, which are quick reports you can read without having to manipulate any data.

The widgets at the top of the All Store Order Items report

At a glance, you will be able to see:

  • Your most popular product over the last 30 days

  • Generated revenue over the last 30 days

To see the data behind each widget, click View Report.

Opening the report behind a widget

Filters and grouping options

You can narrow the list using the following filters.

Any Customer

Search a customer's name or email

Any Product

Select one or more products

Any Payment Status

Select "Paid" and/or "Not Paid"

Any Delivery Status

Select "Delivered" and/or "Not Delivered"

Use See Results From to choose the time period you want, and the group by options under Show to group the data using one or more dimensions.

Choosing a time period and grouping the report data

Downloading the report

To extract email addresses and other customer fields based on your search results, click the Download button.

šŸ’” To learn more about the fields you can include, see Introduction to Customer Fields here.


ā“ Frequently Asked Questions (FAQs)

Find answers to common questions or additional details that may not be covered in the main instructions.

Click the arrow to view frequently asked questions

What is the difference between this report and Store Orders?

Click the arrow to see the answer

This report is based on products, so each row represents an individual item that was sold. The Store Orders report is based on orders, so each row represents a customer's whole order.

For the orders view, see Reports - Store Orders here.

How do I find my best-selling products?

Click the arrow to see the answer

Use the Best Selling Products quick link, which sits alongside the full report and gives you the ranked view straight away.

The widgets at the top of the full report also show your most popular product over the last 30 days.

Where do I fulfil items that have not been delivered?

Click the arrow to see the answer

This report shows you the delivery status of your items, but you fulfil them from your To-Dos section, where outstanding store orders are listed for you to action.

For the steps, see Managing store orders here.

Can I change the order my products appear in?

Click the arrow to see the answer

Yes. You can drag and drop your products into the order you want from the Product Sorting tab, and that order is reflected in Point of Sale, the Customer Site store, and your own store.

For the steps, see Reordering how Store Items are Displayed here.

Where can I see all the other reports available?

Click the arrow to see the answer

For a full list of every report, organised by category, see An Overview of Reporting here.

Did this answer your question?