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.

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.

get_combined_pnl

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.

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.

list_cogs

Get customer cohort analysis showing LTV, repeat purchase rate, and revenue by cohort month/week over time.

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.

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.

list_customers

Classify customers into VIP / regular / casual / one-time tiers based on lifetime spend and order count.

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.

get_date_range_summary

Identify products with zero sales in the window and (when Shopify is connected) their current on-hand inventory.

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.

get_discount_code_performance

Group orders by customer email hash to find customers under multiple names or phone numbers.

find_duplicate_customers

Get OPEX and CAPEX expenses broken down by category and vendor over a date range, including recurring expenses and CAPEX amortisation.

get_expenses_breakdown

Retrieve the full record for an opaque document id from MerchantFlow's retrieval results. Returns id, title, text, URL, and metadata.

fetch

Digest of open orders by fulfillment status and age. Surfaces orders stuck for more than 3 days.

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.

generate_report

Outstanding gift card balance grouped by currency plus redemption percentage against initial issuance.

run_gift_card_balance_report

Shopify-flagged orders with medium or high fraud risk in the recent window. Read-only.

run_high_risk_order_report

Get the connection status of all integrations (Shopify, WooCommerce, GA4, ad platforms, SpeedFulfill) including last sync time and any errors.

get_integration_status

Total dollar value of inventory currently on hand (on-hand quantity x recorded COGS per SKU).

run_inventory_valuation

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.

get_item_cogs

Get customer lifetime value summary, optionally segmented by country, including average LTV, CAC, and LTV:CAC ratio.

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.

list_reports

Look up a single order by number and return its line items, margin, fulfillment state, and refund history.

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.

get_markets

Find variants that are out of stock at some locations but available at others - candidates for transfers.

run_multi_location_inventory_audit

Get the current status of all configured North Star KPIs with target, actual, delta, and trend direction.

get_north_star_status

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.

query_order_basket_analytics

Store pages flagged by content thinness, unpublished status, or staleness.

run_page_content_audit

Scores every product on a 0-100 scale based on images, SEO fields, description length, and taxonomy.

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.

get_product_detail

Products without a featured image or fewer than N total images.

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.

run_product_viability

Find products or variants with missing or stale COGS data that are affecting P&L accuracy. Returns product titles, SKUs, and the gap reason.

find_cogs_gaps

Get the Markets country drilldown for a date range, ranked by variant and bundle contribution margin using the same service as the dashboard.

get_market_products

Get a profit and loss summary for the tenant's store over a date range, broken down by revenue, COGS, ad spend, expenses, fees, and net profit. Optionally compare to the previous period or previous year for percentage deltas.

get_pnl_summary

Get a chronological feed of recent tenant activity: syncs, large orders, and integration events.

get_recent_activity

Percentage of customers in the selected window who placed two or more orders.

run_repeat_purchase_rate

Resolve a product name, category word or SKU (e.g. 'chairs', 'oak desk', 'CHR-01') to concrete product IDs in this store's catalog. Each match includes a similarity score and supports disambiguation of natural-language product references for product-level basket analysis.

resolve_products

Get revenue broken down by country over a date range.

get_revenue_breakdown