Table inventory_special_prices

Table inventory_special_prices is used to override the price sheets on a sku by sku, proce sheet by price sheet level. Price sheets are defined to help create multi-level pricing accross the entire inventory dtabase. If certain sku-s require a different fomula, special price are used. For example, you may have defined two price sheets, retail and dealer, that set your default price levels. However, one of your sku's requires a different pricinf formula. Special prices allows an individual sku to have it's own formula for the sku and for ach price sheet.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
inventory_id int(11) 0 This is the record number in the inventory table that this special price applies to. Basically the sku.
price_sheet_id int(11) 0 This is the record id of the price sheet that this special price applies to.
price_levels varchar(255) NULL This is the encoded price level/value applied to the sku.