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).

• To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the ⚡️ button in the column header to open the selection window to choose the data you want to pull in.

  

• From the Shopify Sync Settings window, choose a metric.

• Select a time range, if necessary.

The data will begin to populate the column.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.