Home » Resources » Documentation » Get Involved » Database Schema

Database Schema

3.8 Branch

Database Tables

It is entirely possible WP e-Commerce 3.8 will have no additional database table footprint through utilisation of core WordPress tables.

3.7 Branch

WordPress Options

The following is an outline and description of the WordPress options (within wp_options) created during the standard installation of WP e-Commerce.

  • widget_wp_shopping_cart
  • wpsc-widget_specials
  • wpsc_checkout_form_fields
  • wpsc_checkout_form_sets
  • wpsc_purchaselogs_fixed
  • wpsc_version
  • country_form_field
  • email_form_field
  • wpsc_minor_version
  • show_thumbnails
  • product_image_width
  • product_image_height
  • category_image_width
  • category_image_height
  • product_list_url
  • shopping_cart_url
  • checkout_url
  • transact_url
  • payment_gateway
  • cart_location
  • currency_type
  • currency_sign_location
  • gst_rate
  • max_downloads
  • display_pnp
  • display_specials
  • do_not_use_shipping
  • postage_and_packaging
  • purch_log_email
  • return_email
  • terms_and_conditions
  • default_brand
  • wpsc_default_category
  • product_view
  • add_plustax
  • nzshpcrt_first_load
  • show_categorybrands
  • paypal_business
  • paypal_url
  • paypal_ipn
  • paypal_multiple_business
  • paypal_multiple_url
  • product_ratings
  • wpsc_email_receipt
  • wpsc_email_admin
  • wpsc_selected_theme
  • single_view_image_height
  • single_view_image_width
  • wpsc_gallery_image_height
  • wpsc_gallery_image_width
  • custom_gateway_options
  • wpsc_category_url_cache
  • user_account_url
  • wpsc_trackingid_subject
  • widget_wpsc_categorisation
  • wpsc_trackingid_message
  • wpsc_product_page_order
  • base_country
  • wpsc_ups_services
  • tax_inprice
  • wpsc_sort_by
  • show_breadcrumbs
  • wpsc_replace_page_title
  • wpsc_dropshop_theme
  • wpsc_category_description
  • show_category_count
  • use_pagination
  • wpsc_products_per_page
  • wpsc_page_number_position
  • wpsc_comments_which_products
  • return_name
  • shippingsameasbilling
  • payment_gateway_names
  • paypal_curcode
  • address_override
  • paypal_ship
  • paypal_form_first_name
  • paypal_form_last_name
  • paypal_form_address
  • paypal_form_city
  • paypal_form_state
  • paypal_form_post_code
  • paypal_form_country
  • custom_shipping_options
  • base_zipcode
  • wpsc_australiapost_settings
  • wpsc-widget_product_tag
  • wpsc-widget_price_range

Database Diagram

The diagram below provides a visual overview of the WP e-Commerce database and the relations between the tables.

3.6 Branch

Database Tables

The follow is a list of the database tables found maintained by WP e-Commerce.

  • wp_also_bought_product
  • wp_cart_contents
  • wp_cart_item_extras
  • wp_cart_item_variations
  • wp_collect_data_forms
  • wp_currency_list
  • wp_download_status
  • wp_extras_values
  • wp_extras_values_associations
  • wp_item_category_associations
  • wp_product_brands
  • wp_product_categories
  • wp_product_extra
  • wp_product_files
  • wp_product_images
  • wp_product_list
  • wp_product_order
  • wp_product_rating
  • wp_product_variations
  • wp_purchase_logs
  • wp_purchase_statuses
  • wp_region_tax
  • wp_submited_form_data
  • wp_variation_associations
  • wp_variation_priceandstock
  • wp_variation_values
  • wp_variation_values_associations
  • wp_wpsc_categorisation_groups
  • wp_wpsc_coupon_codes
  • wp_wpsc_logged_subscriptions
  • wp_wpsc_productmeta
  • wp_wpsc_variation_combinations