search
Help / Topics / Templates

Templates

Pre-built spreadsheet templates for data editing, exports, and analytics use cases.

Using Mixtable > Templates

Basic Product Information
Bulk edit Shopify product titles, descriptions, tags, and SEO fields with a ready-made template. A fast way to clean up the basics across your catalog.
Full Product Information
Bulk edit Shopify products and variants with a ready-made template. Update prices, inventory, metafields, and more from one spreadsheet.
Inventory
Track Shopify inventory across every warehouse in one spreadsheet. Spot dead stock, plan restocking, and see availability by location at a glance.
International Prices
Manage Shopify international market prices with a ready-made template. View, edit, and set Compare At prices for every market in one spreadsheet.
Product Metafields
Bulk edit Shopify product and variant metafields with a ready-made template. Manage references, preset choices, and SEO data from one spreadsheet.
Google Shopping
Manage your Shopify Google Shopping feed in bulk with a ready-made template. Keep titles, prices, and inventory accurate so your ads keep running.
Orders and Order Items
Manage Shopify orders in bulk with a ready-made spreadsheet template. Track status, fulfillment, customer behavior, and inventory in one place.
Unfulfilled Orders
See every unfulfilled Shopify order in a live spreadsheet. Review what is still pending, spot delays early, and manage fulfillment from one place.
Customers
View and manage your Shopify customers in a ready-made spreadsheet template. See orders, tags, and total spend, then segment or delete customers in bulk.

Analytics > Templates

Product Sales Metrics
Create a Shopify product sales spreadsheet with order count, quantities sold, refunds, discounts, and Net Sales using Mixtable Analytics.
Product Variant Sales Metrics
Compare Shopify product variant orders, quantities sold, refunds, discounts, and Net Sales by SKU using Mixtable Analytics Spreadsheet.
Product Sales by Year
Compare Shopify product Net Sales and Gross Sales year over year with all-time and annual analytics columns in a Mixtable spreadsheet.
Product Sales by Month
Track Shopify product Net Sales and Gross Sales for the latest 24 months with a ready-made Mixtable reporting template.
Product Orders by Year and Month
Compare Shopify Orders Count for every product by calendar year and recent month with a ready-made Mixtable analytics spreadsheet.
Collection Sales
Compare Shopify collection order count, quantities sold, refunds, discounts, and Net Sales using the Mixtable Collection Sales template.
Sales by Product Type
Compare Shopify product-type Net Sales, Gross Sales, quantities, discounts, refunds, and tax with a ready-made Mixtable analytics report.
Sales by Product Category
Compare Shopify sales, units, discounts, refunds, and tax by standardized product category, and spot the products you have left uncategorized.
Sales by Product Tag
Compare Shopify sales, units, discounts, refunds, tax, and net revenue by product tag in a ready-made analytics template.
Sales by Vendor Template
Compare Shopify vendor Net Sales, Gross Sales, quantities, discounts, refunds, and tax with a ready-made Mixtable Pivot Table worksheet.
Sales by Market
Compare Shopify Market orders, gross sales, discounts, refunds, net sales, and average order value with Mixtable analytics.
Sales by Customer
Compare Shopify customer orders, sales, discounts, refunds, average order value, product interests, and segment membership using Mixtable Analytics.
Sales by Customer Segments
Compare Shopify customer segments by orders, Gross Sales, discounts, refunds, Net Sales, and Average Order Value using Mixtable Analytics.
One-Time Customers
Find Shopify customers with exactly one order and review their contact details, latest order, and gross order amount with Mixtable.
Customers With No Orders
Find the Shopify customer records with zero orders and review their contact details, all in a ready-made spreadsheet template.
Monthly Store Performance
Track Shopify sales, orders, refunds, discounts, taxes, shipping, duties, fees, quantities, and Average Order Value over 12 months.
Holiday Season Sales
Compare Shopify product Net Sales and Gross Sales across the latest three September-to-December holiday seasons with Mixtable.
Order Fulfillment Template
Track the number of fulfilled Shopify orders for each of the latest 12 months with Mixtable's Order Fulfillment analytics template.
Product Returns Template
Compare Shopify quantities ordered, quantities refunded, and refund-based return rates for every product in a ready-made template.

Can't find what you need?

We read every email. Real merchants, real answers, usually the same day.