shah-mohammed/ecommerce-claude-skills

inventory-risk-brief-ecommerce

Turns e-commerce inventory and sales exports into a practical risk brief for stockouts, overstock, promo conflicts, and traffic allocation.

소스 보기

사용 방법

  1. 설치 명령을 복사하고 자신의 에이전트 환경에 설치하기 전에 소스 패키지를 확인하세요.
  2. 필요한 도구, 인증 정보, 지원 환경은 원본 문서에서 확인하세요.
  3. 입력과 원하는 산출물을 설명하고 출처와 결과를 대조하세요.
npx skills add https://github.com/shah-mohammed/ecommerce-claude-skills --skill inventory-risk-brief-ecommerce

시작 전 확인

  • 설치에는 모델 구독, API 한도, 파일 접근 권한이 포함되지 않습니다.
  • 별점 수와 설치 수는 활동 지표이며 독립적인 품질·보안 검증이 아닙니다.
원본 Skill 문서

원본 저장소의 제목, 예시, 코드, 표, 링크, 이미지를 유지해 표시합니다.

Inventory Risk Brief - E-commerce

Use this skill when

The user wants an inventory-aware growth or promo review from exports.

Common requests:

  • "Review this inventory export."
  • "Which products are at risk of stockout?"
  • "Which products need promo support?"
  • "What should we avoid pushing in ads?"

Required input

Minimum useful input:

  • Inventory export with SKU, product name, current stock, and variant.
  • Sales export for the last 30, 60, or 90 days.
  • Date range and sales velocity.
  • Promo calendar or planned campaign notes if available.

Recommended columns:

  • SKU
  • product name
  • variant
  • current inventory
  • units sold
  • revenue
  • margin or priority flag if available
  • incoming stock quantity and ETA if available
  • supplier lead time if available

Before analysis

  1. Confirm the purpose: prevent stockout, reduce overstock, plan promo, or protect paid traffic.
  2. Ask for exports if the user only describes inventory from memory.
  3. Mark missing lead time, incoming stock, and margin data as caveats.
  4. Do not pretend to run demand forecasting.

Analysis workflow

  1. Normalize SKU and product names.
  2. Calculate simple signals where data allows:
  • recent sales velocity
  • days of inventory remaining
  • sell-through risk
  • slow mover status
  • promo conflict risk
  1. Classify products:
  • stockout risk
  • overstock risk
  • safe to promote
  • do not scale traffic
  • needs more data
  1. Tie risks to marketing action.
  2. Name what cannot be decided yet. Reorder quantity needs lead time and incoming stock; a promo decision needs margin. Where those are absent, hand the owner the question rather than a recommendation built on a guess.

Decision and evidence standard

Every finding should include:

  • Evidence tag: export, screenshot, url, review_cluster, support_ticket, return_reason, policy, feed_diagnostics, margin_csv, inventory_export, hypothesis, or needs_data.
  • Severity: low, medium, high, or critical.
  • Confidence: low, medium, or high.
  • Business impact: revenue, margin, cashflow, retention, conversion, support_load, or risk.
  • Effort: XS, S, M, or L.
  • Owner decision: donow, test, investigate, monitor, ignore, or approvalneeded.

If the evidence is weak, mark the finding as hypothesis or needs_data and lower confidence.

Output format

Inventory verdict

Short owner-level summary.

Risk table

Product/SKUStatusEvidenceMarketing implicationRecommended action

Promo notes

Products suitable for promotion, products to protect, and products to avoid scaling.

Missing data

Fields needed for better confidence.

Example input and output

Input:

  • inventory export
  • 60-day sales export
  • incoming stock ETA
  • promo calendar

Good output excerpt:

FindingEvidenceSeverityConfidenceBusiness impactEffortOwner decision
Bestseller SKU may stock out during planned campaigninventory_export, exporthighmediumrevenue/riskSapproval_needed
Slow-moving variant has high stock and low recent sales velocityinventory_export, exportmediummediumcashflowStest

What not to do yet: infer stock risk without inventory or sales exports, or recommend purchase orders without lead time and approval.

Guardrails

  • Requires an inventory or sales export. Do not infer stock risk from product names alone.
  • Do not replace ERP, inventory planning, or demand forecasting systems.
  • Do not recommend purchase orders without lead time, margin, and business approval.
  • Do not recommend pushing products that may stock out during the campaign.
  • Do not ignore variant-level constraints.