Tables

Description

addoninfo

Used for Modules Manager

affiliatelog

Log affiliate entries

affiliates

Affiliate details (requires VPCart option package)

apiusers

Used for API Manager

basic_configs

Used to store encryption key and last currency updated date time

billing

Recurring Billing

blogs

Used to store blog

blogsreviews

Used to store blog reviews

cartsessions

Used for Cart Cookie DB

categories

Holds all the categories of products

checkoutsteps

Used to store Checkout Steps Indicator information

concatcategories

Used for shopcms (contents and content categories)

configuration

VPCart Configuration

configuration1

VPCart Configuration for running two shop using one database

containerbox_components

Used for Layout Manager

containerbox_fields

Used for Layout Manager

containerbox_lists

Used for Layout Manager

containerbox_v9

Used for Layout Manager

content

Used for dynamic site content

contentcategories

Used to store content categories

cookies_acceptance

Used for cookies acceptance

coupons

Discount Coupons

currencyvalues

Store different currency types available for the store

customergroups

Used in Customer Grouping, mapping the customer group id and customer contact id

customerprices

Customer based pricing table

customers

Each time a customer orders a product(s) a record is stored in the database. Even if the customer cancels the order, the customer information is not deleted

customers_pwd_token

Used for resetting customers password

dashboardwidget

Used for admin dashboard widgets

design_fonts

List of available fonts

downloads

Used with secure download facility

emailtemplate

Used for Abandoned Cart Notification Email

filter_main

Used for Product Side Filtering

gifts

Gift Certificates

googleproductfeed

Used for Google Product Feed

groups

Used to store the Customer Grouping data.

hackers

Place to store hacker e-mail addresses and IP address

languages

Shop languages

layout_types

Used for Layout Manager

menu_parentoptions

Used for Menu Manager (Mega Menu) for parent menu options

menu_submenuoptions

Used for Menu Manager (Mega Menu) for sub menu options

menuitem

The top navigation bar is created based on the data in this table

mycompany

Describes details about the merchant. Used to print merchant details on printed orders

news

Used for news

newsletter

Used for newsletter subcribers

newsreviews

Used to store news reviews

oitems

One row for each item ordered. If multiple products are ordered in a single transaction, there are multiple rows in the database.

orders

The order information is stored here

ordertracking

Tracking messages

pinnumbers

Used with pin number add-on

prodcategories

Lists all categories for a specific product. Used only if the products in multiple categories is used

prodfeatures

Product Features such as color, size or any other attribute

products

The products in the database

products_variant_options

Used for Product Variants

products_variant_options_value

Used for Product Variants

productvariants

Unused

projects

Non product services

quantitydiscounts

Quantity discount table

registrant

Gift registry customer details

registryitems

Gift registry items

reviews

Reviews of products by customers and suppliers

savedcarts

Wish list values

savedquery

Used to store admin entered sql queries

searchresults

Search term recording

shipmethods

Different shipping methods and prices

shopcountries

A list of countries available to ship to

shoppingcom

Used for Shopping.Com XML Feed Add On

shoprma

Stores RMA requests

shopstates

A list of states available to ship to

sitesessions

Used for advanced session handilng

stock_hold

Used for stock hold feature

stocknotification

Used for stock notifications

suppliers

Supplier details

tblaccess

Access rights for users

tblaudithist

Used to store audit trail history

tbllog

User login to admin system

tblmenuheader

Used to store the admin top menu

tbluser

Userids and passwords for admin system

templates

Instead of storing template files on the server, it can be stored here

translateblogs

Descriptions and meta tags of blog in other languages

translatecategories

Descriptions of categories in other languages

translatecontent

Stores page contents in other languages

translatecontentcategories

Stores page contents categories in other languages

translatenews

Descriptions and meta tags of news in other languages

translateprodfeatures

Stores product feature captions and descriptions in other languages

translateproducts

Stores product details in other languages

ups_config

Configuration details for the in-built UPS facility

xmlfeed

Used for XML Feed feature