Where is the product Shipping class stored?

  • Resolved carmaine

    (@carmaine)


    10 years, 1 month ago

    Hi! I need to check if all our products has a product shipping class assigned and would like to run a SQL query. Unfortunately I can’t seem to find which table and column it may be found. I’ve tried to do a %like% query already in the meta_key and meta_value of wp_postmeta but I was not successful. I hope someone could perhaps give me a tip to the right direction?

    https://wordpress.org/plugins/woocommerce/

Viewing 1 replies (of 1 total)
  • Thread Starter carmaine

    (@carmaine)

    10 years, 1 month ago

    Never mind, I found it.

    The product_shipping_class is in nor_term_taxonomy table and the products can be found in nor_term_relationships.

Viewing 1 replies (of 1 total)
  • The topic ‘Where is the product Shipping class stored?’ is closed to new replies.