Start Free Trial
Start Free Trial
Documentation

Pages

Pages

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?

Download Pages Demo file

See Tutorials about Pages

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 Values

Number

Example
44920047631
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.
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 Pages – in that case, the app will generate it for you from Title.

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 Values

Any characters allowed in a URL

Example
contact-us
Command When importing Page row – tell the app, what to do with it:

  • NEW: will try to create a new Page with the provided details. If such Page will already exist (with the same ID or same Handle), then the result will be Failed.
  • MERGE: will try to find existing Page, and update it with data from the row. If such Page will not be found, then it will create new.
  • UPDATE: the app will search for an existing Page and update it. If an item cannot be found then that item will fail to import.
  • REPLACE: WARNING! Use this Command value to fully replace the whole page, not individual fields. Using this Command value, the app will delete the page from the store completely and create a new one only from data in the file, resulting in losing all data that is not included in the import file.
    If such Page with provided ID or Handle exists, then the app will delete it. After that, it will create a new one. If an existing Page 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 Page will be deleted and re-created.
  • DELETE: the app will delete the existing Page, which is found by ID or Handle. If such Page will not be found, then the result will be Failed. This DELETE command is very handy for deleting Pages in bulk.
  • IGNORE: the app will ignore this Page and will skip it.

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

Allowed Values
NEW
MERGE
UPDATE
REPLACE
DELETE
IGNORE
Example
MERGE
Title Title of the page.

Allowed Values

Text

Example
Contact Us
Author The name of the author. Can assign any name.

Allowed Values

Text

Example
Your 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:

  • Converting text to UTF-8 encoding.
  • Automatically removing invalid characters like “_x000D_” , “” , and such (ask Matrixify Support if there are any other characters invalid that need to be removed).
  • Converting plain text to HTML if this is not an HTML already – so that you have proper newlines and basic formatting.
  • Optionally removing images from HTML (if checkbox enabled in Import Options).
Allowed Values

Text, 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 Values

Date & Time

Example
2018-12-17 18:20:07 +0200
Updated At

Export only

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

Allowed Values

Date & Time

Example
2018-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 Values
TRUE
FALSE
Example
TRUE
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 Values

Date & Time

Example
2018-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 Values

Text

Example
contact

 

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
  • equals to any of
  • not equal to any of
Example
12311123423,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.
* – asterisk symbol will represent any amount of any characters
? – question mark will represent any one character

Possible Conditions
  • contains any of
  • equals to any of
  • matches pattern
  • contains none of
Example
Part 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
  • on or after
  • on or before
  • date range
  • relative date
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
  • on or after
  • on or before
  • date range
  • relative date
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
  • on or after
  • on or before
  • date range
  • relative date
Metafield Filters the Orders export by Page Metafields.

Specify Metafield by:

  • Namespace
  • Key
  • Value
Possible Conditions for Text value
  • equals to any of
  • not equal to any of
  • contains any of
  • contains all of
  • contains none of
  • matches pattern
  • contains
  • does not contain
  • is empty
  • is not empty
Possible Conditions for Number value
  • equals
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to
  • between
  • is empty
  • is not empty

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.

 

Start managing your Shopify data today!

Get Matrixify now
Excelify Facebook channel Excelify Twitter channel Excelify Youtube channel
Newsletter
Thank you for subscribing!
© 2023 Matrixify.app
Made in Latvia Latvia