Sample File
Download a sample spreadsheet with manual 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 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 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.
Products
Products that belong to the manual collection. You can manually add, remove, or reorder products in manual collections.
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.
Product: Command
Description | Example Value |
Product action |
|
MERGE: Add product to collection (default if not specified)
DELETE: Remove product from collection
REPLACE: Replace all existing products with ones listed in the file
When using REPLACE, only products included in the import file will remain in the collection.
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_tagSEO 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