CSV 导入

支持商品、供应商、选品、采购、库存、订单、广告、财务、售后、预警、报表和 SOP 数据导入,表头需使用系统字段名

数据库:DuckDB / data/amz_seller_runtime_*.duckdb
返回

导入模板

先下载对应模板,按表头填入数据后上传。采购单和销售订单支持 line1 到 line3 三行明细。

字段说明

商品:store_id, product_name, product_line, brand, category, lifecycle_status, owner, internal_sku, msku, asin, status, current_price, price_currency, fba_available_qty, inbound_qty, avg_daily_sales_7d

供应商:supplier_code, company_name, short_name, contact_name, phone, email, main_categories, payment_terms, currency, monthly_capacity, lead_time_days, status, risk_level, owner

选品:keyword, marketplace, category, search_volume, competitor_count, avg_price, avg_rating, review_count, opportunity_score, estimated_margin, status, owner, remark

采购单:po_no, supplier_id, order_date, expected_ship_date, expected_arrival_date, currency, status, owner, line1_sku_id, line1_supplier_quote_id, line1_quantity, line1_unit_cost

销售订单:amazon_order_id, store_id, purchase_date, order_status, fulfillment_channel, buyer_region, currency, line1_sku_id, line1_asin, line1_msku, line1_quantity, line1_item_price, line1_platform_fee, line1_fba_fee, line1_item_profit

上架任务:sku_id, task_type, title, owner, status, due_at, content;预警:alert_type, severity, store_id, sku_id, supplier_id, title, content, status, assignee, due_at

库存:store_id, sku_id, snapshot_date, local_qty, fba_available_qty, fba_reserved_qty, inbound_qty, unsellable_qty, avg_daily_sales_7d

广告:store_id, sku_id, report_date, campaign_id, campaign_name, keyword_text, impressions, clicks, cost, sales, orders

财务:store_id, sku_id, report_date, currency, sales_amount, product_cost, platform_fee, fba_fee, ad_cost, refund_amount