Exporting Your Menu as CSV

  1. Log in to your Shopify store and navigate to the Menuf.ai app.
  2. Select the menus you want to export.
  3. Click on the "Export" button.
  4. Select "CSV" as the export format.
  5. Click "Export" to download the CSV file.

 

Understanding the CSV Structure

The CSV file contains the following columns:

  1. Menu Handle: The unique identifier for the menu (can be modified).
  2. Menu Title: The name of the menu (can be modified).
  3. Menu ID: The system-generated ID for the menu (do not modify).
  4. Parent Menu: The ID of the parent menu for nested items (do not modify unless restructuring).
  5. Parent Item: The ID of the parent item for nested items (do not modify unless restructuring).
  6. MenuItem ID: The system-generated ID for the menu item (can be modified).
  7. MenuItem Title: The name of the menu item (can be modified).
  8. MenuItem Type: The type of the menu item (can be modified, see valid types below).
  9. MenuItem Resource ID: The ID of the linked resource, if applicable (can be modified).
  10. MenuItem URL: The URL for the menu item (can be modified).
  11. MenuItem Tags: Any tags associated with the menu item (can be modified).

 

Modifying the CSV File

When modifying the CSV file:

  • Use a spreadsheet application like Microsoft Excel or Google Sheets.
  • Do not change the order of the columns.
  • Do not remove any columns, even if they're empty.
  • Be careful when modifying IDs or parent relationships, as this can break the menu structure.

Fields You Can Safely Modify

  • Menu Handle
  • Menu Title
  • Is Default
  • MenuItem Title
  • MenuItem Type
  • MenuItem Resource ID
  • MenuItem URL
  • MenuItem Tags

Fields to Modify with Caution

  • Parent Menu
  • Parent Item
  • MenuItem Resource ID

Fields You Should Typically Not Modify

  • Menu ID
  • MenuItem ID
  • Parent Menu
  • Parent Item

Valid MenuItem Types

  • FRONTPAGE
  • CATALOG
  • PAGE
  • COLLECTION
  • BLOG
  • ARTICLE
  • SEARCH
  • HTTP (for external links)

Best Practices for CSV Modification

  1. Always keep a backup of the original CSV file.
  2. Make changes incrementally and test after each significant modification.
  3. Use consistent formatting for URLs and tags.
  4. When adding new items, leave the MenuItem ID field blank.
  5. To create nested items, ensure the Parent Item field is correctly set.

 

Importing the Modified CSV

  1. Log in to your Shopify store and navigate to the Menuf.ai app.
  2. Click on the "Import" button.
  3. Choose your modified CSV file.
  4. Select whether to use the "Automatically link menu items" option.
  5. Click "Import" to upload and process your file.

 

Common Pitfalls to Avoid

  1. Changing system-generated IDs, which can break menu relationships.
  2. Inconsistent use of quotation marks in text fields.
  3. Using invalid MenuItem Types.
  4. Forgetting to set the Parent Item for nested menu items.

 

Troubleshooting

If you encounter issues during import:

  1. Check for any error messages and address them specifically.
  2. Verify that all required fields are filled.
  3. Ensure all MenuItem Types are valid.
  4. Double-check the Parent Menu and Parent Item relationships.
  5. If problems persist, try re-exporting the original menu and making changes incrementally.

Still getting unexpected results even though you're sure your file is correct? Don't worry! Our support team is here to help. We'd love to take a look and assist you further.

The CSV feature in Menuf.ai provides a powerful way to manage and modify your menu structures. By following these guidelines, you can effectively use this feature to make bulk changes to your menus while maintaining their integrity.