BigCommerce Analytics | Merchandising Report

The Merchandising Report is all about diving deeper into your product catalog so you can best understand its performance and make major or minor adjustments to both save and make you money. This report lets you drill down to see revenue, orders, and quantity sold at both the product and variation levels. You'll be able to see your product’s strengths and weaknesses so you know where to focus and where to improve.

The Merchandising Report can be viewed under AnalyticsMerchandising.

Product Merchandising Report

Click on the Products tab to view the Product Merchandising Report.

Monitoring this report is key to understanding what your customers are purchasing and viewing, and is a great tool to help you plan product assortments for future collections.

Top Line Statistics

These statistics only take product-level information into account, so will differ from the top line statistics you see on other pages. For example, the revenue will take product-level discounts into account, but not order-level discounts.

Product top line statistics

  • Products Sold — the number of products sold in your store during your selected date range
  • Orders — the number of orders placed during your selected date range
  • Merch Revenue — the total amount of revenue from your merchandise. This amount includes product-level discounts, but does not take shipping, taxes, or order-level discounts into account.
  • Avg Price — the average (mean) price of your products that have been ordered
  • Price Range — the highest and lowest prices of products that have been ordered

 

Metric Breakdown

MetricDescriptionCalculation
Products Soldtotal number of unique products sold (not total quantity sold; rather it is quantity of unique products sold)sum (products included in completed orders)
Orderstotal number of orders that included productssum (orders with at least 1 product)
Merch Revenuerevenue from all successful orders of products, minus order level discounts, shipping, and taxes(sum (line item sale price - order level discounts) * qty)) - (sum (line item price for returned + refunded products from orders in the time period) * qty))
AVG Pricesum of the line item prices of the products divided by the total quantity included in completed orders(sum line item prices of products in all completed orders) / total quantity of products
Price Rangelowest sale price of an item purchased (including discounts), and highest sale price of an item purchasedlowest sale price of an item purchased (including discounts), and highest sale price of an item purchased

Merchandise Revenue Graph

The Merchandise Revenue graph shows how your merchandise revenue has changed over the course of your selected date range. The graph in purple shows the revenue for your current date range, and the graph in orange represents the revenue from the date range you are comparing with.

Product Revenue Graph

If the time period for the whole graph is a single day, the hover will display the hour of the day and the amount of Merchandising Revenue earned in that hour. If the time period for the whole graph is multiple days, the hover will display the date of the single day you hover over and the amount of Merchandising Revenue earned on that date.

Products Table

The products table helps you quickly understand some very important data about the best and worst selling products, the fastest and slowest growing products, and the most and least visited products. Click on a column name to change how the list is sorted, or click on a product name to see the individual product report.

Use the tools in the top-right corner to hide columns, reset the table, or download the table to a CSV file.

Product merchandising report

  • Product — the product's name. Click to view the individual product report.
  • Brand — the product's brand, if applicable
  • Merch Revenue — the revenue from units of the product sold within the provided date range
  • Orders — the total number of orders that include the product within the provided date range
  • Qty Sold — the quantity of the product sold within the provided date range
  • Visits — the number of page views the product has received within the provided date range

 

Metric Breakdown

MetricDescriptionCalculation
Merch Revenuemerchandising revenue from all completed orders from this product(sum (line item sale price - order level discounts) * qty))
Ordersall completed orders that included this productsum (completed orders that included this product as a line item)
QTY Soldnumber of this product that were included in completed orderssum (qty of products in completed order)
Visitsall pageviews to this product pagesum (pageviews of this product page)
 

Take Action with Data — Revenue is just one way to identify the top performing products in your shop. It’s important to evaluate product performance across multiple metrics to gain a true understanding of how your product mix works to complement each other.

Some questions to consider include:

  • Are there products that attract a lot of visitors?
  • Are there products that haven’t been viewed at all?
  • Which products are growing the most rapidly?
  • Which products are declining the quickest?

Using this table to answer those questions will help you gain a better understanding of which products are attracting the most visitors to your site and which products need to be reevaluated. You may find that the products that drive the most visits are not always the ones that result in the highest revenue, or that a fast growing product is not featured prominently enough in your online store.

Identifying products that are under-performing also allows you to explore the causes behind the poor performance and start experimenting with those products.

SKU Merchandising Report

Click on the SKUs tab to view the SKU Merchandising Report. In addition to the top line statistics and revenue graph provided from the product report, this report shows all of your store's SKUs in a table, sorted by your top revenue producers.

Click a column name to change the sort order, or use the icons in the top-right corner to hide columns, restore the table to its original format, or export this report. Clicking on the name of a product will bring you to the individual product report.

SKU merchandising report

  • SKU Code — the SKU assigned to the product variant
  • Product — the product's name. Click to view the individual product report.
  • Attributes* — the product variant. (*product options)
  • Merch Revenue — the revenue from units of the variant sold within the provided date range
  • Qty Sold — the quantity of the variant sold within the provided date range
  • Orders — the total number of orders that include the variant within the provided date range

 

Metric Breakdown

MetricDescriptionCalculation
Merch Revenuemerchandising revenue from all completed orders from this variant(sum (line item sale price - order level discounts) * qty))
QTY Soldnumber of this variant that were included in completed orderssum (qty of variant in completed order)
Ordersall completed orders that included this variantsum (completed orders that included this variant as a line item)

Individual Product Report

By selecting an individual product from any table you will be able to review that product's merchandising report. This report shows the product's basic information and statistics, such as its revenue, how often it's viewed, and its abandonment rate.

This detailed view into each individual product gives you the opportunity to drill down on products and understand the drivers behind product performance.

Product Statistics

Product details and statistics

The product's statistics include the following:

  • Revenue — revenue from units of the product sold
  • Avg Price — the average selling price per unit
  • Qty Sold — the quantity of the product sold
  • Orders — the total number of orders that include the product
  • Visits — the number of page views the product has received
  • Abandonment Rate — the percentage of abandoned carts that include the product

 

Metric Breakdown

MetricDescriptionCalculation
Revenuesale price minus order discounts, item returns and item refunds (these are returns from orders that happened in the given time period, rather than only returns that happened in the time period)(sum (line item sale price - order level discounts) * qty)) - (sum (line item price for returned + refunded products from orders in the time period) * qty))
Average Pricesum of the line item prices of the product divided by the total quantity sold(sum line item prices of product from all completed orders) / total quantity of product included in orders
QTY Soldnumber of this product that were included in completed orderssum (qty of products in completed order)
Ordersnumber of completed orders that include this productsum completed orders where this product is included as a line item
Visitsall pageviews to this product pagesum (pageviews of this product page)
Abandon Ratepercentage of all carts that included the product that did not become orders(total carts with product - total orders with product)/total carts with product
 

What is considered an abandoned cart? In BigCommerce Analytics, abandoned carts are defined as carts where a product has been added prior to a 30-minute period of inactivity.

Product Revenue Graph

This graph shows how your product's revenue has changed over the course of your selected date range. The graph in purple shows the revenue for your current date range, and the graph in orange represents the revenue from the date range you are comparing with.

Product Revenue Graph

 

Take Action with Data — This detailed view into each individual product gives you the opportunity to drill down on products and understand the drivers behind product performance. For example, you can take a closer look at both the best and worst selling products to see if there are any large differences that could be impacting sales, such as image quality, price or return rates.

You can then use this information to start creating some experiments to test whether changing any of these variables could help improve under-performing items. If return rates are high, this could be an indicator that there are issues with the product itself that may need to be resolved.

Additionally, you can take a closer look into the best performing products and use this detailed information as you start planning for next season’s product assortment.

SKU Statistics

Click on the SKUs tab to view the SKU statistics. This report provides detailed information on each variant of a base product that's been associated with a SKU.

Product sku details

  • Revenue — revenue from units of the SKU (including product-level discounts)
  • Avg Price — average price of the purchased units (including all discounts)
  • Qty Sold — the number of units of the SKU sold
  • Orders — the total number of orders that include the SKU unit
  • Visits — the number of visits to the base product page
  • Abandonment Rate — the percentage of abandoned carts that include the SKU

 

Metric Breakdown

MetricDescriptionCalculation
Revenuesale price minus order discounts, unit returns and unit refunds (these are returns from orders that happened in the given time period, rather than only returns that happened in the time period)(sum (line item sale price - order level discounts) * qty)) - (sum (line item price for returned + refunded units from orders in the time period) * qty))
Average Pricesum of the line item prices of the units divided by the total quantity sold(sum line item prices of units from all completed orders) / total quantity of units included in orders
QTY Soldnumber of units that were included in completed orderssum (qty of units in completed order)
Ordersnumber of completed orders that include this unitsum completed orders where this unit is included as a line item
Visitsall pageviews to the base product pagesum (pageviews of the base product page)
Abandon Ratepercentage of all carts that included this unit that did not become orders(total carts with this unit - total orders with this unit)/total carts with this unit

Understanding your product sales down to the SKU level can help you optimize your inventory by identifying large and small differences that could be impacting sales.

SKUs Table

The SKUs table helps you quickly understand your product sales down to the variant level by providing important data about the best and worst selling variants. Click on a column name to change how the list is sorted.

Product sku list

  • SKU Code — the SKU assigned to the product variant
  • Variants* — the product variants. (*product options)
  • Revenue — the revenue from units of the variant sold within the provided date range
  • Qty Sold — the quantity of the variant sold within the provided date range
  • Orders — the total number of orders that include the variant within the provided date range

 

Metric Breakdown

MetricDescriptionCalculation
Merch Revenuemerchandising revenue from all completed orders from this variant(sum (line item sale price - order level discounts) * qty))
QTY Soldnumber of this variant that were included in completed orderssum (qty of variant in completed order)
Ordersall completed orders that included this variantsum (completed orders that included this variant as a line item)
 

Have a question? Check out the Reports & Analytics section of BigCommerce's Community Answers.

Was this article helpful?