MMv4 KB
 
stock_level DB Table
  Last Edited - 02/4/2010 4:49pm PST
  Category Path - Developer's Guide > Database Structure
 

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

 

Powered by ModularKB