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.

 

  • Mie Minoru
    Posted at 01:29, 31 MarchReply

    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 !

    • Website tutorials
      Posted at 07:13, 31 MarchReply

      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.

Post A Comment

Anti-Spam Quiz: