WooCommerce Finding the products in database

Question

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

User · Accepted Answer

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 lookuptable 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  wp term relationships - column object id as relational index  the product ID   wp woocommerce termmeta  wp woocommerce attribute taxonomies  for product attributes only   wp wc category lookup  for product categories hierarchy only since WooCommerce 3 7     Product types are handled by custom taxonomy product type with the following default terms   simple grouped variable external  Some other product types for Subscriptions and Bookings plugins   subscription variable-subscription booking   Since Woocommerce 3  a new custom taxonomy named product visibility handle   The product visibility with the terms exclude-from-search and exclude-from-catalog The feature products with the term featured The stock status with the term outofstock The rating system with terms from rated-1 to rated-5  Particular feature  Each product attribute is a custom taxonomy     References   Normal tables  Wordpress database description Specific tables  Woocommerce database description

User · Answer

I would recommend using WordPress custom fields to store eligible postcodes for each product  add post meta   and update post meta are what you re looking for  It s not recommended to alter the default WordPress table structure  All postmetas are inserted in wp postmeta table  You can find the corresponding products within wp posts table

User · Answer

Bulk add new categories to Woo   Insert category id  name  url key  INSERT INTO wp terms  VALUES    57   Apples    fruit-apples    0       58   Bananas    fruit-bananas    0      Set the term values as catergories  INSERT INTO wp term taxonomy  VALUES    57  57   product cat       17  0      58  58   product cat       17  0    17 - is parent category  if there is one  key here is to make sure the wp term taxonomy table term taxonomy id  term id are equal to wp term table s  term id  After doing the steps above go to wordpress admin and save any existing category  This will update the DB to include your bulk added categories

User · Answer

The following tables are store WooCommerce products database     wp posts -  The core of the WordPress data is the posts  It is stored a post type like product or variable product  wp postmeta-  Each post features information called the meta data and it is stored in the wp postmeta  Some plugins may add their own information to this table like WooCommerce plugin store product id of product in wp postmeta table    Product categories  subcategories stored in this table     wp terms wp termmeta wp term taxonomy wp term relationships wp woocommerce termmeta   following Query Return a list of product categories  SELECT wp terms        FROM wp terms      LEFT JOIN wp term taxonomy ON wp terms term id   wp term taxonomy term id     WHERE wp term taxonomy taxonomy    product cat        for more reference -         Database Description   Fetch the Products of Woocommerce from it   s Table in Database

[mysql] WooCommerce: Finding the products in database

Examples related to mysql

Examples related to database

Examples related to wordpress

Examples related to woocommerce

Examples related to product