WooCommerce
woo-product-lookup-integrity
Check WooCommerce product lookup integrity
Checks WooCommerce product lookup tables row by row, finds mismatch classes, confirms samples, and verifies approved repairs.
- Area
- WooCommerce
- Checked against
- WooCommerce 11.1.2, WordPress 7.1.2, Action Scheduler 4.0.0
- Last verified
- 29 September 2026
- Files
- SKILL.md, 7 references, 4 scripts
How it works
- 1Take the read-only report and record versions, settings, queues, indexes and mismatch classes.
- 2Rule out regenerations or queued lookup work before judging rows.
- 3Review meta and attribute mismatch classes from the report.
- 4Confirm representative products with
lookup-product-diff.php. - 5Trace each confirmed class to its likely cause before proposing repairs.
- 6Apply one approved repair on staging, then repeat the same checks.
- 7Repeat verified changes on production with separate backups and report the result.
Use it when
- Check wrong attribute filters, price filters or product sorting.
- Audit lookup tables after imports, migrations or direct database edits.
- Verify either lookup table before and after regeneration.
- Investigate a short or empty attributes lookup table.
How it stays safe
- Starts with read-only helpers, SQL and WP-CLI checks that need no approval.
- Tests repairs on a restored staging copy before repeating approved steps on production.
- Takes a restorable backup before each write and states its check and undo.
- Waits for owner approval before each write, one step at a time.
Install it
Copy the whole woo-product-lookup-integrity folder into your agent's skills folder, not only SKILL.md.
git clone --depth 1 https://github.com/hamzaahmadaslam/agent-skills.git
cp -R agent-skills/woo-product-lookup-integrity "<your agent's skills folder>/"