Products Missing from Your Feed?

You generated your feed, but some products are not showing up — or the feed has fewer products than your store actually has. This is one of the most common issues CTX Feed users run into, and in most cases, it is caused by a single setting called Product Query Type.

This guide explains what that setting does, how to change it, and what to check if products are still missing after the fix.

Video Tutorial — Watch Before You Start

This short video walks through the full fix. Watch it first so you know exactly what to look for, then use the written steps below as a reference.

Why Are Products Missing?

WooCommerce stores products in two different ways behind the scenes — using the older WordPress post system and the newer custom database tables. CTX Feed uses a setting called Product Query Type to decide which system it reads from when building your feed.

If this setting is pointed at only one system, and some of your products live in the other system, those products will not be found — and will not appear in the feed. This is not a bug. It is simply the plugin looking in one place when the products are stored in another.

What does each Product Query Type do?

WP Query

Reads products using the WordPress post system

This is the traditional method. Works well for most stores but can miss products stored in WooCommerce’s newer custom database tables (used by HPOS — High-Performance Order Storage — and newer WooCommerce versions).

SQL Query

Reads products directly from the database

Faster in large stores. Works well when all products use the newer WooCommerce storage system. Can miss products that are still stored using the older WordPress post system.

Both

Reads from both systems — recommended for missing products

CTX Feed checks both the WordPress post system and the WooCommerce database tables. This catches every product regardless of how WooCommerce is storing it. Use this setting when products are missing.

The Fix: Change Product Query Type to “Both”

1. Go to CTX Feed Settings

This is where the Product Query Type setting lives

• In your WordPress dashboard, go to CTX Feed → Settings.

2: Find “Product Query Type” and set it to “Both.”

This is the key setting that fixes missing products

• On the Settings page, look for the Product Query Type option. It is usually near the top of the page.
• You will see a dropdown with three options: WP Query, SQL Query, and Both. Select Both.
• Click Save Settings (or Save Changes) at the bottom of the page.

3. Re-generate your feed

The new setting only takes effect after the feed is rebuilt

• Go to CTX Feed → Manage Feeds and find the feed that was missing products. Click Update Feed to rebuild it with the new query setting.
• After the feed finishes updating, open the feed preview and check whether the missing products now appear. In most stores, this step alone will fix the issue completely.

✅ Check the product count
After regenerating, compare the number of products in your feed with the total number of published products in WooCommerce. They should now match (or be very close, depending on your filters).

Products Still Missing? Check These Things

If some products are still not showing up after changing the query type, one of these is likely the cause:

• Product is not published
  CTX Feed only includes products with a Published status in WooCommerce. Draft, pending, or private products are not included. Go to WooCommerce → Products and check the product’s status.
• Product is excluded by a filter
  If you have set up product filters in CTX Feed (for example, filtering by category, tag, or stock status), those filters might be removing the product. Go to your feed settings and check the Filter Products section. Remove or adjust filters and regenerate the feed.
• Product is out of stock and stock filtering is on
  Some channels require in-stock products only. If you have a filter set to only include In Stock products, out-of-stock products will not appear. Check your stock status filter in the feed settings.
• Product is a variation without a visible parent
  Individual product variations only show up in the feed if their parent variable product is published. If the parent is hidden or draft, the variations will not appear either.
• Product is missing a required field
  Some channels (like Google Shopping) skip products that are missing required data — such as a price, image, or GTIN. Check the feed preview for any validation errors next to the affected products.
• Feed was not regenerated after the settings change
  The query type change only applies the next time the feed is built. If you saved the settings but did not click Update Feed, the feed still uses the old query. Go to Manage Feeds and rebuild it.

💡 Still stuck? If you have checked all of the above and products are still missing, reach out to the CTX Feed support team with the name of a specific product that should be in the feed but is not. That gives the support team exactly what they need to diagnose the issue quickly.