get_business_days_report
ChatGPTDaily totals per business day (open/close times, net sales, order count) over a date range. Use for day-by-day operational summaries.
By Foodics
Connect your Foodics business to explore sales, orders, menu, inventory, customers and restaurant performance in English or Arabic. All tools are read-only. Connection requires a Foodics business owner or a user authorized to manage apps. Data access follows the connected business account.
level is required — pass 'item' for per-ingredient costs or 'category' for category-level rollup. Use when you need COGS or cost-variance analysis.gender code — read meta.enums for the labels.status, type, source, delivery_status and discount_type codes — read meta.enums for the labels (note order_status decodes the order's own status, product_status decodes each line item's; they are different tables). Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.allergens and nutrition_info — the only tool that returns those (search_modifier_options cannot include them). For other detail prefer search_modifier_options(ids=[...], include=[...]), which takes up to 50 at once. Here every relation is returned, so a missing one means none is set. Rows carry a numeric costing_method code — read meta.enums for the labels.status, type, source, delivery_status and discount_type codes — read meta.enums for the labels (note order_status decodes the order's own status, product_status decodes each line item's; they are different tables).metric argument is required; call once per KPI you need. Use as the first stop for 'how are we doing?' questions. Whole-business only — this report accepts NO filters at all (no branches/branch_id); for per-branch figures use a sales_by_ report. There is also no gross_sales metric of any name here (see the `metric` param) — for gross revenue use a sales_by_ report's gross_sales column.allergens and nutrition_info — the only tool that returns those (search_products cannot include them). For other detail prefer search_products(ids=[...], include=[...]), which takes up to 50 at once. Here every relation is returned, so a missing one means none is set. Rows carry numeric pricing_method, selling_method and costing_method codes — read meta.enums for the labels.order_source code — read meta.enums for the labels. Use to compare channel performance.order_type code — read meta.enums for the labels. Use to compare fulfilment-type revenue.include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.name is free-text (substring match); reference is exact. Also filterable by online-order capability. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.status code — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.coupon_type code — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.gender code — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — never present it as complete. Fetch the next batch (pass meta.next_starting_page as starting_page) only when you need the rows themselves; for totals, use the report named above instead of paging to the end. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.qualification code — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.status code — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.type and status codes — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — never present it as complete. Fetch the next batch (pass meta.next_starting_page as starting_page) only when you need the rows themselves; for totals, use the report named above instead of paging to the end. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.costing_method code — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.status, type, source, delivery_status and discount_type codes — read meta.enums for the labels (note order_status decodes the order's own status, product_status decodes each line item's; they are different tables). Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — never present it as complete. Fetch the next batch (pass meta.next_starting_page as starting_page) only when you need the rows themselves; for totals, use the report named above instead of paging to the end. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.pricing_method, selling_method and costing_method codes — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.type, condition_type and reward_type codes — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.status code — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.status code — read meta.enums for the labels. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.name is free-text (substring match); reference is exact. Rows are lean: a related object (category, branches, options, …) is present only when named in include — a missing key means not requested, not empty. To look up known records by UUID, pass ids=[...] (up to 50, live or deleted) with the include you need, in one call. Returns up to 200 items per call. If meta.has_more is true, THE RESULT IS INCOMPLETE — do not summarize, count, chart, or answer from it yet. Call this tool again passing meta.next_starting_page as starting_page to fetch the next batch, and repeat until meta.has_more is false before presenting any answer. If meta.rate_limited_retry_after is set, the batch stopped at the rate limit: wait that long before fetching the next one.Click any prompt to copy it.
Add this badge to your site or README. It links to this page.
HTML
<a href="https://mcp-app-store.keenethics-labs.com/app/foodics"><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
[](https://mcp-app-store.keenethics-labs.com/app/foodics)