Formato de exportación

Actualitzat: 29 d'octubre de 2026

Quan prems «Descarregar les meves dades» a Configuració → Compte reps un fitxer JSON. Aquesta n'és l'estructura: cada taula i els seus camps.

• exported_at
• gdpr_notice
• export_complete
• tables_unavailable
• sub_processors_url
• account
• sessions
• identities

account

• email
• user_id
• created_at
• last_sign_in_at
• email_confirmed_at
• signup_language
• plan
• plan_status
• restaurant_limit
• scans_used
• scan_limit
• is_trial
• trial_started
• trial_ends_at
• cancel_at_period_end
• credit_balance_cents
• extra_usage_enabled
• monthly_spend_cap_cents
• extra_spent_this_month
• auto_reload_enabled
• auto_reload_threshold_cents
• auto_reload_amount_cents
• language
• country
• region
• onboarding_completed
• weekly_pnl_emails_enabled
• price_lock_alerts_enabled
• low_stock_alerts_enabled
• dispute_hold
• data_deletion_scheduled_at
• deletion_notice_sent_at
• deletion_requested_at
• deletion_hold_tier
• terms_version
• terms_accepted_at
• terms_language
• deleted_at

sessions

• created_at
• updated_at
• ip
• user_agent

identities

• provider
• created_at
• last_sign_in_at

restaurants

• id
• name
• settings
• language
• currency
• description
• is_extra
• cancel_at_period_end
• lock_notified_at
• created_at
• deleted_at

plan_audit_log

• id
• old_plan
• new_plan
• old_restaurant_limit
• new_restaurant_limit
• old_scan_limit
• new_scan_limit
• changed_at

credits_ledger

• id
• source_id
• direction
• amount_cents
• created_at

ingredients

• id
• name
• brand
• purchase_price
• purchase_quantity
• unit
• category
• vat
• vat_deductible
• merma_pct
• peso_bruto
• peso_neto
• is_sub_recipe
• recipe
• output_quantity
• output_unit
• current_stock
• stock_tracking_enabled
• stock_threshold
• stock_unit
• restaurant_id
• created_at
• deleted_at

menu_items

• id
• name
• price
• vat
• recipe
• category
• description
• margin
• target_margin
• menu_only
• cost
• restaurant_id
• created_at
• deleted_at

ingredient_purchases

• id
• ingredient_id
• ingredient_name
• brand
• purchase_quantity
• quantity
• unit
• unit_price
• total_price
• vat_percent
• vat_deductible
• invoice_scan_id
• invoice_date
• source
• restaurant_id
• created_at
• deleted_at

inventory

• id
• ingredient_name
• current_quantity
• unit
• min_threshold
• last_updated
• restaurant_id
• created_at
• deleted_at

invoice_scans

• id
• filename
• file_hash
• invoice_date
• supplier
• invoice_number
• status
• restaurant_id
• created_at
• deleted_at

menu_price_history

• id
• menu_item_id
• bundle_id
• dish_name
• price
• effective_date
• price_type
• option_dish_id
• course_name
• restaurant_id
• created_at
• deleted_at

weekly_sales

• id
• menu_item_id
• dish_name
• week_start_date
• units_sold
• revenue
• dish_snapshot
• restaurant_id
• created_at
• deleted_at

weekly_pnl_snapshots

• id
• week_start
• total_revenue
• total_cogs
• gross_profit
• food_cost_pct
• margin_pct
• waste_cost
• carte_revenue
• carte_cogs
• menu_revenue
• menu_cogs
• dishes_count
• dishes_without_recipe
• dishes_snapshot
• bundles_snapshot
• restaurant_id
• created_at
• deleted_at

alert_events

• id
• lock_id
• triggered_value
• threshold_value
• message
• status
• severity
• triggered_at
• acknowledged_at
• snoozed_until
• restaurant_id
• deleted_at

price_locks

• id
• lock_type
• target_id
• target_name
• threshold_value
• baseline_value
• is_active
• notification_channels
• note
• snoozed_until
• restaurant_id
• created_at
• deleted_at

stock_movements

• id
• ingredient_id
• type
• quantity
• actual_quantity
• unit
• reason
• note
• week_start
• reference_id
• estimated
• unit_mismatch
• restaurant_id
• created_at
• deleted_at

bundles

• id
• name
• price
• is_fixed
• courses
• included_extras
• vat_rate
• weekday_recurrence
• specific_dates
• is_active
• restaurant_id
• created_at
• deleted_at

bundle_sales

• id
• bundle_id
• sale_date
• covers_sold
• revenue
• bundle_snapshot
• extras_actual
• supplements_actual
• restaurant_id
• created_at
• deleted_at

waste_log

• id
• ingredient_id
• quantity
• unit
• reason_code
• log_date
• notes
• restaurant_id
• created_at
• deleted_at

weekly_bundle_sales

• id
• bundle_id
• week_start_date
• covers_sold
• revenue
• bundle_snapshot
• extras_actual
• restaurant_id
• created_at
• deleted_at

Updated: 29 October 2026

When you press 'Download my data' in Settings → Account, you get a JSON file. This is its structure: each table and its fields.

The top of the file

key	type	meaning
exported_at	string, ISO 8601 date and time with offset	when this file was made
gdpr_notice	string	what the file is - or, if a table could not be read, that it is INCOMPLETE and which
export_complete	true or false	every table was read; false means the file is incomplete
tables_unavailable	array	present only when incomplete: the tables that could not be read
sub_processors_url	string	where the providers that process your data are listed
account	object	your login identity and your plan, usage and settings (the fields below)
sessions	array	your open sessions (the fields below)
identities	array	how you sign in (the fields below)

account

Your login identity, then your plan, usage and settings.

key	type	meaning
email	string	the email you sign in with
user_id	string, a UUID	your account's identifier
created_at	string, ISO 8601 date and time with offset	when the account was created
last_sign_in_at	string, ISO 8601 date and time with offset	your last sign-in
email_confirmed_at	string, ISO 8601 date and time with offset	when you confirmed your email
signup_language	string	the language chosen when the account was created (es, ca, en)
plan	string	your plan: basico, profesional, premium (or trial)
plan_status	string	the plan's state: active, trialing, past_due, canceled, unpaid
restaurant_limit	number, whole	how many restaurants the plan allows
scans_used	number, whole	invoice scans used this month
scan_limit	number, whole	invoice scans the plan includes each month
is_trial	true or false	the account is on its free trial
trial_started	true or false	the free trial was started
trial_ends_at	string, ISO 8601 date and time with offset	when the free trial ends or ended
cancel_at_period_end	true or false	the plan is cancelled and ends at the end of the paid period
credit_balance_cents	number, whole	prepaid credit, in euro cents
extra_usage_enabled	true or false	scans beyond the plan are paid from credit
monthly_spend_cap_cents	number, whole	your monthly limit on extra usage, in euro cents
extra_spent_this_month	number, whole	extra usage spent this month, in euro cents
auto_reload_enabled	true or false	credit is topped up automatically
auto_reload_threshold_cents	number, whole	the balance, in euro cents, below which credit is topped up
auto_reload_amount_cents	number, whole	how much, in euro cents, each automatic top-up adds
language	string	the interface language (es, ca, en)
country	string	your country
region	string	your region
onboarding_completed	true or false	the first-run setup was completed
weekly_pnl_emails_enabled	true or false	you receive the weekly P&L email
price_lock_alerts_enabled	true or false	you receive price-lock alert emails
low_stock_alerts_enabled	true or false	you receive low-stock emails
dispute_hold	true or false	access is held while a card dispute is open
data_deletion_scheduled_at	string, ISO 8601 date and time with offset	when the account was scheduled for deletion, if it is
deletion_notice_sent_at	string, ISO 8601 date and time with offset	when we emailed you that deletion was coming, if we did
deletion_requested_at	string, ISO 8601 date and time with offset	when you asked for your account to be deleted, if you did
deletion_hold_tier	string	the plan you keep until the deletion date, while a deletion you asked for is pending
terms_version	string	the version of the terms and the processing annex you accepted
terms_accepted_at	string, ISO 8601 date and time with offset	when you accepted them
terms_language	string	the language they were shown in (es, ca, en)
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

sessions

Each session open on your account, one entry per session.

key	type	meaning
created_at	string, ISO 8601 date and time with offset	when the session started
updated_at	string, ISO 8601 date and time with offset	its last activity
ip	string	the IP address it was opened from
user_agent	string	the browser and device it was opened from

identities

How you sign in, one entry per sign-in method.

key	type	meaning
provider	string	how you sign in (email)
created_at	string, ISO 8601 date and time with offset	when this sign-in method was added
last_sign_in_at	string, ISO 8601 date and time with offset	its last use

restaurants

Your restaurants. A list: your account's rows.

key	type	meaning
id	string, a UUID	the restaurant's identifier
name	string	its name
settings	object or array, as stored	its settings: VAT, prices with or without VAT, cost targets and the like
language	string	its language
currency	string	its currency
description	string	its description
is_extra	true or false	an extra restaurant paid on top of the plan
cancel_at_period_end	true or false	the extra restaurant is cancelled at the end of its paid period
lock_notified_at	string, ISO 8601 date and time with offset	when we emailed you that this restaurant is locked by a plan change, if we did
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

plan_audit_log

Every change to your plan and its limits. A list: your account's rows.

key	type	meaning
id	number, whole	the entry's identifier
old_plan	string	the plan before
new_plan	string	the plan after
old_restaurant_limit	number, whole	the restaurant limit before
new_restaurant_limit	number, whole	the restaurant limit after
old_scan_limit	number, whole	the monthly scan limit before
new_scan_limit	number, whole	the monthly scan limit after
changed_at	string, ISO 8601 date and time with offset	when it changed

credits_ledger

Every credit top-up, use and refund. A list: your account's rows.

key	type	meaning
id	number, whole	the entry's identifier
source_id	string	the Stripe reference on your receipt (cs_, pi_, re_ or ch_)
direction	string	credit (added) or debit (used or refunded)
amount_cents	number, whole	the amount, in euro cents
created_at	string, ISO 8601 date and time with offset	when it was created

ingredients

Your ingredients and sub-recipes. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the ingredient's identifier
name	string	its name
brand	string	its brand
purchase_price	string	the price of one pack, without VAT, as a decimal string
purchase_quantity	string	the pack size, as a decimal string
unit	string	the unit of the pack size
category	string	its category
vat	string	its VAT rate, in percent
vat_deductible	true or false	its VAT is deductible (if not, it counts as a cost)
merma_pct	number, may have decimals	the waste percentage applied when costing
peso_bruto	number, may have decimals	gross weight
peso_neto	number, may have decimals	net weight
is_sub_recipe	true or false	it is a sub-recipe made from other ingredients
recipe	object or array, as stored	a sub-recipe's ingredients and quantities
output_quantity	number, may have decimals	how much a sub-recipe makes
output_unit	string	the unit of output_quantity
current_stock	number, may have decimals	the stock on hand
stock_tracking_enabled	true or false	stock is tracked
stock_threshold	number, may have decimals	the low-stock threshold
stock_unit	string	the unit stock is counted in
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

menu_items

Your dishes and their recipes. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the dish's identifier
name	string	its name
price	number, may have decimals	its sale price
vat	string	its VAT rate, in percent
recipe	object or array, as stored	its ingredients and quantities
category	string	its menu category
description	string	its description
margin	number, may have decimals	its margin when last calculated, in percent
target_margin	number, may have decimals	the margin you aim for, in percent
menu_only	true or false	it is served only inside a set menu
cost	number, may have decimals	its cost when last calculated
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

ingredient_purchases

Every purchase recorded, by hand or from a scanned invoice. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the purchase's identifier
ingredient_id	string, a UUID	the ingredient bought (see ingredients)
ingredient_name	string	the ingredient's name on the purchase
brand	string	its brand
purchase_quantity	number, may have decimals	how many packs
quantity	number, may have decimals	the size of each pack
unit	string	the unit of the pack size
unit_price	number, may have decimals	the price per unit, without VAT
total_price	number, may have decimals	the line total, without VAT
vat_percent	number, may have decimals	the VAT rate, in percent
vat_deductible	true or false	its VAT is deductible
invoice_scan_id	string, a UUID	the scanned invoice it came from (see invoice_scans)
invoice_date	string, YYYY-MM-DD	the invoice's date
source	string	how it was recorded: invoice_scan or manual
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

inventory

Your stock counts. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the entry's identifier
ingredient_name	string	the ingredient
current_quantity	number, may have decimals	the quantity counted
unit	string	its unit
min_threshold	number, may have decimals	the minimum you keep
last_updated	string, ISO 8601 date and time with offset	when it was last counted
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

invoice_scans

Every invoice you scanned (the image itself is never kept). A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the scan's identifier
filename	string	the file's name
file_hash	string	a fingerprint of the file, to spot a duplicate
invoice_date	string, YYYY-MM-DD	the invoice's date
supplier	string	the supplier
invoice_number	string	the invoice number
status	string	the scan's state
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

menu_price_history

Every price a dish or a set menu has had. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the entry's identifier
menu_item_id	string, a UUID	the dish (see menu_items), for a dish's price
bundle_id	string, a UUID	the set menu (see bundles), for a set menu's price
dish_name	string	the name at the time
price	number, may have decimals	the price
effective_date	string, YYYY-MM-DD	from when
price_type	string	which price: base, or a supplement inside a set menu
option_dish_id	string, a UUID	the dish a supplement is for
course_name	string	the set menu course it belongs to
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

weekly_sales

Dishes sold, week by week. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the entry's identifier
menu_item_id	string, a UUID	the dish (see menu_items)
dish_name	string	its name at the time
week_start_date	string, YYYY-MM-DD	the week's Monday
units_sold	number, whole	units sold
revenue	number, may have decimals	revenue
dish_snapshot	object or array, as stored	the dish's price and cost that week
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

weekly_pnl_snapshots

Each week's P&L summary. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the summary's identifier
week_start	string, YYYY-MM-DD	the week's Monday
total_revenue	number, may have decimals	revenue, without VAT
total_cogs	number, may have decimals	cost of goods sold
gross_profit	number, may have decimals	gross profit
food_cost_pct	number, may have decimals	food cost, in percent of revenue
margin_pct	number, may have decimals	margin, in percent
waste_cost	number, may have decimals	the cost of waste
carte_revenue	number, may have decimals	revenue from à la carte
carte_cogs	number, may have decimals	cost of goods for à la carte
menu_revenue	number, may have decimals	revenue from set menus
menu_cogs	number, may have decimals	cost of goods for set menus
dishes_count	number, whole	dishes counted
dishes_without_recipe	number, whole	dishes with no recipe
dishes_snapshot	object or array, as stored	each dish's figures that week
bundles_snapshot	object or array, as stored	each set menu's figures that week
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

alert_events

Every price-lock alert raised. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the alert's identifier
lock_id	string, a UUID	the price lock that raised it (see price_locks)
triggered_value	number, may have decimals	the value that crossed the threshold
threshold_value	number, may have decimals	the threshold
message	string	the alert's text
status	string	its state
severity	string	how serious
triggered_at	string, ISO 8601 date and time with offset	when it was raised
acknowledged_at	string, ISO 8601 date and time with offset	when you acknowledged it
snoozed_until	string, ISO 8601 date and time with offset	until when you snoozed it
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

price_locks

The price locks you set. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the lock's identifier
lock_type	string	what it watches
target_id	string, a UUID	the ingredient or dish it watches
target_name	string	its name
threshold_value	number, may have decimals	the threshold
baseline_value	number, may have decimals	the value when the lock was set
is_active	true or false	it is on
notification_channels	array	how it tells you
note	string	your note
snoozed_until	string, ISO 8601 date and time with offset	until when you snoozed it
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

stock_movements

Every stock movement: purchases, use, adjustments, waste. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the movement's identifier
ingredient_id	string, a UUID	the ingredient (see ingredients)
type	string	what kind of movement
quantity	number, may have decimals	the quantity, in its unit
actual_quantity	number, may have decimals	the quantity counted, for a count
unit	string	its unit
reason	string	the reason
note	string	your note
week_start	string, YYYY-MM-DD	the week it belongs to
reference_id	string, a UUID	the record that caused it (a purchase, a sale)
estimated	true or false	it was estimated from sales
unit_mismatch	true or false	its unit could not be converted to the stock unit
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

bundles

Your set menus. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the set menu's identifier
name	string	its name
price	number, may have decimals	its price
is_fixed	true or false	a fixed menu, as opposed to one with choices
courses	object or array, as stored	its courses and the dishes in each
included_extras	object or array, as stored	extras included in the price
vat_rate	number, may have decimals	its VAT rate, in percent
weekday_recurrence	array	the weekdays it is served (0 = Sunday)
specific_dates	array	the dates it is served
is_active	true or false	it is on the menu
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

bundle_sales

Set menus sold, day by day. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the entry's identifier
bundle_id	string, a UUID	the set menu (see bundles)
sale_date	string, YYYY-MM-DD	the day
covers_sold	number, whole	covers sold
revenue	number, may have decimals	revenue
bundle_snapshot	object or array, as stored	the set menu as it was that day
extras_actual	object or array, as stored	extras actually served
supplements_actual	object or array, as stored	supplements actually served
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

waste_log

Every waste entry. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the entry's identifier
ingredient_id	string, a UUID	the ingredient wasted (see ingredients)
quantity	number, may have decimals	the quantity
unit	string	its unit
reason_code	string	why
log_date	string, YYYY-MM-DD	the day
notes	string	your notes
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge

weekly_bundle_sales

Set menus sold, week by week. A list: each of your restaurants' rows.

key	type	meaning
id	string, a UUID	the entry's identifier
bundle_id	string, a UUID	the set menu (see bundles)
week_start_date	string, YYYY-MM-DD	the week's Monday
covers_sold	number, whole	covers sold
revenue	number, may have decimals	revenue
bundle_snapshot	object or array, as stored	the set menu as it was that week
extras_actual	object or array, as stored	extras actually served
restaurant_id	string, a UUID	the restaurant it belongs to (see restaurants)
created_at	string, ISO 8601 date and time with offset	when it was created
deleted_at	string, ISO 8601 date and time with offset	null if live; when it was deleted, if it is waiting for the 30-day purge