Skip to content
woo-low-stock-restock-alert logo

Woo Low Stock Restock Alert

woo-low-stock-restock-alert

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

SKILL.md

Full skill instructions

woo-low-stock-restock-alert

Purpose

Identify all WooCommerce products and variations with stock_quantity at or below a configurable threshold and export a prioritized reorder sheet. Groups results by category for easy routing to suppliers. Read-only — no stock data is modified.

Prerequisites

  • WooCommerce store with REST API enabled
  • Consumer Key with Read scope
  • Store management must track stock per product (manage_stock: true per product)
  • 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
thresholdintno5Stock quantity at or below which a product is flagged
include_out_of_stockboolnotrueInclude products with stock_quantity = 0
category_idintno—Limit to products in this category
include_variationsboolnotrueAlso check variations of variable products

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 products with low stock

GET /​wp-json/​wc/​v3/​products
  ?stock_status=instock&manage_stock=true&per_page=100&page=1
  [&category=<category_id>]

Filter client-side: keep products where stock_quantity <= threshold.

Also fetch out-of-stock products if include_out_of_stock: true:

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

Step 2 — Check variations (if include_variations: true)

For each variable product in the low-stock set:

GET /​wp-json/​wc/​v3/​products/​{id}/​variations?per_page=100&page=1

Add variations where manage_stock == true and stock_quantity <= threshold.

Step 3 — Fetch category names

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

Build category ID → name lookup.

Step 4 — Sort and export

Sort by stock_quantity ascending (most critical first), grouped by category.

API Endpoints Used

GET  /​wp-json/​wc/​v3/​products                      — list products with stock filter
GET  /​wp-json/​wc/​v3/​products/​{id}/​variations      — variation stock levels
GET  /​wp-json/​wc/​v3/​products/​categories           — category name lookup

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-low-stock-restock-alert      ║
║  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-low-stock-restock-alert   ║
║  RECORDS PROCESSED: <n>                  ║
║  OUTPUT: <filename>                      ║
╚══════════════════════════════════════════╝

COMPLETION (json format):

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

Output Format

CSV filename: woo-low-stock-restock-alert_<YYYY-MM-DD>.csv Columns: product_id, variation_id, sku, name, category, stock_quantity, stock_status, regular_price, low_stock_amount

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
Empty resultNo products below thresholdIncrease threshold or check manage_stock settings

Best Practices

  • Run daily before placing supplier orders to catch critical stock levels.
  • Set threshold to your average daily units sold × your supplier lead time in days.
  • Combine with woo-inventory-adjustment to post the restocked quantities after receiving.
  • Export the CSV directly to your purchasing team or ERP system.

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-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-return-initiation logo
navarroido/Woocommerce-skill

woo-return-initiation

Update order status to returned/refunded and log a timestamped note with return reason.

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