Do you want a tool that allows you to search WooCommerce products missing SEO metadata such as SEO titles or meta descriptions? You can use WP Sheet Editor to find products with empty SEO fields.
In this tutorial, we’ll show you how to find WooCommerce products missing Yoast SEO titles or meta descriptions and edit the missing metadata directly in a spreadsheet.
Important: We will use Yoast SEO, but it also works with Rank Math, SEO Press, All In One SEO, etc.
1. Install WP Sheet Editor – WooCommerce Products
We’ll use the WP Sheet Editor – WooCommerce Products plugin to search products with empty SEO metadata fields and update their SEO titles and meta descriptions.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
After installing and activating the plugin, go to WP Sheet Editor > Edit Products to open the products spreadsheet.
2. Open the WooCommerce Product Search Tool
Click Search on the spreadsheet toolbar to open the product search filters.
3. Search WooCommerce Products Missing SEO Titles or Meta Descriptions
Enable the Enable advanced filters checkbox to search products with empty Yoast SEO fields.
You can search for missing SEO titles or meta descriptions using the following settings.
Option A: Find WooCommerce Products Missing SEO Titles
To find products without a custom Yoast SEO title, configure the advanced search filters as follows:
- Field key: SEO Title (_yoast_wpseo_title)
- Operator: =
- Value: Leave empty
Click Run search to find products with an empty Yoast SEO title field.
Option B: Find WooCommerce Products Missing SEO Meta Descriptions
To find products without a custom Yoast SEO meta description, configure the advanced search filters as follows:
- Field key: SEO Description (_yoast_wpseo_metadesc)
- Operator: =
- Value: Leave empty
Click Run search to display products with an empty Yoast SEO meta description field.
4. Edit Missing WooCommerce SEO Titles and Meta Descriptions
WP Sheet Editor displays the products matching your search filters.
To update the missing SEO metadata:
- Locate the SEO Title or SEO Description column.
- Enter the SEO title or meta description for each product.
- Click Save to apply your changes.
You can edit multiple SEO titles and meta descriptions without opening each product individually.
You can also use AI to bulk generate WooCommerce SEO titles and meta descriptions for the products that need them.
Find and Update Missing WooCommerce SEO Metadata
With WP Sheet Editor – WooCommerce Products, you can search products missing SEO titles or meta descriptions using advanced filters and update the matching products directly in a spreadsheet.
You can also use the plugin to manage other WooCommerce product data, including prices, stock, categories, attributes, and descriptions.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features