Connectors

/

WooCommerce

/

Audit the WooCommerce product catalog
Report

Find the WooCommerce catalog errors that cost sales

For ecommerce teams who want missing SKUs, bad prices and negative stock found across the WooCommerce catalog by their AI assistant.

Try PopdockAI free
Get a live demo
Audit the WooCommerce product catalog
Audit our WooCommerce product catalog for data problems.
I found 41 catalog problems across 612 products and variations. - Duplicate SKUs: 4 pairs, including TSHIRT-BLK-M - No price: 6 simple products - Sale price over regular: 3 variations - Negative stock: 5 products, including Contoso travel mug - Unused: 7 categories and 12 tags Want the examples and fixes for each rule?
WooCommerce
Sample figures. Your results come from your own account.
woocommerce-get-product
woocommerce-get-product-variation
woocommerce-get-product-category
woocommerce-get-product-tag
woocommerce-get-product-attribute
woocommerce-get-product-attribute-term

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

WooCommerce

WooCommerce
Run it on your own WooCommerce data.

Connect WooCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Catalog errors that quietly cost sales

A WooCommerce catalog collects errors over time: missing and duplicate SKUs, products with no price, bad sale prices and negative stock. Each one costs sales or breaks an integration, but finding them means paging through every product and variation.

Without PopdockAI

  • Page through every product and variation
  • Check SKUs, prices and stock by eye
  • Look for unused categories, tags and terms
  • Find the error when an order fails

With PopdockAI

  • Products and variations are read, with categories and terms for a full audit
  • SKU, price, stock and category rules are applied
  • Findings are grouped by rule, most harmful first
  • It is read-only and warns when results may be truncated

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Audit the WooCommerce product catalog for data problems and report them grouped by rule. If `{category}` is given, only audit products in categories whose name contains it.

**Step 1: Pull the catalog**

* `woocommerce-get-product` with `max-records` 2000, and `categories.contains` = `{category}` when given.
* `woocommerce-get-product-variation` with `max-records` 5000. When `{category}` is given, keep only variations whose `product-id` is in the product set.
* Only when `{category}` is empty: `woocommerce-get-product-category`, `woocommerce-get-product-tag`, `woocommerce-get-product-attribute`, and for each attribute `woocommerce-get-product-attribute-term` with `product-attribute-id`.

**Step 2: Apply the rules**

Products and variations:

* **No SKU** on a published product or variation.
* **Duplicate SKU:** the same `sku` on two products, two variations, or a product and a variation.
* **No price:** `regular-price` empty or 0 on a published `simple` product or a published variation.
* **Bad sale price:** `sale-price` equal to or above `regular-price`.
* **Negative stock:** `stock-quantity` below 0.
* **Uncategorized:** `categories` empty or only "Uncategorized".
* **Variable with no variations:** a `variable` product with no variation rows.
* **Not published:** `draft`, `pending` or `private` products. List them without calling them wrong.

Taxonomy (whole store only):

* Categories with `number-of-products` 0.
* Tags and attribute terms with `count` 0.

**Step 3: Report**

1. A count per rule.
2. One section per rule, most harmful first (duplicate SKU, no price, bad sale price, negative stock, then the rest): up to 20 examples each with name, SKU, id and the problem, plus "and N more".
3. Suggested fixes. Point price and stock fixes at the update-product-by-sku prompt.

**Rules & Guidelines:**

* This prompt is read-only. Do not call any write tool: `woocommerce-add-order`, `woocommerce-update-order`, `woocommerce-add-order-note`, `woocommerce-send-order-details`, `woocommerce-add-refund`, `woocommerce-add-customer`, `woocommerce-update-customer`, `woocommerce-add-product`, `woocommerce-update-product`, `woocommerce-update-product-variation`, `woocommerce-add-coupon`, `woocommerce-update-coupon`.
* Pass `max-records` explicitly (500 unless stated otherwise). If a read returns exactly that many rows, say the result may be truncated and that totals are a lower bound.
* `grouped` and `external` products have no price of their own. Do not flag them under "No price".

**Validation:**

* If no products match `{category}`, list the closest category names from `woocommerce-get-product-category` with `name.contains` and stop.
* If the catalog is empty, say so and stop.

Who it's for

One answer, three teams that use it

Ecommerce managers

Fix the errors that lose orders

Get missing prices, bad sale prices and negative stock at the top of the list, with examples and fixes.

Audit the WooCommerce catalog and show me products with no price or a sale price above the regular price.

Integration specialists

Find SKU problems before they break syncs

Missing and duplicate SKUs are flagged, so integrations that match on SKU keep working.

Which WooCommerce products or variations have missing or duplicate SKUs?

Catalog managers

Tidy categories and tags

Uncategorized products and unused categories, tags and terms are listed for clean up.

Audit the Outdoor category in WooCommerce for data problems.

How it works

What PopdockAI does when you ask

You can name a category or audit the whole store, and your AI assistant checks every product against clear rules. It suggests fixes and changes nothing.

01

Ask

You optionally name a category.

Your AI tool

02

Read

It reads products and variations, plus categories, tags and terms for a full audit.

woocommerce-get-product
woocommerce-get-product-variation
woocommerce-get-product-category
woocommerce-get-product-tag
woocommerce-get-product-attribute
woocommerce-get-product-attribute-term

03

Check

It applies rules for SKUs, prices, stock and categorization.

No items found.

04

Report

You get findings by rule with examples and suggested fixes.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for WooCommerce and one secure connection to your AI tool. No code, no exports.

get-data

woocommerce-get-product

Returns WooCommerce products with prices, stock, status, categories, total sales and average rating. Filter by SKU, name, category, type, status, stock status, price range or a low stock threshold.
get-data

woocommerce-get-product-variation

Returns the variations of WooCommerce variable products with SKU, prices, sale flag and stock. Filter by parent product, SKU, status, stock status, price range, on sale or a low stock threshold.
get-data

woocommerce-get-product-category

Returns WooCommerce product categories with their parent category and number of products. Filter by name, slug, id or parent category.
get-data

woocommerce-get-product-tag

Returns WooCommerce product tags with how many products use each. Filter by name or slug.
get-data

woocommerce-get-product-attribute

Returns the global product attributes defined in WooCommerce, such as Color or Size. Filter by name or slug.
get-data

woocommerce-get-product-attribute-term

Returns the terms of WooCommerce product attributes, such as Red or Large, with how many products use each. Filter by attribute id or name and term name.
Read only.Nothing in WooCommerce Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Costly catalog errors found in one sweep

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation