Stores information on actions that will be executed by Action Scheduler.
Logs Action Scheduler execution.
Stores customer session data, such as carts.
Stores API Keys used for the REST API.
Stores global attribute taxonomy names for products.
Stores product access permissions for downloadable products (granted
Stores line items which are associated with orders.
Stores meta data about order line items.
Stores tax rates you define in the admin area.
Stores locations (postcodes and cities) associated with the above tax rates.
Stores shipping zones you create in the settings area.
Stores locations associated with your shipping zones.
Stores shipping methods linked to your shipping zones.
Stores customer payment tokens (used by gateways).
Stores meta data about payment tokens.
General logging table (alternative to file based logging).
Stores any webhooks that have been setup on the store.
Logs user downloads of downloadable products.
Lookup table that indexes order meta data to speed up requests.
Stores tax classes data.
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:
- wp_posts and wp_postmeta store orders and products separated by a custom post type field called ‘orders.’
- In wp_posts and wp_postmeta, WordPress keeps much of its data, including pages, posts, menu entries, and more.
- Users data are stored in wp_users and wp_usermeta.