Table inventory_ms_list

Table inventory_ms_list holds the reference information of the sub-items created off of a Master Stock item. Any number of up to two attributes can be used to create a master stock item. For example, color and size would be two attributes with any number of colors and any number of sizes. The number of items created will be attr1 count * attr2 count.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
sku varchar(15) NULL Holds the sku of the created master stock item. This will be the Master Stock base sku (10 characters) plus the 2 character codes for each of the two attributes assigned to the master stock item.
attr_name_0 varchar(16) NULL Holds the short description of the first attribute
attr_name_1 varchar(16) NULL Holds the short description of the second attribute
attr_0 varchar(255) NULL Hold a textual description of the first attribute providing a more detailed description of the attribute.
attr_1 varchar(255) NULL Hold a textual description of the second attribute providing a more detailed description of the attribute.