How to find Woocommerce Product Additional Information in the database?

  • Resolved simon1970

    (@simon1970)


    2 months ago

    I’m working on a WordPress website that has lots of Woocommerce products. I can’t add a link to the site because the site is not live at the moment. I use the Product Additional Information section to list the different sizes of the products. I just noticed that I have made a mistake with many of the sizes and need to make the same change to a large number of products. I was going to write some code to do this task but firstly I need to find this data in the database, but I can’t find it. I’ve searched online but can’t find the answer. I’ve searched through wp_posts and wp_postmeta but it doesn’t seem to be there.

    To be clear, I’m searching for a block of text/html in the WordPress database that includes the Product Additional Information that I added in the Edit Product page of each product. Where can I find this data?

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Stef

    (@serafinnyc)

    Hi @simon1970

    The Additional Information section is stored in the wp_postmeta table. The relevant meta_key is _product_attributes and it is linked to the product’s post ID or post_id

    Thread Starter simon1970

    (@simon1970)

    @serafinnyc Hi Stef, thank you for your reply. I just realised that the Product Additional Information on my website is a field that I added using a plugin called Advanced Custom Fields. This must be why I can’t find the data in the database. Would you happen to know where I could find the data for that plugin in the database?

    Thanks.

    Stef

    (@serafinnyc)

    That would definitely cause a riff ???? Glad you found it @simon1970

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi @simon1970,

    ?I just realised that the Product Additional Information on my website is a field that I added using a plugin called Advanced Custom Fields.

    For reference, this particular forum is meant for general support with the core functionality of WooCommerce itself.?In order to get assistance with third-party plugins, I recommend reaching out to their plugin support for further assistance, as they stand a better chance at knowing where to find the information from their plugin.

    I hope this gets you going.

    Thread Starter simon1970

    (@simon1970)

    Thank you, I have now found the data I was looking for by searching the entire database for a specific string. The data was stored in the wp_postmeta table with a meta_key of ‘dimensions’.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.