Title: Woocommerce database
Last modified: August 22, 2016

---

# Woocommerce database

 *  [cstack](https://wordpress.org/support/users/cstack/)
 * (@cstack)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/woocommerce-database/)
 * Hey there…okay, I am attempting to make my own shopping cart (actually it’s already
   made but in plain html) and have it populate and function dynamically like it’s
   supposed. I’ll be using woocommerce/wp as the backend CMS for all the items but
   I want the changes to reflect into my site. Question is – what tables in particular
   are involved with the shopping cart images/desc/etc.. as well as the woocommerce
   products. I am somewhat familiar with PHP/sql so I understand connecting to the
   wp-database – I just don’t know what statements will retrieve the information
   I need regarding the products/shopping cart products. I want my site to be fully
   functional as my wordpress shopping cart is. I appreciate the help very much.
 * Thank you,
    Casey
 * [https://wordpress.org/plugins/woocommerce/](https://wordpress.org/plugins/woocommerce/)

Viewing 1 replies (of 1 total)

 *  [Peter Lawrenson](https://wordpress.org/support/users/lorro/)
 * (@lorro)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/woocommerce-database/#post-5249734)
 * A product is a type of the post object, so products are in the wp_posts table,
   where the post_type field is set to “product”. Extra bits of data that don’t 
   fit in a post record go into the wp_postmeta table.

Viewing 1 replies (of 1 total)

The topic ‘Woocommerce database’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 1 reply
 * 2 participants
 * Last reply from: [Peter Lawrenson](https://wordpress.org/support/users/lorro/)
 * Last activity: [11 years, 8 months ago](https://wordpress.org/support/topic/woocommerce-database/#post-5249734)
 * Status: not resolved