Excel Sheet Name
In this export, as you see Pages in Shopify Admin – each page will be exported in one row.
All this data is exported and imported exactly as you see it in Admin.
Columns Available For Export And Import
|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 Page, leave this value empty.
|Handle||Any characters allowed in a URL||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.
|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.
|Title||Text||Title of the page.|
|Author||Text||The name of the author. Can assign any name.|
|Body HTML||Text, HTML||The page contents. It can be as plain text, and as HTML code.|
If you import plain text, it will be converted to HTML – with paragraphs and line breaks.
<h2>Subtitle</h> Contact us here.
|Created At||Time||This column will only be exported.|
It will show the date and time when the page was created.
2017-12-19 22:00:00 UTC
|Updated At||Time||This column will only be exported.|
It will be automatically updated, whenever you change the Page data.
2017-12-19 23:03:00 UTC
|Published||TRUE / FALSE||Tells, whether the Page should be published or no. TRUE means it will get published, FALSE means it will be invisible.|
|Published At||Time||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.
2016-02-01 00:03:00 UTC
|Template Suffix||Text||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.
Read the description on Metafields page.
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.