Exercise 2: Where a Product's Data Actually Lives — Possible Solution ==================================================================== TITLE AND DESCRIPTION ------------------------------ Per this chapter, a product's title and description are stored exactly the way any post's title and content are stored: as columns on a row in the wp_posts table, with post_type set to 'product' instead of 'post' or 'page'. This is the direct result of WooCommerce calling register_post_type('product', ...) - the same registration mechanism WordPress Intermediate/Advanced 4 covered for any custom content type. PRICE AND SKU ------------------------------ Per this chapter, price, SKU, and stock quantity are not columns on wp_posts at all - they're stored as post meta, in the wp_postmeta table, keyed to the product's post ID. This is the identical mechanism WordPress Intermediate/Advanced 4 already covered for adding custom fields to any post type; WooCommerce doesn't invent a new storage mechanism for this data, it just uses a large, defined set of meta keys (like _price and _sku) on top of the existing system. THE TWO TABLES ------------------------------ wp_posts (title, description/content) and wp_postmeta (price, SKU, stock, and other product-specific fields). WHY THIS WORKS AS AN ANSWER ------------------------------ It correctly separates the two categories of product data, names the specific table each lives in, and explicitly ties both back to the exact custom-post-type and custom-field mechanisms already taught in WordPress Intermediate/Advanced 4, rather than treating WooCommerce's storage as something new.