Connect your restaurant data to QuantDine

orders.csv

pos_reference, datetime, covers, total_amount, table_number, status
LF-001-2024, 2024-10-15 19:30:00, 4, 124.50, 5, closed
LF-002-2024, 2024-10-15 20:15:00, 2, 68.00, 2, closed
LF-003-2024, 2024-10-16 12:45:00, 3, 42.75, 1, closed

pos_reference

— Stable order id from your POS (links to order lines)

datetime

— Order date and time (YYYY-MM-DD HH:MM:SS)

covers

— Party size / guest count

total_amount

— Total bill in your currency

table_number

— Table or check label (optional if unused)

status

— e.g. closed, voided

order_items.csv

pos_reference, item_name, quantity, price, category
LF-001-2024, Gambas al Ajillo, 2, 12.50, Starters
LF-001-2024, Paella Valenciana, 1, 38.00, Mains
LF-001-2024, Crema Catalana, 2, 7.50, Desserts

pos_reference

— Same key as orders.csv for this line

item_name

— Dish or drink name

quantity

— Units sold on this line

price

— Line total or unit price as exported by your POS

category

— Menu section (Starters, Mains, etc.)

menu_items.csv

name, category, sell_price, cost_price, is_food, is_alcoholic
Gambas al Ajillo, Starters, 12.50, 3.20, true, false
Paella Valenciana, Mains, 38.00, 11.40, true, false
Sangria de Cava, Drinks, 8.50, 1.80, false, true

name

— Item name as on the menu

category

— Category for reporting

sell_price

— Menu price ex VAT as you use it

cost_price

— Recipe cost (optional)

is_food

— true / false

is_alcoholic

— true / false