MMv4 KB
 
product_status DB Table
  Last Edited - 07/1/2009 3:35pm PDT
  Category Path - Developer's Guide > Database Structure
 

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

  • id
    Primary Key of the table.
    int(10) | unsigned | auto increment | primary key | indexed
  • name
    The display name of the product status.
    varchar(255) | indexed
  • purchasable
    Products with a status in which the purchasable field contains a value greater than zero will be displayed in the storefront and may be purchased by customers. Store administrators may still place orders for products that are not purchasable. Scheduled Orders may also contain products that are not purchasable.
    int(10) | unsigned | Values: 0/timestamp | Default: 1
  • editable
    Product status entries that are not editable (set to 0) are used by the system, and cannot be edited in the store's administration area.
    int(10) | unsigned | Values: 0/timestamp | Default: 1
  • memo
    A description of the product_status that may be displayed to customers in certain circumstances.
    text
  • notes
    Internal-only notes about this product status that are never displayed to the customer.
    text
Powered by ModularKB