Skip to main content

Smart Collection Fields

Smart collections automatically group products based on conditions you define

Updated this week

Sample File

Download a sample spreadsheet with smart collection data to import.

General

ID

Description

Example Value

Shopify collection identifier

12345678

If present, the ID will be used to group multiple rows together into a single collection. When importing, the ID will be used to see if the collection already exists on the store. If there's no ID match the app will attempt to find an existing collection using the Handle.

Handle

Description

Example Value

URL-friendly identifier

summer-sale

The handle is the URL-friendly version of the collection title used in the collection's URL. The handle is used for grouping multiple rows together into a single collection and finding an existing collection on the store if the ID is not present.

Command

Description

Example Value

Action to perform

MERGE

  • NEW: Create a new collection (will fail if collection already exists)

  • MERGE: Update existing collection or create if not found

  • UPDATE: Update existing collection (will fail if collection doesn't exist)

  • REPLACE: Delete and recreate the entire collection with only data from the file

  • DELETE: Remove the collection from the store

  • IGNORE: Skip this collection during import

Title

Description

Example Value

Collection name

Summer Sale Items

The main title of the collection that will be displayed to customers.

Body HTML

Description

Example Value

Collection description

<p>All our summer sale items</p>

The main description of the collection in HTML format. You can include plain text or formatted HTML with images, videos, links, and tables.

Sort Order

Description

Example Value

Product sorting method

Manual

  • Alphabet (ALPHA_ASC): A-Z by title

  • Alphabet Descending (ALPHA_DESC): Z-A by title

  • Best Selling (BEST_SELLING): Sort by sales volume

  • Created (CREATED): Newest products first

  • Created Descending (CREATED_DESC): Oldest products first

  • Manual (MANUAL): Custom ordering (allows setting Product: Position)

  • Price (PRICE_ASC): Lowest price first

  • Price Descending (PRICE_DESC): Highest price first

Template Suffix

Description

Example Value

Alternative template name

sale-template

Allows you to use a custom template for displaying this specific collection. Work with your developer to create new templates in your theme.

Updated At

Description

Example Value

Last modification time - Export only

2024-12-05 06:12:35 -0500

The timestamp when the collection was last modified. This field is export-only and cannot be imported. ISO-formatted timestamps are also supported.

Published

Description

Example Value

Visibility

TRUE

  • TRUE: Collection is published and visible to customers

  • FALSE: Collection is unpublished and hidden from customers

Published At

Description

Example Value

Publication time - Export only

2024-12-05 06:12:35 -0500

The timestamp when the collection was published. This field is export-only and cannot be imported. ISO-formatted timestamps are also supported.

Published Scope

Description

Example Value

Publication scope

web

  • global: Published on both Online Store and Point of Sale channels

  • web: Published only on Online Store channel

Row

Description

Example Value

Row number - Export only

2

Used when a collection spans multiple rows (e.g., when including multiple rules or products). This field is export-only.

Top Row

Description

Example Value

Main collection row - Export only

TRUE

  • TRUE: This is the primary row for the collection

  • FALSE: This is a secondary row (e.g., for rules or products)

This field is export-only.

Image Src

Description

Example Value

Collection image URL

https://cdn.shopify.com/s/files/1/0001/collection.jpg

The URL of the featured image that represents the collection. The image must be publicly accessible.

Image Width

Description

Example Value

Image width - Export only

1200

The width of the collection's featured image in pixels. This field is export-only and cannot be imported.

Image Height

Description

Example Value

Image height - Export only

800

The height of the collection's featured image in pixels. This field is export-only and cannot be imported.

Image Alt Text

Description

Example Value

Image alternative text

Summer sale collection banner

Alternative text for accessibility and SEO purposes.

Products Count

Description

Example Value

Total products - Export only

25

The total number of products currently in the collection. This field is export-only and automatically calculated by Shopify.

Rules

Smart collections use rules to automatically determine which products belong in the collection. Each rule compares a product field against a specified condition.

Must Match

Description

Example Value

Rule matching logic

any condition

  • all conditions: Product is added to collection only if all rules are TRUE

  • any condition: Product is added to collection if at least one rule is TRUE

Rule: Product Column

Description

Example Value

Product field to evaluate

Vendor

  • Title: Product title

  • Type: Product type

  • Category: Product category

  • Vendor: Product vendor

  • Variant Title: Product variant title

  • Variant Compare At Price: Variant compare at price

  • Variant Weight: Variant weight

  • Variant Inventory: Variant inventory quantity

  • Variant Price: Variant price

  • Tag: Product tag

  • Metafield: Product metafield (use format Metafield: namespace.key)

Rule: Relation

Description

Example Value

Comparison method

Equals

  • Greater Than (GREATER_THAN): Field value is greater than the condition value

  • Less Than (LESS_THAN): Field value is less than the condition value

  • Equals (EQUALS): Field equals the condition value

  • Not Equals (NOT_EQUALS): Field does not equal the condition value

  • Starts With (STARTS_WITH): Field value starts with the condition value

  • Ends With (ENDS_WITH): Field value ends with the condition value

  • Contains (CONTAINS): Field value contains the condition value

  • Not Contains (NOT_CONTAINS): Field value does not contain the condition value

  • Is Empty (IS_NOT_SET): Field has no value (only for Variant Compare At Price)

  • Is Not Empty (IS_SET): Field has a value (only for Variant Compare At Price)

Note that Tag rules can only use Equals relation.

Rule: Condition

Description

Example Value

Value to compare against

Nike

The value that the product field will be compared against. For Category rules, you can use ID, Name, Breadcrumb, or ID|Breadcrumb format.

Products

Products that belong to the smart collection based on the defined rules. You can also manually adjust product positions when Sort Order is set to MANUAL.

Product: ID

Description

Example Value

Product identifier

987654

The unique identifier of a product in this collection.

Product: Handle

Description

Example Value

Product URL handle

blue-t-shirt

The URL handle of a product in this collection. Used as an alternative way to identify products when Product ID is not available.

Product: Position

Description

Example Value

Display order in collection

1

The position of the product in the collection. Only applies when Sort Order is set to MANUAL.

Metafields and SEO

Metafields can be imported and exported with collections to store custom metadata, SEO information, and additional attributes.

For detailed information about working with metafields, see our Metafields guide.

SEO fields are special metafields:

  • SEO Title: Metafield: title_tag

  • SEO Description: Metafield: description_tag

Export Filters

You can use these filters to limit which collections are exported:

  • handle: Filter by collection handle

  • id: Filter by collection ID

  • product_id: Filter collections containing specific products

  • publishable_status: Filter by status (published/unpublished)

  • published_at: Filter by publish date

  • title: Filter by collection title

  • updated_at: Filter by last update date

Did this answer your question?