Inquiry about WooCommerce Order Data Storage

  • Could you please clarify if WooCommerce automatically records all order-related data in the database when an order is placed on the website? Additionally, where is this database located? Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    I recommend asking at https://www.ads-software.com/support/plugin/woocommerce/#new-post so the plugin’s developers and support community can help you with this.

    Hello there,

    To reply to your questions, yes – WooCommerce records all order data, here are the primary database tables involved in storing order information:

    1. wp_posts Table: Each order is stored as a post of type shop_order. This table holds the basic order information, including the order ID, status, date, and other metadata.
    2. wp_postmeta Table: This table stores the order meta-data. It includes details like billing and shipping information, payment method, order total, and any custom data related to the order.
    3. wp_woocommerce_order_items Table: This table stores individual items associated with each order, such as the products purchased in the order.
    4. wp_woocommerce_order_itemmeta Table: This table stores meta-data for each order item, including product IDs, quantities, tax data, and other item-specific details.
    5. wp_woocommerce_payment_tokens and wp_woocommerce_payment_tokenmeta Tables: These tables store payment token information if the site uses saved payment methods.

    The WooCommerce data is stored in the same database as the rest of the WordPress site. Database defined in the wp-config.php file.

    We hope you find this answer helpful, cheers.

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.