this article last updated: July 1, 2009 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 product_stock_assoc database table.
- pid
Reference to the product's SID number: product.id.
int(10) | unsigned | indexed
- stock_id
Reference to the stock object's SID number: stock_level.id.
int(10) | unsigned | indexed
- units_per_qty
For every one unit purchased by the customer, the stock level will be reduced by this number.
int(10) | unsigned
|