Skip to content
Guides

How to see which products a CSV import will move between Shopify collections

A product CSV import can add or remove products from automated collections. How conditions decide membership, and how to check before you import.

Why a product can leave a collection you didn't touch

Automated collections in Shopify don't hold a fixed list of products. Each one has conditions, such as "Tag includes sale" or "Price is less than 20", and Shopify adds or removes products as their details change. So a product CSV import that edits tags, type, vendor, prices or status can move products into or out of collections, even though the CSV never mentions a collection.

1. Know how a collection decides

Open the collection’s conditions in Shopify admin. You’ll see:

  • whether products must match all conditions or any condition;

  • each condition's field, operator and value.

Two rules from Shopify's help matter most for imports:

  • One matching variant is enough. In a collection with a Products source, a condition is true if any variant of the product matches it. One variant dropping below a price is enough to bring a product into a "Price is less than" collection.

  • Tags with special characters can match each other. Shopify ignores or treats as the same some special characters in tags, so a condition "Tag includes red-new" also includes products tagged red_new or red+new.

2. Find the columns your import will change

Compare your planned CSV with what's in your store now. The edits that most often move products are:

  • Tags: adding or removing a tag a collection checks;

  • Type and Vendor: renaming or correcting values;

  • Price and Compare-at price: a sale starting or ending;

  • Status: moving products to draft or archived.

A few import rules decide what actually changes:

  • If you tick "Overwrite products with matching handles", the values in your CSV replace the store's values, and a blank cell in a column you included blanks the value.

  • A column you leave out of the file keeps the store's value.

  • A column you include that depends on columns you left out can delete data. Shopify's example: a SKU column without the Option1 name and Option1 value columns deletes the variant option.

  • If you don't tick overwrite, products whose handle is already in your store are ignored.

3. Why an export alone won't tell you

A Shopify product export doesn't include the Collection column. So you can't open two exports and see collection membership; you have to work it out from each collection's conditions.

4. Check it by hand, for a small import

For each collection you care about:

  1. Write down its conditions and whether it matches all or any.

  2. For each product in your planned CSV, check each condition against the product's values before and after the import, variant by variant for prices.

  3. Mark the products whose result changes: those would join or need review.

  4. Note anything you couldn't check, for example inventory stock or a metafield, and treat those products as undecided rather than safe.

This works for a handful of products and one or two collections. It gets slow with many variants or many collections.

5. Or preview it in your browser

Crowdfile makes Shopify Collection Change Preview, a free tool that does step 4 in your browser tab. You choose an export of your store and the CSV you plan to import, answer the overwrite question, and enter each collection's conditions. If you're not sure about overwrite, choose "I don’t know" and it shows what would happen either way.

For each collection it lists Would join, Couldn’t decide whether it leaves, how many Stays in, Couldn’t decide and Not checked, and you can download a receipt as CSV or text. Shopify may retain manually added products, and the export doesn’t identify how a product became a member.

It uses the conditions you enter, because exports don't include collections. It checks title, type, vendor, tag, price, compare-at price, product category and status, for collections with a Products source. Conditions on variant title, weight, inventory stock or metafields are marked Not checked, and products that depend on them, or on letter case or tag special characters, are listed as Couldn’t decide rather than guessed. It previews up to 20 collections at a time. Your files stay in your browser and are never uploaded. Crowdfile is not affiliated with Shopify.

6. What this guide can't do

It can't change your import or fix a collection. If a product would leave a collection you need it in, change the planned CSV or the collection's conditions in Shopify, then preview again before you import. Manual collections have no conditions, so they aren't affected this way and can't be previewed.