Because, orders/products are not generated as different variables needing their own tables,
they are basically generated using standard WordPress functionality known as “Custom Post Types”,
therefore they are all stored in the “xxx_posts” table of WordPress database.
Thank you for your help. However, I still have a problem.
I found a wp_posts table, thanks to you help. However, there is nothing there more=recent than 2/5/2015, even though there have been orders received since then.
How come?
You have search a bit more about “Custom Post Types”.
Becuse in WooCommerce, it is not stored in only one table.
In the “_posts” table,
the ones in “post-type” column having the “shop_order” value,
they represents the ORDERS.
That ID is the Order-ID,
And the order details are stored in other tables,
woocommerce_order_itemmeta
woocommerce_order_items
using that Order-Id.
ALl those tables used related to each other…
Thank you again, Manus, for your valuable help.
That info is helpful. I guess I’ll need to write a query pulling from several tables to get what I’m looking for.
what tables do I need to get at the Products? Is there an active/inactive field somewhere? If not, how can I make an active product inactive, or vice versa? How can I change the inventory counts using a flat file import?
You may active or inactive a product in different ways or both.
1.) In “posts” table set the “post_status” to “inactive” or publish to activate the product.
2.)Using “postmeta” table set the “_visibility” to visible if active or something else for inactive. Also you may set the “_stock_status” to out of stock and/or “_stock” to 0.
