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
|