Skip to content
woo-product-cross-sell-analysis logo

Woo Product Cross Sell Analysis

woo-product-cross-sell-analysis

Read-only: Identify products most frequently purchased together in the same order.

SKILL.md

Full skill instructions

woo-product-cross-sell-analysis

Purpose

Analyse WooCommerce completed orders to find product pairs that appear together most frequently. Surfaces natural cross-sell and bundle opportunities based on real purchase behavior. Read-only.

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
date_afterstringyes—Start date (YYYY-MM-DD)
date_beforestringyes—End date (YYYY-MM-DD)
min_co_occurrencesintno5Only report pairs appearing together at least this many times
top_nintno20Number of top product pairs to return

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 range

GET /​wp-json/​wc/​v3/​orders
  ?status=completed&after=<date_after>T00:00:00Z&before=<date_before>T23:59:59Z&per_page=100&page=1

For each order, extract the list of product_id values from line_items.

Step 2 — Build co-occurrence matrix

For each order with 2+ line items, generate all unique product ID pairs (combinations, not permutations). Increment the pair's counter.

for each order:
  product_ids = [item.product_id for item in order.line_items]
  for each pair (A, B) where A < B:
    co_occurrence[A][B] += 1

Step 3 — Filter and rank

Filter pairs with count < min_co_occurrences. Sort descending by co-occurrence count. Take top top_n.

Step 4 — Enrich with product names

GET /​wp-json/​wc/​v3/​products?include=<id1,id2,...>&per_page=100

Map product IDs to names.

Step 5 — Export

API Endpoints Used

GET  /​wp-json/​wc/​v3/​orders     — line items for co-occurrence analysis
GET  /​wp-json/​wc/​v3/​products   — product names for enrichment

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-product-cross-sell-analysis  ║
║  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-product-cross-sell-analysis║
║  RECORDS PROCESSED: <n>                  ║
║  OUTPUT: <filename>                      ║
╚══════════════════════════════════════════╝

COMPLETION (json format):

{
  "skill": "woo-product-cross-sell-analysis",
  "store": "<store_url>",
  "completed_at": "<ISO-8601>",
  "records_processed": <n>,
  "output_file": "<path>",
  "dry_run": false
}

Output Format

CSV filename: woo-product-cross-sell-analysis_<YYYY-MM-DD>_<YYYY-MM-DD>.csv Columns: product_a_id, product_a_name, product_b_id, product_b_name, co_occurrence_count, product_a_total_orders, product_b_total_orders, lift

Where lift = co_occurrence / (product_a_total_orders * product_b_total_orders / total_orders) — values > 1 indicate stronger-than-random association.

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
Low pair countsDate range too short or low order volumeExtend date_after/date_before range

Best Practices

  • Use lift > 1.5 as the threshold for actionable cross-sell pairs — high co-occurrence alone can reflect popular products, not true affinity.
  • Feed top pairs into WooCommerce product cross-sells via the product editor to surface recommendations at cart.
  • Run quarterly — purchase patterns shift with seasonal inventory changes.

More skills from navarroido

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-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