Formulas & actions

Sort your Shopify store data in ascending or descending order with Mixtable. Arrange products, orders, or customers by any column in just a few clicks.

Filter Shopify products, orders, and customers in Mixtable spreadsheets using text, number, and date criteria to find exactly what you need.

Use Ctrl+F to search your Shopify data in Mixtable. Quickly find specific values across any worksheet and navigate between matching cells with ease.

Set up a Conditional Worksheet in Mixtable to load only the Shopify data you need. Filter products, orders, or customers by vendor, tag, date, or any custom criteria.

Use Mixtable Action Columns to bulk add or remove Shopify product tags, update manual collections, and upload images. All from a spreadsheet in one click.

Format Shopify spreadsheet columns in Mixtable. Apply currency, date, number, percentage, text, or dropdown formatting to keep your data clean.

Preview Shopify changes before syncing with Mixtable's Sync Preview. Hide unchanged rows and columns to review exactly what will update in Shopify.

Restore accidentally deleted rows in your Mixtable worksheet. The Fill Missing Worksheet Data dialog repopulates any Shopify data that is no longer in the worksheet, without overwriting what's already there.

Pull related Shopify data into any worksheet with Mixtable. Add vendors, metafields, SKUs, inventory value, and more without writing a single formula.

Use Mixtable's bulk actions to update Shopify data fast. Find and replace text, bulk update numbers, and add or remove tags across products, orders, and customers.

Find and replace Shopify data in bulk with Mixtable. Update product descriptions, SEO fields, tags, and option values across your store with one action.