IdealData.io

Full detail for a single order: the customer, where it ships and who pays, line items, fulfillment, refunds and financials, the customer's history with the store, and how this order compares to their average.

get_order

Full detail for a single product: pricing, per-warehouse inventory and bins, its sales over the last 12 months (revenue, units, trend, segment), and its stock outlook — forecast sell rate, the day it runs out, the last day to order and what is on order — computed exactly as the Low Stock alert computes it. Use the outlook for any "will it run out / how long will stock last" question; do not work out days of stock yourself.

get_product

One purchase order in full: vendor, status, dates, and every line — SKU, quantity ordered, unit cost, expected delivery and what has already been received.

get_purchase_order

Where site traffic comes from, per source: sessions, share, orders and revenue attributed to that source, and (for organic search sources) impressions and clicks. Matches the Traffic Sources page.

get_traffic_sources

The alert types that actually have events in this organization. Use this to discover valid signalCode values before filtering with search_alerts.

list_alert_types

The organization's brands (businesses), with their connected integrations. Use a brand's businessId to scope other tools to that brand.

list_brands

Search this organization's alerts (signal events) — abandoned carts, low stock, late purchase orders, pricing issues, re-engagement and second-order opportunities, follow-ups and shoppers on the site now. Returns the most recent matches. Narrow with signalCode when the question is about one kind — for "will anything run out?" ask for low_stock_warning and late_po. Use get_alert for the full detail of one.

search_alerts

Search shopping carts — active, abandoned, recovered or converted — with the shopper and cart value. "needsAttention" returns the abandoned/active carts most worth acting on. Returns compact rows — use get_cart with the cartId for one cart's line items and full detail.

search_carts

B2B COMPANIES — buying organizations (business accounts) the merchant sells to, unified across HubSpot and storefront B2B. NOT individual customers (use search_customers for people) and NOT the merchant's own brands (that is businessId / list_brands). Rows carry lifetime and trailing-12-month revenue, order count, linked people and last order date. Use get_company for one account in full. Note: a customer whose record shows a free-text company NAME may have no company record here — only real B2B accounts from a connected source become companies.

search_companies

Search customers by name or email, rank them by a metric (lifetime value, order count, recency, churn risk, …), or both at once — e.g. top customers by lifetime value matching a name. Filters by customer type, lifecycle state and last-order date range combine freely with the ranking.

search_customers

Search orders: by order number, customer email or last name; filter by payment/fulfillment status, attention flags, tags, date range and LINE-ITEM COUNT. Reports how many orders match in total, so it answers "how many orders …" questions without paging through them. Returns compact rows — use get_order for one order's full detail.

search_orders

Search the product catalog by name or SKU; filter by performance segment or product type. Rows carry revenue and velocity metrics. Use get_product for one product's full detail.

search_products

Purchase orders the merchant has placed WITH VENDORS to restock inventory — not customer orders. Answers "what is on order", "what is late", "what is stuck waiting for approval". Rows carry the vendor, status, expected delivery date and outstanding units. Use get_purchase_order for the line items.

search_purchase_orders