Use case for Mixtable Spreadsheet Editor
Update collection memberships across your whole catalog with a spreadsheet. Filter to the right products, add or remove them from manual collections, review the changes, then sync to Shopify.
Collections - Summer Refresh Sync 4 changesPreview Trusted by thousands of Shopify stores
What you can do
Mixtable connects your products and collections to a spreadsheet, so building and maintaining collections becomes a filter, a column, and a sync instead of an afternoon of clicking.
Choose a collection once, then fill or paste it down the add-to-collection column to move hundreds of products at a time.
Clear out last season's picks or a discontinued vendor from any manual collection without touching the rest.
Pick one or more collections for a cell with the built-in picker, or type handles directly, then fill the add and remove action columns for bulk changes.
Filter by vendor, tag, product type, category, or status so membership changes hit exactly the right products.
Use the Collections template to load collection details and product memberships. With Mixtable Analytics Spreadsheet, add Net Sales, quantity sold, order count, or refund analytics beside each collection.
Export products together with their collection information to Excel or CSV for merchandising reviews and audits.
Work with memberships from the product side, or load collections themselves as worksheets. Automated collection rules stay in Shopify, and Mixtable helps you maintain the tags they use.
In the spreadsheet
Summer Sale - Additions Sync 4 changesPreview Pick collections for a cell with the built-in picker, then fill or paste that value down the add-to-collection column. Every assignment is visible in the sheet, and nothing changes in your store until you review and sync.
Guide: Add products to collections Filter: tag is clearance Sync 4 changesPreview New arrivals, clearance, best-of-vendor: most collections are really a filter over your catalog. Apply that filter in the worksheet, then add everything that matches in one move.
Guide: Build a collection from a filter Summer Sale - Cleanup Sync 3 changesPreview Collections rot quietly: sold-out styles, ended promotions, dropped vendors. Use the remove action column to clear them out in bulk, with every removal listed for review before it happens.
Guide: Clean up a collection Collections - Overview Manual collections hold the products you put in them. Automated collections fill themselves from rules like tags, vendor, or price. Mixtable edits manual memberships directly, and for automated collections it is the fastest way to maintain the tags their rules depend on.
Guide: See your collections clearlyReview and sync
Every add and remove is listed before anything happens in Shopify. Check the pending values for your worksheet, drop anything that does not belong, then run Sync to Shopify.
| Row | Product | Field | Pending value |
|---|---|---|---|
| 2 | Classic Oxford Shirt | Add to collection | Summer Sale |
| 3 | Straw Hat | Add to collection | New Arrivals |
| 4 | Wool Scarf | Remove from collection | Summer Sale |
| 5 | Espadrille | Add to collection | Summer Sale |
| 6 | Waxed Jacket | Remove from collection | Summer Sale |
Compare
When a collection needs fifty products moved in or out, here is how the usual tools hold up.
| Collection task | Mixtable | Shopify admin | CSV import and export | Other bulk-edit apps |
|---|---|---|---|---|
| Add many products to a collection | Yes, filter and add | Bulk action on a selection | Import-only Collection column | Sometimes |
| Remove many products from a collection | Yes, in bulk | Bulk action on a selection | No | Sometimes |
| Filter your catalog before changing memberships | Any column, live | Basic search | Manual in Excel | Basic filters |
| See products together with their collections | Yes, one sheet | Per collection view | Not in the standard export | Varies |
| Export memberships for audits | Excel or CSV | No | Partial | Varies |
| Review changes before they go live | Yes | Applies immediately | No preview | Some |
Comparison reflects typical collection management workflows. Shopify features can change over time.
Getting started
Connect your store, filter your catalog, and move products where they belong.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and open a spreadsheet.
Create product worksheets, plus collection worksheets when you want the full picture.
Filter to the right products, then fill the add and remove action columns with the picker, paste, or fill down.
Every membership change is listed with its collection before anything happens.
Apply the reviewed changes and your storefront collections update.
Questions
Load your products into Mixtable and filter to the ones you want. Pick collections for a cell in the add-to-collection action column, fill or paste that value down the filtered rows, then review the pending changes and run Sync to Shopify.
Use the remove-from-collection action column on the filtered rows, review the removals in the sync preview, and sync. Only the memberships you targeted change.
Yes. A product can belong to as many manual collections as you like, and you can assign different rows to different collections in the same worksheet pass.
Manual collections contain exactly the products you add to them. Automated collections fill themselves from rules like tag, vendor, type, or price. Mixtable edits manual memberships directly and helps you maintain the tags automated rules depend on.
Not directly, because automated collections are controlled by their rules. The practical route is to bulk edit the matching field, usually a tag, and the collection updates itself. Mixtable makes that tag edit a one-minute job.
Yes. Export products together with their collection information to Excel or CSV, which is ideal for merchandising reviews, audits, and sharing with your team.
Yes. The Collections template creates one worksheet for collection details and another product worksheet where you can review and update manual collection memberships.
No. Adds and removes stay as pending changes until you review them and run Sync to Shopify. Once synced, your storefront collections reflect the update.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store, filter your catalog, and put every product where it belongs.
