Geospatial inventory control

• US 6,598,025 B1
• Filed: 12/29/2000
• Issued: 07/22/2003
• Est. Priority Date: 12/29/2000
• Status: Expired due to Term

• Current Assignee: NCR Voyix Corporation
• Original Assignee: NCR Corporation (NCR Voyix Corporation)
• Inventors: Hamilton, Brian J., Wewerka, Diane M.
• Primary Examiner(s): Rice, Kenneth R.
• Assistant Examiner(s): JASMIN, LYNDA C
• Application Number:
  US09/752,354
• Time in Patent Office: 935 Days
• Field of Search: 705/28, 705/22, 705/16, 340/5.91, 340/5.92, 340/825.72
• US Class Current: 705/22
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 20/203 Inventory monitoring

Abstract

An inventory-management system includes data-collection terminals that acquire product-identification data identifying products placed on store shelves, product-placement data identifying the locations of the products in the store, and sales data providing information about sales of the products. The system also includes a database that receives and stores the product-identification, product-placement, and product sales data collected by the terminals. A database-query component queries the database to identify relationships between product sales and product placement.

Claims

1. A method for use in managing inventory in a retail store, the method comprising:

acquiring product-identification data that identifies products placed on store shelves;

acquiring product-placement data that identifies the locations of the products in the store;

acquiring sales data that provides information about sales of the products;

storing the product-identification, product-placement, and product sales data in a database system; and

querying the database system to identify relationships between product sales and product placement.

2. The method of claim 1, where the step of acquiring product-placement data includes placing location labels on product packages to identify the locations of products in the store.

3. The method of claim 2, where the step of acquiring sales data includes acquiring information from the location labels as the products are sold.

4. The method of claim 1, where the step of acquiring product-placement data includes acquiring information from the store shelves as the products are placed on the shelves.

5. The method of claim 4, where the step of acquiring product-placement data includes acquiring information from location labels mounted on the store shelves.

6. The method of claim 1, where the step of acquiring product-placement data includes acquiring information that indicates a product'"'"'s distance from a store floor.

7. The method of claim 1, where the step of acquiring sales data includes acquiring product-identification data as the products are sold.

8. The method of claim 1, where the step of acquiring sales data includes acquiring information that distinguishes like products placed at different locations in the store.

9. The method of claim 1, where the step of querying the database includes calculating a physical distance between two types of products that will optimize joint sales of those products.

10. The method of claim 1, where the step of querying the database includes calculating a physical distance between two types of products that will preserve a minimum acceptable level of joint sales of the products.

11. The method of claim 1, where the step of querying the database includes predicting whether a particular product arrangement will produce acceptable levels of sales.

12. The method of claim 1, where the step of querying the database includes identifying product arrangements that have not produced acceptable levels of sales.

13. A data-processing system for use in managing inventory in a retail store, where the data-processing system includes executable instructions that are stored on a tangible storage medium and that, when executed by a computer processor, cause the computer to:

receive product-identification data that identifies products placed on store shelves;

receive product-placement data that identifies the locations of the products in the store;

receive sales data that provides information about sales of the products;

store the product-identification, product-placement, and sales data in a database system; and

query the database system to identify relationships between product sales and product placement.

14. The system of claim 13, where the computer, in querying the database system, calculates a physical distance between two types of products that will optimize joint sales of those products.

15. The system of claim 13, where the computer, in querying the database, calculates a physical distance between two types of products that will preserve a minimum acceptable level of joint sales of the products.

16. The system of claim 13, where the computer, in querying the database, predicts whether a particular product arrangement will produce acceptable levels of sales.

17. The system of claim 13, where the computer, in querying the database, identifies product arrangements that have not produced acceptable levels of sales.

18. An inventory-management system for use in a retail store, the system comprising:

one or more data-collection terminals configured to acquire product-identification data identifying products placed on store shelves, product-placement data identifying the locations of the products in the store, and sales data providing information about sales of the products;

a database system configured to receive and store the product-identification, product-placement, and product sales data collected by the terminals; and

a database-query component configured to query the database system to identify relationships between product sales and product placement.

19. The system of claim 18, where at least one terminal is configured to generate location labels for use on the product packages in identifying the locations of the products in the store.

20. The system of claim 19, where at least one terminal is configured to acquire information from the location labels as the products are sold.

21. The system of claim 18, where at least one terminal is configured to acquire information from the store shelves as the products are placed on the shelves.

22. The system of claim 21, where the terminal is configured to acquire information from location labels mounted on the store shelves.

23. The system of claim 18, where the product-placement data includes information that indicates a product'"'"'s distance from a store floor.

24. The system of claim 18, where at least one terminal is configured to acquire product-identification data as the products are sold.

25. The system of claim 24, where the terminal is configured to acquire information that distinguishes like products placed at different locations in the store.

26. The system of claim 18, where the database-query component is configured to calculate a physical distance between two types of products that will optimize joint sales of those products.

27. The system of claim 18, where database-query component is configured to calculate a physical distance between two types of products that will preserve a minimum acceptable level of joint sales of the products.

28. The system of claim 18, where the database-query component is configured to predict whether a particular product arrangement will produce acceptable levels of sales.

29. The system of claim 18, where the database-query component is configured to identify product arrangements that have not produced acceptable levels of sales.