See what each field/column from our “Pages” 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
Pages
To tell the app that you are importing Pages you need:
- If using CSV file then the file name needs to contain the word “page”, for example, “my-shopify-pages.csv”
- If using XLSX file then the sheet/tab name in the file needs to be “page”. 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 Pages. When creating new Page, leave this value empty. Allowed ValuesNumber Example44920047631 |
Handle | This is what your store visitors will see in the Pages URL address like this: https://mystore.com/pages/contact-us
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 Examplecontact-us |
Command | When importing Page 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 page.
Allowed ValuesText ExampleContact Us |
Author | The name of the author. Can assign any name.
Allowed ValuesText ExampleYour Name |
Body HTML | The page contents. It can be as plain text, and as HTML code.
The app is also doing some helping with the descriptions automatically to make it easier to use and fix popular issues:
Allowed ValuesText, HTML Example<h2>Subtitle</h> Contact us here. |
Created At
Export only |
It will show the date and time when the page was created.
Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Updated At
Export only |
It will be automatically updated, whenever you change the Page data.
Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Published | Tells, whether the Page should be published or no. TRUE means it will get published, FALSE means it will be invisible.
Allowed ValuesTRUE FALSE ExampleTRUE |
Published At | Can be imported and exported.
When exported, it shows the time, when the page was set visible. When importing, can set the time in the past, when it should be considered as published. Can just use Published to TRUE, without setting Published At date – then it will set published at date to current time. Allowed ValuesDate & Time Example2018-12-17 18:20:07 +0200 |
Template Suffix | Suffix of the page template to be used.
For example, contacts page template suffix is “contact”. You can create your own custom page templates and assign them to be used by setting the appropriate template suffix. If this is left empty, then the default Page template will be used. Allowed ValuesText Examplecontact |
Metafields
Read the description on Metafields page.
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 Page IDs to export or not include in the export, separated by a comma.
Possible Conditions
Example12311123423,2342342342 |
Title | Allows you to export Pages 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 Title * End of Title |
Created At | Allows exporting Pages which were created in the Shopify within a specific date range.
Relative date condition allows you to export Pages that have been created in the last full amount of time. For example – Last 1 Days, would export Pages from last full day, so yesterday. Possible Conditions
|
Updated At | Allows exporting Pages which were last updated in the Shopify within a specific date range.
Relative date condition allows you to export Pages that have been updated in the last full amount of time. For example – Last 1 Days, would export Pages from last full day, so yesterday. Possible Conditions
|
Published At | Allows exporting Pages which were published in the Shopify within a specific date range.
Relative date condition allows you to export Pages that have been published in the last full amount of time. For example – Last 1 Days, would export Pages from last full day, so yesterday. Possible Conditions
|
Metafield | Filters the Orders export by Page Metafields.
Specify Metafield by:
Possible Conditions for Text value
Possible Conditions for Number value
|
Good To Know
- 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.