Ecom Fulfill

Get Summary

Site-level revenue rollup over a date range. Returns one row per site with total_revenue, fb_revenue, organic_revenue, base_cost, spend, orders, units, net_profit, CR (GA4), ROAS, AOV, AOI. Use this as the primary tool for "how did site X perform from date A to B?" queries.

Get Daily Breakdown

Per-day breakdown rows for each site over a date range. Each row = one calendar day with total_revenue, fb_revenue, organic_revenue, spend, net_profit, orders, ROAS, CTR. Use this for time-series / trend analysis (e.g. "show me revenue trend for last 14 days").

Get Campaign Profit

Per-campaign rollup for each site. Each campaign has spend, attributed revenue, ROAS, AOV, AOI, net_profit, status, objective. Use this when user asks "which campaign is performing best?" or "find losing campaigns".

Get Last Sync

Last FB data sync timestamp for each site and ad account. Use this to determine data freshness before drawing conclusions (e.g. "data is X minutes old").

Get Profit Snapshot

Compact profit-only view per site. Returns {revenue, base_cost, spend, net_profit, last_sync_at, generated_at} per site. Lower token count vs get_summary — use when you only need profit numbers.

Analyze Site Profit Window

Comprehensive profit analysis for one or more sites over a date range. Returns a pre-cooked insight package with verdict (PROFITABLE/BREAK_EVEN/LOSING), key stats, top/worst campaigns, trends (last 7d vs prior), warnings, and recommendations. Use this for "how is my site doing?" type questions — saves 4+ raw tool calls.

List Cards

Liệt kê listing card Amazon bạn được phép. Lọc: q (card_id/title/family), status (pipeline), lark_status, store (tên store). Phân trang: page + limit (max 200), trả total + has_more để lấy tiếp trang sau.

Get Card

Chi tiết 1 card theo card_id: content (title/bullets/description), backend_keywords, validation, SKU. Xem trước khi validate/push.

Get Card Status

Trạng thái xử lý 1 card (pipeline_run.step, validation, đã push chưa). POLL sau khi chạy generate/run_pipeline.

List Product Types

Tìm Amazon Product Type theo tên hoặc code. Trả TẤT CẢ kết quả khớp (code + name). Dùng code để gán cho card.

Get Product Type

Chi tiết 1 Product Type theo code (family code).

Update Card

Sửa card: gán store (tên) + product_type_code (family code), sửa content (title/bullets/description), backend_keywords. Chỉ gán được store bạn có quyền.

Generate Content

Chạy nền: quét ảnh + generate AI content cho card. Trả {started}. POLL get_card_status tới status=content_review.

Run Pipeline

Chạy hết → validate (images→content→approve→files→validate, KHÔNG push). Cần đã gán store + product_type_code. Trả {started}; POLL get_card_status tới pipeline_run.step="done".

Validate Listing

Validate listing với Amazon (SP-API), trả VALID/INVALID + issues. Đồng bộ.

Push Listing

PUSH listing THẬT lên Amazon (tạo listing sống). Chỉ khi validate VALID. allow_overwrite=true để ghi đè SKU trùng (cẩn thận). Trả listing hoặc 409 nếu SKU trùng.

Upload Xlsm To Product Type

Nạp template .xlsm cho Product Type (theo code) + store. Đưa URL https tải file .xlsm công khai. Chỉ store bạn có quyền.

Upload Custom Template To Product Type

Nạp custom template (.xlsx/.txt) cho Product Type (theo code) + store. url https hoặc base64 cho .txt nhỏ (<256KB). Chỉ store bạn có quyền.