DB structure of woocommerce

Tables of woocommerce

wc_download_log

No data


wc_webhooks

No data


woocommerce_api_keys

No data


woocommerce_attribute_taxonomies

No data


woocommerce_downloadable_product_permissions

No data


woocommerce_log

No data


woocommerce_order_itemmeta

No data


woocommerce_order_items

No data


woocommerce_payment_tokenmeta

No data


woocommerce_payment_tokens

No data


woocommerce_sessions

No data


woocommerce_shipping_zone_locations

After setting up


woocommerce_shipping_zone_methods

Data


woocommerce_shipping_zones

After setting up


woocommerce_tax_rate_locations

No data


woocommerce_tax_rates

No data


Change to existing tables

options

mysql> select option_id, option_name, substring(option_value, 1,50), autoload from bdroptions where option_name not like “%transient%” and option_id >140;


posts

select * from bdrposts where id > 4;


usermeta

select * from bdrusermeta where umeta_id > 20;


terms

栗田 創 (Hajime Kurita): Search Engineer/AWS Solution Architect/Professional Scrum Master/Web Master

I am using Twitter for announcing updates and my thought, so if you are interested in my articles, please follow me on twitter.