Skip to content
woo-stock-velocity-report logo

Woo Stock Velocity Report

woo-stock-velocity-report

Read-only: Compute units-sold-per-day per SKU over a rolling window and flag fast-movers and slow-movers.

SKILL.md

Full skill instructions

woo-stock-velocity-report

Purpose

Compute stock velocity (units sold per day) for every SKU over a configurable rolling window. Flags fast-movers at risk of stockout and slow-movers consuming storage space. Combines current stock levels with velocity to project days-of-stock-remaining for each product. Read-only — no data is modified.

Prerequisites

  • WooCommerce store with REST API enabled
  • Consumer Key with Read scope
  • Minimum WooCommerce version: 3.5.0

Parameters

ParameterTypeRequiredDefaultDescription
store_urlstringyes—Base URL of the WooCommerce store
consumer_keystringyes—WooCommerce REST API consumer key (ck_...)
consumer_secretstringyes—WooCommerce REST API consumer secret (cs_...)
dry_runboolnofalseNo effect — read-only skill
formatstringnohumanOutput format: human or json
lookback_daysintno30Rolling window for velocity calculation
fast_mover_thresholdnumberno2.0Units/​day above which a product is flagged as fast-mover
slow_mover_thresholdnumberno0.1Units/​day below which a product is flagged as slow-mover
low_days_of_stockintno14Days of stock remaining below which product is flagged critical
category_idintno—Limit to this category

Authentication

WooCommerce uses OAuth 1.0a for HTTP and Basic Auth over HTTPS.

For HTTPS stores (recommended):

Authorization: Basic base64(consumer_key:consumer_secret)

For HTTP stores (development only): Use OAuth 1.0a — include oauth_consumer_key, oauth_nonce, oauth_signature, oauth_signature_method=HMAC-SHA1, oauth_timestamp, oauth_version=1.0

Never log or output consumer_key or consumer_secret values.

See docs/​AUTHENTICATION.md for full setup instructions.

Safety

Read-only skill — no mutations are executed. Safe to run at any time.

Workflow Steps

Step 1 — Fetch completed orders in the lookback window

GET /​wp-json/​wc/​v3/​orders
  ?status=completed&after=<now - lookback_days>&per_page=100&page=1

Aggregate units sold per product_id from line_items.

Step 2 — Fetch current stock for all products

GET /​wp-json/​wc/​v3/​products?status=publish&per_page=100&page=1

Extract: id, name, sku, stock_quantity, manage_stock

Step 3 — Compute velocity

For each product:

velocity = units_sold / lookback_days  (units per day)
days_of_stock = stock_quantity / velocity  (if velocity > 0, else ∞)

Step 4 — Classify and export

Classify as: FAST (velocity > fast_mover_threshold), SLOW (< slow_mover_threshold), NORMAL Flag CRITICAL if days_of_stock < low_days_of_stock.

API Endpoints Used

GET  /​wp-json/​wc/​v3/​orders              — sales data for velocity calc
GET  /​wp-json/​wc/​v3/​products            — current stock levels
GET  /​wp-json/​wc/​v3/​reports/​top_sellers — supplementary ranking data

Pagination Strategy

WooCommerce REST API uses page/​per_page pagination (not cursor-based).

Standard pattern:

page = 1
while True:
  response = GET /​endpoint?per_page=100&page=page
  process(response)
  if len(response) < 100: break
  page += 1

Maximum per_page is 100 for most endpoints. The X-WP-Total and X-WP-TotalPages response headers report totals. Always read X-WP-TotalPages on the first request to estimate job size.

Session Tracking

Claude MUST emit the following output at each stage. This is mandatory.

STARTUP:

╔══════════════════════════════════════════╗
║  SKILL: woo-stock-velocity-report        ║
║  STORE: <store_url>                      ║
║  TIME:  <ISO-8601 UTC>                   ║
║  MODE:  READ-ONLY                        ║
╚══════════════════════════════════════════╝

PER-OPERATION (emit after each API call batch):

[N/​TOTAL] <METHOD> <endpoint> → <result_count> records | params: <key>=<val>

COMPLETION (human format):

╔══════════════════════════════════════════╗
║  COMPLETE: woo-stock-velocity-report     ║
║  RECORDS PROCESSED: <n>                  ║
║  OUTPUT: <filename>                      ║
╚══════════════════════════════════════════╝

COMPLETION (json format):

{
  "skill": "woo-stock-velocity-report",
  "store": "<store_url>",
  "completed_at": "<ISO-8601>",
  "records_processed": <n>,
  "output_file": "<path>",
  "dry_run": false
}

Output Format

CSV filename: woo-stock-velocity-report_<YYYY-MM-DD>.csv Columns: product_id, sku, name, category, units_sold, lookback_days, velocity_per_day, stock_quantity, days_of_stock, classification, critical

Error Handling

ErrorCauseResolution
401 UnauthorizedInvalid credentialsVerify consumer_key and consumer_secret
403 ForbiddenKey lacks Read scopeRegenerate with Read scope
429 Too Many RequestsRate limitWait 2 seconds and retry

Best Practices

  • Run weekly to track velocity changes, especially during promotions or seasonal peaks.
  • Use critical flag to trigger immediate reorder — these products will stock out before your lead time.
  • Combine SLOW classification output with woo-dead-stock-identifier for comprehensive clearance planning.

More skills from navarroido

woo-cancel-and-restock logo
navarroido/Woocommerce-skill

woo-cancel-and-restock

Cancel one or many WooCommerce orders and restore stock quantities for all line items with dry-run preview.

7 0
View
woo-loyalty-segment-export logo
navarroido/Woocommerce-skill

woo-loyalty-segment-export

Read-only: Export customers meeting spend or order-count thresholds for loyalty program enrollment.

7 0
View
woo-order-status-bulk-update logo
navarroido/Woocommerce-skill

woo-order-status-bulk-update

Move a filtered set of orders (by date, current status, or payment method) to a new status with dry-run preview.

7 0
View
woo-variant-attribute-normalizer logo
navarroido/Woocommerce-skill

woo-variant-attribute-normalizer

Read-only: Find product variations where attribute values are inconsistently cased or spelled, and export a normalization report.

7 0
View
woo-product-tag-bulk-update logo
navarroido/Woocommerce-skill

woo-product-tag-bulk-update

Add or remove tags from a filtered set of products (by category, price range, or stock status) with dry-run preview.

7 0
View
woo-low-stock-restock-alert logo
navarroido/Woocommerce-skill

woo-low-stock-restock-alert

Read-only: Query products below a configurable stock threshold and export a prioritized reorder sheet grouped by category.

7 0
View
woo-product-data-completeness-score logo
navarroido/Woocommerce-skill

woo-product-data-completeness-score

Read-only: Score each product against a required fields checklist (images, description, weight, SKU, attributes) and export a completeness gap report.

7 0
View
woo-fulfillment-status-digest logo
navarroido/Woocommerce-skill

woo-fulfillment-status-digest

Read-only: Aggregate order counts by status and flag orders overdue for processing based on a configurable SLA age threshold.

7 0
View
woo-customer-spend-tier-tagger logo
navarroido/Woocommerce-skill

woo-customer-spend-tier-tagger

Segment customers into Bronze, Silver, and Gold tiers based on lifetime total_spent and write the tier as a customer meta field.

7 0
View
woo-bulk-order-notes logo
navarroido/Woocommerce-skill

woo-bulk-order-notes

Append a private or customer-visible note to multiple orders matching a status, date, or payment method filter.

7 0
View
woo-b2b-customer-overview logo
navarroido/Woocommerce-skill

woo-b2b-customer-overview

Read-only: Export customers with a B2B role or meta_data flag including order count, lifetime spend, and last order date.

7 0
View
woo-order-lookup-and-summary logo
navarroido/Woocommerce-skill

woo-order-lookup-and-summary

Read-only: Retrieve a WooCommerce order by ID or customer email and produce a human-readable support summary.

7 0
View

Popular AI tools

Kaiber logo
Video

Kaiber

Generate, edit, and beat-sync AI video with leading models in one workspace.

Paid
View
Vimcal logo
Productivity

Vimcal

The world's fastest calendar for remote work

Free
View

Transform Your Design with AI Designer by ImgCreator.ai

Freemium
View
Akool AI logo
Content & writing

Akool AI

Revolutionizing Video Production with AI-Powered Creativity

Paid
View

Extend an image past the frame and let AI fill the new aspect ratio.

Freemium
View
StarByFace logo
Security

StarByFace

Discover your celebrity doppelgänger with StarByFace!

Free
View
C

ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.

Freemium
View
Opus Clip logo
Coding & apps

Opus Clip

Opus.ai: Revolutionize Your Web Experience

Free
View