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 an ACF field on each product to list the different sizes of the products, eg. 60 x 120 cm. 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 data I entered into the custom field on the Edit Product page of each product.
How can I find this data from within phpMyAdmin? I may need quite specific instructions as I have already searched through wp_posts and wp_postmeta without success.
Thanks!