WooCommerce DataBase
Let’s see some of the tables that WooCommerce uses in it’s database.
wp_woocommerce_order_items
This is the table that your order details for each user are stored.
order_id
Each order is given a unique order ID. So, the rows in the table that have the same ID, all refer to the same order.
order_item_type
This field can take 2 values, line_item and shipping. Thev value line_item indicates that this order row refers to a product in the order while the value shipping indicates that this order row refers to the shipping method of the order.
order_item_name
If order_item_type has the value of line_item, then this field takes the name of the product.
If order_item_type has the value of line_item, then this field takes the name of the shipping method (eg. Free Shipping).
wp_woocommerce_order_itemmeta
This is the table that the meta data for each one of your rows in the wp_woocommerce_order_items are stored.
Post A Comment
Where can I find the table of price details, products and users name,password, id so I can fetch this these data from WordPress database and use jquery mobile to login, order, etc. Thank you !
I think that you should not mess with the database directly, you can use the default WordPress functions to get everything you need. You can look here or here for more info on using jQuery mobile with WordPress.