Customers & orders
Customer spreadsheets, order management, exports, and bulk updates across order data.
Customers
Bulk edit customers
Bulk edit Shopify customer data with Mixtable. Update names, tags, addresses, and notes in a spreadsheet or import a CSV, then push all changes to Shopify at once.
›
Building a Shopify store CRM
Build a lightweight CRM for your Shopify store using Mixtable. View, filter, sort, and manage all customer data in a spreadsheet that stays in sync with Shopify.
›
Bulk delete customers
Bulk delete Shopify customers in seconds using Mixtable. Select multiple customer rows in your spreadsheet and remove them from your store with one confirmation.
›
Bulk import or add customers
Import customers to Shopify in bulk with Mixtable. Add customer records individually or paste from Excel, import from a CSV, then sync everything to your store at once.
›
Bulk edit customer language
Load and bulk edit the language preference for your Shopify customers using Mixtable. See each customer's locale at a glance and update it in bulk directly from a spreadsheet.
›
Orders
Bulk delete orders
Bulk delete Shopify orders using Mixtable. Sync your orders to a spreadsheet, select the rows you want to remove, and delete them from Shopify in three steps.
›
Mark orders as paid
Mark multiple Shopify orders as paid at once using Mixtable Action Columns. Set true in your spreadsheet and sync payment status in bulk.
›
Set order customer
Set, change, or remove the customer on Shopify orders in bulk using Mixtable. Link guest checkouts to existing customers by updating the Customer Email field.
›
Analytics > Order Analytics
Orders Count Analytics
Track Shopify Orders Count per product or customer in Mixtable Analytics. Measure purchase frequency dynamically for any date range.
›
Orders for Last 30 days
See Shopify order counts for the last 30 rolling days in Mixtable. Automatically recalculated daily so you always have current order data.
›
Orders for Last Month
View Shopify order counts for last month in Mixtable. Data covers the full previous calendar month and updates dynamically as time moves forward.
›
Orders Net Profit Analytics
Calculate Shopify Orders Net Profit per product in Mixtable. Subtract COGS from net sales to compare product profitability across any date range.
›
Orders for Last Year
Analyze Shopify order counts for last year in Mixtable. Pull annual order data per product or collection and make data-driven decisions.
›
Analytics > Customer Analytics
Customer Analytics
Analyze Shopify customer behavior with Mixtable. Track AOV, total sales, refunds, order count, and product categories bought per customer in a live spreadsheet.
›
Customer Segment Analytics
Track Shopify customer segment performance with Mixtable Analytics. Measure sales, orders, discounts, and refunds per segment to improve targeting and retention.
›
Can't find what you need?
We read every email. Real merchants, real answers, usually the same day.