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

Manual Collection Fields

Metafield Definition Fields

Product Fields

Discount Fields

Metafields

Smart Collection Fields