Also known as Shopify Manual Collections. Those are the Collections, where you attach Products manually.
See what each field/column from our “Custom Collections” template means including possible allowed values and examples.
Fields marked with “Export only” tag cannot be imported/set in Shopify but can be exported with Matrixify export.
Excel Sheet Name
Custom Collections
To tell the app that you are importing Custom Collections you need:
- If using CSV file then the file name needs to contain the word “Custom Collection”, for example, “my-shopify-custom-collections.csv”
- If using XLSX file then the sheet/tab name in the file needs to be “Custom Collection”. The file name for the XLSX file does not matter.
Need a quick start?
Columns Available For Export And Import
Basic Columns
Column | Description / Example Value |
---|---|
ID | ID is automatically generated number by Shopify to identify the item. It is filled in by an Export. Can be used for Import to identify and update existing Custom Collections. When creating new Custom Collection, leave this value empty. Allowed ValuesNumber Example22920047631
|
Handle | This is what your store visitors will see in the Collection URL address like this:
https://mystore.com/collections/cool-looking-tshirts
URL address has a great impact on SEO, so be sure to give it a meaningful name. If the handle will have non-Latin characters like Chinese, Arabic or Russian, or any other language, it will get “transliterated” to the similar-sounding Latin letters by default. You can switch this option off in Options upon importing by unchecking “Transliterate Handles to English alphabet”. Whatever you will put in the Handle column, the app will convert it to the required Handle format, which is acceptable by Shopify. When updating Handle the app by default will also create a Redirect from old Handle to the new one. You can turn this off in the Import options with importing a file. In Shopify, all Handles have a limitation of 255 characters, so any Handle longer than that will be truncated to 255 characters. Allowed ValuesAny characters allowed in a URL Examplecool-looking-tshirts
|
Command | When importing the Custom Collection row – tell the app, what to do with it:
If no Command is specified, then the app will assume the UPDATE command. Allowed ValuesNEW MERGE UPDATE REPLACE DELETE IGNORE ExampleMERGE
|
Title | Title of the Collection
Allowed ValuesText ExampleCool Looking T-shirts
|
Body 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, Collections or sites, tables, and so on. You can learn about HTML capabilities online, for example, W3Schools.com or use some online video courses, like from Treehouse.com or Udemy.com. 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. The app is also doing some helping with the descriptions automatically to make it easier to use and fix popular issues:
Allowed ValuesText, HTML ExampleThose all are nice T-shirts, and this is their <b>description</b>.
|
Sort Order | This defines, how the Products will be sorted in that Custom Collection.
Essentially, this is the same as a drop-down choice you have in the Admin when you edit the Custom Collection. If you set Sort Order to “Manual” then you can update column “Product: Position” to change positions of Products inside the Collection. Allowed ValuesAlphabet Alphabet Descending Best Selling Created Created Descending Manual Price Price Descending ExampleBest Selling
|
Template Suffix | Template Suffix allows you to specify another Template from your Theme for this specific Collection. For example, you might want to specify a 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 a 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. Allowed ValuesText Examplewomen
|
Updated At
Export only |
This column will only be exported.
It will be automatically updated, whenever you change the Collection data. Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Published | 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. Allowed ValuesTRUE FALSE ExampleTRUE
|
Published At
Export only |
This column can be only exported.
It will be automatically updated, whenever you publish the Custom Collection to Online Store channel. You cannot set a specific publication date. Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Published Scope | Tells where the Collection is published
Allowed Valuesglobal web Exampleglobal
|
Products Count
Export only |
Number of Products in the Collection.
Allowed ValuesNumber Example5
|
Row #
Export only |
Will have row number from 1 till the end for each row. So that if you change the sorting in your exported file to easier update your data, you can sort it back by “Row #” and return it to the original sorting. Because, you know, all the item data should be together – and if you change the sorting, you need to sort it back. |
Top Row
Export only |
It will have value “TRUE” for each “top row” of the item. That can help you filter in Excel to get only the base rows, in case you need to get rid of repeated rows for each item. Some sheets already had this as Primary Row column earlier, but we have added it now to all the sheets now and renamed to Top Row so it’s more clear. |
Image Src | 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. Allowed ValuesURL Examplehttps://images.com/image.jpg
|
Image Width
Export only |
The width of the image, in pixels.
Allowed ValuesNumber Example1263 |
Image Height
Export only |
The height of the image, in pixels.
Allowed ValuesNumber Example573 |
Image Alt Text | Alt Text for the Collection image. Great for SEO, because then search engines will know, what is inside the image.
Allowed ValuesText ExampleSome descriptive name of the image
|
Linked Products
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 | Description / Example Value |
---|---|
Product: ID | 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. Allowed ValuesNumber Example11920047631
|
Product: Position | 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. The 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 the 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. Allowed ValuesNumber Example27
|
Product: Handle | 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. Allowed ValuesText Examplemom-strength-tshirt |
Product: Command | Whenever Custom Collection linked products are imported, there is always one of those commands executed for each of linked product row:
If no Product: Command is specified, then the MERGE will be assumed. Allowed ValuesMERGE DELETE REPLACE ExampleMERGE |
Metafields
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”
Export Filters
In the Matrixify app, you can apply filters to Export only specific items from your Shopify Store.
When creating new export, select what you wish to export, and under that entity click on the “Filters” button.
Note: total displayed item count and estimated time won’t be affected by the filters applied.
Filter | Description |
---|---|
Handle | Allows you to export specific collections by their Handles, separated by a comma.
Possible Conditions
Examplemy-collection-handle, other-collection-handle |
Title | Allows you to export Products whose Title contains specific text.
“Matches pattern” condition allows entering wildcard symbols. Possible Conditions
ExamplePart of Title, other title Title * End of Title |
Updated At | Allows exporting Collections which were last updated in the Shopify within a specific date range.Relative date condition allows you to export Collections that have been updated in the last full amount of time.
For example – Last 1 Days, would export Collections from last full day, so yesterday. Possible Conditions
|
Published At | Allows exporting Collections which were published in the Shopify within a specific date range.Relative date condition allows you to export Collections that have been published in the last full amount of time.
For example – Last 1 Days, would export Collections from last full day, so yesterday. Possible Conditions
|
Products Count | With the “Products Count” filter you can export collections that have a specific amount of Product in it based on your set condition.
Possible Conditions
Example5 |
Metafield | Filters the Orders export by Collections Metafields.
Specify Metafield by:
Possible Conditions for Text value
Possible Conditions for Number value
|
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 an empty value, then this column will be changed to empty.
- You can have an unlimited count of Metafields.