Shopify’s new collection rules can match any or all of several values in a single condition, like “tagged with any of sale, clearance”. Until now those rules had no spreadsheet representation, so exports skipped them with a warning. Now they fit on a single row with the new Rule: Match Type column.
🚀 What’s New#
- Rule: Match Type column - put several values in one rule row and set
anyorallto control how they combine (see Collection fields). - List values in Rule: Condition - separate values with commas, or use a JSON array like
["Acme", "Smith, Jones & Co"]when a value contains a comma.
🔧 Improvements#
- Complete collection exports - rules whose any/all setting differs from the source’s Must Match logic now export as one row instead of being skipped.
- Safer round trips - re-importing an exported Collections file with REPLACE keeps those rules on the collection.
- Clear validation - a match type that Shopify doesn’t accept for the rule’s relation is skipped with a warning that names the row.

