Screen - Smart Collections

Also known as Shopify Automated Collections. Those are the Collections, where you attach tts by defining Rules.

Excel Sheet Name

Smart 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, the 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, the app will generate it for you from Title.

Even if the handle will be in the non-English language, it will transliterate it to English, so that it is valid for URL. For example “рубашка” will be converted to “rubaska”.

Whatever you will put in the Handle column, the app will convert it to required Handle format, which is acceptable by Shopify.

  • NEW
When importing Smart Collection row – tell the app, what to do with it:

  • NEW: will try to create a new Smart Collection with the provided details. If such Smart Collection will already exist (with the same ID or same Handle), then the result will be Failed.
  • UPDATE: will try to find existing Smart Collection, and update it with data from the row. If such Smart Collection will not be found, then it will create new.
  • REPLACE: at first, if such Smart Collection with provided ID or Handle exists, then the app will delete it. After that, it will create a new one. If an existing Smart Collection will not be found, then still the app will create a new one. The difference from UPDATE is that it will not keep any of columns, which were not included in the import file since the Smart Collection will be deleted and re-created.
  • DELETE: the app will delete the existing Smart Collection, which is found by ID or Handle. If such Smart Collection will not be found, then the result will be Failed. This DELETE command is very handy for deleting Smart Collections in bulk.

If no Command is specified, then the app will assume the UPDATE command.

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 Collections, 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 drop-down choice you have in the Admin, when you edit the Smart 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 cell 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 can be only exported.

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

You cannot set specific publication date.

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

  • global: will be published in all your active store channels, like Online, POS, Facebook, etc.
  • web: will be published only in Online 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.

A collection can have only one image.

Once an 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.
Image Width Number The width of the image, in pixels.

Exported only.

Image Height Number The height of the image, in pixels.

Exported only.

Image Alt Text Text Alt Text for the Collection image. Great for SEO, because then search engines will know, what is inside the image.

Some descriptive name of the image
Must Match
  • all conditions
  • any condition
Here you define, how Rules will be applied to Smart Collection – by entering one of those possible values:

  • all conditions: Product is added to Collection, if all Rules are TRUE
  • any condition: Product is added to Collection, if at least one Rule is TRUE

Essentially, it’s the same as in Shopify Admin, when you manually edit the Smart Collection.

any condition


Rule Columns

Each Smart Collection has set of rules, that defines what products go into the automated collection.

Those rules are actually the same, as you can enter in Shopify Admin for collection. The best way to understand how to fill those in, is to enter one through Shopify Admin, and then do the Export. Then in the Excel you will see, what is what, and will be able to repeat that same principle when creating many collections to import in bulk.

For example, to include only Products, which are in stock, Rule will be:

Variant Inventory | Greater Than | 0
Column Allowed Values Description / Example Value
Rule: Product Column
  • Title
  • Type
  • Vendor
  • Variant Title
  • Variant Compare At Price
  • Variant Weight
  • Variant Inventory
  • Variant Price
  • Tag
Here you define, which Product Column should be the rule applied for.

Those are the same options, which are available in Shopify Admin, when you create the Smart Collection Rule.

Variant Inventory
Rule: Relation
  • Greater Than
  • Less Than
  • Equals
  • Not Equals
  • Starts With
  • Ends With
  • Contains
  • Not Contains
Here you define, what relation should be applied for that product column and the condition.

Those are the same options, which are available in Shopify Admin, when you create the Smart Collection Rule.

There are some limitations and interesting combinations as to which Rule relations can be applied to which columns, and what results you can achieve. Read more about Automated collections.

For Rule “Tag” use the “Equals” relation.

Greater Than
Rule: Condition Text Here you write the condition value you want to set.



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

  • To import several rules for each Smart Collection, just repeat the row with at least the same ID, Handle or Title (whichever comes first), and set the Rule 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.