Patent ID: 7769625

Claim:
A computer-readable medium comprising instructions that when executed by a processor, perform the steps of consolidating sales promotion data in a data warehouse, the steps comprising: selecting by the processor a first markdown profile for a product group, the product group comprising a first product and a second product, the first markdown profile configured to compare a first targeted sales amount during at least a first time period to a first markdown amount for the at least first time period; setting by the processor the first markdown profile as a product group markdown profile for the first product and the second product; assigning by the processor a second markdown profile to the second product, the second markdown profile configured to compare a second targeted sales amount during at least a second time period to a second markdown amount for the at least second time period; selecting by the processor a first price plan; selecting by the processor a second price plan; selecting by the processor a first retail price for the first product; selecting by the processor a second retail price for the second product; acquiring by the processor first updated sales data for the first product; acquiring by the processor second updated sales data for the second product; determining by the processor at least one of a first change to the first price plan and a second change to the second price plan based on comparing at least one of the first updated sales data to the first markdown profile and the second updated sales data to the second markdown profile; receiving by the processor a first sales promotion data and a second sales promotion data corresponding to a first sales promotion and a second sales promotion from the data warehouse based on at least one of the first change and the second change; adjusting by the processor at least one of the first retail price and the second retail price based at least one of the first sales promotion and the second sales promotion; grouping by the processor the first sales promotion data and the second sales promotion data to define a third promotion data corresponding to a third sales promotion; and storing product data in the data warehouse.