Stempla

For businesses

Data export and switching provider

Last updated: 16 November 2026

In short: You can leave Stempla at any time and take your data with you free of charge, as JSON and CSV files with your images. You can get the export without terminating, too. Switching, export and deletion are free.

1. Switching in brief

The binding text is the annex “Switching provider and data export” to the business terms. It implements Chapter VI of Regulation (EU) 2023/2854 (“Data Act”).

2. Data formats

This section is our register of data structures and data formats. It describes format “stempla-business-export”, version 1.

Structure of the ZIP file

You receive a file stempla-betriebsexport-<business>-<date>.zip with this content:

Open interface

Rules for all sections

Types

uuid
ID in the format 8-4-4-4-12 (e.g. 3f2b…)
text
string
integer
whole number
number
decimal number
boolean
true or false
date
date YYYY-MM-DD
time
time hh:mm:ss
timestamp
point in time, ISO 8601 with time zone
json
nested value; in the CSV as JSON text

Sections and fields

One part per section in data. “List” means one entry per row, also as CSV. “Object” means only in export.json.

business object Business profile
Field Type Meaning
id uuid Business ID
name text Business name
slug text Address of the business page on stempla.at (/en/businesses/<slug>/)
category text Category
logo_url text Logo address (file also in bilder/)
address text Address
city text City
zip text Postcode
country text Country
phone text Phone
email text Business email
website text Website
opening_hours json Opening hours (older field; locations are authoritative)
latitude number Latitude
longitude number Longitude
about_de text “About us” (German)
about_en text “About us” (English)
cover_image_url text Cover image address (file also in bilder/)
google_review_url text Link to Google review
feedback_enabled boolean Post-visit feedback enabled
welcome_stamp_enabled boolean Welcome bonus (stamps) enabled
welcome_stamp_card_id uuid Card for the welcome bonus (older field)
welcome_stamp_count integer Welcome bonus stamps
welcome_reward_config json Welcome reward: enabled, text DE/EN, validity in days
birthday_campaign_config json Birthday campaign settings
qr_template_config json Custom texts for promotional material
is_listed boolean Listed in the directory
is_coming_soon boolean Listed as “coming soon”
coming_soon_until timestamp Planned start while “coming soon”
onboarding_done boolean Setup completed
trial_start timestamp Trial start
trial_end timestamp Trial end
group_id uuid Group or network (→ group.id), otherwise empty
is_group_home boolean The group’s or network’s own account
created_at timestamp Created at
updated_at timestamp Last changed at
locations list, also CSV Locations
Field Type Meaning
id uuid Location ID
business_id uuid Business
name text Location name
kind text fixed = fixed location, mobile = on the road with dates
address text Address
city text City
zip text Postcode
country text Country
latitude number Latitude
longitude number Longitude
phone text Phone
email text Email
website text Website
is_primary boolean Main location
is_active boolean Active
sort_order integer Sort order
hours_mode text fixed = fixed hours, appointment = by appointment, both = both
hours_program boolean Opening hours according to programme
opening_hours json Weekly opening hours
opening_hours_base json Standard weekly hours while a season has its own hours
holiday_rule text Public holidays: closed, custom = own hours, as_weekday = like the weekday
holiday_hours json Hours on public holidays (custom only)
hours_note_de text Note on opening hours (German)
hours_note_en text Note on opening hours (English)
timezone text Time zone (Europe/Vienna)
google_review_url text Link to the location’s Google review
created_at timestamp Created at
updated_at timestamp Last changed at
location_seasons list, also CSV Seasons per location
Field Type Meaning
id uuid Season ID
location_id uuid Location (→ locations.id)
name_de text Name (German)
name_en text Name (English)
starts_on date Start
ends_on date End
repeats_yearly boolean Repeats every year
opening_hours json Weekly hours of the season
sort_order integer Sort order
created_at timestamp Created at
updated_at timestamp Last changed at
location_closures list, also CSV Closing days and season breaks
Field Type Meaning
id uuid Entry ID
location_id uuid Location (→ locations.id)
kind text closure = entered by the business, season = season break
starts_on date First day
ends_on date Last day
is_closed boolean Fully closed (otherwise changed hours)
hours json Changed hours
note_de text Note (German)
note_en text Note (English)
repeats_yearly boolean Repeats every year
closure_group_id uuid Same ID = one entry for several locations
created_at timestamp Created at
updated_at timestamp Last changed at
location_dates list, also CSV Dates of locations on the road
Field Type Meaning
id uuid Date ID
location_id uuid Location (→ locations.id)
title_de text Title (German)
title_en text Title (English)
address text Address
zip text Postcode
city text City
country text Country
latitude number Latitude
longitude number Longitude
starts_on date First day
ends_on date Last day
opens_at time Opening time
closes_at time Closing time
day_hours json Different hours per day
note_de text Note (German)
note_en text Note (English)
link text Link to the date
preview_days integer Days shown in advance as “coming here soon”
cancelled_at timestamp Cancelled at (empty = not cancelled)
series_id uuid Same ID = same series
created_at timestamp Created at
updated_at timestamp Last changed at
stamp_cards list, also CSV Stamp cards
Field Type Meaning
id uuid Card ID
business_id uuid Business
name text Card name
description text Description
stamps_required integer Stamps needed for the reward
reward_description text Reward (older field)
reward_description_de text Reward (German)
reward_description_en text Reward (English)
reward_expires_days integer Reward validity in days
conditions_de text Conditions (German)
conditions_en text Conditions (English)
stamp_rule_type text Stamp rule: visit, amount, product or custom
stamp_rule_amount number Amount in euros per stamp (amount only)
stamp_rule_text_de text Stamp rule text (German)
stamp_rule_text_en text Stamp rule text (English)
min_stamp_interval text Minimum interval: off, 1h, 2h, 4h or visit_day
color text Colour
icon text Icon
background_image_url text Card image address (file also in bilder/)
is_active boolean Active
sort_order integer Sort order
created_at timestamp Created at
updated_at timestamp Last changed at
settings object Settings (three sub-objects)
Field Type Meaning
notifications.notify_inactivity boolean Reminder to guests who have not visited for a while
notifications.notify_reactivation boolean Message on return
notifications.inactivity_days integer Days until the reminder
notifications.created_at timestamp Created at
notifications.updated_at timestamp Last changed at
misuse_protection.enabled boolean Misuse protection enabled
misuse_protection.updated_at timestamp Last changed at
hazel_data_access.enabled boolean Hazel may read your own figures
hazel_data_access.decided_at timestamp Decided at
team list, also CSV Team, without email addresses
Field Type Meaning
team_id uuid Team member ID within the business (not an account ID)
name text Display name
role text owner, manager or employee
active boolean Active
joined_at timestamp Joined at
deactivated_at timestamp Deactivated at
location_ids json Assigned locations (list of locations.id)
team_notices list, also CSV Notices shown to the team, with time shown (record)
Field Type Meaning
team_id uuid Team member (→ team.team_id)
notice_key text Notice ID
role text Role at that time
shown_at timestamp Shown at
app_version text App version
guest_cards list, also CSV Card status per guest and card
Field Type Meaning
guest text Guest ID, valid only within this export (12 characters); empty for birthday gifts and automatically awarded stamps
stamp_card_id uuid Stamp card (→ stamp_cards.id)
current_stamps integer Current stamps
completed_at timestamp Last completed at
created_at timestamp Card started at
stamps list, also CSV Stamp history, including this business’s stamps on group or network cards
Field Type Meaning
stamped_at timestamp Time
guest text Guest ID, valid only within this export (12 characters); empty for birthday gifts and automatically awarded stamps
stamp_card_id uuid Stamp card (→ stamp_cards.id)
location_id uuid Location (→ locations.id)
date_id uuid Date on the road (→ location_dates.id)
team_id uuid Team member (→ team.team_id); empty for system stamps (e.g. welcome, birthday) and for stamps of other businesses
team_name text Team member’s name at that time; empty like team_id
stamp_transfers list, also CSV Transferred paper cards
Field Type Meaning
created_at timestamp Time
guest text Guest ID, valid only within this export (12 characters); empty for birthday gifts and automatically awarded stamps
stamp_card_id uuid Stamp card (→ stamp_cards.id)
stamp_count integer Stamps transferred
location_id uuid Location (→ locations.id)
team_id uuid Team member (→ team.team_id); empty if another business made the transfer
rewards list, also CSV Rewards including redemption
Field Type Meaning
reward_id uuid Reward ID
guest text Guest ID, valid only within this export (12 characters); empty for birthday gifts and automatically awarded stamps
stamp_card_id uuid Stamp card (→ stamp_cards.id)
source text Origin: stamp_card (full card), birthday or welcome (welcome reward)
status text pending, redeemed or expired
description_de text Reward (German)
description_en text Reward (English)
earned_at timestamp Earned at
valid_from date Redeemable from (empty = immediately)
expires_at timestamp Valid until
redeemed_at timestamp Redeemed at
redeemed_location_id uuid Location of redemption
redeemed_team_id uuid Team member who redeemed (→ team.team_id); empty if another business redeemed it
redeemed_by_business boolean Redeemed at this business
welcome_bonuses list, also CSV Redeemed welcome bonuses
Field Type Meaning
redeemed_at timestamp Time
guest text Guest ID, valid only within this export (12 characters); empty for birthday gifts and automatically awarded stamps
stamp_card_id uuid Stamp card (→ stamp_cards.id)
stamp_count integer Stamps
reward_id uuid Welcome reward (→ rewards.reward_id)
feedback list, also CSV Guest feedback, without names and without guest ID
Field Type Meaning
day date Day of the feedback (Vienna time, deliberately without time of day)
location_id uuid Location (→ locations.id)
stamp_card_id uuid Stamp card (→ stamp_cards.id)
stars integer Stars (1 to 5)
comment text Guest’s text
status text sent or closed
google_opened boolean Google review link opened
misuse_hits list, also CSV Misuse protection hits, without guest ID
Field Type Meaning
visit_day date Day concerned
rule text Type: same_day, employee_volume or frequent_override
stamp_card_id uuid Stamp card (→ stamp_cards.id)
team_id uuid Team member (→ team.team_id)
team_name text Team member’s name
event_count integer Number of events
messages list, also CSV Messages to guests with aggregated figures
Field Type Meaning
sent_at timestamp Sent at
kind text message, appearance (date), season_start or cancellation
segment text Audience
location_id uuid Location (→ locations.id)
date_id uuid Date on the road (→ location_dates.id)
title_de text Title (German)
title_en text Title (English)
body_de text Text (German)
body_en text Text (English)
targeted integer Guests in the audience
sent integer Delivered in the app
pushed integer Sent as push notification
ai_assisted boolean Created with a text suggestion from Hazel
statistics_monthly list, also CSV Statistics per month (Vienna time)
Field Type Meaning
month date Month (first day)
stamps integer Stamps given by this business
new_guests integer New guests: a guest’s first stamp at this business
rewards_earned integer Rewards earned at this business
rewards_redeemed integer Rewards redeemed at this business
billing_months list, also CSV Monthly statements (amounts in cents)
Field Type Meaning
id uuid Statement ID
business_id uuid Business
business_name text Business name at that time
group_id uuid Group (if billed as a group)
group_name text Group name
unit_kind text business or group
month date Month (first day)
phase text trial, contract or inactive
billable boolean Month is billed
stammgast_count integer Regular guests
return_visits integer Return visits
active_locations integer Active locations
unit_cents integer Price per regular guest
min_cents integer Minimum amount
cap_cents integer Monthly cap
cap_first_cents integer Cap for the first location
cap_addon_cents integer Cap increase per additional location
has_override boolean Individual prices agreed
is_fixed boolean Fixed price agreed
fixed_price_cents integer Fixed price
fixed_price_included_locations integer Locations included in the fixed price
fixed_price_location_addon_cents integer Fixed-price surcharge per additional location
calc_amount_cents integer Calculated amount before any waiver
amount_cents integer Amount due
is_min boolean Minimum applied
is_capped boolean Cap applied
waived_min boolean Minimum waived
waived_all boolean Whole month waived
outage_days integer Outage days
outage_reduction_cents integer Reduction for outage
outage_min_waived boolean Minimum dropped due to outage
rest_month boolean Rest month, no minimum
rest_kind text Reason: season, no_appearances or closure
rest_manual boolean Rest month set or lifted by us
rest_reduction_cents integer Reduction for rest month
currency text Currency
price_plan_id uuid Price list
terms_version text Version of the terms
contract_start date Contract start
contract_end date Contract end
trial_end_date date Trial end
computed_at timestamp Computed at
recompute_count integer Number of recalculations
exported_at timestamp Taken over for invoicing at
created_at timestamp Created at
billing_month_regulars list, also CSV Regular guests per monthly statement, without guest ID
Field Type Meaning
billing_month_id uuid Monthly statement (→ billing_months.id)
qualifying_day date Day the guest became a regular
location_name text Location
visit_days_in_month integer Visit days in the month
return_visits integer Return visits in the month
contract object Contract data (amounts in cents; empty if none agreed)
Field Type Meaning
business_id uuid Business
contract_start date Contract start
contract_end date Contract end
price_plan_id uuid Price list
fixed_price_cents integer Fixed price
fixed_price_included_locations integer Locations included in the fixed price
fixed_price_location_addon_cents integer Fixed-price surcharge per additional location
fixed_price_until date Fixed price valid until
unit_cents_override integer Individual price per regular guest (empty = price list)
min_cents_override integer Individual minimum (empty = price list)
cap_first_cents_override integer Individual cap for the first location (empty = price list)
cap_addon_cents_override integer Individual cap increase (empty = price list)
trial_bonus_months integer Additional trial months
monthly_mail_enabled boolean Monthly summary email enabled
created_at timestamp Created at
updated_at timestamp Last changed at
location_confirmations list, also CSV Confirmations when adding or closing locations (contract data)
Field Type Meaning
created_at timestamp Time
action text Type of change, e.g. add (location added)
location_name text Location name
location_id uuid Location (→ locations.id)
source text Channel, e.g. app or admin
confirmed_by_name text Name of the person who confirmed
role text Role of that person
old_active_locations integer Active locations before
new_active_locations integer Active locations after
old_cap_cents integer Cap before
new_cap_cents integer Cap after
is_fixed boolean Fixed price agreed
in_trial boolean During the trial
trial_end timestamp End of trial
terms_version text Version of the terms
accepted_terms list, also CSV Decisions on versions of the terms
Field Type Meaning
version text Version
decision text accepted or rejected
accepted_at timestamp Time of the decision
accepted_by_name text Name of the person who decided
rejected_at timestamp Rejected at
source text Channel, e.g. app, admin or antrag (application)
hazel_usage list, also CSV Questions to Hazel per month
Field Type Meaning
month date Month (first day)
questions integer Questions
hazel_assist list, also CSV Hazel translations and text suggestions per month
Field Type Meaning
month date Month (first day)
kind text translate or suggest
used integer Used
group object Groups and networks only
Field Type Meaning
id uuid Group ID
name text Name
kind text company (group) or federation (network)
is_group_home boolean This export concerns the group’s or network’s own account
locals json The group’s businesses (business_id, name); empty for members of a network
images list, JSON only Images (addresses; in an export by Stempla the files are also in the folder bilder/)
Field Type Meaning
kind text logo, cover, card_background or group_logo (group logo, group business only)
ref text Business or card ID
url text Original address

Data not included

Known limitations when switching

Printed QR codes, displays and links to your business no longer lead to an active card after the end. Your guests see their stamps and rewards until your business is deleted; they are then deleted. Another provider cannot take them over without the guests. You remain responsible for open rewards under the terms. Inform your guests in good time.

You may give the export to a new provider and use it with your or its systems to continue and evaluate your loyalty programme. You only need to delete it once you no longer need it for this. From receipt, you are a controller of the export under the GDPR. Do not try to identify guests through the guest ID; you would need your own legal basis for that (annex, “Data in the export”).

Standards

There are no standards or open specifications for loyalty programmes in the Union repository under Art. 35 Data Act yet. We therefore use the open JSON and CSV format described here.

3. Server location and access by authorities

Where our servers are and which law the companies behind them are subject to, per service:

Service Infrastructure Company, registered office
App database, files, server functions Supabase, region EU West (Paris); data centres of Amazon Web Services Supabase Pte. Ltd. (Singapore); support Supabase, Inc. (USA); hosting Amazon Web Services, Inc. (USA)
Hazel on the website, Hazel metrics, chat Supabase, region Frankfurt am Main as above
Network in front of the server functions, spam protection in the application form Cloudflare Cloudflare, Inc. (USA)
AI model for Hazel Anthropic Anthropic PBC (USA)
Push notifications Firebase Cloud Messaging, Google data centres worldwide Google LLC (USA)
Website, administration, customer portal, email Hostinger Hostinger International Ltd. (Cyprus)

What we do against unlawful access by foreign authorities

The database with your business data and the customer portal are hosted in data centres in the EU. For push notifications and the AI assistant Hazel, providers in the USA are involved (see table). The data is encrypted in transit and at rest. Under its contract, our provider for the website and customer portal only discloses data where a law or a binding order of an authority requires it. We ourselves never voluntarily give data of your business to authorities outside the EU. If we receive such a request, we review it, disclose only what is legally required and inform you as far as we are allowed to. We only store what Stempla needs.

How we process personal data is described in the privacy policy.

4. Charges