Database Schema – Product Table

  • Resolved sloughmiller

    (@sloughmiller)


    13 years, 3 months ago

    Hello,

    Does anyone know where I can find the products table in MySql, i.e. when I add a new product, in what database table is it stored?

    (When I add a product, I don’t see it anywhere in my database or database tables (in phpmyadmin).

    Your timely assistance would be greatly appreciated!

    Thank you,
    Sandra

    http://wordpress.org/extend/plugins/wp-e-commerce/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter sloughmiller

    (@sloughmiller)

    13 years, 3 months ago

    Listed below are the only wp e-commerce tables listed in my phpmyadmin. I don’t see the table I need as described in the Documentation (Database Schema), yet the product seems to have been installed and working (so far)!!

    wp_wpsc_also_bought
    wp_wpsc_cart_contents
    wp_wpsc_checkout_forms
    wp_wpsc_claimed_stock
    wp_wpsc_coupon_codes
    wp_wpsc_currency_list
    wp_wpsc_download_status
    wp_wpsc_meta
    wp_wpsc_product_rating
    wp_wpsc_purchase_logs
    wp_wpsc_region_tax
    wp_wpsc_submited_form_data

    Mihai Joldis

    (@misulicus)

    13 years, 3 months ago

    I believe products are added in the wp_posts table since WPCE uses the posts page to add products

    Thread Starter sloughmiller

    (@sloughmiller)

    13 years, 3 months ago

    Thanks misulicus,

    Yep, took all day to find the test entries, looked through every table, can’t say happy about that. I wanted to import into that table; perhaps, add some fields.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database Schema – Product Table’ is closed to new replies.