Customers & orders

Review Shopify fulfillments and fulfilled items in a spreadsheet. Check shipment status, tracking, delivery timing, quantities, and the related order details.

Review Shopify returns and returned items in a spreadsheet. Check return status, timing, quantities, reasons, customer notes, products, and variants.

Mark many Shopify orders as paid at once. Set true in an action column, sync, and every order's payment status updates together.

Set, change, or remove the customer on Shopify orders in bulk. Link guest checkouts to existing customers by updating the Customer Email field.

Track Shopify order payment terms in a spreadsheet. Review due dates, term length, overdue status, and the payment-term name and type on every order.

Delete old or test Shopify orders in bulk. Sync orders to a spreadsheet, select the rows you want to clear out, and remove them in three steps.

Bulk edit Shopify customer data. Update names, tags, addresses, and notes in a spreadsheet or import a CSV, then push every change to your store at once.

Import customers to Shopify in bulk. Add records by hand, paste them from Excel, or import a CSV, then sync every customer to your store at once.

Load and bulk edit the language preference on your Shopify customers. See each customer's locale at a glance and update them all from one spreadsheet.

Build a lightweight CRM for your Shopify store in a spreadsheet. View, filter, sort, and manage every customer record while it stays in sync with your store.

Delete Shopify customers in bulk. Select the customer rows you want to remove from your spreadsheet and clear them from your store with one confirmation.

Count Shopify orders by product, customer, vendor, collection, market, or segment, using analytics columns, Pivot Tables, and Time Series worksheets.

Calculate Shopify Average Order Value by customer, company, market, segment, vendor, product type, marketing channel, month, or year.

Analyze Shopify tax, shipping, duties, and additional fees by customer, B2B company, location, market, month, year, and other supported reports.

Calculate Shopify Orders Net Profit per product variant using cost per item and net quantity sold with Mixtable Analytics Spreadsheet.

Analyze Shopify customer lifetime value, orders, sales, refunds, product interests, segments, attribution, and returns with Mixtable Analytics.

Compare Shopify customer segments by sales, orders, refunds, discounts, and average order value using Mixtable Pivot Table and Time Series worksheets.