Quick Links
Troubleshoot
Guide for WooCommerce Products
Here’s a full list of fields in the array passed to woocommerce_checkout_fields:
- Billing
billing_first_namebilling_last_namebilling_companybilling_address_1billing_address_2billing_citybilling_postcodebilling_countrybilling_statebilling_emailbilling_phone
- Shipping
shipping_first_nameshipping_last_nameshipping_companyshipping_address_1shipping_address_2shipping_cityshipping_postcodeshipping_countryshipping_state
- Account
account_usernameaccount_passwordaccount_password-2
- Order
order_comments
Each field contains an array of properties:
type– type of field (text, textarea, password, select)label– label for the input fieldplaceholder– placeholder for the inputclass– class for the inputrequired– true or false, whether or not the field is requireclear– true or false, applies a clear fix to the field/labellabel_class– class for the label elementoptions– for select boxes, array of options (key => value pairs)
In specific cases you need to use the woocommerce_default_address_fields filter. This filter is applied to all billing and shipping default fields:
countryfirst_namelast_namecompanyaddress_1address_2citystatepostcode
WooCommerce Database Table
- actionscheduler_actions
Stores information on actions that will be executed by Action Scheduler. - actionscheduler_claims
- actionscheduler_groups
- actionscheduler_logs
Logs Action Scheduler execution. - woocommerce_sessions
Stores customer session data, such as carts. - woocommerce_api_keys
Stores API Keys used for the REST API. - woocommerce_attribute_taxonomies
Stores global attribute taxonomy names for products. - woocommerce_downloadable_product_permissions
Stores product access permissions for downloadable products (granted
after purchase). - woocommerce_order_items
Stores line items which are associated with orders. - woocommerce_order_itemmeta
Stores meta data about order line items. - woocommerce_tax_rates
Stores tax rates you define in the admin area. - woocommerce_tax_rate_locations
Stores locations (postcodes and cities) associated with the above tax rates. - woocommerce_shipping_zones
Stores shipping zones you create in the settings area. - woocommerce_shipping_zone_locations
Stores locations associated with your shipping zones. - woocommerce_shipping_zone_methods
Stores shipping methods linked to your shipping zones. - woocommerce_payment_tokens
Stores customer payment tokens (used by gateways). - woocommerce_payment_tokenmeta
Stores meta data about payment tokens. - woocommerce_log
General logging table (alternative to file based logging). - wc_webhooks
Stores any webhooks that have been setup on the store. - wc_download_log
Logs user downloads of downloadable products. - wc_product_meta_lookup
Lookup table that indexes order meta data to speed up requests. - wc_tax_rate_classes
Stores tax classes data. - 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:
- 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.
