Shopify Page Import and Export

Excel Sheet Name

Pages

Summary

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.

44920047631
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.
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.

Even if the handle will be in the non-English language, it will transliterate it to English, so that it is valid for URL. For example “о нас” will be converted to “o-nas”.

Whatever you will put in the Handle column, the app will convert it to required Handle format, which is acceptable by Shopify.

contact-us
Command
  • NEW
  • UPDATE
  • REPLACE
  • DELETE
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.
  • UPDATE: 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.
  • REPLACE: at first, 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.

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

UPDATE
Title Text Title of the page.

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

Your Name
Body HTML Text, HTML The page contents. It can be as plain text, and as HTML code.

<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.

TRUE
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.

contact

 

Metafields

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.