woo-weekly-store-reviewlisted
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