Question About WooCommerce Database Structure

  • Resolved ventio

    (@ventio)


    1 year, 4 months ago

    Hi,

    I have noticed that my database contains the following tables:

    wp_wc_admin_notes
    wp_wc_admin_note_actions
    wp_wc_category_lookup
    wp_wc_customer_lookup
    wp_wc_download_log
    wp_wc_orders
    wp_wc_orders_meta
    wp_wc_order_addresses
    wp_wc_order_coupon_lookup
    wp_wc_order_operational_data
    wp_wc_order_product_lookup
    wp_wc_order_stats
    wp_wc_order_tax_lookup
    wp_wc_product_attributes_lookup
    wp_wc_product_download_directories
    wp_wc_product_meta_lookup
    wp_wc_rate_limits
    wp_wc_reserved_stock
    wp_wc_tax_rate_classes
    wp_wc_webhooks

    and

    wp_woocommerce_api_keys
    wp_woocommerce_attribute_taxonomies
    wp_woocommerce_downloadable_product_permissions
    wp_woocommerce_log
    wp_woocommerce_order_itemmeta
    wp_woocommerce_order_items
    wp_woocommerce_payment_tokenmeta
    wp_woocommerce_payment_tokens
    wp_woocommerce_sessions
    wp_woocommerce_shipping_zones
    wp_woocommerce_shipping_zone_locations
    wp_woocommerce_shipping_zone_methods
    wp_woocommerce_tax_rates
    wp_woocommerce_tax_rate_locations

    Does your plugin utilize all these tables?

    Additionally, I have noticed that no new data has been added to the wp_wc_customer_lookup table for the past few months. Is this expected behavior?

    Thanks in advance for your help!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Zee

    (@doublezed2)

    1 year, 4 months ago

    Hello ventio,

    Thank you for contacting WooCommerce support.

    I understand you’re asking whether WooCommerce utilizes all the tables listed and why no new data has been added to the wp_wc_customer_lookup table in recent months.

    WooCommerce uses these tables for managing orders, products, and other functionalities.
    These tables are required for WooCommerce to function properly.

    wp_wc_customer_lookup table stores customer data for reports and is populated when an order is placed or updated. If there have been no new orders or updates to existing ones, the table might not change.

    Are you facing any issues or seeing any errors?
    I am trying to confirm if there is a problem we need to resolve.

    Looking forward to your response. 🙂

    Plugin Support Feten L. a11n

    (@fetenlakhal)

    1 year, 4 months ago

    Hi,

    I’ll close this out since we haven’t heard from you, but we’re always here if you need any assistance!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Question About WooCommerce Database Structure’ is closed to new replies.