WordPress.org

Ready to get started?Download WordPress

Forums

WP e-Commerce
[resolved] Database Schema - Product Table (4 posts)

  1. sloughmiller
    Member
    Posted 1 year 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/

  2. sloughmiller
    Member
    Posted 1 year 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

  3. Mihai
    Member
    Plugin Author

    Posted 1 year ago #

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

  4. sloughmiller
    Member
    Posted 1 year 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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic