Add or remove Shopify products from collections in bulk

Mixtable lets you manage Shopify manual collection membership with a spreadsheet. You can filter your products, choose collections from a picker, apply the same change to many rows, preview the result, and intentionally sync it to Shopify.

This guide covers two useful approaches:

• Edit each product’s complete manual collection list when you want to see its current memberships
• Use Add to Collections and Remove from Collections Action columns when you want to add or remove specific memberships without replacing the rest

Start with the Collections template

The fastest setup uses Mixtable’s ready-made Collections template:

1. Install Mixtable Spreadsheet Editor
2. Open your Mixtable dashboard and click Create spreadsheet at the top of the page. If you haven't created a spreadsheet yet, click Browse all templates below the dashboard's suggestions instead. In the Create spreadsheet window, find Collections under Organization, or type its name in the search box, and click it. Mixtable creates the spreadsheet and fills it with data from your Shopify store.
3. Open the Product Collections worksheet

If more than one Shopify store is connected, choose the store at the top of the Create spreadsheet window before you click the template.

The template creates two worksheets:

• Collections has one row per Shopify collection and is useful for editing collection details
• Product Collections has one row per product and is the worksheet used to change manual collection membership

The Product Collections worksheet already includes the product title, handle, Add to Collections, Remove from Collections, and Product’s Manual Collections columns.

Filter the products you want to change

Before making a large update, narrow the worksheet to the right products:

1. Click Filter in the Mixtable toolbar
2. Open the filter in a useful column, such as Title or Product’s Manual Collections
3. Set the condition that identifies the products you want to change

You can add more Shopify data columns, such as vendor, product type, or tags, when those fields make the group easier to identify. Filtering keeps unrelated products out of view while you prepare the collection changes.

Edit a product’s complete manual collection list

Use Product’s Manual Collections when you want to see and control the complete set of manual collections for a product.

1. Find the product row in the Product Collections worksheet
2. Click the + button in its Product’s Manual Collections cell
3. Search or filter the collection picker by title, handle, or description
4. Check each manual collection the product should belong to
5. Uncheck each manual collection the product should leave
6. Click Update cell with selected collections

The cell contains the selected collection handles as a comma-separated list. You can copy and paste a completed cell into other product rows when those products should have exactly the same collection memberships.

Add or remove products with Action columns

Action columns are the safer choice when you want to add or remove specific manual collection memberships without replacing a product's complete collection list.

The Collections template already includes these columns. To add one to another Products (no variants) or Products (with variants) worksheet:

1. Click ＋ Shopify data in the header row of an empty column, or choose Column > Add Shopify data… from the menu bar
2. In the field picker, click Action columns in the list of sections on the left
3. Click Add to collections or Remove from collections
4. Click Save Column

To use the new column:

1. Click the + button in an action cell
2. Check the manual collections to add or remove for that product
3. Click Update cell with selected collections
4. Repeat for other products, or copy the completed action cell to rows that need the same change
5. Click Preview at the top right of the spreadsheet and review the pending collection actions
6. Click Sync when the preview is correct

On a Products (with variants) worksheet, the action applies to the parent product for that variant row. A Products (no variants) worksheet is usually easier for collection work because each product appears once.

Learn more about Action columns.

Preview and sync the collection changes to Shopify

Updating a cell does not immediately change Shopify. Mixtable keeps the edits as drafts so you can review a large collection update before it reaches the store.

1. Click Preview at the top right of the spreadsheet
2. Review the affected products, collection actions, and pending values
3. Return to the worksheet and correct anything unexpected
4. Click Sync when the preview is correct

Allow the sync to finish before checking collection membership in Shopify.

Collection membership troubleshooting

An automated collection is missing from the picker

The picker intentionally lists manual collections. To affect an automated collection, change the Shopify field used by its conditions, such as a tag, vendor, product type, price, or inventory value.

I copied a cell and removed other collection memberships

The Product’s Manual Collections cell represents the complete membership list. Restore the missing handles before syncing, or discard the draft edits and use Add to Collections for an additive change.

A product appears more than once in a Products (with variants) worksheet

Collection membership belongs to the parent product, not an individual variant. Action columns on variant rows update the parent product. A Products (no variants) or Product Collections worksheet is usually clearer because it shows one row per product.

The worksheet changed but Shopify did not

The values are still drafts. Click Preview, review the pending collection updates, then click Sync.