Inventory Analytics - StateSet API Docs

curl -X GET "https://api.stateset.com/api/v1/inventory/analytics?metric_type=overview&include_trends=true" \
  -H "Authorization: Bearer YOUR_API_KEY"

{
  "metric_type": "overview",
  "period": {
    "from": "2024-01-01T00:00:00Z",
    "to": "2024-11-15T23:59:59Z"
  },
  "metrics": {
    "total_value": 485750.00,
    "total_units": 12500,
    "unique_skus": 256,
    "average_turnover": 8.5,
    "stockout_rate": 0.03,
    "overstock_rate": 0.12,
    "dead_stock_value": 15000.00,
    "carrying_cost": 121437.50
  },
  "breakdown": [
    {
      "group": "Electronics",
      "name": "Electronics Category",
      "metrics": {
        "units": 3500,
        "value": 175000.00,
        "turnover_rate": 12.5,
        "days_of_supply": 29.2,
        "velocity": "fast"
      }
    },
    {
      "group": "Accessories",
      "name": "Accessories Category",
      "metrics": {
        "units": 5000,
        "value": 75000.00,
        "turnover_rate": 6.0,
        "days_of_supply": 60.8,
        "velocity": "medium"
      }
    }
  ],
  "trends": {
    "inventory_value": [
      { "date": "2024-01-01", "value": 450000 },
      { "date": "2024-02-01", "value": 465000 },
      { "date": "2024-03-01", "value": 478000 }
    ],
    "turnover_rate": [
      { "date": "2024-01-01", "rate": 7.5 },
      { "date": "2024-02-01", "rate": 8.0 },
      { "date": "2024-03-01", "rate": 8.5 }
    ]
  },
  "insights": [
    {
      "type": "opportunity",
      "severity": "high",
      "message": "15 SKUs have been non-moving for 180+ days",
      "affected_items": ["OLD-001", "OLD-002", "OLD-003"],
      "potential_savings": 15000.00
    },
    {
      "type": "warning",
      "severity": "medium",
      "message": "Electronics category showing 25% increase in stockouts",
      "affected_items": ["ELEC-101", "ELEC-102"],
      "potential_savings": 5000.00
    },
    {
      "type": "recommendation",
      "severity": "low",
      "message": "Consider implementing ABC classification for better control",
      "affected_items": [],
      "potential_savings": 8000.00
    }
  ]
}

GET

https://api.stateset.com

api

inventory

analytics

curl -X GET "https://api.stateset.com/api/v1/inventory/analytics?metric_type=overview&include_trends=true" \
  -H "Authorization: Bearer YOUR_API_KEY"

{
  "metric_type": "overview",
  "period": {
    "from": "2024-01-01T00:00:00Z",
    "to": "2024-11-15T23:59:59Z"
  },
  "metrics": {
    "total_value": 485750.00,
    "total_units": 12500,
    "unique_skus": 256,
    "average_turnover": 8.5,
    "stockout_rate": 0.03,
    "overstock_rate": 0.12,
    "dead_stock_value": 15000.00,
    "carrying_cost": 121437.50
  },
  "breakdown": [
    {
      "group": "Electronics",
      "name": "Electronics Category",
      "metrics": {
        "units": 3500,
        "value": 175000.00,
        "turnover_rate": 12.5,
        "days_of_supply": 29.2,
        "velocity": "fast"
      }
    },
    {
      "group": "Accessories",
      "name": "Accessories Category",
      "metrics": {
        "units": 5000,
        "value": 75000.00,
        "turnover_rate": 6.0,
        "days_of_supply": 60.8,
        "velocity": "medium"
      }
    }
  ],
  "trends": {
    "inventory_value": [
      { "date": "2024-01-01", "value": 450000 },
      { "date": "2024-02-01", "value": 465000 },
      { "date": "2024-03-01", "value": 478000 }
    ],
    "turnover_rate": [
      { "date": "2024-01-01", "rate": 7.5 },
      { "date": "2024-02-01", "rate": 8.0 },
      { "date": "2024-03-01", "rate": 8.5 }
    ]
  },
  "insights": [
    {
      "type": "opportunity",
      "severity": "high",
      "message": "15 SKUs have been non-moving for 180+ days",
      "affected_items": ["OLD-001", "OLD-002", "OLD-003"],
      "potential_savings": 15000.00
    },
    {
      "type": "warning",
      "severity": "medium",
      "message": "Electronics category showing 25% increase in stockouts",
      "affected_items": ["ELEC-101", "ELEC-102"],
      "potential_savings": 5000.00
    },
    {
      "type": "recommendation",
      "severity": "low",
      "message": "Consider implementing ABC classification for better control",
      "affected_items": [],
      "potential_savings": 8000.00
    }
  ]
}

The Analytics API provides real-time insights into inventory performance, trends, and optimization opportunities.

Query Parameters

metric_type

string

required

Type of analytics to retrieve:

overview - General inventory metrics
turnover - Inventory turnover analysis
aging - Stock aging report
performance - SKU performance metrics
forecast_accuracy - Forecast vs actual comparison

sku

string

Filter analytics for specific SKU

location_id

string

Filter by specific location

date_from

string

Start date for analytics period (ISO 8601)

date_to

string

End date for analytics period (ISO 8601)

group_by

string

Group results by: sku, category, location, supplier

include_trends

boolean

Include historical trend data. Default: false

Response

metric_type

string

Type of analytics returned

period

object

Analytics time period

Show properties

from

string

Start date (ISO 8601)

string

End date (ISO 8601)

metrics

object

Core metrics based on metric_type

Show properties

total_value

number

Total inventory value

total_units

integer

Total units in stock

unique_skus

integer

Number of unique SKUs

average_turnover

number

Average inventory turnover rate

stockout_rate

number

Percentage of SKUs out of stock

overstock_rate

number

Percentage of overstocked items

dead_stock_value

number

Value of non-moving inventory

carrying_cost

number

Total inventory carrying cost

breakdown

array

Detailed breakdown by grouping

Show properties

group

string

Group identifier (SKU, category, etc.)

name

string

Group name

metrics

object

Group-specific metrics

Show properties

units

integer

Units in stock

value

number

Inventory value

turnover_rate

number

Turnover rate

days_of_supply

number

Days of supply on hand

velocity

string

Movement velocity: fast, medium, slow, non-moving

trends

object

Historical trend data (if requested)

Show properties

inventory_value

array

Time series of inventory values

turnover_rate

array

Time series of turnover rates

stockout_incidents

array

Historical stockout events

insights

array

AI-generated insights and recommendations

Show properties

type

string

Insight type: opportunity, warning, recommendation

severity

string

Severity level: high, medium, low

message

string

Insight description

affected_items

array

List of affected SKUs

potential_savings

number

Estimated savings if actioned

curl -X GET "https://api.stateset.com/api/v1/inventory/analytics?metric_type=overview&include_trends=true" \
  -H "Authorization: Bearer YOUR_API_KEY"

{
  "metric_type": "overview",
  "period": {
    "from": "2024-01-01T00:00:00Z",
    "to": "2024-11-15T23:59:59Z"
  },
  "metrics": {
    "total_value": 485750.00,
    "total_units": 12500,
    "unique_skus": 256,
    "average_turnover": 8.5,
    "stockout_rate": 0.03,
    "overstock_rate": 0.12,
    "dead_stock_value": 15000.00,
    "carrying_cost": 121437.50
  },
  "breakdown": [
    {
      "group": "Electronics",
      "name": "Electronics Category",
      "metrics": {
        "units": 3500,
        "value": 175000.00,
        "turnover_rate": 12.5,
        "days_of_supply": 29.2,
        "velocity": "fast"
      }
    },
    {
      "group": "Accessories",
      "name": "Accessories Category",
      "metrics": {
        "units": 5000,
        "value": 75000.00,
        "turnover_rate": 6.0,
        "days_of_supply": 60.8,
        "velocity": "medium"
      }
    }
  ],
  "trends": {
    "inventory_value": [
      { "date": "2024-01-01", "value": 450000 },
      { "date": "2024-02-01", "value": 465000 },
      { "date": "2024-03-01", "value": 478000 }
    ],
    "turnover_rate": [
      { "date": "2024-01-01", "rate": 7.5 },
      { "date": "2024-02-01", "rate": 8.0 },
      { "date": "2024-03-01", "rate": 8.5 }
    ]
  },
  "insights": [
    {
      "type": "opportunity",
      "severity": "high",
      "message": "15 SKUs have been non-moving for 180+ days",
      "affected_items": ["OLD-001", "OLD-002", "OLD-003"],
      "potential_savings": 15000.00
    },
    {
      "type": "warning",
      "severity": "medium",
      "message": "Electronics category showing 25% increase in stockouts",
      "affected_items": ["ELEC-101", "ELEC-102"],
      "potential_savings": 5000.00
    },
    {
      "type": "recommendation",
      "severity": "low",
      "message": "Consider implementing ABC classification for better control",
      "affected_items": [],
      "potential_savings": 8000.00
    }
  ]
}

Metric Types

Overview Analytics

General inventory health metrics and KPIs.

const overview = await stateset.inventory.analytics.get({
  metric_type: 'overview',
  group_by: 'category'
});

Turnover Analysis

Detailed inventory turnover rates and velocity metrics.

const turnover = await stateset.inventory.analytics.get({
  metric_type: 'turnover',
  group_by: 'sku',
  date_from: '2024-01-01'
});

Aging Report

Analysis of stock age and identification of slow-moving items.

const aging = await stateset.inventory.analytics.get({
  metric_type: 'aging',
  location_id: 'loc_warehouse_001'
});

Performance Metrics

SKU-level performance including sales velocity and profitability.

const performance = await stateset.inventory.analytics.get({
  metric_type: 'performance',
  sku: 'WIDGET-001',
  include_trends: true
});

Forecast Accuracy

Compare forecasted demand with actual sales to improve planning.

const accuracy = await stateset.inventory.analytics.get({
  metric_type: 'forecast_accuracy',
  date_from: '2024-06-01',
  date_to: '2024-11-01'
});

Exporting Analytics

Export analytics data in various formats:

// Export as CSV
const csvExport = await stateset.inventory.analytics.export({
  metric_type: 'overview',
  format: 'csv'
});

// Export as PDF report
const pdfReport = await stateset.inventory.analytics.export({
  metric_type: 'performance',
  format: 'pdf',
  include_charts: true
});

Scheduling Reports

Set up automated analytics reports:

const schedule = await stateset.inventory.analytics.schedule({
  name: 'Weekly Inventory Report',
  metric_type: 'overview',
  frequency: 'weekly',
  recipients: ['[email protected]'],
  format: 'pdf'
});

Inventory Planning - Generate inventory plans
List Inventory - View current inventory
Inventory Webhooks - Real-time inventory events

Batch Operations Inventory Planning

⌘I

StateSet One

​Query Parameters

​Response

​Metric Types

​Overview Analytics

​Turnover Analysis

​Aging Report

​Performance Metrics

​Forecast Accuracy

​Exporting Analytics

​Scheduling Reports

​Related Endpoints

Query Parameters

Response

Metric Types

Overview Analytics

Turnover Analysis

Aging Report

Performance Metrics

Forecast Accuracy

Exporting Analytics

Scheduling Reports

Related Endpoints