Web Development

How to Use WooCommerce

How To Use WooCommerce

Quick Links

  1. Documentation
  2. Video Tutorials

Troubleshoot

  1. How to Fix Common Issues
  2. How To Fix Error 403 WooCommerce Mobile App

Guide for WooCommerce Products

  1. How to add new product
  2. How to use product attributes
  3. Different Product Types
  4. About Taxanomies

WooCommerce Database Table  

  1. actionscheduler_actions
    Stores information on actions that will be executed by Action Scheduler.
  2. actionscheduler_claims
  3. actionscheduler_groups
  4. actionscheduler_logs
    Logs Action Scheduler execution.
  5. woocommerce_sessions
    Stores customer session data, such as carts.
  6. woocommerce_api_keys
    Stores API Keys used for the REST API.
  7. woocommerce_attribute_taxonomies
    Stores global attribute taxonomy names for products.
  8. woocommerce_downloadable_product_permissions
    Stores product access permissions for downloadable products (granted
    after purchase).
  9. woocommerce_order_items
    Stores line items which are associated with orders.
  10. woocommerce_order_itemmeta
    Stores meta data about order line items.
  11. woocommerce_tax_rates
    Stores tax rates you define in the admin area.
  12. woocommerce_tax_rate_locations
    Stores locations (postcodes and cities) associated with the above tax rates.
  13. woocommerce_shipping_zones
    Stores shipping zones you create in the settings area.
  14. woocommerce_shipping_zone_locations
    Stores locations associated with your shipping zones.
  15. woocommerce_shipping_zone_methods
    Stores shipping methods linked to your shipping zones.
  16. woocommerce_payment_tokens
    Stores customer payment tokens (used by gateways).
  17. woocommerce_payment_tokenmeta
    Stores meta data about payment tokens.
  18. woocommerce_log
    General logging table (alternative to file based logging).
  19. wc_webhooks
    Stores any webhooks that have been setup on the store.
  20. wc_download_log
    Logs user downloads of downloadable products.
  21. wc_product_meta_lookup
    Lookup table that indexes order meta data to speed up requests.
  22. wc_tax_rate_classes
    Stores tax classes data.
  23. wc_reserved_stock
    Stores reserved stock and is used to prevent race conditions during checkout.

WordPress and WooCommerce store orders, products, customer data, and other data like posts and pages:

  1. wp_posts and wp_postmeta store orders and products separated by a custom post type field called ‘orders.’
  2. In wp_posts and wp_postmeta, WordPress keeps much of its data, including pages, posts, menu entries, and more.
  3. Users data are stored in wp_users and wp_usermeta.

Related Posts