get_category_sales
ChatGPTSummarize paid, closed transaction line items by menu category and menu item for one authorized store over up to 366 business dates. Uses current data and private Store Data backups, including QRWise 1.0 orders. Pass category for an exact case-insensitive category filter, menuItem for a case-insensitive item-name search, and limit for the number of top menu items. Omit both filters to answer category and best-selling-item questions. Cancelled line items and cancelled, returned or refunded transactions are excluded. Transaction gross sales, recorded discounts, net sales, service charge and amount payable are allocated to items in proportion to their line totals with cent reconciliation. item_sales_amount is a compatibility alias for net_sales_amount.
get_daily_payment_method_sales
ChatGPTReturn a complete day-by-day payment-method sales report for one authorized store over up to 31 business dates in one tool call. Use this for requests such as a 30-day × payment-method breakdown; do not paginate raw transaction records. Uses paid, closed transactions from current data and authorized private Store Data backups with transaction-ID deduplication. Returns service charge, VATable sales, VAT-exempt sales, zero-rated sales, VAT 12%, senior discount, PWD discount, employee discount, voucher discount, net sales and transaction count for each business date and payment method. NAAC, MOV and Solo Parent discount fields are also returned when their government discount toggles are enabled for the store. Take-out charge is not returned separately because it is included in net sales. Staff & employees audience vouchers are employee discounts; vouchers for every other audience are voucher discounts. Split-tender values are allocated proportionally to recorded paid payment amounts.
get_discount_voucher_activity
ChatGPTUse for actual discount and voucher usage over up to 366 business dates. Summarizes paid, closed transactions from current data and Store Data backups. Reports transaction counts and amounts by recorded discount or voucher name; legacy records without a name are grouped as unspecified.
get_integration_health
ChatGPTRead safe enablement and configuration status for a store's supported integrations. Credentials, tokens, external merchant IDs, webhook payloads and provider error bodies are never returned.
get_inventory_activity
ChatGPTUse for restocks, transaction deductions, manual stock adjustments, low stock and out-of-stock items over up to 366 Asia/Manila calendar dates. Inventory history is current-system data and is not reconstructed from transaction backups. Results are ranked and limited by limit.
get_kiosk_experience
ChatGPTUse for kiosk feedback over up to 366 Asia/Manila calendar dates: average rating, response and skip rates, positive ratings and star distribution. Feedback is current-system-only and this tool returns no customer identity.
get_merchant
ChatGPTIdentify the merchant authorized for this connection. Does not accept a merchant ID.
get_order_operations
ChatGPTUse for current order workflow questions over up to 366 business dates: open and completed orders, cancellations, preparing/ready items, items delayed at least 15 minutes, active tables and average completion time. Workflow state is current-system-only and is not reconstructed from backups.
get_payment_activity
ChatGPTUse for payment-method and payment-status activity over up to 366 business dates, including paid, pending, failed, refunded and cancelled payments. Uses transaction payment rows when available and transaction-level payment fields as a legacy fallback. Provider references and credentials are never returned.
get_reading_activity
ChatGPTRead current-system X- and Z-reading activity for one authorized store over up to 366 business dates. Filter by reading type or use ALL. Returns at most limit latest readings and never reconstructs missing readings from transactions or backups.
get_register_activity
ChatGPTSummarize drawer opens and net cash activity for one authorized store over up to 366 business dates. Uses the same drawer-open rule as the Admin Register Log: every cash transaction counts as one open, plus recorded manual cash-drawer-open audit events. Cash transactions are unified across current data and private Store Data backups; manual opens are counted only when an audit event exists. Net cash adds normal cash transactions and subtracts refunded or cancelled cash transactions. Legacy voided backup records are treated as cancelled. Z/X-readings are not used, so this tool does not report drawer over/short. Set includeDaily=true only for a day-by-day breakdown.
get_sales_channel_activity
ChatGPTCompare sales channels or inspect one exact channel such as Grab or Foodpanda over up to 366 business dates. Uses paid, closed transactions from current data and private Store Data backups. Category and item rows allocate transaction gross sales, recorded discounts, net sales, service charge and amount payable proportionally across line items with cent reconciliation.
get_shift_reconciliation
ChatGPTUse for X-reading shift counts, expected versus counted accountable cash, card and wallet totals, over/short and reconciliation status over up to 366 business dates. Marketplace, Onda Fit and other externally settled tenders are excluded. This is current-system-only because QRWise 1.0 backups do not contain X-readings. Differences are not inferred when a cash count is missing.
get_staff_activity
ChatGPTUse for staff transaction counts, paid sales, discounts, exceptions and manual drawer opens over up to 366 business dates. Returns staff display names only; no employee numbers, contact details or credentials. This is current-system-only because legacy backups do not reliably identify staff.
get_store_activity
ChatGPTRead a sanitized store activity feed over no more than 31 dates. Returns a bounded actor label, activity label and allowlisted source only. Detailed metadata, changed values, source record IDs, credentials and request payloads are excluded. Follow next_offset until null.
get_tax_sales_summary
ChatGPTSummarize the tax classifications recorded on paid, closed transactions for one authorized store over up to 366 business dates. This is a transaction summary, not a replacement for a finalized X- or Z-reading. Legacy backups may not contain every tax classification. Set includeDaily=true only when needed.
get_transaction_exception_activity
ChatGPTUse for transaction exceptions over up to 366 business dates: refunded, returned and cancelled counts and amounts, plus available safe reason summaries. Legacy voided backup records are grouped under cancelled. Uses unified current and Store Data backup transactions. Reasons may be unavailable in older records. Set includeDaily=true only when a daily trend is needed.
get_transaction_sales
ChatGPTRead sales and exclusive transaction-status totals for one authorized store over up to 366 business dates using current data and authorized private Store Data backups. Paid sales exclude cancelled, returned and refunded transactions. Legacy voided backup records are reported as cancelled. Status amounts use each transaction's amount payable. Z-readings are not used. Transaction IDs are deduplicated, with current data taking precedence over backup snapshots. Storage provenance is not exposed. Monthly totals are always returned. Set includeDaily=true only when a day-by-day breakdown is needed; it is false by default to keep long-range reports fast and compact. Missing days are not zero-sales days.
list_settlements
ChatGPTRead Netbank payout amounts and statuses, without bank account details. Dates use Asia/Manila calendar days for payout creation, not Z-reading business dates. Follow next_offset until null.
list_store_business_records
ChatGPTRead approved catalog, inventory, voucher configuration, discounts, settings, order and payment fields for one authorized store. For transactions, transaction_items, transaction_payments, transaction_order_rounds and menu_item_stock_history, dateFrom/dateTo are required (up to 31 Asia/Manila creation dates, not business dates). Transaction rows include unpaid/cancelled/refunded states: do not sum them as finalized sales or double-count payments and transaction totals. Voucher usage_count is configured allowance, not redemption count; transaction voucher_id links recorded usage. Includes inactive catalog entries. Prices are base PHP amounts. Hours day_of_week uses 1=Monday through 7=Sunday; is_closed takes precedence. Follow next_offset until null; pages are not a snapshot. No credentials, customer identity, notes, voucher codes, or arbitrary database access.
list_store_data_backups
ChatGPTList automatic and manually uploaded NDJSON backups for one authorized store. A manual upload is explicitly associated with its destination store even when it contains a different legacy store ID. Backups are historical snapshots, not current live data. Follow next_offset until null.
list_stores
ChatGPTList this merchant's stores. Follow next_offset until null to retrieve all stores.
read_store_data_backup
ChatGPTRead a bounded page of privacy-filtered records from an authorized store's QRWise .ndjson or .ndjson.gz backup. Use a path returned by list_store_data_backups. Manually uploaded QRWise 1.0 raw transaction exports are normalized to the destination store and may be up to 128 MB compressed and 1 GB expanded; automatic backups retain 25 MB compressed and 100 MB expanded limits. Customer identity, notes, voucher codes, provider references, credentials and bank details are excluded. Follow next_offset until null.