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.