# Warehouse Chart Reports

> Generate warehouse analytics charts, table images, and report-ready visuals from SQLite/CSV data. Use when the user asks for warehouse charts, product table images, stock health pie charts, revenue/profit visuals, missing-product visuals, or image assets for PDF/slide reporting.

- Skill: `dvcrn/warehouse-chart-reports` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add dvcrn/warehouse-chart-reports`
- Raw SKILL.md: https://api.skillmd.com/api/skills/dvcrn/warehouse-chart-reports/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: dvcrn (https://skillmd.com/u/dvcrn)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/dvcrn/warehouse-chart-reports

---


# Warehouse Chart Reports

Use this skill to produce clean chart/report images for warehouse demos.

## Run full warehouse visual pack (recommended)

Execute:

```bash
python skills/warehouse-chart-reports/scripts/run_warehouse_reports.py \
  --db demo/warehouse_agent/warehouse_demo.db \
  --out demo/warehouse_agent/outputs
```

This generates:
- `stock_status_pie.png`
- `revenue_by_category.png`
- `daily_profit_30d.png`
- `product_table_top40.png`
- `missing_products.csv`
- `kpi_summary.txt`

## Generate product table image only

Execute:

```bash
python skills/warehouse-chart-reports/scripts/product_table_image.py \
  --db demo/warehouse_agent/warehouse_demo.db \
  --out demo/warehouse_agent/outputs/product_table_top40.png \
  --limit 40
```

## Notes

- Prefer virtualenv Python when matplotlib is unavailable system-wide.
- Keep chart style simple and readable for PDF embedding.
- If sales timestamps are sparse for today, use the 30-day profit chart for trend visibility.