Shopify Smart Collections Excel Screenshot

Also known as Shopify Manual Collections. Those are the Collections, where you attach Products manually.

Excel Sheet Name

Custom Collections

Columns Available For Export And Import

Base Columns

Column Allowed Values Description / Example Value
ID Number ID is automatically generated number by Shopify to identify the item.
It is filled in by an Export.
When creating new Smart Collection, leave this value empty.

Handle Any characters allowed in a URL This is what your store visitors will see in the Collection URL address like this:

URL address has a great impact on SEO, so be sure to give it a meaningful name.
Regardless, what you write here, app will convert it to lowercase, and remove all non-URL friendly symbols.
You can leave it empty when creating new Collections – in that case we will generate it for you from Title.

Title Text Title of the Collection

Cool Looking T-shirts
Body HTML Text, HTML This is a long description of the Collection.

You can write here just a plain text, or format that text using HTML code.

You can put here additional images, videos, links to other Products or sites, tables, and so on.

You can learn about HTML capabilities online, for example or use some online video courses, like from or

The best way to create HTML Description, is to write a Description in the Shopify Admin for one Collection, format it as you like, and then do the export. Then you will see how that translates to HTML, and will be able to apply the same to other Collections.

Those all are nice T-shirts, and this is their <b>description</b>.
Sort Order
  • Alphabet
  • Alphabet Descending
  • Best Selling
  • Created
  • Created Descending
  • Manual
  • Price
  • Price Descending
This defines, how the Products will be sorted inside that Smart Collection.

Essentially, this is the same as a dropdown choice you have in the Admin, when you edit the Smart Collection.

If you set Sort Order to “Manual” then you can update column “Product: Position” to change positions of Products inside the Collection.

Best Selling
Template Suffix Text Template Suffix allows you to specify another Template from your Theme for this specific Collection. For example, you might want to specify different template for a Women T-shirts collection, which has different page layout.

Work with your developer to create new Template or read Shopify documentation about adding additional templates for Collections. Once new Template is created, you can set in this column to activate it for needed Collections.

That different template will show as dropdown for Collections in Shopify Admin, when new Collection Template will be created in your Theme. For example, if the new Template file name is “collection.women.liquid”, then – to activate this Template for this Collection, write “women” as the Template Suffix.

Updated At Time This column will only be exported.

It will be automatically updated, whenever you change the Collection data.

2017-10-06 23:03:00 UTC
  • TRUE
Tells, whether this Collection should be Published on your “Online Store” Sales Channel. If you will set it to FALSE, it will be hidden from Online Store, and clients will not be able to find it.

If you will leave this column empty, then it will hide that Collection form Online Store.

If Collection is not Published, you can publish it from Shopify Admin by finding this Collection, or importing the update of this column, marking Published to TRUE.

If you will write anything else in this column, the Collection will not get imported, and you will get an error “Bad Request” in Import Results row for this item, just to be safe it was intentional.

Published At Time This column will only be exported.

It will be automatically updated, whenever you publish the Collection to Online Store channel.

2017-10-06 23:03:00 UTC
Published Scope
  • global
  • web
Tells Shopify, where to publish this Product.

  • global: will be published in Point of Sale
  • web: will be published only in Web channel
Primary Row TRUE / FALSE Since all the base rows values are repeated for all item rows, in the export the primary row is set to TRUE, so that it can be used in sorting, to have that primary row on top.
Image Src URL Link to the image. This link must be publicly available.

Collection can have only one image.

Once image is imported, it doesn’t need to be hosted anymore with this link, because Shopify will download this image and store on their own servers.

If you don’t need to update image for Collection, just remove this column from Import file, and it will leave image unchanged when you do your import.


Product Columns

Each Custom Collection can include products, that are defined in these Columns.

Product Columns are added to the exported file, if exporting Custom Collections with “Linked Products”.

Column Allowed Values Description / Example Value
Product: ID Number The ID of linked Product in this Collection.

Since there can be several Products linked to a Collection, when you will do the export of existing Collections, there will be as many rows repeated, as there are linked Products.

When you need to import a Collection with linked Products, just export Products and Custom Collections with Linked Products, and import into new Store. Make sure that you have also Products exported in the same file, because the import will use information from Products sheet to determine, which old Product ID is now which new Product ID.

Product: Position Number For each Custom Collection, which has several linked Products, you can see and change the linked product Position in that Collection, by setting the appropriate position number. Number starts with 1. Like: 1, 2, 3…

Position numbers are used only for those Custom Collections, where [Sort Order] is “Manual”. Where sorting is not Manual, the position is calculated inside the Shopify dynamically, depending on the Sorting criteria.

To change order of linked Products in large Custom Collections, just Export, set the position numbers as you like, and import that one Collection back.

Especially in cases, when there is a large collection, it’s hard to change positions by mouse in Shopify Admin, then this helps.

When importing Custom Collection with Product columns, be sure to include all Product IDs, which belong to this Collection, because those will be overwritten.

If you need to update just Collection columns, and don’t need to change anything for linked Products, just remove those Product columns (and delete duplicated rows). Or you can just do the Export and don’t include Linked Products – then those Product columns will not be generated.

Product: Handle Text When “Products” are included in the export, this column will contain the Product Handle for linked Product.

When importing – this column is read when Product can’t be found by “Product: ID”, it is used as a secondary method to identify the linked product for Collection.

That way the smooth copying from one store to another is accomplished.



Read the description on Metafields page.

SEO Fields

SEO fields are actually Metafields with the following names:

  • SEO Title Metafield name is “Metafield: title_tag”
  • SEO Description Metafield name is “Metafield: description_tag”


Good To Know

  • If you don’t need to update linked Products for collections, then unselect the checkbox “Linked Products” when doing the Export of Custom Collections.
  • Generally, it’s good practice to try and use Smart Collections to link Products, because it is more dynamic – you don’t need to attach products manually. Custom collections would be best used when Smart Collection rules are not enough to identify, which Products to include in that Collection.
  • To import several linked Products for each Custom Collection, just repeat the row with at least the same ID, Handle or Title (whichever comes first), and set the “Product: ID” values. You don’t have to delete contents of base rows – that makes copying easier.
  • To not update some columns, remove those columns from Excel file. Then the Import will not touch them.
  • If you will have the Column with empty value, then this column will be changed to empty.
  • You can have unlimited count of Metafields.