← ClaudeAtlas

woo-weekly-store-reviewlisted

Turns a WooCommerce orders CSV export into a weekly store review — revenue, orders, AOV, problem orders (cancelled/failed/refunded), top products, COD vs online payment split, and 3–5 data-referenced actions for the coming week. Use when the user says "here's my orders export, how is my store doing", "weekly store report", "review my WooCommerce orders", "what happened in my store this week", "what should I fix in my shop".
t-nguyen2107/winsols-free-skills · ★ 0 · Data & Documents · score 72
Install: claude install-skill t-nguyen2107/winsols-free-skills
# WooCommerce Weekly Store Review Drop in your orders export, get the week on one page: what sold, what broke, how people paid, and the 3–5 things to do next week. Numbers come from the file only — nothing invented. ## When to use - The user shares a WooCommerce orders CSV (or pasted table) and asks how the store is doing, for a weekly review, or what to fix. - Comparing this week against last week when the export covers both. ## Inputs 1. **The orders export** — CSV file path or pasted text (WooCommerce → Orders → export, or a plugin export). 2. Optional: currency (auto-detect: values ≥ 100,000 with no decimals → likely VND; a `currency` column wins; ask only if still ambiguous). 3. Optional: which week is "this week" (default: the most recent 7 days of data in the file — use the data's max date, NOT today's date, so stale exports still review correctly). ## Column detection (case-insensitive, partial match) | Need | Accepts | |---|---| | Order ID | `order number`, `order_id`, `id`, `#` | | Date | `order date`, `date_created`, `date`, `paid date` | | Status | `status` | | Total | `order total`, `total`, `amount`, `grand total` | | Payment | `payment method`, `payment_method`, `gateway`, `paid via` | | Items | `items`, `item names`, `products`, `skus` | Report what could NOT be detected instead of guessing. Parse totals with commas stripped; statuses lowercased. ## Process 1. **Week split**: current week = last 7 days ending at the data's max date; prior week = the