MCP App Store
by KeenEthics
QR Wise icon

QR Wise MCP Server for ChatGPT

By Pacific Equities Holding Corp.

Overview

Connect your authorized QRWise merchant to explore stores, finalized sales, tax and payment summaries, menus, inventory, orders, discounts, vouchers, register activity, X/Z readings, operational exceptions, kiosk feedback, settlements, and available store-data backups. QRWise provides read-only, merchant-scoped access and does not expose unrestricted database access, customer contact details, payment credentials, or business-data write actions. A QRWise account and an approved connection are required.

How to connect

  1. ChatGPT: Open the QR Wise listing in the ChatGPT app directory and choose Connect. ChatGPT listing QR Wise exposes 25 tools here.

Tools

get_category_sales

ChatGPT
Summarize 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

ChatGPT
Return 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

ChatGPT
Use 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

ChatGPT
Read 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

ChatGPT
Use 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

ChatGPT
Use 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_menu_health

ChatGPT
Check one authorized store for inactive or low-stock items, empty categories, unassigned options and add-ons, and missing Grab or Foodpanda prices. Results are read-only and issue name lists are bounded by limit.

get_menu_item_hourly_sales

ChatGPT
Return hourly sales for a case-insensitive menu-item name search at one authorized store over up to 366 business dates. Uses the same paid, closed, transaction-ID-deduplicated current and Store Data backup records as get_category_sales. Cancelled line items and cancelled, returned or refunded transactions are excluded. Hours use Asia/Manila and the transaction invoice-entry timestamp, falling back to transaction creation time. Amounts allocate transaction gross sales, recorded discounts, net sales, service charge and amount payable proportionally across line items with cent reconciliation. Only hours with matching sales are returned; transactions without a usable timestamp are reported separately in unbucketed.

get_merchant

ChatGPT
Identify the merchant authorized for this connection. Does not accept a merchant ID.

get_order_operations

ChatGPT
Use 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

ChatGPT
Use 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

ChatGPT
Read 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

ChatGPT
Summarize 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

ChatGPT
Compare 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

ChatGPT
Use 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

ChatGPT
Use 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

ChatGPT
Read 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

ChatGPT
Summarize 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

ChatGPT
Use 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

ChatGPT
Read 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

ChatGPT
Read 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

ChatGPT
Read 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

ChatGPT
List 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

ChatGPT
List this merchant's stores. Follow next_offset until null to retrieve all stores.

read_store_data_backup

ChatGPT
Read 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.

Example Prompts

Click any prompt to copy it.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/qr-wise"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/qr-wise)