Skip to content

Formulas & actions

Spreadsheet functionality, formulas, sorting, filtering, and bulk action workflows.

Spreadsheet functionality

15 guides

Menus and toolbarFind every tool in your Mixtable spreadsheet, from the menu bar and column menus to the toolbar and shortcuts, plus where the old Shopify controls moved.
Action columnsAction columns bulk add or remove Shopify product tags, update manual collections, and add product images, all from your spreadsheet in a few clicks.
Filter Shopify dataFilter Shopify products, orders, and customers by text, number, and date criteria, so your spreadsheet shows exactly the rows you need.
Set up a Conditional WorksheetSet up a Conditional Worksheet that loads only the Shopify data you need. Filter products, orders, or customers by vendor, tag, date, or your own criteria.
Sorting DataSort your Shopify store data in ascending or descending order. Arrange products, orders, or customers by any column in a couple of clicks.
Print a worksheetPrint a pick list of unfulfilled Shopify orders, or any Mixtable worksheet, with the columns you choose, a tick box on each row, and a live preview of every page.
Find Shopify informationPress Ctrl+F to search your Shopify data. Find any value across a worksheet fast and jump between matching cells as you go.
Related data fieldsPull related Shopify data into Orders, Products, Customers, and Media Images worksheets. Show vendors, SKUs, tracking numbers, inventory value, and more, without formulas.
Sync with ShopifySync spreadsheet edits to Shopify, preview them first, bring in updates from your store, and download the latest data with the Mixtable sync control.
Preview sync changesPreview every Shopify change before it syncs. Review each pending edit, row, field, and value in one dialog, so nothing reaches your store by accident.
Format cells and columnsFormat the columns in your Shopify spreadsheet. Apply currency, date, number, percentage, text, or dropdown formatting to keep your data tidy and readable.
Conditional formattingColor Shopify data automatically with conditional formatting in Mixtable, and spot low stock, missing SEO titles, draft products, and recent orders.
Details panelSee everything Mixtable has saved for a row's Shopify record in the Details panel, including images, variants, metafields, and fields that aren't columns.
Fill Missing Worksheet DataRestore rows you deleted from a worksheet by accident. Fill Missing Worksheet Data repopulates any Shopify data that is gone, without overwriting what is there.
Remove empty worksheet rowsClean up empty rows in a worksheet using the automatic Empty rows detected notice, or the Remove Empty Rows command in the Worksheet menu.

Bulk Actions

2 guides

Related topics

Products & variants22 guides Import & export14 guides Analytics metrics36 guides

Can't find what you need?

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

Email [email protected]

Most replies in under 4 hours, Monday to Friday
Screen shares for tricky setups, on request
Free plans get the same answers
You can also message us from inside the app