1. Order Identification & Tracking
Column Name | Definition |
Account ID | Unique identifier for your restaurant account within the Sociavore system. Used to associate all orders, menus, and payments with your business. |
Order ID | Unique identifier for each individual order. Used for tracking, reconciliation, and customer support. |
Source | The platform where the order originated — for example, website, table, kiosk, or other integrated ordering channels. |
Order type | Specifies how the order is fulfilled: table side, delivery, or pickup. |
Creation time | Timestamp (date and time) when the customer submitted the order. |
2. Menu & Integration Details
Column Name | Definition |
Menu name | Name of the menu the order was placed from — e.g., regular, catering, brunch, or special events menu. |
Deliverect channel | Indicates the Deliverect channel the order was submitted to. |
Stripe Account ID | The connected Stripe account ID where the customer’s payment was processed. Useful for multi-location or multi-brand setups. |
3. Order Financial Breakdown
Column Name | Definition |
Full total | Total amount for the entire order, including all items, taxes, tips, and fees, before discounts or gift cards. If the order included items from multiple menus or merchants, this value represents the combined total for all of them. |
Subtotal | The sum of the food and beverage items before taxes, fees, tips, or discounts. |
Delivery fee paid | Delivery fee charged to the customer. This covers the delivery cost and does not represent restaurant revenue. |
Discount | Total discount amount applied through promo codes, loyalty rewards, or special offers. |
Tax | Total sales tax collected from the customer. |
Delivery tip | Tip designated by the customer for the delivery driver. |
Restaurant tip | Tip designated for restaurant staff or pooled tips within your venue. |
4. Platform Fees & Costs
Column Name | Definition |
App fee | Platform service fee charged by Sociavore for order processing and software usage. |
Absorbed gift card fee | Gift card processing fee that the merchant absorbs when a customer uses a gift card as payment (optional). |
Delivery cost | Actual cost of fulfilling the delivery, paid to a delivery provider or courier partner. |
Processing fee | Payment processing fee charged by Stripe (typically 2.9% + $0.30 per transaction). |
Food Hall commission | Commission retained by the food hall operator from your restaurant’s gross order total, if applicable. |
5. Payment Settlement
Column Name | Definition |
Gift card | Amount of the order covered by a customer’s gift card balance. |
Total | Final amount paid by the customer after applying discounts and gift cards. |
Transferred | Net payout deposited to your restaurant’s bank account after all platform fees, delivery driver costs, commissions, and processing costs are deducted. |
Payment status | Indicates the status of the customer’s payment: Paid, Pending, Failed, or Refunded. |
Transfer status | Indicates the payout status to your bank account: Transferred, Pending, or Scheduled. |