WooCommerce Product Category SEO Title and Meta Description DB Table Location

  • Resolved bengriffiths

    (@bengriffiths)


    2 years, 7 months ago

    WordPress: Version 6.0.1
    Yoast SEO plugin: Version 19.5.1
    WooCommerce plugin: Version 6.7.0

    I have ~1,200 product categories for which I’d like to set custom SEO titles and Meta descriptions. I’d prefer not to have to edit these individually in the WooCommerce > Products > Categories section of WP.

    I’ve located the ‘wp_yoast_indexable’ table in my DB and set the SEO titles and Meta descriptions there. At first pass, this looks like a viable solution as they are reflected on the live site.

    However, when I navigate to each product category in the WP admin at WooCommerce > Products > Categories, those SEO titles and Meta descriptions that I set in the ‘wp_yoast_indexable’ DB table are not present in the Yoast SEO section.

    My question is: When SEO title and Meta description values are set via the WP admin for WooCommerce product categories, what table are those values saved to? And, at what point are those values then pushed to the ‘wp_yoast_indexable’ table?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello Bengriffiths,

    Thanks for reaching out regarding your WooCommerce metadata.

    Product categories and subcategories are stored in this table :

    wp_terms
wp_termmeta
wp_term_taxonomy
wp_term_relationships
wp_woocommerce_termmeta

    You can read more here.

    Furthermore, have you considered resetting the indexables and table and migrations? You may follow these steps:

    1. Install & activate the?Yoast Test Helper plugin
    2. Go to Tools > Yoast Test
    3. Locate the Yoast SEO section and click on the ‘Reset indexables tables & migrations’, ‘Reset Prominent words calculation’, and ‘Reset Internal link counter’ buttons. After each click, the page will reload to confirm that the specific reset was successful.
    4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your content.

    Then check the wp_yoast_indexable DB table again.

    Do let us know how it goes.

    This thread was marked resolved due to a lack of activity, but you’re always welcome to re-open the topic. Please read this post before opening a new request.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WooCommerce Product Category SEO Title and Meta Description DB Table Location’ is closed to new replies.