Importing and exporting
Add or update many dishes, choices, menus and extras at once from a spreadsheet, or download them in the same format to edit and import again. Nothing is saved until you have checked the preview.
To import from a spreadsheet
- Step 1: On a computer, click Import in the sidebar, then click Import (there is no Import on phones).
- Step 2: Click Download the template and fill in the sheets you need. Click a column heading in the spreadsheet to see what goes in it.
- Step 3: Choose your file and click Check. Every sheet in the file is read, so you upload it once.
- Step 4: Read the table: every row is OK or says in plain words what to fix.
- Step 5: Click Import to save the OK rows, or fix the sheet and choose it again. Click Download the rows to fix to get the rows with a problem as a CSV, with the reason beside each.
To export
- Step 1: Click Export in the section of the Library you want (Menus, Dishes, Choices or Extras) for that section's items.
- Step 2: Or on the Import page, click Export everything. It asks first, then downloads the venue you are in. In group view you choose one venue, or all of them, in that question.
- Step 3: Edit the file and import it again: items are matched by name.
To see past imports
- Step 1: Click Import in the sidebar and scroll to Import history under the import box.
- Step 2: Each line shows when, who, the file, the venue, what was added (for example 12 dishes, 3 menus), the problems and whether it finished.
- Step 3: Click the number under Problems to read what to fix in your sheet. Imports are listed for two years.
To import into another venue
- Step 1: Choose the venue in the venue switcher: an import always goes to the venue you are in, and the pop-up says which one.
- Step 2: Or choose All venues (group view), click Import in the sidebar, click Import and choose the venue, or Group items, under Import into.
- Step 3: In an export of all venues, each row's Venue column decides where it goes.
What things mean
- New
- Not in PreOrderly yet: it will be added.
- Updated
- Already in PreOrderly with this name, and something in the file is different.
- Unchanged
- Already in PreOrderly exactly as in the file: nothing to do.
- Problem
- A row has something we cannot read, such as a blank or unknown allergen. It is left out and nothing is guessed; the OK rows can still be imported.
Tips
- Items are matched by name and capitals do not matter. A name you already have is updated, a new one is added, and nothing is ever deleted.
- Imported menus are always saved as drafts. A published menu stays live, unchanged, until you publish the new draft.
- Every dish and choice needs its Allergens cell filled in. Write None if it has no allergens: a blank cell is flagged, never read as no allergens, and an allergen we do not recognise is flagged too.
- Name the specific cereal or nut in Allergens, such as Wheat or Almond, and use May contain for cross-contact. Always check imported allergens before you publish.
- Rows whose name starts with Example: are never imported, so you can leave the template's examples in.
- The template has about six columns on each sheet. Extra columns (May contain, Tag, Extra charge, menu settings and more) are optional: add one by typing its heading, as listed on the Start here sheet. Older templates still import.
- You can also import one CSV file per sheet, with the template's column headings.
- An import never archives or restores anything: archive and restore items in PreOrderly. An Archived column in an older file is ignored.
Still need help?
Email us with what you were doing and what you saw. A person replies within one working day. Guests and hosts: for questions about a booking, please contact the venue first.
Contact supportsupport@preorderly.appSomething not loading? Check the system status.