WooCommerce: Finding the products in database

soup_sam

I'm creating a website using WooCommerce and I want to restrict the available products to users depending on the postcode that they enter in the search form on my home page. To be able to achieve that I'll have to specify the conditions of each product within the database in phpMyAdmin, but I can't seem to find it. Does anybody know where the woocommerce database for products and/or categories are within phpmyAdmin? Thank you in advance.

Originally asked by T.Doe on Stack Exchange (stackoverflow) (CC BY-SA 3.0).

uphilltech

Great question — answering as the UphillTech team:

Update 2020 Products are located mainly in the following tables: wp_posts table with post_type like product (or product_variation ), wp_postmeta table with post_id as relational index (the product ID). wp_wc_product_meta_lookup table with product_id as relational index (the post ID) | Allow fast queries on specific product data (since WooCommerce 3.7) wp_wc_order_product_lookup table with product_id as relational index (the post ID) | Allow fast queries to retrieve products on orders (since WooCommerce 3.7) Product types, categories, subcategories, tags, attributes and all other custom taxonomies are located in the following tables: wp_terms wp_termmeta wp_term_taxonomy...

Full answer by LoicTheAztec: https://stackoverflow.stackexchange.com/a/36973435 (CC BY-SA 3.0).

Need it done for your business? UphillTech.