System and method for defining a sales promotion

• US 7,769,625 B2
• Filed: 08/26/2004
• Issued: 08/03/2010
• Est. Priority Date: 03/08/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Veit, Thomas
• Primary Examiner(s): Boswell; Beth V.
• Assistant Examiner(s): CHONG CRUZ, NADJA N
• Application Number:
  US10/926,844
• Publication Number:
  US 20050197900A1
• Time in Patent Office: 2,168 Days
• Field of Search: 705/10, 705/14
• US Class Current: 705/7.29
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data
• CPC Class Codes: G06Q 30/0207 Discounts or incentives, e.g. coupons or rebates
• CPC Class Codes: G06Q 30/0264 based upon schedule
• CPC Class Codes: G06Q 30/0272 Period of advertisement exposure

Abstract

A method of and system for defining a sales promotion including consolidating sales promotion data in a data warehouse are disclosed. The method includes receiving in a computerized system first and second sales promotion data corresponding to first and second sales promotions from the data warehouse, and grouping the first and second sales promotion data to define third promotion data corresponding to a third sales promotion. The system includes means for receiving first and second sales promotion data corresponding to first and second sales promotions from the data warehouse, and means for grouping the first and second sales promotion data to define third promotion data corresponding to a third sales promotion.

Claims

1. 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.

2. The method of claim 1, further including generating a report for the third sales promotion data.

3. The method of claim 1, further including storing the third sales promotion data in the data warehouse.

4. The method of claim 1, wherein the first, second and third sales promotions correspond to first, second and third levels in a hierarchical listing of products.

5. The method of claim 4, wherein the third level is a higher level than either of the first and second levels.

6. The method of claim 4, wherein the first and second levels are not the same level.

7. The method of claim 4, wherein the second level is below the first level.

8. The method of claim 1, wherein the first, second and third sales promotions correspond to first, second and third nodes in a hierarchical listing of products.

9. The method of claim 8, wherein the third node is at a higher level in the hierarchical listing of products than either the first node or the second node.

10. The method of claim 8, wherein the third node is at a same level in the hierarchical listing of products as one of the first and the second node.

11. The method of claim 1, wherein at least one of the first, second and third sales promotions corresponds to a group of sales promotion sites.

12. The method of claim 1, wherein at least one of the first, second, and third sales promotions is based on a hierarchical listing of products associated with a particular season.

13. The method of claim 1, wherein at least one of the first, second, and third sales promotions is related to at least one of a product and a service.

14. The method of claim 1, wherein the first and second sales promotions have different validity periods, and the third sales promotion has a validity period that spans the first and second validity periods.

15. The method of claim 1, further including saving the first, second and third sales promotions into a single price planning document.

16. The method of claim 1, wherein the first sales promotion is a general sales promotion and the second sales promotion is a more specific sales promotion of the first sales promotion for a select group of articles or sites.

17. The method of claim 1, wherein the first sales promotion and the second sales promotion correspond to a same set of articles or sites but for different validity periods.

18. The method of claim 1, wherein the first sales promotion and the second sales promotion correspond to different sets of articles or sites for a same or overlapping validity periods.

19. A program product for consolidating sales promotion data in a data warehouse, the program product comprising machine-readable program code for causing, when executed, one or more machines to perform the following method steps:

selecting 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 the first markdown profile as a product group markdown profile for the first product and the second product;

assigning 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 a first price plan;

selecting a second price plan;

selecting a first retail price for the first product;

selecting a second retail price for the second product;

acquiring first updated sales data for the first product;

acquiring second updated sales data for the second product;

determining 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 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;

receiving a product quantity data which represents an amount of product still in stock at a particular date;

adjusting at least one of the first retail price and the second retail price based on the product quantity data and at least one of the first sales promotion and the second sales promotion;

grouping 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.

20. The program product of claim 19, further including generating a report for the third sales promotion data.

21. The program product of claim 19, further including storing the third sales promotion data in the data warehouse.

22. The program product of claim 19, wherein the first, second and third sales promotions correspond to first, second and third levels in a hierarchical listing of products.

23. The program product of claim 22, wherein the third level is a higher level than either of the first and second levels.

24. The program product of claim 22, wherein the first and second levels are not the same level.

25. The program product of claim 22, wherein the second level is below the first level.

26. The program product of claim 19, wherein the first, second and third sales promotions correspond to first, second and third nodes in a hierarchical listing of products.

27. The program product of claim 26, wherein the third node is at a higher level in the hierarchical listing of products than either the first node or the second node.

28. The program product of claim 26, wherein the third node is at a same level in the hierarchical listing of products as one of the first and the second node.

29. The program product of claim 19, wherein at least one of the first, second and third sales promotions corresponds to a group of sales promotion sites.

30. The program product of claim 19, wherein at least one of the first, second, and third sales promotions is based on a hierarchical listing of products associated with a particular season.

31. The program product of claim 19, wherein at least one of the first, second, and third sales promotions is related to at least one of a product and a service.

32. The program product of claim 19, wherein the first and second sales promotions have different validity periods, and the third sales promotion has a validity period that spans the first and second validity periods.

33. The program product of claim 19, further including saving the first, second and third sales promotions into a single price planning document.

34. The program product of claim 19, wherein the first sales promotion is a general sales promotion and the second sales promotion is a more specific sales promotion of the first sales promotion for a select group of articles or sites.

35. The program product of claim 19, wherein the first sales promotion and the second sales promotion correspond to a same set of articles or sites but for different validity periods.

36. The program product of claim 19, wherein the first sales promotion and the second sales promotion correspond to different sets of articles or sites for a same or overlapping validity periods.

37. A system for consolidating sales promotion data in a data warehouse, the system comprising:

a slow seller engine configured to select 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;

the slow seller engine further configured to set the first markdown profile as a product group markdown profile for the first product and the second product;

the slow seller engine further configured to assign 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;

a price planning system configured to select a first price plan;

the price planning system further configured to select a second price plan;

the price planning system further configured to select a first retail price for the first product;

the price planning system further configured to select a second retail price for the second product;

the price planning system further configured to acquire first updated sales data for the first product;

the price planning system further configured to acquire second updated sales data for the second product;

the slow seller engine further configured to determine 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;

the slow seller engine further configured to receive 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 updated sales data, the second updated sales data, the first change and the second change;

the slow seller engine further configured to adjust at least one of the first sales promotion and the second sales promotion;

the price planning system further configured to group 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.

38. The system of claim 37, wherein the price planning system further configured to generate a report for the third sales promotion data.

39. The system of claim 37, further including storing the third sales promotion data in the data warehouse.

40. The system of claim 37, wherein the first, second and third sales promotions correspond to first, second and third levels in a hierarchical listing of products.

41. The system of claim 40, wherein the third level is a higher level than either of the first and second levels.

42. The system of claim 40, wherein the first and second levels are not the same level.

43. The system of claim 40, wherein the second level is below the first level.

44. The system of claim 37, wherein the first, second and third sales promotions correspond to first, second and third nodes in a hierarchical listing of products.

45. The system of claim 44, wherein the third node is at a higher level in the hierarchical listing of products than either the first node or the second node.

46. The method of claim 44, wherein the third node is at a same level in the hierarchical listing of products as one of the first and the second node.

47. The method of claim 37, wherein at least one of the first, second and third sales promotions corresponds to a group of sales promotion sites.

48. The method of claim 37, wherein at least one of the first, second, and third sales promotions is based on a hierarchical listing of products associated with a particular season.

49. The method of claim 37, wherein at least one of the first, second, and third sales promotions is related to at least one of a product and a service.

50. The method of claim 37, wherein the first and second sales promotions have different validity periods, and the third sales promotion has a validity period that spans the first and second validity periods.

51. The method of claim 37, further including saving the first, second and third sales promotions into a single price planning document.

52. The method of claim 37, wherein the first sales promotion is a general sales promotion and the second sales promotion is a more specific sales promotion of the first sales promotion for a select group of articles or sites.

53. The method of claim 37, wherein the first sales promotion and the second sales promotion correspond to a same set of articles or sites but for different validity periods.

54. The method of claim 37, wherein the first sales promotion and the second sales promotions correspond to different sets of articles or sites for a same or overlapping validity periods.