This report gives you access to a breakdown of your sales by product.

Important: Stock quantity is calculated in near real-time. The other metrics of the report will be updated within 10 minutes with the exception of product tags which can take up to 60 minutes.
Please be aware that your deleted products will still be viewable in the report for historical sales performance. Deleted products will be listed regardless of the date period selected.

Product report columns meaning

SKU
SKU stands for Stock keeping unit. A unique identifier per product variation.

Stock

Physical inventory on hand.

Allocated

Units sold but not yet shipped.

Incoming

Inventory incoming from a supplier.

In Transit

Inventory due to arrive from another of your warehouses.

Price per unit

Average sales price per single unit. Calculated by: Sales revenue excluding sales tax / units sold.

Cost Price

The weighted average of multiple units costs over a period of time. You can manually set cost price in Veeqo or if you use our purchase order module, we will calculate it automatically as you make purchases.

Cover 14

How much inventory you would need to order to ensure you had enough for the next 14 days. Calculated using last 30 days sales.

Cover 30

How much inventory you would need to order to ensure you had enough for the next 30 days. Calculated using last 30 days sales.

Cover 90

How much inventory you would need to order to ensure you had enough for the next 90 days. Calculated using last 30 days sales.

Sell Through

How much time before you run out of inventory based on your last 30 days sales. Calculated by: Available inventory / (Units sold for last 30 days / 30).

Units Sold

The number of products sold excluding any sold as part of a kit/bundle product.

Units sold in kits

The number of this product which was sold as part of kit/bundle product.

Total units sold

Units sold + units sold in bundles.

Profit

Units sold * (Sales price - cost price). Excludes sales tax and this excludes units sold in bundles.

Profit %

Profit / Net sales

Net Sales

Total sales revenue for this product excluding sales tax but includes discounts and shipping revenue.

Report Views

When opening the Product report, it is set to the default OVERVIEW grouped by By Product. Data can be grouped by:

  • Product - Whether it's a simple or variant product, it will show data for the product as a whole.
  • Variant - This will drill down a product with multiple variations to give the data for each variation.
  • Options - This will drill down a product with multiple variations into the individual options. E.g. If you have a t-shirt in options (small, medium, large) and (grey, green, blue), you would be able to see all the small options grouped together.

Once you've selected your grouping, you can change the data you'd like to view. By changing the Show dropdown, the breakdown of your group by X your show option will then form the graph.

Report Filters

Use the left-hand filter panel to filter your selected data by:

  • Store (Sales Channel)
  • Product Tag
  • Product Brand
  • Warehouse

Searching for a product

If you're looking for a particular product or want to view all variants of that product on its own, use the search bar to find it. You can search by product name or product SKU.

 

Why is my profit not showing?

Veeqo calculates your profit using an Average Cost Price for each product. Make sure all your Veeqo products have a cost price. You can do this in bulk by following the Update/Edit Products In Bulk and updating the cost-price column of your products.

Refunded or cancelled orders

If a product has been sold and then later returned or the order has been cancelled, this will then update and remove the sales data for that product and order.

View a breakdown of your products order history

Once you've selected the filters to display the data you're after, select a cell of data and this will show the breakdown of the order history for that period.

This will show each individual order's details.

   

How to use the date selector

Filter date ranges by:

  • Today
  • Yesterday
  • Last 7 days
  • Last 30 days
  • Last 90 days
  • Last month
  • Last 12 months
  • Week to date
  • Month to date
  • Year to date
  • Custom

To show a custom date range, select the dates you'd like to show in the calendar to switch to those dates: 

 

Comparing against the previous date period

When you choose a previous period to compare against you will see this data in a summary table in small grey font.

Choose from the following option to compare against.

  • Previous Day - The day before.
  • Previous Week - The same day (i.e. Monday) in the week before
  • Previous Month - The same date (i.e. 17th) in the previous month.
  • Previous Year - The same date (i.e. 17th) in the previous year.

Seeing your data grouped by day, week or month

You can change the graph and table to split any time periods into the following:

  • Day
  • Week
  • Month

Please note: If the text for any of these options is greyed out, they cannot be selected for the date range/data values. For example, if you select "Last 12 months" you can not choose "Day" as there is not enough room on the screen to show the data.

Sorting by column

Select a column header in the table to then sort the data by that column (highest value to lowest). Select the same header again to sort by lowest value to highest for that column.

Showing and hiding columns

Columns can be turned on / off to give you more space or if there are only certain data points you want to view.

(Please note: Turning columns off here will not affect the CSV export, all columns will be included in the export.)

 

Exporting sales data to a spreadsheet (CSV)

When exporting sales data, it is exported to a CSV file which you can view in a spreadsheet program such as MS Excel or Google Sheets.

There is the option to download the sales summary or the order history.

 

The summary will download a spreadsheet file that includes:

  • The Products/Variants/Options you are displaying
  • SKU
  • Stock
  • Allocated
  • Incoming
  • Cost Price
  • Price per Unit
  • Cover 14 days
  • Cover 30 days
  • Cover 90 days
  • Sell through rate
  • Units sold
  • Units Sold In Kits
  • Profit
  • Profit Margin Percent
  • Net Sales

 

 

The order history will download a spreadsheet file that includes a full Order CSV export with all order details.

(Please note: This CSV will be created in the background and be ready to download from the notifications bar when ready.)

 

Product Report

Keep the GROUP BY dropdown on BY PRODUCT to only show insights about whole products. This report is the default OVERVIEW when the Product Report is first opened. To return to this view, select OVERVIEW in the SHOW dropdown.

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the cost price, average price per unit, units sold, profit, % profit or gross sales. Don't forget to use the left hand filters to drill down further by: channel, product tag, product brand, warehouse.

 

Product Variant Report

To view a breakdown per product variant, select BY VARIANT in the GROUP BY dropdown. To just view the data overview of your channels, leave OVERVIEW selected in the SHOW dropdown. 

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the cost price, average price per unit, units sold, profit, % profit or gross sales. Don't forget to use the left hand filters to drill down further by: channel, product tag, product brand, warehouse.

 

Product Options Report

To view a breakdown per sales channel, select BY OPTIONS in the GROUP BY dropdown. To just view the data overview of your channels, leave OVERVIEW selected in the SHOW dropdown. 

To then view a breakdown of your date range for one specific column, use the SHOW dropdown to drill down into the cost price, average price per unit, units sold, profit, % profit or gross sales. Don't forget to use the left hand filters to drill down further by: channel, product tag, product brand, warehouse.

 

Did this answer your question?