search
Help / Topics / Customers & orders

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.