Sales by Product Variant Template
The Sales by Product Variant spreadsheet template offers valuable insights into your Shopify store’s performance, enabling you to make more informed business decisions.
You can use the template to:
- Identify Top and Bottom Performers: By analyzing the Total Order Count, Gross Quantity Sold, and Net Quantity Sold for each variant, you can pinpoint your best-selling and worst-selling product options. This helps you focus on promoting popular items and potentially discontinuing those that underperform.
- Optimize Inventory Management: Understanding which variants sell more helps you forecast demand more accurately, reducing the risk of stockouts for popular items and overstocking less popular ones.
- Refine Product Offerings: Insights into variant performance can inform decisions about introducing new variants, bundling popular ones, or adjusting pricing strategies for different options.
How do you load the Sales by Product Variant template?
- After installing the Mixtable Analytics app, click the Create a Workbook button.
- Select the Sales by Product Variant pre-built template from the list.
Data included in the Sales by Product Variant template
The Sales by Product Variant template contains the following default data points:
- Product Title
- Handle
- Variant Title
- SKU
- Total Order Count
- Gross Quantity Sold
- Net Quantity Sold
- Returns
- Discounts
- Net Sales
In addition to the default data pulled from Shopify, you can map extra columns with desired data. Here’s how:
- Select an empty column (or insert a new one).
- Click the Link button from the column header.
- From the Shopify Sync Settings window, choose a metric.
- Select a time range, if necessary.
The data will begin to populate the column.
Analyze store data with spreadsheet functions
Operating in the Mixtable app allows you to use spreadsheet functions to analyze and manage your data, such as:
Find out more about the Mixtable suite of products here.
