Includes Blog Posts, Blogs, and Comments.
See what each field/column from our “Blog Posts” template means including possible allowed values and examples.
Fields marked as “Export Only” cannot be imported/set in Shopify but can be exported with Matrixify export.
Excel Sheet Name
Blog Posts
To tell the app that you are importing Blog Posts you need:
- If using CSV file then the file name needs to contain the word “blog post”, for example, “my-shopify-blog-posts.csv”
- If using XLSX file then the sheet/tab name in the file needs to be “blog post”. 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 Blog Posts. When creating new Blog Post, leave this value empty. Allowed ValuesNumber Example22920047631 |
Handle | This is what your store visitors will see in the Blog Post URL address like this:
https://mystore.com/blogs/blog-handle/blog-post-handle 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. Allowed ValuesAny characters allowed in a URL Examplered-tshirt-story |
Command | When importing Blog Post 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 Blog Post
Allowed ValuesText ExampleRed Tshirt Story
|
Author | The Author of the Blog Post
Allowed ValuesText ExampleJimmy Kimmel |
Body HTML | A long description of the Blog Post.
You can write here just a plain text or format that text using HTML code. You can put here additional images, videos, links to any other URLs: Blog Posts, Pages, Collections, Products 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 one Blog Post in the Shopify Admin, 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 Blog Posts. The app is also doing some helping with the descriptions automatically to make it easier to use and fix popular issues:
Allowed ValuesText, HTML ExampleHere goes the everything <b>you need to know</b> about <em>T-Shirts</em>.
|
Summary HTML | A short summary of your Blog Post.
This is shown in the list of all blog posts so that the reader can see the short snippet of the blog post text. It can be text or HTML code – the similarily to Body HTML. Allowed ValuesText, HTML ExampleT-shirts are for wearing. <b>That's it!</b> |
Tags | Tags allow you to add additional elements or “properties” to your Blog Post which you can use for filtering.
See this tutorial on how to bulk manage your Tags. Allowed ValuesComma Seperated List ExampleFunny, Smart, T-shirt |
Tags Command | Tell the app, what to do with Tags:
You can also have Tags listed in multiple rows within the item and with different Tags Commands. If Tags Command is not set, the app will assume the REPLACE command by default. See this tutorial on how to bulk manage your Tags. Allowed ValuesMERGE DELETE REPLACE Example |
Created At
Export only |
This column will only be exported.
It will be automatically set to the date and time when the Blog Post was first created. Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Updated At
Export only |
This column will only be exported.
It will be automatically updated, whenever you change the Blog Post data. Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Published | Tells, whether this Blog Post should be Published on your “Online Store”. 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 Blog Post form Online Store. Allowed ValuesTRUE FALSE ExampleTRUE
|
Published At | This column can be exported and imported.
You can set a specific Blog Post publication date at the current time or in the past. Published At cannot be set in future. Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Template Suffix | Template Suffix allows you to specify another Template from your Theme for this specific Blog Post. For example, you might want to specify a different template for a Women T-shirts Blogs, which has different page colors.
Allowed ValuesText Examplewomen
|
Image Src | Link to the image. This link must be publicly available so that Shopify can download the image to the store.
A Blog Post 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 Blog Post, 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. |
Image Height
Export only |
The height of the image, in pixels. |
Image Alt Text | Alt Text for the Blog Post image. Great for SEO, because then search engines will know, what is inside the image.
Allowed ValuesText ExampleWoman wearing red T-shirt on horse |
Blogs
You can have several Blogs on your store. Each Blog can have many Blog Posts.
Therefore – each Blog Post needs to be associated with the specific Blog.
Those columns will describe that Blog.
You only need to have values for Blog: ID and/or Blog: Handle columns in all rows – so that each Blog Post can be linked to the Blog.
Since each Blog Post is updated separately then if you don’t need to update Blog fields each time, you can leave those other columns empty.
Column | Description / Example Value |
---|---|
Blog: ID
Export only |
Unique identifier for the Blog.
When creating new Blog, leave this empty. This allows to identify the Blog and match it to the Blog Post of the same row. When importing data – if the existing Blog is not found by ID, then it is searched by the Handle. Allowed ValuesNumber Example22920047635 |
Blog: Handle | This is what your store visitors will see on the Blog or Blog Post URL address like this:
https://mystore.com/blogs/blog-handle/blog-post-handle Blog handle works by the same principle as Blog Post Handle. When importing – this handle is also used to identify the Blog if it cannot be found by Blog: ID. If Handle is left empty then it will be generated from the Blog: Title. Allowed ValuesAny characters allowed in a URL Exampletshirt-blog |
Blog: Title | Title of the Blog.
Required only when creating new Blog. Allowed ValuesText ExampleEverything About Tshirts
|
Blog: Commentable | Tells whether the Blog Posts allow comments from the blog visitors:
Allowed Valuesno yes moderate Exampleyes |
Blog: Feedburner URL | URL to the Feedburner / RSS / Atom service for pushing your blog changes to the platforms that notify subscribers about new posts.
If you don’t know what this is – leave it empty. Read more in the Shopify article: Advanced publishing. Allowed ValuesURL Examplehttp://feedproxy.google.com/ |
Blog: Feedburner Path | The subfolder (path) of the Feedburner URL.
If your Feedburner full URL is, for example, http://feedproxy.google.com/tshirt-blog then your path will be tshirt-blog. If you don’t know what this – leave it empty. Allowed ValuesURL path Exampletshirt-blog |
Blog: Template Suffix | Template Suffix allows you to specify another Template from your Theme for this specific Blog. For example, you might want to specify a different template for a T-shirts Blog than for the others.
Allowed ValuesText Exampletshirt
|
Blog: Created At
Export only |
It will be automatically set to the date and time when the Blog was first created.
Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Blog: Updated At
Export only |
It will be automatically updated, whenever you change the Blog data.
Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
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. |
Comments
Each Blog Post can have many Comments – written by the blog visitors.
Column | Description / Example Value |
---|---|
Comment: ID
Export only |
Unique identifier for the Blog Post Comment.
When creating new Comment, leave this empty. This allows to identify the Blog Post Comment and match it to the Blog and the Blog Post of the same row. When importing data – if the existing Blog is not found by ID, then the app will create new Comment. So be careful if you import the same comments two times with no valid ID then those will be added again and can result in duplicate comments. Allowed ValuesNumber Example22920047635 |
Comment: Author | Author of the Comment.
Allowed ValuesText ExampleJohn Smith |
Comment: Body | Comments written by blog post visitors cannot be written in HTML to format them. But Shopify allows using the Textile Markup to add basic formatting to the text.
Allowed ValuesText, Textile Markup ExampleThis is *my* text. |
Comment: Body HTML | The HTML representation of the comment body.
This column will only be exported and you cannot import the HTML comments here – Shopify will ignore them. Basically, this is used for showing those comments on the website. Allowed ValuesHTML Example<p>This is <strong>my</strong> text.</p> |
Comment: Email | E-mail address of the comment author.
Allowed ValuesEmail Address Example[email protected] |
Comment: Status | Status of the comment:
Allowed Valuespending unapproved published spam removed Example |
Comment: IP
Export only |
The IP address of the comment author at the moment of posting their comment.
Example159.148.34.56 |
Comment: Browser
Export only |
The browser – also known as “User Agent” of the website visitor at the moment of posting the comment. It allows determining the browser kind, version and even the operating system of the commenter.
ExampleMozilla/5.0 (Windows NT 6.1; Win64; x64; rv:47.0) Gecko/20100101 Firefox/47.0 |
Comment: Created At
Export only |
It will be automatically set to the date and time when the Comment was first created.
Example2018-12-17 18:20:07 +0200 |
Comment: Updated At
Export only |
It will be automatically updated, whenever you change the Comment data.
Example2018-12-17 18:20:07 +0200 |
Comment: Published At | The time when the blog post Comment was Published – made visible to the public.
You can set this time to what you need. Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Comment: Command | Tell the app what to do with the Comment row:
If no value is specified then the MERGE is assumed by default. Allowed ValuesMERGE UPDATE DELETE ExampleMERGE |
Metafields
You can add up to 250 custom metafields to the Blog Posts.
Just start the column name by “Metafield: “.
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 |
---|---|
ID | Allows you to list specific Blog Post IDs to export or not include in the export, separated by a comma.
Possible Conditions
Example12743246124,2346584351 |
Title | Allows you to export Blog Posts whose Title contains or does not contain specific text, separated by a comma.
“Matches pattern” condition allows entering wildcard symbols. Possible Conditions
ExamplePart of Title, other title, different title Title * End of Title |
Handle | Allows exporting Blog Posts filtering the export by Blog Post Handle, separated by a comma.
Possible Conditions
Examplemy-blog-post-handle, your-blog-post |
Created At | Allows exporting Blog Posts which were created in the Shopify within a specific date range.
Relative date condition allows you to export Blog Posts that have been created in the last full amount of time. For example – Last 1 Days, would export Blog Posts from last full day, so yesterday. Possible Conditions
|
Updated At | Allows exporting Blog Posts which were last updated in the Shopify within a specific date range.
Relative date condition allows you to export Blog Posts that have been updated in the last full amount of time. For example – Last 1 Days, would export Blog Posts from last full day, so yesterday. Possible Conditions
|
Published At | Allows exporting Blog Posts which were published in the Shopify within a specific date range.
Relative date condition allows you to export Blog Posts that have been published in the last full amount of time. For example – Last 1 Days, would export Blog Posts from last full day, so yesterday. Possible Conditions
|
Blog Handle | Allows exporting Blog Posts filtering the export by Blog Handle, separated by a comma.
Possible Conditions
Examplenews, first-blog |
Metafield | Filters the Orders export by Blog Post Metafields.
Specify Metafield by:
Possible Conditions for Text value
Possible Conditions for Number value
|
Good To Know
- The best way to understand what data goes into which column, create one Blog Post manually in Shopify Admin, and then export that.
- You don’t need to fill in all columns to create Blog, Blog Posts or Comments.