I’m using Filemaker pro to view and manage my WordPress database and I’m trying to figure out the proper table relationship(s) for WooCommerce and other tables such as wp_posts. Does anyone have any experience with the mapping of which tables and fields?
For example, which woocommerce table and field would I map wp_post: ID to? etc…
Thank you in advanced.
Like most things in WordPress they are located in the tables;
posts AND postmeta
posts contain the single post and postmeta would contain all the posts fields and data, linked by post.id -> postmeta.post_id in a one to many relationship.
In the field posts.post_type you will see where things come from, a woocommerce product will have the “product” as content in the posts.post_type field.
That will be your link.
Hope this clears things for you…