|
this article last updated: February 4, 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 stock_level database table.
- id
Primary Key of table.
int(10) | unsigned | auto increment | primary key | indexed
- name
A descriptive name of the Stock Level. Used for administrative purposes.
varchar(255) | indexed
- infinite
If greater than zero, then the product has an infinite stock level.
int(10) | unsigned | Format: 0/timestamp | Default: 0 | indexed
- units
The number of units that are available in stock. A product with zero units in stock may not be purchased.
int(10) | indexed
- low_stock_alert
When the number of units in stock of this item falls below this value, notices will be triggered stating that the item's stock levels are running low. This value may be set to a negative number.
int(10) | indexed
- restock_alert
When the number of units in stock of this item falls below this value, notices will be triggered stating that the item needs to be restocked. This value may be set to a negative number.
int(10) | indexed
- low_stock_hide
When the number of units in stock of this item falls below this value, then the products associated with it will no longer be displayed in the storefront until the stock is raised back up above this number. This value may be set to a negative number.
int(10) | indexed
- allow_oversell
Whether or not this stock level will allow for backordering or overselling of product that is out of stock.
int(10) | indexed
|
