The SaleAdjust component, which appears in the Item Adjust Price stage of an order processing pipeline, allows you to apply the sale price of an item. If the item is on sale, and if its _iadjust_currentprice has not been initialized by a previously executed component, SaleAdjust initializes _iadjust_currentprice to the value stored in the item’s _product_sale_price name/value pair.
The SaleAdjust component determines if an item is on sale by comparing the current date to the dates specified in the item’s _product_sale_start and _product_sale_end name/value pair.
The SaleAdjust component requires that the sale_* values in the product table of the site database be set. Otherwise, the OrderForm will be missing the data needed to calculate the _iadjust_currentprice name/value pair, and an error message will be generated. The _product_sale_* values are set by QueryProdInfo or QueryProdInfoADO in the Product Information stage.
Because _product_sale_start and _product_sale_end are actually date/time pairs that specify midnight, _product_sale_end excludes the date specified. Thus, if you want the last day of a promotion to be 3/31, be sure to specify that the promotion ends on 4/1.