Vendion
    Marketing

    Moving your guests to Vendion

    6 min read
    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

    1. 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).
    2. Choose your file with Välj fil (Choose file), or click Ladda ner mall (Download template) first if you are building the list yourself.
    3. 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.
    4. Check that each column has the right field under Matcha kolumnerna (Match the columns) and click Prova (Try).
    5. 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:

    FieldGood to know
    Name, First name, Last nameAt most 200 characters for the name
    Phone, EmailAt least one of them is required
    BirthdayCan be used by a birthday automation
    Note, TagsAt most 2,000 characters for the note and 50 for a tag
    Visits, No-shows, Cancellations, Total spent (kr), First visit, Last visitThe figures from your previous system
    SMS consent, Email consent, Consent dateSee 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?