This report gives you access to a breakdown of your products with the flexibility to dig into the data however you like to get the best insights. Find a full breakdown of how to use the report and some examples of reports you can create.

Note: On the product report the stock quantity is calculated in near real time. The other sections of the product report/metrics will be updated within 10 minutes. However, if you update any product tags then this can take a little longer to reflect in the report; up to 60 minutes.

Veeqo calculates your profit using an Average Cost Price. Before Veeqo can begin calculating your profit and update your cost prices you must first 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.

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.

Find out how to make the most of your Products Report, with the guides for filtering and grouping below:

  • By Product
  • By Variant
  • By Options

You can then see the best performing product/variant/option for individual/bulk:

  • Channel
  • Product Tag
  • Product Brand
  • Warehouse

Report Breakdown 

Filtering:

When opening the Product report, it is set to the default OVERVIEW grouped by By Product

To dig deeper into your reports, change the Group by dropdown. 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.

 

(Please note: When data is grouped by date / time, you can only see an OVERVIEW. Change the Group by and Show dropdowns to have a visual view of your data)

To filter your data further, use the left-hand filter panel to filter your selected data by:

  • By Channel
  • By Product Tag
  • By Product Brand
  • Warehouse

If you're looking for a particular product or want to view all variants of that product on it's own, use the search bar to find it.

 

Breakdown your products by 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.

   

Selecting a date range:

Filter date ranges by:

  • Today
  • Yesterday
  • Last 7 days
  • Last 30 days
  • Last 90 days
  • Last month
  • Week to date
  • Month 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: 

 

This can then be viewed by:

  • Day
  • Week
  • Month

(Please note: If text for any of these options is greyed out, they cannot be selected for the date range / data values you've chosen. E.g. If you have a date range of 7 days selected, you cannot view the data by month in the table as the date period isn't long enough.)

 

Data Sorting:

Once you've got your filters setup, 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.

 

Table Columns:

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

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

 

 Exporting:

When exporting sales data, it is exported to a CSV file. There is the option to download the sales summary or the order history from a selected cell.

 

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
  • Gross 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?