The seasonal launch
A buyer sends 400 new SKUs shipping for Black Friday. Marketing needs them in the campaign collection today, not after a CSV export, a column match, and an upload that may or may not go through cleanly.
Bulk collections · No CSV
Add a thousand products to a Shopify collection before your coffee gets cold.
MassCat lets you bulk-add products to Shopify collections by pasting a list of SKUs, barcodes or product titles, or by filtering on conditions like stock, price or tags. No CSV template, no column mapping, no waiting on IT.
Free plan · paid plans from $9.99/mo
Short answer
How do you add a list of SKUs to a Shopify collection?
Shopify's admin has no box to paste a list of SKUs into a collection. You have five options, depending on the size of the list:
- Shopify admin: search and tick products page by page, one collection at a time. Fine for a dozen products.
- Sidekick (Shopify's AI): paste the SKUs in the chat and ask for the collection. Exact on small lists; about 200 SKUs per message and 250 products per review in our test.
- Product CSV import: fill the
Collectioncolumn. One collection per product, and the file must follow Shopify's full product format. - Collection conditions: only if the products share a tag, vendor, type or price. Otherwise you have to tag them first.
- MassCat: paste up to 5,000 SKUs or barcodes (or 2,000 titles), see what matched, then add to one or several collections in one action, with undo.
The basics
Why collections carry more weight than a checkbox
A collection looks like a simple grouping: a name and a handful of products. On Shopify, though, collections drive your storefront navigation, your homepage merchandising, your campaign landing pages, and often the logic behind your on-site filters. Get a collection out of sync with your actual catalog, and customers browse a "Best Sellers" page with sold-out items, or land on a "Black Friday" collection that never got the new arrivals.
The problem is that the products that need adding rarely start as a tidy Shopify export. They start as a supplier's shipment list, a buyer's spreadsheet, or a marketing plan for a launch. SKUs or barcodes that need to land in the right collection before the campaign goes live. MassCat exists for exactly that handoff: paste the list you were given, pick the collection, and apply it across every matching product in one action.
Sound familiar
Your product list never comes pre-sorted
The catalog reorganization
A merchandising plan reshuffles products across five collections at once. Doing it one product page at a time in Shopify's admin means opening hundreds of products by hand.
Both start the same way: a list you didn't build inside Shopify, and a deadline that doesn't leave room for a CSV round-trip.
How it works
Three steps. Any list you already have.
- 01
Select your products
Paste a list of SKUs or barcodes (one per line, or separated by commas, spaces or semicolons), or product titles (one per line), exactly as it came from the spreadsheet. Or filter by title, type, vendor, tag, price, stock, dates or metafields, combining conditions with ALL / ANY logic.
- 02
Choose your action
Create a new collection, add to or remove from one or several existing collections, or replace a collection's content with your list. Add whole products, or only the variants in your list.
- 03
Review and launch
MassCat shows exactly what will be added, removed or left unchanged. Confirm, follow the progress, and undo from your activity history if you change your mind.
Create in bulk
Bulk create collections from a list
Shopify creates collections one by one, then makes you add products page by page. MassCat creates the collection and fills it in the same action. Every method compared.
From a pasted list
Paste the SKUs, barcodes or titles of the selection, choose "Create a collection", give it a name. The collection is created with every matching product in it.
From a filter
No list? Select products by vendor, tag, price, inventory, dates or metafields, then create the collection from the result.
Published or not
Tick "Publish on Online Store" to make it visible right away, or leave it unpublished to prepare a launch.
Any identifier
By SKU, barcode or product title
SKUs
The most reliable: one SKU points to one variant. Case doesn't matter, duplicates are ignored.
Barcodes (EAN / UPC)
Same list, same box. Useful when the supplier's file has no SKU column.
Product titles
Choose "Match by: Product title" and paste one title per line. The title must match exactly (upper/lower case and extra spaces don't matter), so "Linen Shirt" won't pick "Linen Shirt - Navy".
Shopify collections 2026
Works with Shopify's new collections
Shopify is replacing manual and smart collections with collections built from sources: hand-picked products, conditions, other collections and exclusions in one place.
Hand-picked part only
MassCat adds and removes hand-picked products. Conditions set by you or other apps are kept as they are.
Products or variants
With the new model you can add only some variants, for example only the red ones. MassCat does it from the same list.
Legacy collections too
Not on the new model yet? Your manual collections work the same way. What changed in 2026.
Why not just use Shopify
What Shopify's product list doesn't do
Shopify's admin lets you select products on the current results page and add them to a collection, but only from whatever's on screen, and only to one collection at a time. Once your list spans more than a page of search results, or needs to land in several collections at once, the native flow breaks down.
Shopify's official workaround is a CSV export and import: download a template, match your data to its exact column structure, upload it, and wait to find out whether the import succeeded or silently skipped rows that didn't fit the format. That workaround assumes your list already came out of Shopify. Most of the lists that actually need bulk sorting (supplier shipments, buyer plans, marketing briefs) never did.
Vs. the CSV round-trip
What you skip
For a batch of 300 SKUs, here's where the two approaches actually diverge.
| For 300 SKUs | The CSV way | The MassCat way |
|---|---|---|
| Format required | ✕Match Shopify's exact export columns | ✓None, paste your list as-is |
| Collections at once | ✕One collection per import | ✓Multiple collections in the same action |
| Steps | ✕Export template → fill in → upload → map fields → import | ✓Paste list → pick collection(s) → confirm |
| Bad rows | ✕Import often skips mismatches silently | ✓Unmatched entries flagged before you run it |
Where this fits
Built for the lists that already exist
Seasonal campaigns
Add hundreds of new products to a "Holiday Sale" or "Black Friday" collection using a filter or a pasted list. No manual page-by-page work.
Multi-collection merchandising
Place the same products into several collections at once, like "Homepage" and "New Arrivals" together, instead of repeating the action collection by collection.
Catalog cleanup
Remove out-of-stock or discontinued items from "Featured" or "Best Sellers" the moment they stop shipping.
Supplier & buyer imports
Sort new shipments into the right collections straight from a supplier's SKU list, without reformatting it into a CSV first.
Who it's for
Built for catalogs that don't sit still
Any Shopify store with a few hundred SKUs feels this eventually. These four run into it every week.
Bookstores & booksellers
New titles arrive by the box from publishers every week. Genre, author and seasonal collections need resorting constantly, not once a quarter.
Electronics & tech
Every model ships in a handful of storage and color variants. Sorting new SKUs into the right brand or category collection by hand stops scaling past a few hundred products.
Fashion & apparel
One style can multiply into a dozen SKUs across size and color. Seasonal collections turn over fast enough that manual sorting becomes a full-time job.
Beauty & cosmetics
Shade ranges alone can push a single product line into dozens of SKUs, and "new arrivals" or "bestsellers" collections need refreshing every drop.
Questions
Before you install
How do I add multiple products to a Shopify collection from a list of SKUs?
Shopify's admin can't take a pasted list: you search and tick products one page at a time. For a long list, paste the SKUs into MassCat: it finds the matching products, flags unknown SKUs, and adds them to one or several collections in one action. Sidekick also works for small lists (about 200 SKUs per message).
Can I add products to a Shopify collection without a CSV?
Yes. Paste a list of SKUs, barcodes or product titles directly into MassCat, or filter by product attributes such as title, tag or stock. No CSV file or template required at any point.
Can I add products to multiple collections at once?
Yes. Select several collections in the same action, for example "Homepage" and "Black Friday" together, instead of repeating the process collection by collection.
What about collections that use rules?
MassCat only adds or removes the products you picked. If a collection also has rules (automated conditions), those rules are kept as they are, and products matched by them stay in the collection.
Is there a limit to how many products I can add at once?
You can paste up to 5,000 SKUs or barcodes (or 2,000 product titles) in one go, and MassCat processes the batch in the background. Your plan sets how many products you can update per 30 days.
Can I remove products from collections the same way?
Yes. The same selection flow, by SKU, barcode or filter conditions, works for removing products from one or several collections at once. You can also replace a collection's content with your list.
How do I bulk create collections in Shopify?
In Shopify's admin you create each collection, then add products page by page. With MassCat, paste the list (SKUs, barcodes or titles) or use a filter, choose "Create a collection" and name it: the collection is created with all the products in one action.
Can I paste product titles instead of SKUs?
Yes. Choose "Match by: Product title" and paste one title per line. MassCat matches the exact title (upper/lower case ignored) and lists the titles it can't find.
Can I add only some variants of a product to a collection?
Yes, with Shopify's new collections model: choose "Only the variants in my list" after pasting SKUs or barcodes. Legacy manual collections only accept whole products.
Does MassCat work with Shopify's new collections (2026)?
Yes. MassCat edits the hand-picked products of a collection and keeps its conditions. It works the same on stores still using legacy manual collections.
What happens if some SKUs in my list don't match a product?
MassCat flags unmatched SKUs or barcodes before the bulk action runs, so you can review and fix them instead of finding out afterward that rows were silently skipped.
Stop sorting products one at a time.
Install MassCat and organize your first collection from the spreadsheet you were handed, in the next five minutes.
Free plan · paid plans from $9.99/mo