Method and system for processing retail data

• US 7,805,334 B1
• Filed: 06/08/2004
• Issued: 09/28/2010
• Est. Priority Date: 06/08/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Huppert, Andreas
• Primary Examiner(s): Zeender; F.
• Assistant Examiner(s): BUCHANAN, CHRISTOPHER R
• Application Number:
  US10/863,816
• Time in Patent Office: 2,303 Days
• Field of Search: None
• US Class Current: 705/16
• CPC Class Codes: G06Q 20/20 Point-of-sale [POS] network systems
• CPC Class Codes: G06Q 20/202 Interconnection or interaction of plural electronic cash registers [ECR] or to host computer, e.g. network details, transfer of information from host to ECR or from ECR to ECR
• CPC Class Codes: G06Q 20/204 comprising interface for record bearing medium or carrier for electronic funds transfer or payment credit

Abstract

A system for communicating retail data from a point of sale system to a data warehouse independent of a merchandising system. The system includes an inbound data interface configured to receive the retail data from the point of sale system, an inbound processing engine configured to apply one or more retail data processing rules to the retail data to generate processed retail data, and an outbound data interface configured to send the processed retail data to the data warehouse.

Claims

1. A system comprising:

a point of sale system;

a merchandising system;

a data warehouse;

an inbound processing engine coupled to the point of sale system, the merchandising system and the data warehouse, the inbound processing engine comprising an inbound data interface, a sales audit engine coupled to the inbound data interface and an outbound data interface coupled to the sales audit engine;

the inbound data interface configured to receive retail data directly from the point of sale system and independent of the merchandising system, wherein the inbound processing engine is configured to apply a retail data processing rule to the retail data to generate processed retail data, the sales audit engine comprising a transaction analysis engine, the transaction analysis engine configured to determine an error in the retail data and provide a description of the error, a source of the error and a suggested remedy for the error;

the outbound data interface coupled to the merchandising system and the data warehouse and configured to provide the processed retail data to the merchandising system and the data warehouse for further processing and reporting of the processed retail data, wherein the processed retail data provided to the data warehouse is provided independent of the merchandising system;

a transaction editor configured to allow editing of a first and a second converted retail data;

a transaction database coupled to an input interface and the sales audit engine, the transaction database configured to store transaction data based on the first and second converted retail data for transactions being processed by the inbound processing engine, and to store a task processing state; and

a plurality of outbound interfaces coupled to the sales audit engine and the transaction database and configured to send processed retail data to the data warehouse, the merchandising system and at least one of an integration server, a forecast engine, a replenishment engine, a material management engine, a sales and distribution/financials engine, a card payment engine and a billing engine;

wherein the inbound processing engine comprises a first inbound data conversion engine and a second inbound data conversion engine, the first inbound data conversion engine being coupled to the input interface and configured to receive first retail data from at least one point of sale device and to provide the first converted retail data to the input interface based on the received first retail data, the second inbound data conversion engine coupled to the input interface and configured to receive second retail data from the at least one point of sale device and to provide the second converted retail data to the input interface based on the received second retail data;

wherein the sales audit engine is configured to receive the first and second converted retail data;

wherein the transaction analysis engine is configured to receive and compare the first and second converted retail data to at least one predefined condition, the transaction analysis engine being further configured to determine an error in the first and second converted retail data and provide a description of the error, a source of the error and a suggested remedy for the error.

2. The system of claim 1, wherein the inbound processing engine is further configured to determine a data stability.

3. The system of claim 1, wherein applying the retail data processing rule includes receiving master data to be compared to the retail data for validation.

4. The system of claim 1, wherein applying the retail data processing rule to the retail data to detect errors includes comparing individual sales transactions in the retail data to aggregate sales data in the retail data.

5. The system of claim 1, wherein the processed retail data includes aggregated transaction data.

6. The system of claim 1, wherein the inbound processing engine is further configured to determine whether the processed retail data was successfully transferred to the data warehouse.

7. The system of claim 1, wherein applying the retail data processing rule to the retail data includes determining whether the retail data was successfully transferred to an external system based on the retail data processing rules for further processing.

8. The system of claim 7, wherein determining whether the retail data was successfully transferred to the external system includes determining whether a processing task to be performed by the external system was successful.

9. The system of claim 7, wherein the external system is at least one of an integration server, a forecasting engine, a replenishment engine, a material management engine, a sales and distribution/financials engine, a card payment engine, and a billing engine.

10. The system of claim 1, wherein applying the retail data processing rule to the retail data includes determining whether the retail data was successfully transferred to at least two external systems for further processing and further determining whether one or more processing tasks to be performed by each external system was successful.

11. The system of claim 1, wherein the inbound processing engine includes a control function configured to allow a user to specify actions to be taken based on the detection of one or more errors in the retail data.

12. The system of claim 11, wherein the control function may be configured to allow a user to specify actions to be taken based on a type of the detected error.

13. The system of claim 1, further including a transaction processing workbench configured to allow a user to selectively review and/or modify transactions in the retail data.

14. The system of claim 1, wherein the inbound processing engine further includes a transaction database configured to store transaction data received in the retail data for transactions being processed by the inbound processing engine.

15. The system of claim 14, wherein the transaction database is further configured to store a task processing state and process logs.

16. The system of claim 14, wherein the transaction data is sorted and stored in either a first field or a second field, wherein a portion of the transaction data is stored under the first field in a binary compressed format.

17. The system of claim 15, wherein the task processing state is stored in a table by a transaction range and by at least one of a store, a business day and a task type.

18. The system of claim 1, wherein the inbound processing engine is coupled to a master data repository configured to receive, store and provide master data affecting the operation of the system, the inbound processing engine further comprises an access module configured to allow a user to enter, read and search data in the master data repository.

19. The system of claim 1, wherein the sales audit engine further comprises a transaction monitoring engine and a transaction editor.

20. The system of claim 19, wherein the transaction monitoring engine determines a data transfer status, compares the received retail data to the master data, reviews the received retail data for errors, logs data transfers to external systems, aggregates received retail data and balances aggregate records of received retail data with individual transaction details.

21. The system of claim 19, wherein the transaction editor is configured to allow editing of received retail data based on a detected error condition.

22. The system of claim 1, wherein the transaction analysis engine determines the error by comparing the received retail data with at least one predefined condition.

23. The system of claim 1, wherein the transaction analysis engine is further configured to update and maintain a log of errors.

24. A system for processing retail data independent of a merchandising system, comprising:

a point of sale system configured to generate retail data based on retail transactions;

the merchandising system;

a data warehouse configured to store the retail data;

a point of sale inbound processing engine coupled to the point of sale system, the merchandising system and the data warehouse and configured to receive the retail data directly from the point of sale system and independent of the merchandising system, perform retail processing steps on the retail data, determine an error in the retail data, provide a description of the error, a source of the error and a suggested remedy for the error, the point of sale inbound processing engine is further configured to provide retail data to the merchandising system and the data warehouse, wherein the retail data provided to the data warehouse is provided independent of the merchandising system;

a transaction editor configured to allow editing of a first and a second converted retail data

a transaction database coupled to an input interface and the sales audit engine, the transaction database configured to store transaction data based on the first and second converted retail data for transactions being processed by the inbound processing engine, and to store a task processing state; and

a plurality of outbound interfaces coupled to the sales audit engine and the transaction database and configured to send processed retail data to the data warehouse, the merchandising system and at least one of an integration server, a forecast engine, a replenishment engine, a material management engine, a sales and distribution/financials engine, a card payment engine and a billing engine;

wherein the inbound processing engine comprises a first inbound data conversion engine and a second inbound data conversion engine, the first inbound data conversion engine being coupled to the input interface and configured to receive first retail data from at least one point of sale device and to provide the first converted retail data to the input interface based on the received first retail data, the second inbound data conversion engine coupled to the input interface and configured to receive second retail data from the at least one point of sale device and to provide the second converted retail data to the input interface based on the received second retail data;

wherein the sales audit engine is configured to receive the first and second converted retail data;

wherein the transaction analysis engine is configured to receive and compare the first and second converted retail data to at least one predefined condition, the transaction analysis engine being further configured to determine an error in the first and second converted retail data and provide a description of the error, a source of the error and a suggested remedy for the error.

25. The system of claim 24, wherein the point of sale inbound processing engine is further configured to format the retail data for storage in the data warehouse.

26. The system of claim 24, wherein performing retail processing steps includes comparing master data to the retail data to check for errors and provide validation.

27. The system of claim 24, wherein performing retail processing steps on the retail data includes transferring the retail data to an external system and determining whether additional processing steps were successfully completed on the external system.

28. The system of claim 27, wherein determining whether additional processing steps were successfully completed on the external system includes determining whether the retail data was successfully transferred to the external system.

29. The system of claim 27, wherein the external system is at least one of an integration server, a forecasting engine, a replenishment engine, a material management engine, a sales and distribution/financials engine, a card payment engine, and a billing engine.

30. The system of claim 24, wherein performing retail processing steps on the retail data includes comparing individual sales transactions in the retail data to aggregate sales data in the retail data to detect errors.

31. The system of claim 24, wherein performing retail processing steps on the retail data includes processing the retail data to generate aggregate transaction data.

32. The system of claim 24, wherein the inbound processing engine includes a control function configured to allow a user to specify actions to be taken based on the detection of one or more errors in the retail transaction data.

33. The system of claim 32, wherein the control function is configured to allow a user to specify actions to be taken based on a type of the detected error.

34. The system of claim 24, further including a transaction processing workbench configured to allow a user to selectively review and/or modify transactions in the retail data.

35. The system of claim 24, further including a transaction database configured to store transaction data for transactions received in the retail data and being processed by the inbound processing engine.

36. The system of claim 24, wherein the point of sale inbound processing engine further includes a transaction database configured to store transaction data received in the retail data for transactions being processed by the inbound processing engine.

37. The system of claim 36, wherein the transaction database is further configured to store a task processing state and process logs.

38. The system of claim 36, wherein the transaction data is sorted and stored in either a first field or a second field, wherein a portion of the transaction data is stored under the first field in a binary compressed format.