Skip to content

Data Import (CSV/ZIP)

Import menu data from a CSV or ZIP file, check it, and update only the fields you choose.

With Data Import, you can import a CSV file or a ZIP file with images. Typical use cases: prices changed in Excel, restoring a backup, or taking over a menu from another restaurant. Always use a file from the Data Export as a template.

Run import

Check data

Check data

Click ⋯ → Data Import in the menu header. Drag the file (.csv or .zip, up to 50 MB) into the field or click Choose file, then click Check data. Nothing is changed yet.

After reviewing, you will see each row with Typ, Name, and Modifikation: Aktualisieren for existing items, Erstellen for new ones. Check the rows you want to apply; at the top you have Alle, Keine, Nur Artikel, and Nur Varianten. Above that, you choose the field groups to apply: Grunddaten, Preise, Status, Rezept, Bilder, Varianten, and Zuordnungen. Everything else remains unchanged. Daten importieren writes the changes.

Rules

  • Matching is done via the ID in the file, not the name. Unknown IDs are created as new.

  • New items require the Basic data, Prices, and Assignments field groups as well as the category and both tax rates in the file.

  • An empty cell removes the information from the item, such as PLU or description, but only in the selected field groups. If a column is missing entirely, the information remains unchanged.

  • Nothing is deleted during the import.

  • Errors like missing columns or invalid values are shown by the check along with the row number. If an item refers to a category that does not exist here, a notice appears.

Before a large import, you should create a data export as a backup. If you are unsure, test with a few rows first.

Data Import (CSV/ZIP): Servire Handbook | Servire