The yellow wp_posts row highlights how the Widget-1 Product custom post type anchors the WooCommerce database schema In the previous post, we initially considered candidate attributes for Product table by analyzing the output of the Product Export facility provided by WooCommerce. We used the Woo Add a Product panel and saw how WooCommerce divides Products … Continue reading Designing the Product Table
SB model v2 In the previous section, we discovered that a Woocommerce Product instance is by default a “Simple Product.” We also learned that three other Product types are available: a) Grouped productb) External/Affiliate productc) Variable product Any of these four Product types can optionally be “virtual” or “downloadable," which are in effect a subtype of … Continue reading Refining the Woo Pricing Analytics Model
Figure 1 Summary: This is the second article in a series of posts about the process of building a simple WP plug-in that implements a temporal DSS database for users of WooCommerce. In the previous post, we “wireframed” a data model that shows the objects of potential interest to this application. At this point, excitement … Continue reading A Closer Look at Woo Products
In case you didn’t already know this: Woo uses a hybrid quasi-relational / EVA NoSQL data model. It is implemented on top of WP's underlying, equally non-relational meta schema, which runs atop MySQL or MariaDB. The WP data model was designed initially to provide data persistence to an early CMS system. It allowed the addition of … Continue reading WooCommerce Exposed!