MerchantFlow

Collections in the store with product count and last-updated date, flagging empty collections. Returns the first "limit" collections and reports how many matched in total. The result covers collection hygiene, empty collections, and potentially stale collections. Best for: empty or stale collections. Not for: individual product listings.

run_collection_membership_audit

Combined profit and loss across every linked store for a date range (default: last 30 days), converted into one reporting currency. Set per_store to also get the per-store breakdown. Requires a plan covering more than one store. Best for: one profit and loss across several linked stores in a single currency. Not for: a single store.

get_combined_pnl

Returns the MerchantFlow account and store this connection is signed in as: an opaque profile id that stays the same across reconnections, the user's name and email, and the store name as a label. Best for: identifying which account and store this connection belongs to. Not for: plan limits or store analytics.

get_profile

List the stores linked to this account, with each store's platform, currency, timezone, connection state and last sync time. The result defines the store set available for combined figures. Best for: which stores are linked to this account. Not for: their combined profit.

get_store_list

List cost-of-goods-sold entries for all items and variants in this store, newest effective date first, enriched with the matching product and variant. Paginate with page/page_size; filter by SKU substring or effective-date range. Best for: browsing cost entries across the catalogue. Not for: one item's cost history.

list_cogs

Get customer cohort analysis showing LTV, repeat purchase rate, and revenue by cohort month/week over time. Best for: how acquisition cohorts retain and spend over time. Not for: one customer's history.

get_cohort_analysis

Get lifetime value detail for a single customer: net profit, revenue, CAC, tenure, and order history (most recent 200 orders). Customer name and email in the response are partially redacted. The customer identifier is the id returned in the customer lifetime value list. Best for: one known customer's lifetime figures and orders. Not for: finding or ranking customers.

get_customer_detail

List customers ranked by lifetime value (net profit after allocated overhead, summed across each customer's full order history) - the same source as the dashboard Customers page. start_date/end_date filter WHICH customers appear, by their first-order date; they do NOT clamp a customer's lifetime totals to that window. Customer name and email in the response are partially redacted. Each returned id identifies a customer record whose detail includes up to 200 recent orders. Best for: ranking individual customers by lifetime value. Not for: store-wide averages.

list_customers

Classify customers into VIP / regular / casual / one-time tiers based on lifetime spend and order count. Best for: segmenting customers into spend tiers. Not for: ranking individual customers by profit.

run_customer_spend_tier_classifier

Get a high-level summary of revenue, profit, orders, ad spend, and top metrics for an arbitrary date range, suitable for quick time-period comparisons. Best for: a quick headline snapshot of a period. Not for: a cost-by-cost profit and loss breakdown.

get_date_range_summary

Identify products with zero sales in the window and (when Shopify is connected) their current on-hand inventory. Best for: products with zero sales and stock still on hand. Not for: ranking products that do sell.

run_dead_stock_report

Get per-discount-code margin metrics: uses, revenue, discount cost, COGS, allocated ad spend, gross profit, and margin percent, ranked by any column. Pre-aggregated rolling timeframes provide the fastest results, while an explicit start_date/end_date produces a custom range computed live. Best for: whether each discount code made money. Not for: gift cards.

get_discount_code_performance

Group orders by customer email hash to find customers under multiple names or phone numbers. Best for: customers who appear under more than one name or phone number. Not for: customer value rankings.

find_duplicate_customers

Get OPEX and CAPEX expenses broken down by category and vendor over a date range, including recurring expenses and CAPEX amortisation. Best for: operating and capital expenses by category or vendor. Not for: cost of goods, ad spend or payment fees.

get_expenses_breakdown

Retrieve the full record for an opaque document id from MerchantFlow's retrieval results. Returns id, title, text, URL, and metadata. Best for: the full record behind a retrieval result id. Not for: keyword lookups.

fetch

Digest of open orders by fulfillment status and age. Surfaces orders stuck for more than 3 days. Best for: unfulfilled orders and how long they have waited. Not for: carrier tracking of shipped orders.

run_fulfillment_digest

Generate the data for any report over a date range - the same numbers the dashboard shows. The report selector is exactly one of report_id (a saved or custom report identifier) and template_key (a built-in template such as pnl or product_performance). Dates default to the report's own default timeframe ending today; narrower ranges reduce truncation. Best for: the figures of a saved or template report. Not for: discovering which reports exist.

generate_report

Outstanding gift card balance grouped by currency plus redemption percentage against initial issuance. Best for: outstanding gift card liability. Not for: discount code performance.

run_gift_card_balance_report

Shopify-flagged orders with medium or high fraud risk in the recent window. Read-only. Best for: orders Shopify flagged for fraud risk. Not for: general order lookups.

run_high_risk_order_report

Get the connection status of all integrations (Shopify, WooCommerce, ad platforms, 3PL and fulfilment providers) including last sync time and any errors. Best for: whether each connection is healthy and when it last synced. Not for: plan limits or rate-limit headroom.

get_integration_status

Total dollar value of inventory currently on hand (on-hand quantity x recorded COGS per SKU). Best for: the value of stock on hand at cost. Not for: sales velocity.

run_inventory_valuation

Returns the progress of a draft invoice cost import: its status and, once read, the supplier, invoice lines and their matched products. Best for: the file viewer following a draft invoice import's progress. Not for: cost history or current costs.

get_invoice_import_draft

Get the current cost of goods sold and full cost history for one item, identified by sku, product_id (internal product id), or variant_id (the commerce platform's variant id, e.g. the Shopify variant id - not an internal uuid). Optional on_date returns the cost effective on that date. Best for: one item's current cost and cost history. Not for: browsing all costs.

get_item_cogs

Get customer lifetime value summary, optionally segmented by country, including average LTV, CAC, and LTV:CAC ratio. Best for: store-wide lifetime value averages and LTV:CAC. Not for: listing or ranking individual customers.

get_ltv_summary

List every report available to this store: saved template reports, custom reports, and the built-in template catalogue. Each returned report id or template key identifies a report available for generation. Best for: discovering which reports exist. Not for: the report figures themselves.

list_reports

Look up a single order by number and return its line items, margin, fulfillment state, and refund history. Best for: one known order's line items, margin, fulfilment and refunds. Not for: looking through many orders at once.

lookup_order

Get the Markets dashboard table for a date range, including real geo ad spend, blended fallback spend, revenue, net profit, margins, ROAS, POAS, CAC, and spend-without-orders markets. Best for: profit, spend and efficiency per country. Not for: products within one country.

get_markets

Lists products and ad campaigns from this store matching the text typed after @ in the ChatGPT composer, as links to their records. Best for: the ChatGPT composer @-mention picker listing products and campaigns. Not for: analytics or order lookups.

search_mentions

Opens the MerchantFlow app on one page of the store's figures for a preset period: today's snapshot, profit and loss, products, ads, markets or orders. Returns each page block's figures, or why the connection cannot show it. Best for: the merchant browsing their store's pages in the MerchantFlow app, opened from the ChatGPT sidebar. Not for: answering a specific question in the conversation.

open_merchantflow

Returns the signed-in user's own MerchantFlow preferences for this store - the ChatGPT app, the Daily AI Summary schedule and anomaly alert emails - with their schema and layout. Best for: ChatGPT's plugin settings page showing the user's own preferences. Not for: store data or tenant-wide configuration.

settings_read

Find variants that are out of stock at some locations but available at others - candidates for transfers. Best for: stock imbalances between locations. Not for: store-wide totals.

run_multi_location_inventory_audit

Get the current status of all configured North Star KPIs with target, actual, delta, and trend direction. Best for: progress against the store's configured KPI targets. Not for: metrics outside those KPIs.

get_north_star_status

Opens a supplier invoice (PDF or image) or a cost CSV in the MerchantFlow app beside the conversation, to preview product cost changes before importing them in MerchantFlow. Best for: previewing a supplier invoice or cost CSV the user opened, beside the conversation. Not for: reading current costs or applying cost changes.

open_cogs_import_file

Analyse orders filtered by what is IN the basket (which products, and how many units), broken down by region, channel or month. Answers questions the pre-computed dashboard context cannot, such as 'orders containing two chairs, average shipping cost per region'. Returns order counts, net revenue, and BOTH shipping figures: what customers were charged (revenue) and what fulfilment actually cost the merchant, with an explicit coverage percentage for the cost side. Best for: totals over orders defined by what they contain, such as orders with two or more of a product. Not for: finding specific orders.

query_order_basket_analytics

Store pages flagged by content thinness, unpublished status, or staleness. Best for: thin, unpublished or stale store pages. Not for: product listings.

run_page_content_audit

Compares a cost CSV with the store's current product costs: which SKUs match, and what each cost would change to. Changes nothing. Best for: the file viewer's diff of a cost CSV against current costs. Not for: importing or saving costs.

preview_cogs_csv

Scores every product on a 0-100 scale based on images, SEO fields, description length, and taxonomy. Best for: an overall 0-100 listing quality score per product. Not for: a single issue such as images or SEO alone.

run_product_completeness_score

Get detailed profitability for a specific product including current catalogue price, variant-level pricing breakdown, COGS, and 90-day trend from the analytics snapshots. Best for: one known product's profitability, pricing and trend. Not for: rankings across the catalogue.

get_product_detail

Products without a featured image or fewer than N total images. Best for: products missing images. Not for: overall listing quality scores.

run_product_image_audit

Run a product viability simulation: given a proposed selling price, COGS, and expected ad spend, compute break-even ROAS, contribution margin, and sensitivity analysis against store averages. Best for: a hypothetical product that is not selling yet. Not for: the performance of existing products.

run_product_viability