/api/nlp_analisys_en

Header
X-Customer-Api-Id: <uuid>
X-Secret: <secret>
Content-Type: application/json
Request Body Schema
{
  "product_code": string | number,           // Echoed in header
  "product_name": string,                    // Echoed in header
  "category": string,                        // Product category
  "uom": string,                             // Unit of measure

  "inventory_snapshot": {                    // Required
    "snapshot_date": "YYYY-MM-DD",
    "current_stock_units": number,
    "safety_stock_units": number,
    "reorder_point_units": number
  },

  "unit_economics": {                        // Required
    "unit_cost": number,
    "unit_price": number,
    "currency": string
  },

  "purchases": [                             // Optional but recommended
    { "purchase_date": "YYYY-MM-DD", "quantity": number, "supplier": string }
  ],

  "returns": [                               // Optional
    { "return_date": "YYYY-MM-DD", "quantity": number, "reason": string }
  ],

  "channel_sales_units": {                   // Optional
    "<channel_name>": number,
    …
  },

  "regional_sales_units": {                  // Optional
    "<region_name>": number,
    …
  },

  "daily_sales_history": [                   // Optional
    { "date": "YYYY-MM-DD", "units": number }
  ],

  "metadata": {                              // Optional traceability
    "data_extract_timestamp": string,
    "prepared_by": string
  }
}
Example Request Body
// Example Request
{
  "product_code": 56421,
  "product_name": "Smart LED Bulb 9 W – Wi Fi (E27)",
  "category": "Lighting > Smart Home",
  "uom": "unit",

  "inventory_snapshot": {
    "snapshot_date": "2024-03-31",
    "current_stock_units": 780,
    "safety_stock_units": 300,
    "reorder_point_units": 450
  },

  "unit_economics": {
    "unit_cost": 2.65,
    "unit_price": 6.90,
    "currency": "USD"
  },

  "purchases": [
    { "purchase_date": "2024-01-08", "quantity": 1000, "supplier": "LumiTech Ltd." },
    { "purchase_date": "2024-02-12", "quantity": 900,  "supplier": "LumiTech Ltd." },
    { "purchase_date": "2024-03-15", "quantity": 850,  "supplier": "BrightSource Inc." }
  ],

  "returns": [
    { "return_date": "2024-02-27", "quantity": 19, "reason": "Factory defect" },
    { "return_date": "2024-03-18", "quantity": 11, "reason": "Buyer remorse" }
  ],

  "channel_sales_units": {
    "ecommerce": 2460,
    "retail_stores": 890,
    "marketplace": 610,
    "wholesale": 430
  },

  "regional_sales_units": {
    "north_america": 1820,
    "europe": 1100,
    "latin_america": 720,
    "asia_pacific": 550,
    "middle_east_africa": 100
  },

  "daily_sales_history": [
    { "date": "2024-01-01", "units": 38 },
    { "date": "2024-01-02", "units": 41 },
    { "date": "2024-01-03", "units": 36 },
    /* … more dates … */
    { "date": "2024-03-31", "units": 57 }
  ],

  "metadata": {
    "data_extract_timestamp": "2024-04-01T11:30:00Z",
    "prepared_by": "ERP Integrator v2.3"
  }
}
Example Response Body
// Example Response
{
  "report_text": "## Executive Sales & Inventory Report: Smart LED Bulb 9W – WiFi (E27) (Code: 56421)\n\n**1. Product & Inventory Overview**\n- Current Stock (03-31-2024): 780 units (Safety: 300 | ROP: 450) → Inventory above both thresholds; no immediate reorder needed.\n\n**2. Unit Economics & Purchasing**\n- Unit Cost/Price: USD 2.65 / 6.90  (Margin: USD 4.25)\n- Q1 Purchases: 2,750 units across two suppliers; returns minimal (30 units), indicating solid quality control.\n\n**3. Sales Breakdown**\n- Channels: Ecommerce 2,460 | Retail 890 | Marketplace 610 | Wholesale 430 → Ecommerce drives 56% of sales.\n- Regions: NA 1,820 | EU 1,100 | LatAm 720 | APAC 550 | MEA 100 → Opportunity to grow in MEA and APAC.\n\n**4. Sales Patterns**\n- Jan–Mar daily sales show a gradual increase in average daily units from ~40 to ~60.\n\n**5. Insights & Recommendations**\n- Maintain ecommerce focus; consider targeted promotions in under-penetrated MEA (100 units).\n- Align channel vs. regional reporting to reconcile the 100-unit gap between aggregates.\n- Monitor returns trend—factory defects (19 units) suggest minor supplier QA review.\n\n**6. Next Steps**\n- Expand daily sales dataset for full trend analysis.\n- Conduct supplier performance audit based on return reasons.\n- Integrate sales data sources to eliminate aggregation discrepancies.\n\n*End of Report*"
}
Description

Automatically transforms your raw JSON (SKU details, inventory, purchases, returns, multi-channel/regional sales, daily history) into a polished, multi-section English report—complete with insights, recommendations and next steps—ready to paste into emails, slide decks or BI tools.

Business Usage

Executives & S&OP: Quick overview of stock health versus safety/ROP, margin, and channel/regional performance. Sales & Ops: Single source for channel vs. regional splits, with alignment actions. Finance & Inventory Planning: Justify inventory levels and margin health. Analysts: Save hours of write-up by dumping your BI JSON straight into this endpoint.

← Back to all routes