OpenParable
Skip to content
← Back to skills

Woocommerce Performance

Testing & Quality
woocommerce-performance

Woocommerce Performance is an Agent Skill for testing & quality published in the woocommerce/woocommerce repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Identify performance issues in WooCommerce PHP code. Use when writing or reviewing code that loads collections of post-based objects (products, orders), renders product lists with images, reads multiple options in a loop or method, or writes SQL queries involving joins, aggregates, meta lookups, or range queries.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/woocommerce/woocommerce/blob/HEAD/.ai/skills/woocommerce-performance/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/woocommerce-performance, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

WooCommerce Performance

Post Cache Priming — cache-priming.md

Use when writing or reviewing code that loads collections of post-based objects (products, orders) or renders product lists with images. Covers _prime_post_caches() usage patterns — both as a generation guide (apply these patterns when writing new code) and a review guide (flag missing priming in existing code).

Options Cache Priming — options-cache-priming.md

Use when writing or reviewing code that reads multiple non-autoloaded options in a loop or method. Covers wp_prime_option_caches() usage patterns for static key lists, derivable key patterns, and dynamically extracted key sets (excluding autoloaded options, which are already in cache).

SQL Query Patterns — sql-query-patterns.md

Use when writing or reviewing any SQL query in WooCommerce PHP code. Covers: redundant posts joins, fan-out JOIN on wp_term_relationships, N-query loops, OR index-merge, cross-product meta conditions, multi-fan join decoupling, WooCommerce lookup table preference (wc_product_meta_lookup, wc_product_attributes_lookup), and MIN/MAX full-scan elimination.