Sample File
Download a sample spreadsheet with smart collection data to import.
General
ID
Description | Example Value |
Shopify collection identifier |
|
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 |
|
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 |
|
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 |
|
The main title of the collection that will be displayed to customers.
Body HTML
Description | Example Value |
Collection description |
|
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 |
|
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 |
|
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 |
|
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: Collection is published and visible to customers
FALSE: Collection is unpublished and hidden from customers
Published At
Description | Example Value |
Publication time - Export only |
|
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 |
|
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 |
|
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: 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 |
|
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 |
|
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 |
|
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 |
|
Alternative text for accessibility and SEO purposes.
Products Count
Description | Example Value |
Total products - Export only |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
The unique identifier of a product in this collection.
Product: Handle
Description | Example Value |
Product URL handle |
|
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 |
|
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 handleid
: Filter by collection IDproduct_id
: Filter collections containing specific productspublishable_status
: Filter by status (published/unpublished)published_at
: Filter by publish datetitle
: Filter by collection titleupdated_at
: Filter by last update date