Install
Install
Documentation

Menus

Menus

Bulk import, export, update and manage Shopify navigation Menus and Menu Items using the Matrixify app.

See what each field/column from our “Menus” 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

Menus

When importing a file, to tell the app that you are importing Menus, you need to ensure that the sheet/tab name is set to “Menu” or “Menus”.

For example:

  • If using a CSV file then the file name can be “my-shopify-menus.csv”
  • If using an XLSX file then the sheet/tab name would be set to “Menus”. The file name for the XLSX file does not matter.

Even if the sheet/tab name is not set correctly, you will be able to manually change and set the entity you are importing after uploading file in the app.

See more on the Matrixify app import process and import user interface.

Need a quick start?

Download Menus Demo file
See Tutorials about Menus

Columns Available For Export And Import

Basic Columns

Column Description / Example Value
ID The ID is a Shopify automatically-generated internal ID number to identify the navigation menu.

Can be used for Import to identify and update existing Menus.
When importing new Menus, leave this column empty.

Allowed Values

Number

Example
2927034435
Handle The unique handle of the Menu.

Can be used for identification when importing.

Allowed Values

Text

Example
main-menu
Command When importing a Menu row – tell the app, what to do with it:

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

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

Allowed Values
NEW
MERGE
UPDATE
REPLACE
DELETE
Example
MERGE
Title

The navigation menu’s title.

Can be used for identification when importing.

The Title is a mandatory field when creating a new Navigation menu.

Allowed Values

Text

Example
Main menu
Is Default

Export only

Whether the menu is a default. The handle for default menus can’t be updated and default menus can’t be deleted.

Possible Values
TRUE
FALSE
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.
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.

Menu Items

Column Description / Example Value
Menu Item: ID A globally-unique ID of the online store navigation menu item.

Cannot be set or changed and is issued by Shopify when the many item is created in the store.

When creating new Menu Items, value from this field can be used in Menu Item: Parent ID column to link the menu item with the correct parent, for example, if you have multiple menu items with the same Menu Item Title.
The ID will not be saved in Shopify and cannot be used for parent relations when updating existing Menu Items as Shopify will assign its own Menu Item IDs after they are created within the Menu.

Allowed Values

Number

Example
2927034435
Menu Item: Title The menu item’s title.

Mandatory when adding new menu items to a Menu.

Can be used to identify existing menu items when importing.

Allowed Values

Text

Example
Summer collection
Menu Item: Command Tells the app how to process and what to do with a menu item in the row.

  • MERGE – will try to find the existing Menu Item within the Menu by Menu Item: ID and Menu Item: Title, and update it. If such a Menu Item will not be found, then will try to create a new Menu.
  • DELETE – the app will delete the existing Menu Item, which is found by Menu Item: ID and Menu Item: Title. If such a Menu Item is not found within the Menu, then the result will be Failed. This DELETE command is very handy for deleting Menu Items from Menus in bulk.

If no menu item command is specified in the import file, the app will assume value MERGE for it by default.

Allowed Values
MERGE
DELETE
Example
MERGE
Menu Item: Resource Type Navigation Menu Items type.

Indicates to what type of entity the menu item is linked to.
Mandatory when importing/adding new menu items.

Allowed Values
  • ARTICLE – linked to a Blog Post.
  • BLOG – linked to a Blog.
  • CATALOG – linked to “All Products”.
  • COLLECTION – linked to a specific collection.
  • COLLECTIONS – linked to “All Collections”.
  • CUSTOMER_ACCOUNT_PAGE – linked to front-end Orders, Profile, and Settings pages for the customer.
  • FRONTPAGE – linked to the Online Store “Home” page.
  • HTTP – linked to a custom URL.
  • METAOBJECT – linked to a Metaobject entry.
  • PAGE – linked to store page from Online Store -> Pages section.
  • PRODUCT – linked to specific Product.
  • SEARCH – linked to Search.
  • SHOP_POLICY – linked to specific online stores policy.
Example
COLLECTION
Menu Item: Resource ID The resource ID to which the menu item is linked to.

Can be used to assign a resource to the menu item when importing new menu items.
If you do not have resource IDs available when importing menu items, you can leave this column blank and use Menu Item: Resource Handle to assign a resource to the menu item.

Empty if Menu Item: Resource Type is CATALOG, COLLECTIONS, FRONTPAGE, SEARCH or HTTP.

Allowed Values

Number

Example
2927034435
Menu Item: Resource Handle Unique identification Handle for resource to which the menu item is linked to.

Can be used to assign a resource to the menu item when importing new menu items.

Allowed Values

This column has different value depending on the Menu Item: Resource Type to which the menu item is linked to:

  • ARTICLE – value in a template “blog_handle.blog_post_handle”, for example, “style-guides.summer-style-post”.
  • BLOG – blog handle.
  • CATALOG – empty value as the menu item is linked to “All Products”.
  • COLLECTION – collections handle, for example, “summer-jeans”.
  • COLLECTIONS – empty value as the menu item is linked to “All Collections”.
  • CUSTOMER_ACCOUNT_PAGE – possible values:
    • orders
    • profile
    • settings
  • FRONTPAGE – empty value as the menu item is linked to the online stores “Home” page.
  • HTTP – empty value, the custom URL is set with Menu Item: URL column.
  • METAOBJECT – value in a template “metaobject.entry”, for example, “manufacturer.Robert-Jones”.
  • PAGE – online stores page handle.
  • PRODUCT – product Handle.
  • SEARCH – empty value as the menu item is linked to the online stores “Search” page.
  • SHOP_POLICY – shop policies handle. The policy must be set in the store with a value to be able to assign it to the menu item. Possible values:
    • CONTACT_INFORMATION
    • LEGAL_NOTICE
    • PRIVACY_POLICY
    • REFUND_POLICY
    • SHIPPING_POLICY
    • SUBSCRIPTION_POLICY
    • TERMS_OF_SALE
    • TERMS_OF_SERVICE
Example
summer-jeans
Menu Item: Collection Tags If menu item is linked to a specific collection, with this field Shopify allows to assign tags by which the collection is filtered.

Only can be imported if Menu Item: Resource Type is COLLECTION.

Allowed Values

Comma-separated list of tags

Example
summer, winter
Menu Item: URL Relative URL path to the menu item.

Exported for all menu items.

Can be imported/set only for Menu Items with Menu Item: Resource Type set to HTTP.

Allowed Values

Text

Example
https://matrixify.app
Menu Item: Parent ID Menu Items parent ID indicating to which other menu item this menu item is linked to. Matches the value from Menu Item: ID.
Used to export/import navigation menu item hierarchy.If the menu item is on the first layer and not under any other menu items, then the value is empty.

Allowed Values

Number

Example
447216123971
Menu Item: Parent Title Menu Items parent Title indicating to which other menu item this menu item is linked.
Used to export/import navigation menu item hierarchy.If the menu item is on the first layer and not under any other menu items, then the value is empty.When creating new Menu Items, if you will have multiple Menu Items with the same Menu Item: Title, then the app will not able to know which Menu Item to use as the parent.
In such a case, in the parent menu item use Menu Item: ID column with any number which then can be used in Menu Item: Parent ID to link correct Menu Item as the parent.

Allowed Values

Text

Example
Seasons
Menu Item: Position Position of the menu item within its parent menu item.

Allowed Values

Number

Example
1

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 Menu IDs to include or not include in the export, separated by a comma.

Possible Conditions
  • equals to any of
  • not equal to any of
Example
12743246124,2346584351
Title Allows you to export Menus whose Title contains specific text.

“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
Examples
Part of Title, other title
Title * End of Title

Start managing your Shopify data today!

Install
Excelify Facebook channel Excelify Twitter channel Excelify Youtube channel
Newsletter
Thank you for subscribing!
© 2025 Matrixify.app
Made in Latvia Latvia