Skip to main content
A spreadsheet import builds a store’s categories and products in one go, so you don’t type a long menu into the dashboard by hand. You can also import into an existing menu to add products or update the ones already there. It covers products only — modifiers and modifier groups are added afterwards in the menu builder. There are two ways in:
  • A store with no menu: start from the store card, as in the steps below.
  • An existing menu: go to Menus, click Edit on the menu, open More actions (the menu builder’s overflow button) and click Import. The same Menu import uploader opens. See Updating an existing menu.

Importing a Menu

1

Download a template

Go to Stores, click Create a menu on the store card, then Spreadsheet Import. On the Import from a spreadsheet page, click Download Excel file or Download CSV file.
2

Fill in your products

One row per product, using the columns in the table below. Keep category names spelled consistently — categories are matched by name, so “Starters” and “Starter” create two categories.
3

Upload the file

Click Import on the same page and choose your file. A file is required; you cannot type rows in by hand.
4

Match your columns

The uploader — headed Menu import — asks you to match each column in your file to a storekit field, then shows your rows so you can fix anything it flags as invalid. This part of the screen comes from our import tool, so its buttons are its own.
5

Finish the import

Submit the reviewed rows. storekit creates a menu called CSV Import Menu for that store and opens it in the menu builder. Rename it from Settings → Name if you want something else.

Updating an Existing Menu

When you import into a menu that already has products, each row is matched to an existing product in that menu, in this order:
  1. Product ID — the storekit product ID, as it appears in the menu’s Export CSV
  2. Product PLU / SKU
  3. Product Name within the same category
A matched product is updated rather than duplicated, and only the columns present in your file are changed, so a file with just Product Name, Category Name and Product Price updates prices and leaves everything else alone. A row with no match creates a new product. If a matched product’s Category Name is different, it is moved to that category. The import never deletes anything: products and categories that aren’t in your file stay as they are.

Columns You Can Import

That list is the whole import. There is no column for modifiers or modifier groups, and on accounts using the newer tax setup there is no tax column either.

Allergen Tags

The allergen list is fixed. Allergens and May contain allergens accept only these values: Celery, Gluten, Crustaceans, Fish, Eggs, Lupin, Milk, Molluscs, Mustard, Nuts, Peanuts, Sesame, Soya, Sulphites, Almonds, Barley, Brazil Nuts, Cashew, Hazelnuts, Kamut, Macadamia, Oats, Pecan, Pistachio, Rye, Spelt, Walnuts, Wheat, Sugared Drink, Dairy, Lentils, Queensland Nuts, Shellfish, Treenuts, Sources of gluten.

Dietary Tags

Dietary tags accepts only these values: Alcohol, Halal, Kosher, Vegan, Vegetarian, Tobacco, E-cigarette, Vapes, Smokeless tobacco, No allergens, Gluten Free, Sugar Free, Lactose Free.

Modifiers Cannot Be Imported

Modifiers and modifier groups can’t be imported from a spreadsheet. The import takes one file of products — a second file of modifiers cannot be uploaded, and there is no modifier column to map. Add them after the import.
After the products land:
  • Add modifier groups per product from Menus → Edit → the product → Modifiers. Groups are shared, so build a group once and attach it to other products with Use an existing group — see Modifiers.
  • Set Tax Rate on each product in the product panel if your file had no Tax Rate % column — see Products.
  • To edit many products at once, export the menu with Export CSV, change the product rows and import the file back into the same menu. Some accounts also have Grid View under More actions.
The menu Export CSV does produce a separate Modifiers_ file, but it is for reviewing your modifiers in a spreadsheet — it cannot be imported back in. See Seeing All Your Modifier Groups.

Troubleshooting

A row is only matched to an existing product by Product ID, Product PLU / SKU or, failing those, the same Product Name in the same category. Include the Product ID column from Export CSV to update products reliably, and delete the duplicates in the menu builder.
Prices must be numbers, so strip currency symbols and thousands separators. Product Inventory Count and Product sorting must be whole numbers. Allergen and dietary values must match the fixed lists above exactly, comma-separated, with nothing extra in the cell.
Header names don’t have to match ours — you map each column to a storekit field during the import. Give every column a single header row, and check that Category Name, Product Name and Product Price are all mapped before continuing.
Categories are created from Category Name as written. Fix the spelling in your file and import it again into the same menu with the Product ID column included: matched products move to the category named in the file. The misspelt category stays, so delete it in the menu builder once it’s empty.

Managing Menus

Replace, archive and un-archive a store’s menu

Products

Prices, images, tax rates and product details

Modifiers

Add modifier groups after importing

Tags & Allergens

How allergen and dietary tags appear to customers