Moving your guests to Vendion
Categories and articles
If you have guests in another booking system, POS or spreadsheet, you can read them into the guest registry. The import takes a CSV file with one guest per row.
Step by step
- Go to Marknadsföring → Gäster → Register (Marketing → Guests → Register) and click Importera (Import). The button is shown to those with the permission Redigera gäster (Edit guests).
- Choose your file with Välj fil (Choose file), or click Ladda ner mall (Download template) first if you are building the list yourself.
- Fill in Varifrån kommer gästerna (Where do the guests come from), for example the name of your previous system. It is shown in the import history.
- Check that each column has the right field under Matcha kolumnerna (Match the columns) and click Prova (Try).
- Read the trial run, decide on consent (see below) and click Importera N gäster (Import N guests).
The template and the file
Ladda ner mall gives you the file gaster-mall.csv with all the columns and an invented example row: Anna Andersson, 070-123 45 67, anna.andersson@example.com. It opens in Excel. Write your guests below the example row or replace it. If the example row is left unchanged, Vendion skips it and says so in the dialog.
- The first row must be headings, then one guest per row.
- The file must be CSV (semicolon, comma or tab). If you have an Excel file: save it as CSV first.
- Every guest needs a phone number or an email.
- An email address that cannot be sent to, for example one without @ or without a domain, means the row is not imported. Correct the address (name@example.com) or remove it, and the guest comes along.
- Write dates as 2024-05-03 or 03/05/2024, amounts in kronor as 1 250,50, and consent as ja or nej (yes/no; x and 1 count as yes, 0 as no). An empty consent cell means the file says nothing about that guest.
- Separate several tags in one cell with a comma or a vertical bar, for example Regular|Vegetarian. A tag that does not exist is created.
Match the columns
Vendion guesses the field from the headings, for example Mobile or Phone as Telefon (Phone) and Newsletter as Samtycke e-post (Email consent). Change it with the list next to each column, or choose Hoppa över (Skip) for a column that should not be included. The fields are:
| Field | Good to know |
|---|---|
| Name, First name, Last name | At most 200 characters for the name |
| Phone, Email | At least one of them is required |
| Birthday | Can be used by a birthday automation |
| Note, Tags | At most 2,000 characters for the note and 50 for a tag |
| Visits, No-shows, Cancellations, Total spent (kr), First visit, Last visit | The figures from your previous system |
| SMS consent, Email consent, Consent date | See Consent to marketing below |
The figures from your previous system stay in the guest profile, and visits and purchases in Vendion are added on top.
The trial run saves nothing
Prova runs the import without saving and shows how many guests will be new, how many already exist and how many rows have errors. Under Rader som inte importeras (Rows that will not be imported) you see the row number in the file (the heading row is row 1) and what is wrong, for example that the row has neither phone nor email, or that the same guest appears earlier in the file. Fix the file and start again, or import without those rows.
Guests who already exist
A guest with the same phone number (or the same email, when there is no phone) counts as the same guest. That guest only gets the missing details filled in, for example email or birthday, plus the tags from the file. The name and anything else already in Vendion is not overwritten, and the guest's consent is never changed.
No texts or emails are sent
The import sends nothing to the guests, not even automations that start when a guest gets a tag.
Consent to marketing
An imported guest only receives offers if you say so. You can do that in two ways:
- The file has the columns Samtycke sms or Samtycke e-post with yes for the guest.
- You tick Ge alla nya gäster samtycke till sms or Ge alla nya gäster samtycke till e-post (Give all new guests consent to SMS / email). This only applies to guests who become new and whose consent column is empty or missing. A guest with no in the file stays no.
Two things are then required before you can import:
- Underlag för samtycket (Basis for the consent): where and how the guests consented, for example "The booking form on our website with a newsletter box the guest ticked themselves". At least 20 characters. The basis is saved with the import.
- The checkbox Restaurangen kan visa att gästerna har samtyckt (The restaurant can show that the guests have consented).
The restaurant is responsible for the consent and must be able to show it if a guest or an authority asks. Only tick it when you know the guests themselves said yes to offers from you. If you are unsure: import without consent and let the guests answer the offer question the next time they book or order. A guest who has previously unsubscribed from messages gets no consent from the import. Read GDPR and consent.
When the import is done
You see how many guests became new, how many already existed and how many got consent to SMS and email. Large files are imported in batches, and the dialog shows how many are done.
Undo an import
Under Tidigare importer (Previous imports) in the same dialog, each import is listed with source, date and count. Click Ångra (Undo) to first see how many guests will be removed and how many will stay, then Ångra importen (Undo the import).
Undoing only removes guests that the import created. It does not remove:
- guests who existed before the import, nor the details and tags the import filled in for them,
- guests who have since booked, bought something or had more visits,
- guests with other activity, for example a message, loyalty or a gift card,
- tags the import created (they stay among your tags).
An import can only be undone once.
AI Boss
You can also ask AI Boss to import a list of guests. AI Boss tries it first, shows the same figures and asks before anything is saved. Consent is only set if you yourself say where the guests consented.
This feature is part of Vendion Marketing.
Curious how it looks in practice? Read more about the product or book a short demo.
Was this article helpful?
Related articles
Adding a guest manually
Add a guest with Ny Gäst under Marknadsföring → Gäster → Register. Name is required, the box for offers follows the offer question you chose, and if the number or email already exists the existing guest is updated.
GDPR, consent and unsubscribing
Choose how guests are asked about offers: Yes box, No box or No question. How the offer question, the messaging choices and unsubscribing work, and what the Swedish Marketing Act says about advertising by SMS and email.
How guests end up in the guest registry
Guests enter the registry when a paid bill has a phone number or a linked guest, when someone books, when a guest leaves their number in an online order or QR payment, or when you add them by hand. An SMS receipt does not create a guest.
