Managing Automated (Smart) Collections with CSV Import
Automated and Manual Collections
With the CSV import feature of BPE you can add new or edit existing collections. Shopify collections can be either Automated or Manual. For Manual collections, products are added individually; however, for Automated collections, products are added based on a set of conditions (also called rules) defined by you.
The conditions for individual Automated collections can be set on Shopify Admin Center:
Importing Smart Collections with CSV Import
When you want to bulk import Automated collections with BPE's CSV import feature, you must pay attention to the naming conventions for each field.
A condition is made of up four (4) parts:
- Condition Field (e.g. Product Title)
- Condition Relation (e.g. contains)
- Condition Value (e.g. T-shirt)
- Product Must Match ("all" or "any")
- This part determines whether products must meet all the conditions ("all") or just one of them ("any") to be included in the collection
The Condition Value can be any text or number that logically fits with the condition. However, the Condition Field and Relation values must be selected from a pre-defined list from Shopify.
Valid Condition Field values:
'TITLE', 'TAG', 'TYPE', 'VARIANT_COMPARE_AT_PRICE', 'VARIANT_INVENTORY', 'VARIANT_PRICE', 'VARIANT_TITLE', 'VARIANT_WEIGHT', 'VENDOR', 'IS_PRICE_REDUCED'
Valid Condition Relation values:
'CONTAINS', 'ENDS_WITH', 'EQUALS', 'GREATER_THAN', 'IS_NOT_SET', 'IS_SET', 'LESS_THAN', 'NOT_CONTAINS', 'NOT_EQUALS', 'STARTS_WITH'
Note: Not every Field can go with every Relation. For example, you cannot have the condition:
TITLE GREATER_THAN 5
Please refer to the relation dropdown menu in the Shopify Admin Center if you are unsure whether a certain field can be paired with a relation:
How do you put these fields into your CSV?
Each part of the condition will be in a separate cell in the CSV. For Automated collections that have multiple conditions, you can put each condition in a separate row.
Note that the "Product Must Match" part is optional and the default value will be "all" if it is excluded. Please only include one (1) value for Product Must Match per set of conditions.