fullmetrixDocs

Variations

Compare the sales and stock of each variation of your products, by size, color or volume, and open the detail page of a variation.

The Variations report shows one row per product variation. A variation is a version of a product that has its own stock and often its own SKU, for example the blue t-shirt in size M. Where the Products report adds up every size and every color, this one keeps them apart.

Open the report

In the sidebar, open E-commerce in the Data group, then click Variations.

The entry is missing from your menu?

Variations only shows up if at least one product in your stores has variations. A store that only sells simple products does not need it. If you just created variations, the entry appears after the next sync.

Sidebar with the Variations entry highlighted and the Variations report displayed, with its title and the total number of variations

Below the Variations title, a sentence shows the total number of variations matching your search and filters, for example "1,284 variations total".

What this report is for

  • Which size or color sells best?
  • Which variation is out of stock while the others are still available?
  • Should we restock the M rather than the XL?
  • Which variations have never sold and can leave the catalog?

Read the table

ColumnWhat it shows
NameThe photo of the variation (or of the main product if the variation has none), its name and its SKU.
Stock quantityThe current stock of this variation alone.
Stock statusAn In stock, Out of stock or On backorder badge, based on the status sent by your store. On backorder means the variation can be sold as a pre-order.
Quantity soldThe number of units of this variation sold over the period.
RevenueThe sum of the order line amounts for this variation over the period.

Quantity sold and revenue are calculated the same way as in the Products report, except that they stop at the variation. Orders excluded in Settings, Reports tab, do not count. How the amount of a line depends on your platform is explained in Products.

Table of the Variations report with three variations of the same product and their stock badges highlighted

Unlike the Products report, this list shows every variation, even those that did not sell during the period. They appear at the bottom of the default sort, with 0 as quantity sold.

Sort, search and filter

Click the Name, Stock quantity, Quantity sold or Revenue header to sort. The default sort is revenue, from highest to lowest.

The Search for a variation... field searches the variation name, its SKU and the name of the main product at the same time. Type "Linen jacket" to find every size of the linen jacket.

The filter bar works as in the other reports. Click Filters, then Add a filter. A few useful filters here.

  • Parent name contains "Jacket", to show only the variations of one product.
  • Attribute is in "XL", to compare the same size across the catalog.
  • Stock status is in Out of stock, to see sold out variations.
  • Quantity sold equals 0, to find variations that do not sell.

See Filters and segments.

Available columns

The Columns button offers Default, All fields and Customize. Here are the columns you can add.

GroupColumns
GeneralE-commerce source, Parent name, Brand, SKU, Price, Regular price, Sale price, On sale, Publication status, Weight, Product category, Attribute
IdentifiersEAN code, UPC code
StockStock status, Stock quantity
SalesQuantity sold, Revenue
DatesDate created, Date modified, First sold, Last sold
IntegrationsMerchant Center ID

See Columns.

Export

The Export button, for example "Export 1,284 variations", downloads the whole filtered list with the displayed columns. See Exports.

The variation detail page

Click a row to open the detail page of the variation. It uses the same layout as the product detail page, with four differences.

  • The breadcrumb shows Variations, then the main product name, then the variation.
  • The type shown is Variant.
  • The Quantity sold, Revenue, Orders and Average order metrics only cover this variation.
  • The Other variants block lists the other variations of the same product with their sales, for a quick comparison.
Variation detail page with the breadcrumb and the four performance metrics highlighted Close view of the Other variants block comparing the two other versions of the same product

Differences between platforms

Each platform names variations its own way. They are combinations on PrestaShop, variations on WooCommerce, variants on Shopify and Sylius, and child products of a configurable product on Magento. Fullmetrix puts them all in this same report.

If the page is empty

No variations found appears when no variation matches the search or the filters. Clear the search, click Clear filters, then check the store selection. If your store was just connected, the message "Variations will appear here once data is synced" means the import is not finished.

Frequently asked questions

On this page