ModularMerchant
Knowledge Base
Shopping Cart Software Online Manual
product DB Table
ospg_order_zone_fee_assoc DB table product_add_ship_assoc DB Table
Location Home > Developer's Guide > Database Structure

product DB Table

this article last updated: June 18, 2010
Due to inevitable changes that will be made to the shopping cart software over time, the cart's variable and database structure may change from time to time without advanced notice. We will attempt to keep the information in this article up-to-date, but Modular Merchant makes no guarantee as to the accuracy of the information provided in this article. Use this information at your own risk.

This article outlines the database structure for the MMv4 product database table.

  • id
    The product's System ID (SID) number.
    int(10) | unsigned | auto increment | primary key | indexed
  • name
    The name of the product.
    varchar(255) | indexed
  • create_date
    The date this product was created.
    int(10) | unsigned | indexed
  • active
    Whether the product is active. If set to zero, the product is inactive. Only active products are displayed in the storefront. Customers may only purchase active products. Store administrators may still place orders for inactive products. Scheduled Orders may contain inactive products.
    i
    nt(10) | unsigned | Values: 0/timestamp | Default: 1 | indexed
  • hidden
    Whether the product is hidden. If set to zero, the product is not hidden. Hidden products are not displayed in the storefront. Customers may purchase hidden products. Store administrators may still place orders for hidden products. Scheduled Orders may contain hidden products.
    i
    nt(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • display_order
    The order in which the product is displayed in relation to other products. Products are displayed first by display order in ascending order, then by name in ascending order, then by SID in descending order.
    int(10) | unsigned | indexed
  • featured
    Determines whether the product is included in the list of products generated by the {FEATURED-PRODUCTS} QuickCode™ Tag. If set to zero, the product is excluded from the list of featured products.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • part_number
    Previously referred to as the product "SKU". The part number is any identifier, be it a SKU, part number or other ID number.
    varchar(255) | indexed
  • status
    Determines the products availability.
    int(10) | unsigned | indexed
  • low_stock_threshold
    Determines the point at which the product is considered "Low Stock".
    int(10) | indexed
  • low_stock_behavior
    Determines the behavior the product will take when it is considered "Low Stock".
    varchar(255) | indexed
  • low_stock_status
    The SID of something....xxxxxxThis needs to be researched!!!!!!
    int(10) |  indexed
  • weight
    The total weight in either grams (if store set to metric units of measure) or ounces (if store set to US standard units of measure).
    int(10) | unsigned | indexed
  • cogs
    Cost Of Goods Sold.
    double(16,2)
    | indexed
  • msrp
    Manufacturer's Suggested Retail Price.
    double(16,2) | indexed
  • price
    The price of the product that will be displayed in the storefront.
    double(16,2) | indexed
  • min_qty
    If set to a value greater than zero, this will determine the minimum quantity of the product that may be purchased per address in an order.
    int(10) | unsigned
    | indexed
  • max_qty
    If set to a value greater than zero, this will determine the maximum quantity of the product that may be purchased per address in an order.
    int(10) | unsigned | indexed
  • seo_url_text
    Any URL entered in this field will be used in the URL of the product's storefront page. If empty, the system will attempt to use the product's name instead.
    varchar(255)
    | indexed
  • store_page
    Any URL entered in this field will override the default product details page created in the storefront.
    varchar(255)
    | indexed
  • template
    The template to be applied to the product's details page in the storefront.
    varchar(255) | indexed
  • tax_exempt
    If set to zero, then the product will be included when taxes are calculated. If greater than zero, then the product will be excluded from the tax calculation.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • shipping_exempt
    If set to zero, then the product will be included when shipping fees are calculated. If greater than zero, then the product will be excluded from the shipping calculation.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • is_gc
    If set to zero, then the product will not be treated as a gift certificate when purchased.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • use_gift_wrap
    If set to zero, then the product will not be eligible to provide an option to be gift wrapped when it is purchased.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • gift_wrap_fee
    The dollar value of gift wrapping fees per unit of the product purchased.
    double(16,2) | indexed
  • restrict_qty
    If set to zero, then the customer will be allowed to change the quantity of the product in their basket. Store administrators may change the quantity of the product in the basket, even if the quantity is restricted.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • include_in_search
    If set to 1, then the product will be included in searches made using the search engine in the storefront.  If set to 0, then the product will not be included in searches made using the storefront search engine.
    int(10) | unsigned | Values: 0/timestamp | Default: 1 | indexed
  • rec_type
    Determines whether a product is a subscription product, and whether it rebills every X days or on a day of the month.
    varchar(255) | Values: (empty), XDAYS, DOM | Default: (empty)
    | indexed
  • rec_term
    The number of days that a product that rebills every X days will rebill.
    int(10)
    | indexed
  • rec_term_text
    Text that can be displayed in the storefront after the product's price. For example, entering "monthly" in this field could allow the product's price to be displayed in the storefront as "$123.45 monthly".
    varchar(255) | indexed
  • rec_times
    The number of times the product will attempt to rebill as itself before moving on to the next product in the subscription daisy chain.
    int(10) | unsigned
    | indexed
  • rec_as
    The SID of the product that the subscription will change over to after the product has rebilled as itself the prescribed number of times.
    int(10) | unsigned
    | indexed
  • rec_num_time_spans
    The number of time spans used to reschedule the order.  Example: A quarterly scheduling scheme would have 3 in this field and M in product.rec_time_spans.
    int(10)
    | indexed
  • rec_time_spans
    The type of time period used when scheduling the order. W = week, M = month, Y = year
    char(1)
    | Value: W/M/Y |indexed
  • rec_grace
    Determines the grace period for rebilling products.
    int(10)
    | indexed
  • rec_subscriber_content
    This content can be displayed in the storefront to customers that have a valid scheduled order for the product.
    text

  • keywords
    A list of keywords to seed the store's search engine.
    text
  • aff_com_value
    The numeric value of the default ccommission value for this product. May also be overridden for specific affiliates in the product_com_vals table.
    double(16,2) | indexed
  • aff_com_type
    Determines whether the aff_com_value field is a dollar value or percentage of the product's purchase price.
    char(1) | Values: D,P | Default: D | indexed
  • aff_com_max
    The default maximum value per unit of the product that an affiliate may earn as a commission.
    May also be overridden for specific affiliates in the product_com_vals table.
    double(16,2) | indexed
  • aff_resources
    The URL of a page containing marketing materials for use by affiliates for this product.
    varchar(255)
    | indexed
  • short_description
    The product's short description.
    text
  • long_description
    The product's long description.
    text
  • ship_solo
    If greater than zero, then the product's shipping fees will be calculated as a separate shipment when it is purchased.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • dropship_id
    Reference to the dropship record associated with this product.
    int(10) | unsigned | indexed
  • width
    The total width in either centimeters (if store set to metric units of measure) or inches (if store set to US standard units of measure). Whole numbers only. (12 is okay, 12.3 is not.)
    int(10) | unsigned | indexed
  • height
    The total height in either centimeters (if store set to metric units of measure) or inches (if store set to US standard units of measure). Whole numbers only. (12 is okay, 12.3 is not.)
    int(10) | unsigned | indexed
  • length
    The total length in either centimeters (if store set to metric units of measure) or inches (if store set to US standard units of measure). Whole numbers only. (12 is okay, 12.3 is not.)
    int(10) | unsigned | indexed
  • allow_backorder
    If greater than zero, then customers will not be allowed to place an order for a product that has fewer units in stock than the quantity being purchased.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • href_target
    Specifies whether the links to the product store page should open in the same browser window or a new one.
    varchar(255) | indexed
  • ptcs_id
    Referenced to the ptcs.id that is associated with this product.
    int(10) | unsigned | indexed
  • allow_wish_list
    Whether the product is compatible with wish lists, or not.
    int(10) | unsigned | indexed | default: 1
  • allow_review
    Whether the product is compatible with reviews, or not.
    int(10) | unsigned | indexed | default: 1

 



— Last Edited - 06/18/2010 10:07am PDT
Rank and add a comment to this article
Only logged in users may leave comments and rank articles. Log in to have your say!
  Knowledge Base Home

  QuickCode™ Tag Glossary

  Modular Merchant.com Homepage

Not Logged in.
Either Log in or create a User Account.

Other articles in this category...

account_activity DB Table

admin DB Table

admin_attr DB Table

admin_attr_data DB Table

admin_attr_node DB Table

admin_password DB Table

aff_commission DB Ttable

aff_default_target_url DB Table

aff_payment DB Table

aff_tid DB Table

aff_traffic DB table

ban_list DB Table

basket DB Table

basket_field_data DB table

category DB Table

category_attr DB Table

category_attr_assoc DB table

category_attr_data DB Table

category_attr_node DB Table

checkout_field DB table

checkout_field_node

customer DB Table

customer_attr DB Table

customer_attr_assoc DB table

customer_attr_data DB Table

customer_attr_node DB Table

customer_field DB Table

customer_field_data DB Table

customer_field_node DB Table

customer_group DB Table

customer_group_assoc DB table

customer_group_rule DB Table

customer_group_rule_node DB table

customer_ip DB Table

customer_pay_method DB Table

customer_ship_addr DB Table

custom_page DB Table

custom_quickcode DB Table

dec_orders DB table

dec_order_event_assoc DB table

dec_order_field_data DB table

dec_order_gateway_assoc DB table

dec_order_item DB table

dec_order_item_field_data DB table

dec_order_pay_method DB table

dec_order_shipment DB table

dec_order_tax_assoc DB table

dec_order_zone_fee_assoc DB table

digdel_fileserver DB table

digdel_ip DB Table

digdel_object DB table

digdel_object_zone DB table

digdel_order_item DB Table

dropship DB Table

dropship_report_hour_assoc DB Table

dropship_ship_method_assoc DB Table

em_attachment DB Table

em_history DB Table

em_link DB table

em_queue DB table

em_queue DB table

em_series DB table

em_series_step DB table

em_template DB table

event_ignore DB table

event_info DB table

event_tr DB table

event_tr_slot DB table

gift_cert DB table

inventory_object DB table

iptocountry DB Table

note DB table

orders DB Table

order_event_assoc DB Table

order_field DB Table

order_field_data DB table

order_field_node DB Table

order_gateway_assoc DB table

order_item DB Table

order_item_field_data DB table

order_item_report DB Table

order_item_royalty_assoc DB table

order_item_status DB Table

order_item_tracking_assoc DB Table

order_pay_method DB table

order_shipment DB Table

order_tax_assoc DB Table

order_zone_fee_assoc DB Table

ospg_orders DB table

ospg_order_event_assoc DB table

ospg_order_field_data DB table

ospg_order_gateway_assoc DB table

ospg_order_item DB table

ospg_order_item_field_data DB table

ospg_order_item_royalty_assoc DB

ospg_order_pay_method DB table

ospg_order_shipment DB table

ospg_order_tax_assoc DB table

ospg_order_zone_fee_assoc DB table

product DB Table

product_add_ship_assoc DB Table

product_attr DB Table

product_attr_assoc DB table

product_attr_data DB Table

product_attr_node DB Table

product_category_assoc DB Table

product_com_val DB Table

product_digobj_assoc DB Table

product_field DB Table

product_field_assoc DB Table

product_field_data DB Table

product_field_node DB Table

product_fulfillment_assoc DB Table

product_group DB Table

product_group_assoc DB Table

product_image DB Table

product_instance DB Table

product_royalty DB Table

product_ship_method_assoc DB Table

product_status DB Table

product_stock_assoc DB Table

product_vendor_assoc DB Table

product_zone_fee_assoc DB Table

ptcs DB Table

ptcs_item DB table

ptcs_item_use DB table

review DB table

review_ceriteria DB table

review_rank DB table

review_vote DB table

ship_method DB Table

ship_method_zone DB Table

ship_status DB Table

stock_level DB Table

subscription DB Table

subscription_item DB Table

system_settings DB Table

sys_email_us_english DB Table

sys_message_us_english

tax DB Table

tax_zone DB Table

tracking_id DB Table

vendor DB Table

vendor_attr DB Table

vendor_attr_data DB Table

vendor_attr_node DB Table

zone_fee DB Table

zone_fee_zone DB Table