MerchantFlow

MerchantFlow is a hosted, read-only ecommerce analytics MCP server for Shopify and WooCommerce. It gives AI assistants tenant-scoped access to revenue, profit and loss, product and SKU profitability, COGS coverage, fulfillment costs, advertising spend, ROAS, marketing performance, cohorts, LTV, and business valuation across connected commerce and marketing platforms. Connect with OAuth over Streamable HTTP. No local server installation is required.

该来源不提供完整文件导出（国内平台多为平台内托管），仅存元数据与原链

接入信息

传输形态: http
鉴权方式: 鉴权未知
端点: https://merchantflow--contact-54p3.run.tools

鉴权方式未标注，请核对官方文档后再接入——不要直接使用以下片段

{
  "mcpServers": {
    "MerchantFlow": {
      "url": "https://merchantflow--contact-54p3.run.tools"
    }
  }
}

能力清单

工具	说明
get_pnl_summary	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_revenue_breakdown	Get revenue broken down by country over a date range.
get_expenses_breakdown	Get OPEX and CAPEX expenses broken down by category and vendor over a date range, including recurring expenses and CAPEX amortisation.
get_bank_balance	Get the current bank balance, burn rate over the last 30/60/90 days, and projected runway in days.
get_mca_status	Get active revenue-based funding (MCA) agreements, repayment schedule, and impact on current period P&L.
get_date_range_summary	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_top_products	Get the top N products ranked by revenue, profit, margin, or units sold over a date range using the same order-based product profit math as the dashboard.
get_bottom_products	Get the bottom N products ranked by profit or margin. Useful for finding SKUs that are losing money. Supports a minimum units filter to drop low-volume noise.
get_product_detail	Get detailed profitability for a specific product including current catalogue price, variant-level pricing breakdown, COGS, and 90-day trend from the analytics snapshots.
find_cogs_gaps	Find products or variants with missing or stale COGS data that are affecting P&L accuracy. Returns product titles, SKUs, and the gap reason.
run_product_viability	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.
get_ad_performance	Get paid and owned channel performance for a date range across Meta, Google, Snapchat, TikTok, Pinterest and Klaviyo, with spend, clicks, impressions, conversions and the revenue each platform reports for itself. Group by platform, campaign, or country. Klaviyo is an owned channel billed as a flat fee, so its spend is 0 by design and it is marked is_owned_channel.
get_channel_roas	Get blended MER (Marketing Efficiency Ratio) and per-platform spend over a date range, with optional comparison to the previous period. Each row also carries platform_reported_revenue and platform_reported_roas - the ad platform’s own self-attributed claim. These figures are non-additive across platforms because Meta and Google may claim the same order; MerchantFlow-attributed revenue remains null in this result.
get_cohort_analysis	Get customer cohort analysis showing LTV, repeat purchase rate, and revenue by cohort month/week over time.
get_ltv_summary	Get customer lifetime value summary, optionally segmented by country, including average LTV, CAC, and LTV:CAC ratio.
get_cac_payback	Get overall customer acquisition cost and payback metrics for a date range.
list_customers	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.
get_customer_detail	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_north_star_status	Get the current status of all configured North Star KPIs with target, actual, delta, and trend direction.
get_anomalies	Get recent anomalies detected by MerchantFlow (profit drops, spend spikes, missing sync data, attribution issues).
get_recent_activity	Get a chronological feed of recent tenant activity: syncs, large orders, and integration events.
run_business_valuation	Run the SDE-multiple business valuation for the tenant based on current P&L data, growth, margin, MER, and risk scoring. Returns valuation range with sensitivity analysis.
get_integration_status	Get the connection status of all integrations (Shopify, WooCommerce, GA4, ad platforms, SpeedFulfill) including last sync time and any errors.
get_markets	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_market_products	Get the Markets country drilldown for a date range, ranked by variant and bundle contribution margin using the same service as the dashboard.
search_orders	Search orders by date range, customer email, order number, or product SKU. Returns a summary of matching orders with profit per order. Hard-capped at 100 results.
resolve_products	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.
query_order_basket_analytics	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.
run_stock_velocity	Rank products by units sold in the selected timeframe and classify them as fast, steady, slow, or dead.
run_dead_stock_report	Identify products with zero sales in the window and (when Shopify is connected) their current on-hand inventory.
run_inventory_valuation	Total dollar value of inventory currently on hand (on-hand quantity x recorded COGS per SKU).
run_multi_location_inventory_audit	Find variants that are out of stock at some locations but available at others - candidates for transfers.
run_fulfillment_digest	Digest of open orders by fulfillment status and age. Surfaces orders stuck for more than 3 days.
lookup_order	Look up a single order by number and return its line items, margin, fulfillment state, and refund history.
run_repeat_purchase_rate	Percentage of customers in the selected window who placed two or more orders.
run_high_risk_order_report	Shopify-flagged orders with medium or high fraud risk in the recent window. Read-only.
find_duplicate_customers	Group orders by customer email hash to find customers under multiple names or phone numbers.
run_product_image_audit	Products without a featured image or fewer than N total images.
run_seo_metadata_audit	Products missing SEO title or with SEO description shorter than threshold.
run_collection_membership_audit	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_product_completeness_score	Scores every product on a 0-100 scale based on images, SEO fields, description length, and taxonomy.
run_url_redirect_audit	URL redirects in the store, flagging loops, empty targets and redirect chains. Returns the first "limit" redirects and reports the total matched. The result covers broken links, redirect loops, and SEO risks from redirect chains after a replatform.
run_page_content_audit	Store pages flagged by content thinness, unpublished status, or staleness.
run_gift_card_balance_report	Outstanding gift card balance grouped by currency plus redemption percentage against initial issuance.
run_abandoned_cart_identifier	Recent abandoned checkouts with recoverable value. Read-only - does not send messages.
run_win_back_candidates	Identify valuable customers who haven't purchased in the last N days.
run_customer_spend_tier_classifier	Classify customers into VIP / regular / casual / one-time tiers based on lifetime spend and order count.
run_wismo_digest	Where Is My Order digest - in-flight orders with tracking status, age, and destination.
get_discount_code_performance	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.
list_reports	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.
generate_report	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.
list_cogs	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.
get_item_cogs	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_cogs_coverage	Report how much of the store's catalogue, units sold, and revenue is covered by COGS data over a date range (default: last 30 days), including margin distribution and the top products still missing costs.
list_capabilities	Report this connection's plan tier, available history, cross-store availability, current rate-limit headroom, and known data limits.
get_store_list	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_combined_pnl	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_tax_insights	Get period tax totals and the blended effective tax rate over a trailing N-day window, plus a per-country split. Tax figures combine tax the platform reported on orders with tax computed from active manual TaxRule entries where the platform reported none (or a fixed-amount rule applies). Mirrors the dashboard tax settings page tiles.
search	Search this MerchantFlow store for products and orders matching a query. Returns retrieval documents with an id, title, and URL; each id resolves to its full record. This endpoint provides record retrieval rather than profit, ad, cohort, or valuation analytics.
fetch	Retrieve the full record for an opaque document id from MerchantFlow's retrieval results. Returns id, title, text, URL, and metadata.

纠错与举报（发现条目失效、署名有误或涉及侵权？）

提交举报 / 纠错

侵权举报经核验成立后，我们会即时下线该条目并删除已存的内容副本。