|
this article last updated: May 24, 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 inventory_object database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- name
The name of the inventory object.
varchar(255) | indexed
- infinite
Whether this inventory object has infinite stock.
int(10) | unsigned | indexed
- units
The amount of units are currently in stock.
int(10) | unsigned | indexed
- low_stock_alert
The number in which a low stock alert email will be generated if the units drop below.
int(10) | unsigned | indexed
- restock_alert
Similar to low_stock_alert, only this will trigger a restock alert email.
int(10) | unsigned | indexed
- low_stock_hide
Similar to the low_stock_alert, only the product will be hidden from the storefront.
int(10) | unsigned | indexed
- allow_oversell
Whether this inventory object allows for overselling or backorders.
int(10) | unsigned | indexed
|
