AU2020101951A4 - IMS- Inventory Management System: INTELLIGENT MART SELLING AND INVENTORY MANAGEMENT SYSTEM - Google Patents

IMS- Inventory Management System: INTELLIGENT MART SELLING AND INVENTORY MANAGEMENT SYSTEM Download PDF

Info

Publication number
AU2020101951A4
AU2020101951A4 AU2020101951A AU2020101951A AU2020101951A4 AU 2020101951 A4 AU2020101951 A4 AU 2020101951A4 AU 2020101951 A AU2020101951 A AU 2020101951A AU 2020101951 A AU2020101951 A AU 2020101951A AU 2020101951 A4 AU2020101951 A4 AU 2020101951A4
Authority
AU
Australia
Prior art keywords
inventory
items
item
information
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Ceased
Application number
AU2020101951A
Inventor
Eknath B. Khedkar
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Khedkar Dr Eknath B
Original Assignee
Khedkar Dr Eknath B
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Khedkar Dr Eknath B filed Critical Khedkar Dr Eknath B
Priority to AU2020101951A priority Critical patent/AU2020101951A4/en
Application granted granted Critical
Publication of AU2020101951A4 publication Critical patent/AU2020101951A4/en
Ceased legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q20/00Payment architectures, schemes or protocols
    • G06Q20/08Payment architectures
    • G06Q20/20Point-of-sale [POS] network systems
    • G06Q20/203Inventory monitoring

Landscapes

  • Business, Economics & Management (AREA)
  • Economics (AREA)
  • Engineering & Computer Science (AREA)
  • Marketing (AREA)
  • Quality & Reliability (AREA)
  • Finance (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Accounting & Taxation (AREA)
  • Operations Research (AREA)
  • Development Economics (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

Patent Title: IMS- Inventory Management System: INTELLIGENT MART SELLING AND INVENTORY MANAGEMENT SYSTEM ABSTRACT My Invention "IMS- Inventory Management System" is a technique, systems, and articles of manufacture consistent with certain aspects related to the invention collect item information from bar-code/RFID tags attached to items in an inventory. The invented technique also uses the collected item information to perform various inventory management processes and the inventory management processes may include determining, reporting, and providing corrective actions for one or more events associated with at least one of depletions of items in the inventory, changes in the design of items in the inventory, defects with any items, misplaced items, the movement of an unusual number of items within a short period of time, and malfunctions of one or more components included in the environment.The invented technique to manage growing product inventories, businesses have implemented perpetual type inventory management systems, which are systems that use Point of Sale (POS) data on products sold, invoicing data, and historical data on inventory audits or cycle counts (e.g., periodic inventory counts of products) to determine the inventory that exists within the walls of a retail store. The POS data generally refers to data generated at a checkout system if any error then immediate notification send to the user, owner and also give the Pop up notification (i.e., cash register). Based on the inventory level within the retail stores, products may be reordered from a manufacturer. Alternatively, the manufacturer and retailer may have an agreement that directs the manufacturer to preemptively deliver products according to the terms of the agreement. Ideally, inventory is replenished in a manner such that inventory arrives at the retail store just before existing stock levels are exhausted. 41 Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) TOTAL NO OF SHEET: 07 NO OF FIG.: 07 EN1IRONMENT 110-1 jggM AumN Pfr110-M Mutiple iReal Tirne SyncA maan @a Pna caminme~m FIG. 1: IS A BLOCK DIAGRAM OF AN EXEMPLARY SYSTEM CONSISTENT WITH CERTAIN ASPECTS RELATED TO THE PRESENT INVENTION.

Description

Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) TOTAL NO OF SHEET: 07 NO OF FIG.: 07
EN1IRONMENT 110-1
jggMAumN maan Pfr110-M @a
Mutiple
iReal Tirne SyncA
Pna caminme~m
FIG. 1: IS A BLOCK DIAGRAM OF AN EXEMPLARY SYSTEM CONSISTENT WITH CERTAIN ASPECTS RELATED TO THE PRESENT INVENTION.
Australian Government IP Australia Innovation Patent Australia
Patent Title: IMS- Inventory Management System: INTELLIGENT MART SELLING AND INVENTORY MANAGEMENT SYSTEM
Name and address of patentees(s):
Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) Address: FL No. 202, Building No.'E', Laburnum Park, Magarpatta City, Hadapsar, Pune-411031, MH, India.
Complete Specification: Australian Government.
FIELD OF THE INVENTION
My invention "IMS- Inventory Management System" is related to intelligent mart selling and inventory management system and more particularly, to methods and systems for performing an inventory management process that uses an intelligent station to track and inventory items that are tagged with Radio Frequency Identification (RFID) tags. BACKGROUND OF THE INVENTION
Inventory management is becoming increasingly important in today's growing economy. New products are continuously being developed and placed in the market for consumer purchase. Although this growth provides consumers with more choices for selecting various goods and services, businesses (e.g., retailers, wholesalers, etc.) are tasked with managing this growing inventory.
To manage growing product inventories, businesses have implemented perpetual type inventory management systems, which are systems that use Point Of Sale (POS) data on products sold, invoicing data, and historical data on inventory audits or cycle counts (e.g., periodic inventory counts of products) to determine the inventory that exists within the walls of a retail store. POS data generally refers to data generated at a checkout system (i.e., cash register). Based on the inventory level within the retail stores, products may be reordered from a manufacturer. Alternatively, the manufacturer and retailer may have an agreement that directs the manufacturer to preemptively deliver products according to the terms of the agreement. Ideally, inventory is replenished in a manner such that inventory arrives at the retail store just before existing stock levels are exhausted.
Although perpetual inventory management systems alleviate some of the burden in managing large inventories, they employ a management that injects inaccuracies in cycle counts, POS scanning data, redundant re-ordering, misdirected shipments, and/or unusual sales velocity (i.e., the sale of products that take place either too fast or too slow). The result is physical (actual) inventory out-of-stock levels as high as 11-12 percent or even much higher for specially promoted products or products that are closely monitored for safety purposes (e.g., products with expiration dates).
Another shortcoming associated with perpetual inventory management systems includes inventory shrinkage, also described as the reduction of inventory due to non-sale circumstances. For example, shrinkage may occur at any point in a supply chain, stemming from invoice errors, vendor fraud, misdirected shipments, retail employee theft and customer theft. If inventory is computed as described above (i.e., using perpetual inventory management techniques), shrinkage rates (amounting to several percent of sales) can cause divergence of theoretical (i.e., inventory that is proposed or planned) and physical inventory. Another problem with perpetual inventory management systems is the uncertainty associated with the effectiveness of product promotions. For instance, if the relationship between price and inventory velocity, known as price elasticity, is not well understood, promotions can cause an out-of-stock condition that negatively impacts customer satisfaction and loyalty. Alternatively, promotions can fail to achieve a desired reduction of inventory when too much inventory is ordered and the price elasticity is poorly estimated or measured.
Further, another related problem with conventional inventory management systems is associated with misplaced inventory on a retail shelf or similar support unit. Product manufacturers devote large sums of money to market certain products to consumers. In some instances, this marketing may include combating a competitor that manufacturers a similar product. Because retailers generally desire to present as much inventory as possible for sale to the customer, some employees may fill a void on a shelf dedicated for an out of stock product with related products. In some instances, the related products may include products produced by a manufacturer's competitor. This may result in lost sales for the manufacturer and, in some cases, reduction in customer satisfaction. This may also violate agreements between retailers and manufacturers or their distributors.
To address the shortcomings of conventional inventory management systems, businesses have begun to incorporate wireless identification devices to assist in managing the inventory of products. This advancement contemplates attaching Radio Frequency Identification (RFID) tags on products during manufacture or when the products are stored in a warehouse. Each RFID tag includes an Integrated Circuit (IC) that enables the tag to have a unique identification number. Therefore, when a product is taken from a warehouse and placed on a retail shelf, for example, the products may be scanned to give a comprehensive inventory. Further, RFID tag technologies have been contemplated in providing distributed inventory management between a manufacturer and a retailer. For example, a manufacturer may be alerted through the Internet each time a product is sold at a retailer using the information stored in the product's RFID tag. The manufacturer may then use this information to forecast replenishment schedules with the retailer to prevent an out of stock situation.
Although the above mentioned RFID tag developments help overcome some of the shortcomings of conventional perpetual inventory management systems, these developments lack the capabilities to provide real, or near real, time comprehensive inventory management in almost any point of a supply chain. Accordingly, there is a need to provide an intelligent inventory management system to provide a comprehensive view of the inventory within a particular environment.
PRIOR ART SEARCH
US4673932A1983-12-291987-06-16Revlon, Inc. Rapid inventory data acquisition system. US4688062A1984-06-291987-08-18Raytheon Company Semiconductor structure and method of manufacture. US4737910A1985-10-151988-04-12Kimbrow Ronald Apparatus for tracking inventory US4766295A1987-03-021988-08-23H.E. Butt Grocery Company Electronic pricing display system. US4783740A1985-12-261988-11-08Kabushiki Kaisha ToshibaInventory management system. US4814742A1985-04-041989-03-2Sekisui Jushi Kabushiki Kaishalnquiry system for detecting a selected object.
US4937586A1986-09-221990-06-26Stevens John KRadio broadcast communication systems with multiple loop antennas. US4951029A1988-02-161990-08-21Interactive Technologies, Inc. Micro-programmable security system, US5168445A1988-03-041992-12-OlHitachi, Ltd. Automatic ordering system and method for allowing a shop to tailor ordering needs. US5198644A1989-05-051993-03-3Diablo Research Corporation System for display of prices and related method.
OBJECTIVES OF THE INVENTION
1. The objective of the invention is to a technique, systems, and articles of manufacture consistent with certain aspects related to the present invention collect item information from bar-code/RFID tags attached to items in an inventory. 2. The other objective of the invention is to a the invented technique also uses the collected item information to perform various inventory management processes and the inventory management processes may include determining, reporting, and providing corrective actions for one or more events associated with at least one of depletions of items in the inventory, changes in the design of items in the inventory, defects with one or more items, misplaced items, the movement of an unusual number of items within a short period of time, and malfunctions of one or more components included in the environment. 3. The other objective of the invention is to the invented technique to manage growing product inventories, businesses have implemented perpetual type inventory management systems, which are systems that use Point of Sale (POS) data on products sold, invoicing data, and historical data on inventory audits or cycle counts (e.g., periodic inventory counts of products) to determine the inventory that exists within the walls of a retail store. 4. The other objective of the invention is to the POS data generally refers to data generated at a checkout system (i.e., cash register). Based on the inventory level within the retail stores, products may be reordered from a manufacturer. 5. The other objective of the invention is to a the alternatively, the manufacturer and retailer may have an agreement that directs the manufacturer to preemptively deliver products according to the terms of the agreement. Ideally, inventory is replenished in a manner such that inventory arrives at the retail store just before existing stock levels are exhausted.
SUMMARY OF THE INVENTION
Methods, systems, and articles of manufacture consistent with certain aspects related to the present invention provide a process for managing an inventory of items, each item being positioned in a respective location within an environment and being associated with a corresponding wireless identification device. In one aspect of the invention, the process may include providing item information associated with each item to each corresponding wireless identification device. Based on the item information, the process may perform an inventory management process to provide real time information associated with the inventory of items.
The inventory management process may include at least one of an out of stock control process, a shrinkage recognition process, a rapid product recall process, an alert monitor process, and a sales optimization process. Each of these processes may perform various tasks that are used to manage the inventory of items in the environment, such as monitoring inventory levels of the items, detecting misplaced items in the environment, and providing feedback information associated with the items based on detected events (e.g., suggested alternative locations for certain items based on sales data).
BRIEF DESCRIPTION OF THE DIAGRAM
FIG. 1: is a block diagram of an exemplary system consistent with certain aspects related to the invention.
FIG. 2: is a block diagram of an exemplary environment consistent with certain aspects related to the invention.
FIG. 3: is a flowchart of an exemplary EPC writer process consistent with certain aspects related to the invention.
FIG. 4: is a block diagram of an exemplary interface map consistent with certain aspects related to the invention.
FIG. 5: is a flowchart of an exemplary inventory analysis process consistent with certain aspects related to the invention.
FIG. 6: is a flowchart of an exemplary shrinkage process consistent with certain aspects related to the invention.
FIG. 7: is a flowchart of an exemplary recall process consistent with certain aspects related to the invention.
DESCRIPTION OF THE INVENTION
FIG.1: is a high level block diagram of an exemplary inventory management system100 consistent with certain aspects related to the present invention. As shown, system100 may include one or more environments 110-1to 110-N interconnected by a network 180. Environments 110-1 to 110-N may also be directly connected via a direct communication path between the environments (not shown). Network 180 may represent any type of communication configuration that allows environments 110 1 to 110-N to exchange information. For example, network 180 may be a Local Area Network (LAN), a Wide Area Network (WAN), and a combination of networks, such as the Internet. Further, network 180 may include the infrastructure that allows environments 110-1 to 110-N to exchange information using wireless based communications.
Environments 110-1 to 110-N may each represent an environment associated with a business or non-business entity. In one aspect of the invention, each environment 110 may include, or is associated with, physical structures that manufacture, produce, maintain, store, and/or sell items. For example, environments 110-1 to 110-N may represent a retail store that sells items, a warehouse that purchases, stores, maintains, and/or ships items, a stock room that stores supplies, etc. Environments 110 1 to 110-N may also represent a main office business entity that manages the sale, production, storage, etc., of items located and sold in other environments 110. For instance, several environments (e.g., 110-1) may represent a retail outlet store, such as a supermarket, that sells items directly to consumers (i.e., users) and environment 110-N may represent a main office that manages the inventory and other business aspects of each of the several environments. In accordance with certain aspects of the present invention, one or more environments (e.g., 110-1) may perform intelligent inventory management based on item information collected by automated services performed within the environment(s).
To perform the intelligent inventory management services consistent with aspects related to the present invention, each environment 110-1 to 110-N may include an Intelligent Inventory Management System (IIMS) 105, a Data Collection System (DCS) 160, and item inventory 170. IIMS 105 may represent one or more computing systems, such as a server, personal computer, workstation, laptop, or any other similar computer system known in the art, that performs one or more processes consistent with certain aspects of the present invention. Although FIG. 1 shows IIMS 105 located within each environment, certain aspects of the invention enable the IIMS 105 to be located outside an environment as well. For instance, a department store chain may have several stores connected by a network to a single IIMS 105.
DCS 160 may be a configuration of hardware, firmware, and/or software that performs data collection functions consistent with certain aspects of the invention. In one aspect, DCS 160 includes components that collect item information from one or more items included in item inventory 170 using RFID technologies. Item inventory 170 may represent one or more items that are physically located within the respective environment 110. Item inventory 170 may also include one or more types of items that may or may not be similar in characteristics, size, price, taste, functionality, etc. For example, in the example that environment 110-1 represents a supermarket store, item inventory may include different types of food and beverages, with each type of item including a number of items. Thus, in the above example, environment 110-1 may include thousands of items of different types of beverages and other edible items. Alternatively, if environment 110-1 is associated with a home improvement warehouse retail store, item inventory 170 may include different types of tools, machines, appliances, etc.
The items described herein are associated with retail merchandise that is assumed to rest on store shelves that contain RFID antennae included in a respective environment 110. Each item may be associated with an RFID tag that includes item information associated with the respective item. For example, an RFID tag may include identification information unique to the item that the tag is attached, such as an a serial number or a price number. Alternatively, the RFID tag may include item information representing a type and/or associated characteristics of the item, and information identification an environment the RFID tag is located (e.g., for scenarios where IIMS 105 is located outside an environment). DCS 160 may be configured to retrieve the item information from RFID tags associated with each item included in item inventory 170 and provide the information to IIMS 105.
Other types of information retrieving mechanisms may be implemented within environment 110-1 associated with the antennae, including pegboard displays, garment racks, shelf-end displays, cabinets, kiosks, backroom or warehouse racks, display cases, and point of sale or checkout lane equipment. Further, although the following description of certain aspects of the invention involves RFID based shelf units, one skilled in the art will appreciate that the present invention can be applied as well with RFID readers associated with POS locations (e.g., checkout lanes), warehouse racks, portal areas, etc.
The characteristics of the antennae (e.g., form factor), and the rate at which antennae are read, may require adjustment for use in applications other than shelves. For example, warehouse applications might require longer read range and less frequent data updates, while point of sale applications may require very fast data updates with possible lower read ranges. The type and functionality of the RFID based components and systems that may be implemented with methods and systems consistent with the present invention is described in the previously mentioned U.S. patent application Ser. No. 10/348,941, which is incorporated by reference in its entirety.
Exemplary Environment 110-1:
As described, system 100 allows item inventories 170 to be intelligently managed by one or more environments 110. FIG. 2 shows a block diagram of an exemplary environment 110-1 consistent with certain features of the present invention. As shown, environment 110-1 may include IIMS 105, a Request Response Manager (RRM) 220, and DCS 160.
IIMS105may include a CPU201, memory202, display204, and database215. CPU 201 may be any type of processor (or processors) known in the art. CPU 201 may be configured to execute instructions and perform processes consistent with certain principles related to the present invention. Although FIG. 2 shows only one CPU 201 included in IIMS 105, one skilled in the art would realize that a number of different architectures may be implemented by methods, systems, and articles of manufacture consistent with certain features related to the present invention. For example, CPU 201 may be replaced, or supplemented, by a plurality of processors with one or more of them performing multi-tasking and/or multiprocessing operations. Display 204 may be any type of device that presents information to a user, such as a computer screen in a workstation, laptop, dumb terminal, kiosk, etc.
Database 215 may be one or more storage device systems that store information used by IIMS 105 to perform the intelligent inventory management features consistent with the present invention. Database 215 may be controlled by a database server (not shown), such as an SQL database server. Further, a Java Data-Base Connectivity (JDBC) driver for the SQL server may be used to access the SQL server database. Database 215 may store information associated with each identifier included in the RFID tags. Thus, for each Stock Keeping Unit (SKU) (i.e., information associated with an item reflecting at least a certain type of product (e.g., item type), made by a certain manufacturer, in a certain size, color, style, etc.), the item information stored in database 215 may be selected from:
1. A Universal Price Code (UPC) and/or an Electronic Price Code (EPC). Note that items made by a certain manufacturer in a certain size, color, etc. may have all the same UPC but each may have a unique EPC. Further description of EPCs is provided below with respect to the section entitled "EPC Writer."
2. A current price of the item.
3. An indicator of a seasonality of the item. A seasonality indicator may represent a relationship between an item and a period of time associated with different events or seasons, such as holidays, a time frame surrounding a certain date of a special event (e.g., the Super Bowl), etc. For example, a soap product may have a seasonality indicator representing no seasonal characteristics, such as "no season," wreaths may have a "Christmas" indicator, charcoal may have a "summer" indicator, etc. Further, promotional items (e.g., those items that are being specially marketed by a manufacturer or retailer) may have a seasonality indicator associated with a time frame, such as "July 2003," etc. The seasonality indicators may be used by ISSA 200 and/or a user to determine when to remove or restock certain items in item inventory 170.
4. A shelf life of the item. A shelf life may be a period of time that an item may be allowed to be included in item inventory 170. For example, perishable products, such as milk, may have a limited period of time that they may be presented on a shelf for sale to a customer. Non-perishable products may also have a limited period of time to be present in inventory 170 based on one or more factors, such as previous sales of items of a similar type, limited promotional time frames, etc.
5. Historical data about the sales rate of each type of item. The historical sales data may extend back a certain period of time, such as a certain number of days, hours, etc. The historical sales data may be formatted in such a manner that provides information reflecting a quantity of sold items of a given type over a period of time, such as a table including a column of sales data having 168 rows representing 7 days multiplied by 24 hours. The column may have fewer rows for an environment that operates less than 24 hours per day, such as a retail store or business that is not open round-the-clock. Further, database 215 may include additional columns of sales rate data for an item, for example representing certain conditions, such as a standard price, a promotional price, a holiday season, a clearance condition, etc. Holiday seasons may be extended (e.g., Christmas) or short (e.g., Memorial Day, July 4, Labor Day, etc.). Other situations that may produce unusual selling patterns (e.g., accelerated selling patterns) include the Super Bowl, or the days before predicted severe weather such as a blizzard or hurricane.
6. Historical out-of-stock data representing one or more conditions when a type of item has been unavailable in item inventory 170.
7. Historical data representing a number of times an item is picked up then returned to a shelf without a purchase.
8. A shelf "volume" size of an item representing a size characteristic of a single package unit of an item. The size characteristic may be measured as a rectilinear solid or other types of geometrical spaces that may be mathematically represented and manipulated by a process executed by a computer and/or user. For items that cannot be stacked on top of each other, the shelf volume size may be considered to extend up to another shelf positioned adjacent to the shelf whereon an item is currently located.
9. One or more locations within environment 110-1 where the item is preferably located, such as shelf numbers or warehouse locations.
10. Information summarizing shrinkage reflecting a movement of a certain number of items specific to time and place within environment 110-1. For example, shrinkage information may be associated with a condition where a large number of items of a certain type are removed from a shelf in a small amount of time.
11.Information summarizing out of stock events specific to time and place within environment 110-1.
Additionally, for an item collection of a certain type (e.g., an individual box of any type of item), database 215 may store item information selected from:
1) The EPC of the item. 2) The UPC of the item to relate back to the SKU information described above. 3) Other types of information not directly known from the SKU (e.g., color, style, size). 4) A serial number associated with the item (if other than the EPC). ) A cost of the item to a business entity associated with environment 110-1, such as a retailer. 6) A date the item was first placed in a location within environment 110-1, such as a particular shelf. 7) An expiration date of the item (if any). 8) Item location information representing a current physical location of the item in environment 110-1 (or if sold, the last known location of the item). 9) A price an item sold was sold (if already sold). ) A date the item was sold (if already sold). 11) A preferred customer number of a purchaser (if already sold) representing a unique number assigned to a user that purchases or may purchase items located within environment 110-1.
Database 215 may be configured to store data in various data formats and database configurations. For example, database 215 may store one or more tables that include information used by ISSA 200 to perform certain functions related to the present invention. These tables may include:
1) tblAlerts-a table that stores alerts and alert confirmations associated with certain events within environment 110-1.
2) tblCompany: a table that stores information about a business entity (e.g., company) that owns, leases, manages, and/or is associated with environment 110-1.
3) tblCurEPC-a table that stores information regarding current EPCs at a given location within environment 110-1 (e.g., at a given shelf).
4) tblEPC: a table that stores information relating an EPC code to product information, such as manufacturer, SKU, and other types of information associated with a product (e.g., an item).
) tblEPCReader-a table that stores information that relates to an EPC reader device, such as reader 262.
6) tblEPCSkuBase-a table that stores information regarding a base level inventory for an EPC reader device (e.g., reader 262) and any item types associated with the reader.
7) tblERPInv-a table that stores information associated with a current theoretical inventory (e.g., a planned or proposed inventory that should be present in environment 110-1 as opposed to actual inventory) provided by an Enterprise Resource Planning system (ERP) or other types of inventory systems. An ERP system is a business management system that integrates many facets of a business, including planning, manufacturing, sales, and marketing, such as those ERP systems provided by SAP, Oracle, and PeopleSoft.
8) tbllnventoryAlertConfig: a table that stores configuration items for an inventory alert job (e.g., a task performed by IIMS 105 that provides alert messages based on one or more inventory conditions).
9) tbllnventoryRemovalAlertConfig: a table that stores configuration data for an Inventory Removal Alerts process.
) tblManu-a table that stores information associated with one or more manufacturers of items included in inventory 170.
11) tblReaderType-a table that stores information that defines actions that an EPC reader may perform (e.g., read, turn displays on/off, adjust power level, etc.).
12) tblReaderTypeActions: a table that stores a list of possible actions for a given EPC reader.
13) tblRelatedEPC-a table that stores identification information for any EPC readers that are related to one of another (e.g., connected to a common shelf unit, associated with a common antenna or antennae, etc.).
14) tblRemEPC-a table that stores EPCs that are no longer located at a given location within environment 110-1 (e.g., no longer on a designated shelf).
) tblRequestBroker-a table that stores information defining a request broker location and associated ports (e.g., TCP/IP port identifiers).
16) tblSku-a table that holds information about item SKU information.
17) tblSkuCat-a table that stores information regarding one or more categories for various items.
18) tblStore: a table that stores information about environment 110-1.
19) tblUser-a table storing a list of any users that are authorized to access ISSA 200.
) tblVirtualCommands: a table that stores a list of virtual commands for an EPC reader. The command list may include commands that may be sent to an RFID reader to direct the RFID tag to perform one or more operations, such as storing item information.
One skilled in the art will appreciate that the above listed tables are exemplary and not intended to be limiting. Database 215 may include more or fewer tables that are configured to store various types of information used by ISSA 200. Memory 202 may be one or more known type of storage devices that store data used by IIMS 105. Memory 202 may be, but is not limited to, a magnetic, semiconductor, and/or optical type storage device. Memory 202 may also be a storage device that allows CPU 201 quick access to data, such as a cache memory. In one configuration consistent with selected features related to the present invention, memory 202 may store data and/or program instructions (e.g., applications) to implement methods consistent with certain features related to the present invention. Among the software that may be included in memory 202 is Intelligent Shelf Software Application (ISSA) 200.
ISSA 200:
ISSA 200 may be an application program, such as a web-enabled application, that provides information to a user, or to an ERP system. Accordingly, ISSA 200 may be configured to receive data from, and supply data to, a user or an ERP system (or other types of business management systems). ISSA 200 may temporarily store inventory data collected from DCS 160 in database 215 before transferring portions of the data to the user and/or an ERP system. In one aspect of the invention, a user may customize ISSA 200 to determine how much inventory data is managed and stored in database 215 and how inventory data is kept in an ISSA system located at another environment, such as environment 110-N.
Additionally, ISSA 200 may execute and/or operate with one or more security processes that are configured to control access to the functions of ISSA 200. For example, ISSA 200 may execute a security process that requires a user to provide a valid username and password (or other form of identification) to access the features provided by IIMS 105, including those performed by ISSA 200. Further, ISSA 200 may assign one or more roles to a user. Based on an assigned role, ISSA 200 (or any other application and/or process included in IIMS 105) may determine which tasks (e.g., programs executed by ISSA 200 via CPU 201) a corresponding user may access. Further, ISSA 200 may control whether a user is to receive certain types of alerts that may be received by ISSA 200 from other components within environment 110-1, such as DCS 160. Also, ISSA 200 may include a process that, when executed by CPU 201, creates and maintains a log file of any transactions performed by a user, such as adding data, requesting data, and/or modifying data in database 215.
ISSA 100 may include one or more user interfaces 210 that allow a user to exchange information with ISSA 200, such as through display 204. User interface 210 allows a user to request data in the form of commands or queries that are processed by business logic/transaction engine 230. Business logic/transaction engine 230 may be software, when executed by CPU 201, manages one or more tasks (i.e., processes) consistent with certain features related to the present invention. In one aspect, these tasks may include an out of stock control task 231, shrinkage monitoring task 232, rapid recall task 233, EPC writer task 234, other features task 235, and alerts task 239.
Out of Stock Task 231:
Out of stock control task 231 provides management functions to ISSA 200 associated with item inventory 170. For example, out of stock control task 231 may perform an inventory process that determines, on command and/or periodically, a physical inventory of items included in some or all of inventory 170, such as an actual inventory of items currently resting on a store shelf. Task 231 may allow a user (e.g., customer, employee, etc.) to request and view the results of the inventory process on a display device, such as peripheral device 255 or display 204. Task 231 may determine whether any item types are out of stock (e.g., not available for purchase by a customer because no items of that type are positioned in a location that the customer may collect and purchase).
Task 231 may create a list of these out of stock item types and prioritize them based on or more factors, such as lost profits due to the item type being out of stock for a previous period of time (e.g., last month), lost profits due to the item type being out of stock at the time the out of stock condition was determined, availability elsewhere in environment 110-1 (e.g., in a back storage room), and sale term (e.g., a new release of a popular DVD, snow shovel sales during a blizzard, etc.).
Additionally, out of stock control task 231 may perform an item misplacement process that creates a log of any items that are positioned in an incorrect location within environment 110-1, such as when an item is placed on a wrong shelf. Further, task 231 may generate and/or forward a misplacement alert message when an item is determined to be misplaced. Also, task 231 may perform a shelf count threshold process that allows a user and/or ISSA 200 to receive and/or be alerted in the event of, an indication of any item types that have a shelf count below a threshold value for a given location. A shelf count represents a number of items of a certain type that are actually present in a given location associated with the item type. For example, in a supermarket, a certain shelf may be assigned to a type of item (e.g., canned soup).
The shelf count of the exemplary item type would represent how many items of a particular type are located in the assigned shelf. In one aspect of the invention, the threshold value may be determined by a user and/or calculated by ISSA 200 based on one or more conditions, such as how many items of the certain type were previously removed from the given location during the same day, a week earlier, during the hours from a present time until the environment 110-1 is no longer open to customers, and/or until a next scheduled restocking of the item type. Also, the threshold value may be adjusted by one or more factors representing certain conditions associated with the item or external conditions, such as whether the item type is exposed to a sale promotion, a holiday shopping season, a time frame corresponding to a special event (e.g., the Super Bowl, weather conditions etc.).
In addition to providing feedback to ISSA 200 and/or a user regarding inventory conditions associated with one or more item types in inventory 170, out of stock control task 231 may also determine how much revenue (e.g., money) is being lost as a function of a certain period of time (e.g., lost revenue per hour) based on an item being out of stock (e.g., unavailable to a customer for purchase). Also, out of stock control task 231 may determine one or more factors that may influence the sale of items of a particular type. These factors may include, but are not limited to, pricing of the items of the item type, seasonal characteristics associated with the sale of the items, and sales of other types of items included in inventory 170.
Out of stock control task 231 may also determine one or more alternate locations within, and/or external to, environment 110-1 that a type of item may be repositioned based on previous sales associated with the item type and/or whether the item type is out of stock. Further, when an item type is determined to be out of stock, task 231 may generate a message to be displayed on a display device reflecting the out of stock condition. The out of stock message may also include other information, such as an apology for the out of stock condition, an offer for a discount of the sale price of another item of a type similar to the out of stock item type (e.g., store or generic brand product), a rain check for the out of stock item, and directions to an alternate environment (e.g., nearby store) that includes an item of the same type in its inventory and the item's price.
Shrinkage Task 232:
Shrinkage task 232 may perform processes that manage the shrinkage of items included in inventory 170, such as the loss of inventory through theft, bookkeeping errors, and misplacement. In one aspect of the invention, shrinkage task 232 may perform a process that determines, and/or allows a user to receive information reflecting, when physical shelf inventory and/or theoretical shelf inventory are off by a certain percentage. Theoretical shelf inventory represents a value determined by ISSA 200 corresponding to an inventory of items that should be located in a particular location in environment 110-1. For example, in a case of high-value merchandise, a user may wish to know when the physical and theoretical inventory quantities are different by only one unit.
Further, shrinkage task 232 may perform a process that determines, and/or allows a user to view, which locations of environment 110-1 are experiencing the greatest shrinkage. Also, task 232 may perform a process that determines, and/or allows a user to view or be alerted, when items are removed from the shelf in a predetermined quantity, such as a quantity defined by a store manager. The predetermined quantity may represent a large quantity of items that are removed in a relatively short time, which may possibly indicate a theft condition. The removal of a large quantity of items, however, may also denote an exceptionally good customer deserving immediate customer service. Accordingly, shrinkage task 232 may record a detected shrinkage condition in a log and may send an interrupt signal to one or more peripheral devices, such as silent alarms, flashing lights over a gondola, a camera or video time stamp, or an audio "thank you message." Further, shrinkage task 232 may create and provide a message to a user (e.g., sales clerk, employee of environment 110-1, etc.) that includes information to dispatch the user to the area to offer assistance to a "valued customer."
Rapid Recall Task 233:
Rapid recall task 233 may perform one or more processes that allow a user or business entity (e.g., retailer, item manufacturer, etc.) to trace items based on critical data, such as lot number, age, etc. Task 233 may determine and provide information about an item or items that may need to be removed from a shelf, or whose sales should be accelerated for other reasons. For example, certain types of items may have an associated expiration date determined by their manufacture, such as pharmaceuticals, health and beauty products, and perishable goods (e.g., foodstuffs). Although some of these items may still be safe (and pharmaceuticals still be effective) for some time beyond the expiration date, accepted practice may be not to sell the items after their expiration date. Therefore, shrinkage task 233 may identify items that are approaching an expiration date and provide information to a user that indicate the expiration date condition. Further, task 233 may provide suggestions to promote the sale of these items before their expiration date, such as determining an alternate location in, or outside, environment 110-1 that has a history of higher item sales (e.g., a front of a shelf), and/or suggestions to sell the items at lower prices.
Also, task 233 may provide information to a user when an item or items have expired so that the items may be removed from inventory 170. Rapid recall task 233 may also provide information associated with purchase planning for item types. For example, an item type that is not selling well (e.g., sales of the item are not reaching expected levels) before its corresponding expiration date may be indicative of excess inventory. Accordingly, task 233 may provide information that reflects a relationship between previous sales of an item type and expiration dates for items of that item type.
Additionally, rapid recall task233may access database215to collect shelf life information associated with each item in inventory170. Shelf life information may represent an approximate useful life of an item, which may be determined from an expiration date for certain types of items. Alternatively, shelf life may represent a usual turnover time for the item, regardless of its useful life or expiration date. Task 233 may determine when an item has exceeded its shelf life and provide an indication of this condition to a user, via a display device (e.g., display 204).
Rapid recall task 233 may also access database 215 to collect time-stamped temperature data associated with certain items in inventory 170. The temperature data may reflect a temperature value of an area proximate to a one or more items stored in environment 110-1, such as a refrigerated shelf unit. Rapid recall task 233 may use the temperature data to calculate a reduced shelf life or predict spoilage for temperature dependent items, such as milk. Further, task 233 may provide and/or forward an alert message to a user that reflects a condition when the temperature of a particular area (e.g., refrigerated shelf unit) falls below an acceptable level for any items stored in the area.
Further, for any items of certain types that have a shelf life or expiration date, rapid recall task 233 may provide, as an additional safety feature against database error, an alert to one or more locations within or external to environment 110-1. For example, an alert message (e.g., sound and/or display message) may be provided at a POS location or checkout lane to have the cashier double-check the expiration date normally printed on the package for an item about to be purchased at the POS location.
Rapid recall task 233 may also determine which items have been modified by a manufacturer or supplier and, based on this determination, provide information reflecting possible actions that may help move older inventory. For example, products (i.e., items) sometimes undergo a style change, such as a new package style, a different size, a color change, a flavor change, etc. While the existing product is still good, a retailer may want to sell off existing older stock as soon as possible because customers may be reluctant to purchase a perceivably older product. Accordingly, rapid recall task 233 allows the retailer to locate such restyled merchandise and to move it to more marketable locations, such as onto the sales floor, in the front of shelves, and/or offer the merchandise at a discounted price to move the older merchandise from inventory 170.
Items also may be defective when they arrive in environment 110-1. In the case of pharmaceuticals, it may be imperative to remove the item immediately to prevent possible health risks. These items may be destroyed at environment 110-1 or returned to the manufacturer. Further, a defective item may need to be recalled by the manufacturer. Accordingly, removing the defective item from inventory 170 before it is purchased may save time for a retailer and the customer, as well as permit the item to be returned to the manufacturer intact in its original package. Rapid recall task 233 may perform one or more processes that address these types of situations. For example, in some cases, an item may have a defect that renders it less valuable, while not constituting a health or safety risk, such as an item with a missing part, a cosmetic defect, a mismatched part, etc.
A manufacturer may be able to identify these items after they have been delivered to environment 110-1 based on an identification number associated with the delivery (e.g., lot numbers). However, once a large number of items are warehoused and/or shipped, different lots may become mixed together and the retailer may have problems identifying the items affected without opening the packages. However, with the RFID tagging features associated with certain aspects of the present invention, the manufacturer may identify a range of RFID serial numbers that were incorrectly packaged. Environment 110-1 may receive these serial numbers and allow ISSA 200 to identify the defective items in inventory 170.
Rapid recall task 233 may perform a process that searches database 215 for items associated with the received serial numbers for the defective items and provide this information to a user, perhaps through display 204 or other peripheral devices. The user may then offer customers various marketing incentives to move the defective items from inventory 170. For example, a customer may be offered a discount on a defective item for purchasing it "as-is." Upon sale of the product, a cashier may either take the customer's name and address and relay this information to the manufacturer, or the customer may be given a key number with which to order a missing part free of charge from the manufacturer, such as through the Internet. Alternately the known missing part may be shipped to the retailer to be handed out as a free "service package." Procedures like these would save the manufacturer shipping and handling costs involved in returning the entire package.
Further, a retailer might even use this feature to offer a special discount to a customer willing to purchase an "open carton" or such as product returned by another customer, that may lack items not due to manufacturer's fault. Using the RFID tagged items, a retailer may offer a special discount on packages damaged in the retailer's inventory 170, without worrying that unscrupulous customers might damage good boxes on the shelf and seek to obtain a discount.
Additionally, certain types of items, such as software products, often contain known errors or "bugs," that may require a remedial "corrective patch." For example, a computer readable medium (e.g., CD-ROM, DVD, magnetic disk, etc.) including one or more programs and data may require a revision comprising only a few megabytes that can be downloaded over the Internet. Rapid recall task 233 may identify these types of defective items using the RFID tags 280 in inventory 170. Consequently, the retailer and/or manufacturer may offer a customer a small discount to purchase an "out-of-date" or "buggy" product, with the customer understanding that the product may be brought up to specification with a few minutes' time on the Internet to download the corrective code. Further, environment 110-1 may provide one or more workstations that a user may use to download the corrective code while in environment 110-1.
EPC Writer 234:
EPC writer 234 may be a process that is used to aid ISSA 200 write EPCs to particular RFID tags 280. In one aspect of the invention, EPC writer 234 may access database 215 to obtain identification numbers, such as a UPC, for particular items that are to be tagged with an EPC on an RFID tag 280. Further description of these aspects of the invention is described below with respect to the section, EPC Writer.
Other Features Task 235:
Other features task 235 may perform one or more applications associated with advertising, price sensitivity, sales optimization, automatic pricing, and customer information and services. In one aspect of the invention, other features task 235 includes an Advertising, Price Sensitivity, and Sales Optimization (APSSO) application that determines relationships reflecting how advertising (e.g., marketing and/or presentment of items) and/or price influences the sales or possible sales of items or item types that are presented to customers that interact with inventory 170. This application may create, on demand or periodically, a summary of how often an item or items of a certain type are physically moved from their current location in environment 110-1, such as when an item is taken off of a shelf and replaced. Thus, the APSSO application may request and receive periodic inventory updates of inventory data reflecting a current inventory of items in inventory 170.
The APSSO application may leverage the out of stock task 231 to collect the inventory information, or alternatively send commands to inventory request interface 250 to collect the information itself, such as requesting an inventory reading a shelfs contents at least every few seconds. The APSSO application may compare the collected inventory information to sale rate data associated with the items corresponding to the collected inventory information to provide an indication (e.g., a ratio) of a number of item examination events per single purchase event. The indication, or ratio, may describe how much attention an item is getting from customers, as opposed to the rate of item purchases. The data could be correlated with location information associated with the item, for instance, whether the item was at eye level, on a shelf-end display, positioned in the front of a store, positioned in a promotional display, positioned in the back of the store, etc.
The term eye level, as used herein, may refer to one or more distances extending from the floor of environment 110-1 where items are displayed for purchase, such as 5 feet to 7 feet high. One skilled in the art will appreciate that the term eye level is not intended to be limited by this exemplary range of distances. Any distance from the bottom of a structure that supports item(s) that rests on the floor of environment 110-1 may be associated with the term eye level without departing from the scope of the invention. Further, the distance associated with the term eye level may be based on the type of environment 110 1 represents. For example, a clothing manufacturer and/or retailer may determine that eye level refers to a distance lower than that of a distance defined by a food retailer.
Also, the APSSO application may determine how often an item is purchased in pairs, triples, etc. Further, for a given item type, the APSSO application may identify other items of other types that are moved from their current position in environment 110-1 at, or about (e.g., within a few seconds, minutes, etc.), the same time as the given item type has an item moved, known as a correlated time of purchase. The APSSO application may also determine which items of a given type, if any, have not moved from their respective positions for a defined time period. Alternatively, or additionally, the APSSO application may determine what items of a given type have been moved and replaced for a defined time period (i.e., items that are not being purchased by the customers) and the APSSO application may identify any items of a given type that have undergone a price change within a previous period of time, such as the past day, week, month, etc. The APSSO application may generate a list of these price changed items and provide the list to a user via a peripheral device (e.g., device 255) and/or display 204. Further, the APSSO application may determine, based on the identified items with price changes, a relationship between these items and the number of item examination events (e.g., when a customer picks up an item and replaces it).
In one aspect of the invention, the APSSO application may interact with an expert system (internal or external to IIMS 105) to analyze historical data on cross-item or correlated sales, sales velocity (i.e., how rapidly or slowly are items being sold and their respective inventory being depleted), price-sales sensitivity (e.g., a relationship between previous sales of an item type and sale price events for that item type), seasonality, etc., to suggest improvements in store layout and shelf organization. That is, the expert system and/or the APSSO application may determine and provide suggestions to a user via a peripheral device on alternative locations for certain item types based on the above analyzed information.
Other features task 235 may also include an Automatic Pricing Application (APP) that performs processes that manage the sale price of an item. In one aspect of the invention, the APP may receive and/or collect price plans from database 215 (or any other memory device that may store these plans) and automatically update a displayed item sale price on a display device (e.g., an LCD mounted on a shelf supporting the item). A price plan may represent a price schedule for certain or all item types in inventory 170 that is generated by a price plan process executed by a computing device (e.g., IIMS 105) or generated by a user (e.g., retail store manager). For example, an exemplary price plan may include scheduled promotions that suggest reducing the price of certain item types based on these promotions.
Further, a price plan may consider season or time dependent conditions, such as holidays, weather conditions, etc., to determine how to modify the price of an item type. For instance, the price plan process may collect periodic weather information from a server system that accesses and stores current weather data for a surrounding area proximate to environment 110-1 (e.g., 50-100-mile radius, city limits, etc.) The price plan may use the collected weather information to determine whether the sale price of certain items (e.g., snow shovels, stock wood studs, etc.) should be adjusted. Alternatively, a user (e.g., store manager) may collect, or automatically receive, the weather information and adjust the sales price manually through the price plan process and/or the APP.
The APP may also correlate, in real time, the price of a target item with the age of the shelf inventory associated with the target item, an amount of items of the same type as the target item in theoretical inventory, and the sales velocity of other item types whose sales correlate with the sale of the target item. The APP may generate a report reflecting the correlation(s) and provide the report on demand or on a scheduled basis to a peripheral device (e.g., storage device, display device, printer, etc.).
The other features task 235 may also include a Customer Information and Special Services Application (CISSA) that performs processes that provide users (e.g., customers shopping in environment 110-1) with assistance in locating an item of interest under a variety of special circumstances. In one aspect of the invention, the CISSA may also provide item inventory availability information to remote users (i.e., customers). For example, a user remotely located from environment 110-1 may access a web site hosted by a server operated in association with environment 110-1 through network 180. Using the web site, the user may request the availability of one or more items of one or more types at environment 110-1 (e.g., is an item in inventory 170). The CISSA may receive the request from the computer server and determine whether the request items are available in inventory 170. In one aspect of the invention, the CISSA may access database 215 to collect inventory information collected by out of stock task 231. Alternatively, or additionally, the CISSA may request a search for the requested items throughout environment 110-1 by providing one or more commands to RRM 220 and DCS 160.
Further, the CISSA may generate a request for the availability of the requested items at one or more remote environments (e.g., environment 110-N) and receive back a response indicating whether the requested item(s) are available at these respective locations. In this scenario, the remote environment may perform a local inventory search process to determine whether the item is currently in stock. Based on the local search, the remote environment may provide a response message to environment 110-1 indicating the result of the local search (e.g., the item is or is not available at that location). Alternatively, remote environments may periodically provide their current inventory data to environment 110-1. ISSA200 may receive and store this received information in a database (e.g., database 215) for access by the CISSA as needed.
Based on the received information indicating whether the item is available, the CISSA may provide the user (via the computer server and network 180) a response indicating a real time availability of a requested item at environment 110-1 and/or at alternate environments, such as a user's favorite retail outlet or the nearest three or four alternative outlets.
Additionally, the CISSA may provide the same item availability functions described above through computing devices located within environment 110-1(e.g., kiosks located in a store). For example, when a customer arrives at a store (e.g., environment 110-1) expecting to find a particular item and is disappointed to learn the item is out of stock, the customer may request the item's availability using a kiosk located within the store. In addition to one or more alternative store addresses that have the item in stock, the kiosk may display to the customer an offer for an inconvenience discount (e.g., a cent off coupon for the item or perhaps another item).
The customer may accept the discount by, for example, providing a simple code word/number of their choice. The discount will be valid for a limited period of time and the customer need only use the chosen word/number within 24 or 48 hours this code word/number will entitle them to the discount at the alternative stores. Further, the CISSA may also provide alternate location information on a display device mounted on a shelf unit supporting an item or group of items. For example, for any item that is not in stock, the display device may display the location of, and/or directions to, the nearest alternate location (e.g., store) that currently includes the item in inventory. For items which are not out-of-stock, the display device may show the item price instead of alternate locations. As described above, the alternate locations may be determined based on these locations performing, on a periodic or a demand basis, an inventory search for the requested item.
Alert Monitor 239:
Alert Monitor 239 may perform one or more processes that notify a user of certain events. In one aspect of the invention, alert monitor 239 may notify a user through e-mail, a pager, a cell phone, an audible or visual signal, etc. Alert monitor 239 may include the appropriate software to interact with other devices, software, and/or computing systems that include the infrastructure to facilitate communications over a particular medium. That is, alert monitor 239 may send an alert message to an output interface that translates the message into a format compatible with a message relaying or provisioning system (e.g., wireless network device, etc.).
Alert monitor 239 may receive data reflecting an event from interface 250 and/or other processes, such as one of tasks 231-234, and formulate an alert message accordingly. The received data may reflect a pending item known to be in an alternate location (e.g., back room) so that a user (e.g., retailer employee) may bring the spare stock onto a retail floor. If the item out of stock cannot be replenished from the alternate location, the user and/or ISSA 200 may reorder the item. Further, the received data may reflect a malfunction in one or more components within environment 110-1, such as an antenna 270.
In one aspect of the invention, alert monitor 239 may operate on an "exception" basis. That is, providing alert messages as an event is detected to indicate to a user when something unusual happened. Also, alert monitor 239 may operate on an escalation basis, where repeated or prolonged events would be given a higher priority. For example, a stock clerk might be alerted whenever an item was approaching an out of stock situation, or when a single shelf malfunctioned. Further, a department manager might be alerted if several types of items were out of stock, if an out of stock situation persisted for more than a day, and if a gondola went out of service.
ISSA 200 may also include one or more inventory request interfaces 250 that collects RFID tag reader events and may receive data and/or requests from business layer 230 and request response manager 220. The exchange of commands, data, and/or information within environment 110-1 denote a typical information flow, which may be associated with a higher level entity, such as inventory request interface 250 sending a command to a lower level entity such as DCS 160, and in return, receiving data from the DCS 160. Further, the information flow may also be reversed. For example, DCS 160 may request information from ISSA 200, such as antenna tuning data, or may report certain events ISSA 200, such as a malfunction in one or more components (e.g., antenna 270). Interface 250 may be an Active Server Page (ASP) that other applications may send HTTP information. Interface 250 may receive EPC data from RRM 220 and send EPC eXtensible
Markup Language (XML) data to a message queue that is set up for each reader 262 in DCS 160.
ISSA 200 may be configured using different types of architectures. For example, in one aspect of the invention, ISSA 200 may be configured in a three-tier architecture structure that includes a top level associated with user interface 210, a middle layer associated with business logic/transaction 230, and a bottom layer associated with database 215.
The top layer user Interface 210 may be software that runs on a web browser, such as Internet Explorer (v5.0 or higher) from Microsoft@ Corp. User interface 210 may, when executed by CPU 201, send requests and receive responses from a computer system, such as a server (e.g., Microsoft@ Internet Information Server (IIS)). The server may return XML and eXtensible Stylesheet Language (XSL) information to user interface 210. The XML and XSL information may be applied together by user interface 210 using one of many Document Object Model (DOM) techniques (e.g., Microsoft DOM). When the XML and XSL are applied by user interface 210, content presented in Hypertext Markup Language (HTML) may be displayed on display 204 through the browser executed by IIMS 105. Although the above examples described XML and HTML based services, one skilled in the art will appreciate that many types of data processing and presentation languages may be implemented without departing from the scope of the invention.
The middle or Business Logic tier 230 exposes business logic to ISSA 200. Business logic components may be developed, for example, using Microsoft .NET Classes, Microsoft VB.NET or C#. Furthermore, .NET Class components may be created from within ASP.NET Web Services. These classes may be stateless, and multi-threaded unless otherwise specified by business logic 230.
The database 215 tier may store data used to perform one or more inventory management processes consistent with certain features of the invention. In one aspect of the invention, there may be no business logic in this tier, that enables IIMS 105 to implement multiple types of databases. Database 215 may be accessed using different types of database languages, depending on the architecture the database is configured upon. For example, Structured Query Language (SQL) commands via ActiveX Data Objects (ADO) and/or Open Data Base Connectivity (ODBC) over Transmission Control Protocol/Internet Protocol (TCP/IP). Further, to prevent mismanagement of the information, database 215 tier may be configured to allow access only by business logic tier 230.
RRM 220:
RRM 220 may be an application that is executed by a computing system (e.g., an RRM system (not shown)) to provide a bridge (i.e., interface) between high level components (e.g., software such as ISSA 200) and lower level components (e.g., hardware/firmware, such as DCS 160). Although FIG. 2 shows RRM 220 as a separate component, RRM 220 may be stored in memory 202 and executed by CPU 201. In one aspect of the invention, RRM 220 may communicate between inventory request interface 250 and one or more primary controllers 260, located in DCS 160, or primary controller proxies (not shown) located within RRM 220, which perform data handling or analysis on information collected from RFID tags 280 in inventory 170. RRM 220 may include a user interface that allows a user to view a current status of RRM 220. The user interface may be accessed from IIMS 105 which may execute RRM 220.
In one aspect of the invention, RRM 220 may load XML configuration documents from an RRM configuration interface (not shown) included in ISSA 200. The configuration file may include one or more event lists and/or command lists, which are a list of events provided by DCS 160 and commands provided by ISSA 200, respectively. RRM 220 may create a request broker 222 for each event list in the configuration file from a configuration XML document provided by ISSA 200 (e.g., inventory request interface 250). Alternatively, RRM 220 may create a primary controller proxy (not shown) for each event list. A primary controller proxy is further explained below with respect to DCS 160 and primary controller 260. Also, RRM 220 may create one or more response brokers 224 that handle responses from one or more primary controllers 260 or primary controller proxies included within RRM 220. A response broker 224 may also send acknowledgment and/or failure information to request broker 222 indicating whether a response has been properly received from primary controller 260. In one aspect of the invention, response broker 224 may initiate an object-oriented class based on a reader 262 that receives read data and converts it to an EPC XML document. Response broker 224 may also send the EPC XML document to ISSA 200, if available. If the ISSA 200 is not available at that time, response broker 224 may store the EPC XML document in a queue until ISSA 200 is available.
When request broker 222 is initiated by RRM 220, it may be sent a list of commands from ISSA 200. Request broker 222 may access the received list and execute each command. After each command is executed, request broker 222 may wait for a response from a response broker 224, such as acknowledgement or failure response. If there is no response from response broker 224 within a certain time period (that may be defined in the command list), or a failure message is returned, another command list may executed in response to the failure. On the other hand, if an acknowledgement is received from response broker 224, then request broker 222 may execute the next command in the command list. Once all commands in a command list are executed, request broker 222 may re-execute the commands in the command list in the original order of execution.
Response broker 224 monitors for any responses provided by primary controller 260 or a primary controller proxy included within RRM 220. When a response arrives, response broker 224 may determine a response Internet Protocol (IP) address and creates a thread to process the received response while continuing to monitor for any additional incoming responses. Based on a received response from primary controller 260, response broker 224 may provide an appropriate request broker 222 with an acknowledgment or failure information representing the status of the broker's request. The appropriate response broker 222 may be the broker that executed a command or request that corresponds to the received response.
In the event the received response contains data, response broker 224 may dynamically initiate a method of an object to parse the data based on the configuration XML. Each class that is initiated may return similar EPC XML data. Response broker 224 may place each returned EPC XML data into a data structure, such as a table. Response broker 224 may also retrieve one or more read sequences for a given reader 262 from the table (e.g., a sequence of read commands that retrieve EPC information from certain RFID tags 280).
If response broker 224 determines that there is EPC XML data left in the queue for a current reader 262, then response broker 264 may send the data to ISSA 200. In one aspect of the invention, response broker 224 may send the EPC XML data from the queue in a particular sequence, such as oldest to newest. Once the queued EPC XML data is provided to ISSA 200, response broker 224 may then send the current EPC XML received. On the other hand, if there is no EPC XML data in the queue for the current reader 262, then the current EPC XML data is passed to the ISSA 200. At that time, if ISSA 200 is unavailable, then response broker 224 may place the current EPC XML in the queue.
In one aspect of the invention, ISSA 200 may request data (e.g., provide a read command) on demand (e.g., requests with response times of a few seconds or less) or periodically, such as requests that are initiated automatically on set schedules (e.g., every minute, hour, day, etc.). DCS 160 may acquire the requested data from RFID tags 280 through one or more antenna 270. The rate of acquisition of the data may be based on the number of RFID tags 280 included in inventory 170. Thus, for example, DCS 160 may collect the requested data within a few seconds for an inventory including a few hundred of tagged items or within a few minutes for much larger inventories, such as those including thousands of RFID tagged items. It is the responsibility of RRM 220 to manage the collection of the data through the components operating within DCS 160. For example, RRM 220 may be configured to sequentially provide a query for requested data to several RFID tag reader devices (e.g., reader 262) that are dedicated to collecting item information from RFID tags positioned in different locations within environment 170.
DCS 160 and RFID Tag Data Collection:
DCS 160 may be a collection of hardware, firmware, and/or software that perform data collection functions consistent with certain aspects related to the present invention. DCS 160 may include a primary controller 260, one or more readers 262, and one or more secondary controllers 266. DCS 160 may control one or more antenna 270 that are associated with (e.g., mounted on) corresponding support structures (e.g., shelf units) from which one or more items rest. The items in inventory 170 may each be tagged with RFID tags 280 that include item information, such as an EPC reflecting various characteristics associated with the respective item. When a corresponding antenna 270 is activated by DCS 160, information within any RFID tags 280 located within a readable proximity of the activated antenna may be retrieved and provided to DCS 160. The RFID tags 280 respond to RF energy emitted by antenna 270, and this response is sensed by reader 262, which returns digital serial data to the primary controller 260. The digital serial data may be parsed by primary controller 260 and then returned to response broker 224 for further processing by ISSA 200.
Primary controller 260 may be a device and/or process that monitors for and receives requests (e.g., commands) from request broker 222 and consequently generates a series of corresponding commands specific to a reader 262 that environment 110-1 may be using to access particular items in inventory 170. In one aspect of the invention, the commands provided by a request broker 222 may be formatted in accordance with a network protocol, for example, the TCP/IP protocol. Primary controller 260 may send the received commands (e.g., TCP/IP packets) to reader 262 and/or one or more secondary controllers 266. In another aspect of the invention, controller 260 may pass the commands to reader 262 and/or one or more secondary controllers 266 in the form of RS-485 or other types of serial communication protocols. Table I shows a list of exemplary commands that primary controller 260 may provide to reader 262 and/or secondary controllers 266.
TABLE I Exemplary Primary Controller Commands EXEMPLARY COMMAND Select an antenna 270 Place reader 262 in active mode Adjust a power level of reader 262 for the selected antenna 270 Perform a first read operation Determine which EPC numbers have been read Prevent the read tag(s) from responding further during a current read cycle Perform additional read operations until no more EPC numbers are read Place reader 262 in standby mode De-setect the antenna 270 Continue with the next antenna 270 to be read
Primary controller 260 also monitors for a response from reader 262 and/or secondary controller 266 that was sent one or more commands. Based on whether a response is received and the type of response, primary controller 260 may generate and send acknowledgment, non-acknowledgment (e.g., failure), and/or read information to response broker 224. The read information may include EPC information associated with the RFID tags 280 in inventory 170. For example, primary controller 260 may provide one or more EPC numbers to response broker 224 each time a read operation is completed by reader 262. Alternatively, primary controller 260 may store the EPC numbers temporarily in a memory device (not shown). Once a certain number of RFID tags 280 for one or more antennae 270 have been read by reader 262 (e.g., all of tags, a portion of the tags, etc.), primary controller 260 may also perform a batch transfer process that provides the read data (e.g., EPC data) all at once, or in groups, to response broker 224.
In another aspect of the invention, primary controller 260 may adjust for any differences in a received command or data stream that may be peculiar to a reader 262 that the controller may use to read information from RFID tags 280. Primary controller 260 may use any of a number of readers 262 so long as the chosen reader 262 is physically able to drive one or more antennae 270. Each antenna 270 may be configured to be compatible with one or more different types of readers 262. In one aspect of the invention, a given antenna 270 may be optimized (i.e., tuned) for one frequency, so that the antenna 270 may work with any reader 262 that uses the same frequency. Accordingly, more than one reader 262 may activate any given antenna 270 within environment 110 1 as long as the reader 262 provides its signals using the frequency tuned to that given antenna 270.
As explained above, although FIG. 2 shows primary controller 260 as part of DCS 160, controller 260 may be implemented as a software primary controller proxy (not shown) within the RRM 220. Accordingly, communications from the primary controller proxy software may leave the RRM 220 as TCP/IP commands and are converted to RS-485 data communications by a separate device and/or process (not shown).
Reader 262 may be one or more of any type of off-the-shelf RFID readers provided by many different manufacturers, such as the I-CODE reader provided by Philips@. More than one type of reader 262 may be implemented within DCS 160, as long as primary controller 260 (or an equivalent device dedicated to communicate with reader 262) is configured to communicate with the reader 262 (e.g., provide valid commands and properly interpreting returned data). Although FIG. 2 shows reader 262 as a separate component within DCS 160, primary controller 260 and reader 262 may be physically combined in a single electronic entity. Depending on the type of environment 110 1 and/or item inventory 170, one, several, several hundred, etc. readers 262 may be used by DCS 160 to collect item information from inventory 170. Although each reader 262 may be associated with its own primary controller 260, a single primary controller 260 may be assigned to work with one or more readers 262 to facilitate collecting item information from inventory 170.
Secondary Controller 266:
Besides communicating with reader 262, primary controller 260 also communicates with one or more secondary controllers 266. Secondary controller 266 is a computing device and/or process that may select one or more antennae 270 by controlling electronic components that act as switches to activate or deactivate a corresponding antenna 270. Each secondary controller 266 may be physically located proximate to and connected with a group of antennae 270, such as several antennae contained within a shelf or localized fixture that store items included in inventory 170. For example, environment 110-1 may have hundreds of secondary controllers 266 and thousands of antennae 270. Further, secondary controller 266 may also, upon receiving one or more commands from primary controller 260, operate a peripheral device 255 to display item information from RFID tags 280 included in item inventory 170 and/or provide inventory information to a user.
For example, peripheral device 255 may be a display mounted on a front edge of a shelf that supports one or more items. Alternately, peripheral device 255 may be connected directly to a serial data bus that communicates between primary controller 260 and secondary controller 266. Further, peripheral device 255 may be connected to a dedicated bus that is not tied to secondary controllers 266 (e.g., USB). Besides output devices such as displays, peripheral device 255 may include an input/output device, such as a bar code reader or any other type of device that may plug into a shelf to facilitate data collection/retrieval from items with or without RFID tags 280. For example, a user may use such a bar code scanner to collect and read the UPC number for an item and to associate an EPC number with UPC numbers already in a database. Accordingly, in circumstances where one or more items are received by environment 110-1 without an RFID tag 280, the scanner may be used to facilitate associating a non-tagged item with a
UPC or EPC. Also, peripheral device 255 may be a monitoring device that connects to an interface mounted on a shelf unit. The monitoring device may perform checking functions, such as checking the status of any antennae in the shelf unit and items resting on the shelf.
In one aspect of the invention, one or more peripheral devices 255 may communicate with one or more secondary controllers 266. For example, peripheral device 255 may represent a plurality of proximity sensors that each detect the presence of a user (e.g., customer) within a predetermined vicinity of the device 255. Based on whether a user, or other entity, was within the vicinity (e.g., a few inches, a few feet, etc.), device 255 may generate a signal (e.g., analog or discrete signal, digital signal, etc.) that may be monitored by a processor device and/or computer executed process with analog and/or digital I/O processing capabilities. Alternatively, device 255 may be a video camera mounted within or proximate to one or more shelves for surveillance purposes. The camera may receive a signal (e.g., interrupt) from secondary controller 266 when it determines that an item, or a number of items above a certain threshold number, was removed from a particular location. The camera may be activated by the signal to record video continuously or may take a still picture only when the signal is received.
One task of secondary controller 266 may be to switch antennae 270 mounted within a single shelf unit (or similar support unit) storing one or more items from inventory 170. Also, secondary controller 266 may be used to communicate information to and from a user (e.g., customer, retailer employee, etc.). For example, secondary controller 266 may receive from ISSA 200 (via database 215) item information about each item known to be on a shelf served by secondary controller 266. This item information may include current price, size, weight, unit price, and/or sale status (e.g., discount on a current sale price). The item information may be displayed on peripheral device 255, such as a shelf edge display. If there is more than one type of item on the shelf, there may be multiple shelf edge displays mounted on or near the shelf.
Alternately, information for each item type might cycle sequentially on a single display, pausing for several seconds before continuing to the next item type. The shelf edge display may be provided with a user interface button to temporarily halt the display cycle and to request additional information about the product being displayed when pressed by the user. Also, if ISSA 200 senses an item being removed from the shelf based on data provided by DCS 160, it may instruct secondary controller 266 to display information associated with that item on the peripheral device 255.
Secondary controller 266 may also be configured to facilitate other interactive operations between ISSA 200 and a customer. In one aspect of the invention, a customer may be provided with an RFID-based customer card that includes an RFID tag containing information concerning or identifying a customer. The customer identification information may be related to information stored in database 215 or another memory device that maintains customer information, such as a current shopping list provided by the customer (via the Internet and browser software, kiosk device, etc.), and profile information associated with the customer and/or the customer's family members (e.g., clothing sizes, brand preferences, etc.). When a customer carrying a customer RFID card enters and moves throughout environment 110-1, the presence of the customer card in the vicinity of a shelf equipped with the RFID antenna associated with secondary controller 266 may cause a signal or data to be passed to ISSA200through primary controller260. In response to the signal or data, ISSA200may direct secondary controller266to display information about an item at the shelf that detected the customer card, such as through peripheral device 255.
In this instance, ISSA 200 may access database 215 to collect any customer information associated with the identifier corresponding to the detected customer card. ISSA 200 may then determine whether any items or types of items located near or at the shelf that detected the card relate to the customer information stored in database 215. For example, ISSA 200 may determine whether an item is included in a shopping list created by the customer and/or relates to a list of preferred products for the customer. Further, ISSA 200 may provide additional information to secondary controller 266 for display on peripheral device 255, such as the availability of the customer's size in the case of a clothing item, the availability of a rebate for an item, and the availability of sales or rebates for other items.
The exemplary features associated with secondary controller 266 are not limited to RFID based customer cards. Methods and systems consistent with certain aspects of the invention may also allow a user who is an employee or similar individual affiliated with environment110-1to be assigned an RFID-based employee card. For example, a salesperson working for a retail store may be provided with an RFID-based employee card that may be detected by antenna 270 located in any shelf unit or similar structure included in the retail store. The presence of the RFID-based employee card within the vicinity of a shelf associated secondary controller 266 may cause ISSA 200 to provide commands to DCS 160 and ultimately secondary controller 266 that direct peripheral device 255 to display information associated with the shelf.
For instance, the information displayed may include data that identifies any out-of-date items that must be removed from the shelf, items approaching an expiration date that may be relocated forward on the shelf, moved to another location (e.g., a promotional area), and/or offered at reduced price, items that are short on stock and where to locate additional units of the items within the store (e.g., environment 110-1), and items that are misplaced and where to relocate them within the store. For items low on stock but not available from a third party supplier, such as a warehouse, ISSA 200 may instruct secondary controller 266 to display a message that conveys expected delivery dates of new stock. Further, the message may also report an availability of a missing item at nearby stores or alternate locations remote from environment 110-1.
ISSA 200 and RRM 220 may also communicate with DCS 160 that is located at POS locations, such as checkout lanes. At these locations, ISSA 200 may interact with the POS system to facilitate certain sales transactions. For example, ISSA 200 may automatically register an item having a warranty with a manufacturer by using serial number information obtained from the EPC number of the item and/or customer identification information (e.g., name, address, etc.) collected from an RFID (or conventional) customer card. The customer may be given an option whether to accept the registration at the checkout lane, or to defer it until later.
Optimization of RFID Tag Reading Performed by DCS 160:
In one aspect of the invention, reader 262 may send RF energy through an RF bus (e.g., cable) to antennae 270 through secondary controller 266. A single antenna 270, or a group of antennae 270 located adjacent to one another and working in concert, may be activated and operational at a given time based on signals provided by secondary controller 266 and/or reader 262. The active period for a given antenna 270 may be based on the amount of time it takes to collect information from RFID tags 280 located in proximity to the antenna 270. Secondary controller 266, under directions from the primary controller 260, may select and activate each antenna 270 in turn. The order in which antenna 270 are selected may be optimized so that the reader 262 may be shared among many antennae 270. The sharing of reader 262 may allow DCS 160 to collect inventory data more or less regularly, as well as focusing immediate attention on antennae 270 where one or more items are being moved. In one aspect of the invention, ISSA 200 may determine which antenna 270 to activate based on one more prioritization factors. These factors may include:
1) antennae 270 that are located in proximity to a RFID tag 280 that was most recently added or moved;
2) antennae 270 that are located in proximity of one or more antennae 270 with recent activity;
3) antennae 270 associated with one or more items known historically to have a high sales volume during a particular time period (e.g., time of day or week);
4) antennae 270 that are associated with a pushbutton request from a customer for information, such as an interactive display peripheral device 255 mounted on a shelf including the antennae 270;
) antennae 270 that have an RFID card (e.g., customer or employee card) located within their read range;
6) antennae 270 that have not been activated for a predetermined period of time;
7) antennae 270 that have one or more theft-prone items within their read range, such as high end merchandise items (e.g., jewels, etc.);
8) antennae 270 that are expected to have a product of immediate interest to a user (e.g., employee or customer), such as when a user requests information reflecting whether a desired item is available "on shelf' or in a back inventory stock room;
9) antennae 270 that are associated with one or more items that have passed through a POS terminal within a predetermined period of time (e.g., recent POS sales); and
) antennae 270 that are associated with one or more items approaching their shelf life.
One skilled in the art will appreciate that the above list of prioritizing factors is not intended to be limiting and ISSA 200 and/or a user may determine other prioritizing factors based on one or more variables and weighting factors associated with the characteristics of the items in inventory 170.
Performance Monitoring Capabilities of DCS 160:
In one aspect of the invention, the hardware/software components of DCS 160, including primary controller 260, reader 262, and secondary controllers 266, may perform self monitoring and self-diagnosing operations to determine and report any operational problems to ISSA 200. For example, to perform some self-diagnosing operations, a shelf unit may include, within the shelf's antennae 270 read range, at least one RFID tag to provide a self-check function. Accordingly, even when the shelf is empty (i.e., no items rest upon the shelf) there is at least one RFID tag that may be read by the antennae 270 included in the shelf. In one aspect of the invention, at least one such RFID tag may be embedded near the center of, or at another location easily read by, an antenna 270 included in the shelf and another RFID tag embedded near the antenna's 270 read-range limit. Secondary controller 266 may, either periodically or on command from ISSA 200, send test read signals/commands to the antenna of a target shelf 270 and monitor any responses collected from the embedded RFID tag(s) included in a corresponding shelf unit. In the event that secondary controller 266 does not receive a proper response from one or more embedded RFID tags, controller 266 (or another device, such as primary controller 260) may ascertain that a malfunction may have occurred.
To locate the source of a malfunction, DCS 160 may perform various self-test read operations through neighboring components to a target shelf unit and/or target antenna 270. For example, if another antenna 270 driven by the same secondary controller 266 can still be read, then DCS 160 may associate the malfunction with the target antenna 270. On the other hand, if all antennae 270 served by a given secondary controller 266 are not responding to command signals from the controller (i.e., not reading any RFID tags 280), then DCS 160 may associate the malfunction with the secondary controller 266. Further, if all antennae 270 served by a given primary controller 260 and reader 262 are not reading data from a secondary controller 266, then the problem is likely within the primary controller 260 or the reader 262. To determine which of these components is the source of the malfunction, DCS 160 may determine whether primary controller 260 may still communicate diagnostic data with one or more secondary controllers 266.
If so, DCS 160 may associate the malfunction with reader 262. Additionally, if RS-485 serial data communication techniques are used between primary controller 260, reader 262, and one or more secondary controllers 266, DCS 160 may provide a sequential order of secondary controllers 266 that primary controller 260 may communicate with during a tag reading operation. Accordingly, if an RS-485 data cable is disconnected somewhere along its length, primary controller 260, having been provided beforehand with the sequence information indicating the order of the secondary controllers 266 along the RS-485 link, may determine at what point the RS-485 link was disconnected. In one aspect, acknowledgment command protocols may be performed by primary controller 260 to determine which secondary controller 266 is not responding to a command. That is, communications along the RS-485 link may include commands that are acknowledged by the receiving entity on the link, and lack of acknowledgment is another means to deduce where any problems may lie.
Exemplary Software Objects for ISSA 200:
In one aspect of the invention, ISSA 200 may perform certain functions related to the present invention using object-oriented programming constructs and techniques. For example, ISSA 200 may employ web services to perform certain functions related to aspects of the present invention. Table II shows a list of exemplary software objects that may be implemented by ISSA 200 that may be used by one or more processes (e.g., tasks 231-239) and interact with one or more of the exemplary tables included in database 215.
Jobs 240:
Jobs 240 may be one or more processes that are executed internally and/or externally from ISSA 200 and may be used to trigger alerts and retrieve information from remote locations, such as a manufacturer's website, or from entities located within environment 110-1. Each process, or job, included in Jobs 240 may be developed using known programming languages, such as the JAVA programming language and JDBC provided by Sun Microsystems, Inc., and known scheduling software, such as Microsoft Scheduler.
In one aspect of the invention, Jobs 240 may include an inventory limit job that runs periodically (e.g., every 60 seconds) and monitors inventory levels based on configurations that may have been set by a user through a user interface provided in interface 210 and stored in a configuration table within database 215. This job may generate an inventory out of limits alert if any inventory items are found to be out of bounds relative to the baseline inventory (e.g., current stock above and/or below a predetermined value). The alert may be generated using an alert method, such as the exemplary Web Service ISSAserv/Alerts.asmx/NewlnventoryAlertJob method described in Table II. In one aspect of the invention, the inventory limit job may direct a message provisioning service to send an e-mail to one or more predefined users each time an inventory out of limits alert occurs.
Jobs 240 may also perform a wrong shelf job that may run continuously and monitors misplaced items that are on an incorrect shelf. If ISSA 200 determines that an item is located on an incorrect shelf, Jobs 240 may generate an alert message corresponding to that type of alert (i.e., misplaced item) and insert it into a table within database 215, such as an alert table (e.g., tblAlerts). In one aspect of the invention, the wrong shelf job may direct a message provisioning service to send an e-mail to one or more predefined users each time a misplaced item alert occurs.
Jobs 240 may also perform a removal limit job that may run continuously and monitor items that have been removed from their designated locations (e.g., shelf) in a quantity and time period specified by a user via user interface 210. The removal limit job may generate and store information associated with the removed items in a table in database 215, such an inventory removal table (e.g., tblInventory Remove). Further, if this job determines one or more items that have been removed based on the specified quantity and time period values, this job may create a new alert message associated with this condition and insert into the alert table (e.g., tblAlerts).
Jobs 240 may also perform an expired products job that may run every day at a predetermined time (e.g., 12:01 a.m.), and determine whether any items have been located in inventory 170 have reached or exceeded their corresponding expiration limit (e.g., expiration date). If the expired products job finds an item that has been expired, or is approaching an expiration date, it may create a corresponding alert message and insert it into the alert table (e.g., tblAlerts).
Further, Jobs 240 may perform a SKU update job that may run periodically (e.g., every 10 minutes) that identifies any new items (e.g., SKUs) that may have been added to environment 170. This job may request item information associated with the identified new items from an ERP system or a manufacturer's website using XML.
Also, Jobs 240 may perform a manufacturer update job that may run periodically (e.g., every 10 minutes) that monitors a table in database 215 that is updated when an item is included in inventory 170 that is provided by a manufacturer that is not registered with ISSA 200 (i.e., a new manufacturer). This update job may retrieve information associated with the new manufacturer from the manufacturer's website or other type of external data source.
EPC Writer:
As the RFID tag industry grows, it is expected that items may be "source-tagged." That is, the RFID tags 280 may be applied to items and the EPCs written to the tags by a manufacturer. There may be instances, however, when items are included in inventory 170 that do not include source tagged items. Accordingly, environment 110 1 may perform an EPC writer process that is designed to write EPCs to RFID tags 280. Since the EPC process may be configured to access data on a particular tag one at a time, the process may be performed by a system that is separate from ISSA 200. Alternatively, ISSA 200 may include a separate EPC writer process (in addition to, or in place of, EPC writer task 234) that is executed by IIMS 105.
The EPC writer process may be a Windows@ executable process that may use.NET serial implementations to communicate to reader 262. The EPC writer may store, in a file location, the number for the last EPC written to an RFID tag for a given manufacturer and its SKU information (e.g., item type information). Further, the EPC writer process may store a range of serial numbers, SKU information, and manufacturer ID's for an EPC and write this EPC information to the memory of one or more RFID Tags 280. Also, the EPC writer may write to RFID tags based on a standard, such as the Philips SLRM900 specification, depending on the type of RFID tags implemented by environment 110-1. Alternatively, the EPC writer may write to tags using RS-232 or other serial interface communication protocols.
In one aspect of the invention, inventory 170 may include one or more RFID enabled shelves that include communication capabilities with peripheral device 255, such as a bar code reader. Accordingly, each shelf may, at least temporarily or periodically, exclusively communicate with the EPC writer process. For instance, a group of items of a certain type may be placed on a shelf by a user (e.g., stock person). One of the items may be scanned with a bar code reader to determine its corresponding UPC number. The EPC writer may then sequentially assign EPC numbers to each item in the group by incorporating the information derived from the UPC number.
Differences between a common UPC and an EPC are shown in Table III. A UPC may consist of decimal (i.e., base ten) data including manufacturer number, object number, and a check digit, totaling 12 digits. An EPC includes binary data that may include a header, manufacturer number, object number, and electronic serial number. In both the UPC and EPC, the manufacturer number may be assigned by a governing body, such as price code standards governing body. An object class (including the object number) may be assigned by a manufacturer. In the case of an EPC, the serial number may also be assigned by the manufacturer.
In situations where a manufacturer or manufacturers have not been assigned EPC manufacturer codes, the EPC writer may use arbitrary number assignments until the EPC manufacturer codes are assigned. Alternatively, the existing UPC manufacturer codes, which fit directly into the larger EPC manufacturer field, may be used. Also, the existing UPC object class would fit into the larger EPC object field.
In such situations where a governing body has not assigned manufacturer's codes, the EPC writer may be used in an arbitrary pseudo-EPC field arrangement for use in initial inventory operations, such as trial inventory management processes that incorporate the current UPC field values or arbitrary values as the manufacturer's codes. However, if a standard EPC field arrangement has been implemented, the EPC writer may be used by environment110-1to ensure items are properly tagged. Also, if a standard EPC field arrangement is promulgated, the EPC writer may be used by retailers, distribution centers or manufacturers, possibly for limited product lines. One skilled in the art will appreciate that in the event RFID tagging becomes more widespread and "source tagging" by the manufacturer becomes common, use of the EPC writer may diminish at retail locations but increase at manufacturing sources, which may implement methods, systems, and articles of manufacture consistent with certain aspects of the invention.
If the pseudo-EPC field arrangement is implemented described above, environment 110 1 may assign EPC codes by defining a determined number of fields (e.g., three) for the pseudo-EPC number. For example, the pseudo-EPC number may be arranged with an 8 bit header (1111,1111) that corresponds to the type header in the EPC, a 52-bit UPC field that is divided into 13 subfields of 4 bits each, and a 36-bit serial number field, such as a sequential number, 0 to 68,719,476,735). The size of the data segments in the EPC may vary without departing from the scope of the present invention.
The UPC number is made up of up to 13 digits, using the binary representation of each digit, one nibble per UPC digit. That is, 0 is 0000,1 is 0001, 2 is 0010,... and 9 is 1001. Individual packages of a given item may be assigned unique serial numbers until more than 68.7 billion packages are encountered. Note that there may be a difference in how the UPC number and the serial number are treated by the EPC writer and environment 110-1 when converting to a binary representation. In the case of the UPC number, each UPC digit (up to 13 digits) is assigned a nibble in the EPC. A binary conversion may be performed by EPC writer digit by digit, keeping particular decimal digits in correspondence with particular EPC nibbles. In the case of the EPC serial number, however, a straight conversion may be performed from the decimal serial number to the binary serial number, which is recorded in the 36-bit EPC field.
At the time when an RFID tag 280 is to be assigned to an item, the EPC writer process may call EPC writer task 234 that operates as an assignment module in ISSA 200. The call may direct task 234 to access the SKU table (which may be stored in database 215) and locate a corresponding UPC for each SKU included in the list obtained in Step 310 (Step 320). For example, EPC writer task 234 may generate a query to search the SKU table for manufacturer and/or item name.
Once a UPC is located for a corresponding SKU, the EPC writer task 234 may provide this information back to the EPC writer process. Once received, the EPC writer process may use the UPC to write the entire pseudo-EPC number to the RFID tag on each package of the item type, by for example, using a write to tag command that is executed by the RFID reader (Step 330). This step assigns the unique serial numbers to each tag. Further, the EPC writer process may log the pseudo-EPC into a table during this procedure, such as a table storedin database 215 (Step 340).
In one aspect of the invention, an RFID tag 280 may contain both the serial number that is assigned as the unique RFID tag number and the pseudo-EPC number that is encoded as extra data. Although the pseudo-EPC number includes information that identifies an item, the serial number may be read faster by reader software/hardware than the pseudo-EPC number. For example, an anti-collision select command provided by certain bar code readers, such as the Philips reader, may automatically return the RFID tag serial numbers. In instances where the type of items located on a particular shelf change very little from one RFID tag read operation to another, the read cycle for obtaining the pseudo-EPC number may be improved by storing the EPC information and corresponding serial number information in a local cache memory device (not shown). Accordingly, the reader may issue an anti-collision select command when attempting to read an RFID tag 280 and initially receive the RFID tag serial number.
The reader may then determine whether the tag serial number is located in the local cache. If it is, then the reader may retrieve the corresponding EPC number from the cache. If the tag is not stored in the cache, then the reader may read the tag data blocks to obtain the pseudo EPC number. The RFID tag serial number and EPC number may then be added to the cache for a subsequent read cycle. Environment 110-1 may perform a purge process that may purge the tag information contained within the cache on a periodic basis. This may provide similar data access performance as a relational type database containing the tag serial number and EPC, with less data management delays.
User Interface Pages:
User interface 210 may provide content-based interfaces to a user that enables the user to request and input information associated with the intelligent inventory management functions consistent with certain aspects related to the invention. FIG. 4 shows an exemplary interface map 400 that provides a framework that ISSA 200 may implement to respond to inquiries from a user via user interface 210. Each box in map 400 may represent a page process performed by user interface 210 that allows a user to request and/or receive information. Each page may check a security key carried in a session for a current user to determine whether the user is allowed access to the corresponding page. Further, each page may post an XML document to ISSA 200 and retrieve XML information. Also, content may be displayed on a display device (e.g., display 204) by applying style sheets to XML from COM+ components described for each page. Further, the page process in map 400 may interact with corresponding one or more processes included in ISSA 200 (e.g., tasks 231-239) and jobs 240.
As shown, FIG. 4 includes a home page 402 allows that allows a user to navigate to other pages displayed by the page process in map 400. Among these pages is a user login page 410 that allows a user to enter a username and password. Page 410 may then initiate a login process, such as a Web Service ISSAserv/Login.asmx/Login method. If the user is a valid user, the login page process may direct user interface 210 to execute home page process 402. Otherwise, login page 410 may again request a user name and password.
File page 408 directs the user to login as new user page 410 which allows the user to create and edit user information and to set up alert subscriptions (e.g., define certain types of alerts that are desired to be reported). Logoff page 412 page allows the user to log off from the current login session.
Stock level control page 414 allows the user to access various inventory level information by directing the user, for example, to View Live Inventory page 416. This page allows users to view the current physical inventory at a particular location, such as a shelf. The user may generate a query using various fields defined by user interface 210. Table V shows a list of exemplary search fields a user may use to filter a search. Once the query is entered by the user, interface 210 may display a search results for Live Inventory page 416 that initiates a process (e.g., Web Service ISSAserv/OutofStock.asmx/Get Inventory XML) that allows the user to search and view information associated with an item. This process may allow the user to receive information from another page, such as an Item Detail page (not shown). In one aspect of the invention, a user who is a vendor with merchandise included in environment 110-1 may be given limited local or remote access to the View Live Inventory page 416 to ascertain whether their item is being displayed according to preset agreements. For example, the vendor may determine whether their items are presented on a certain number of shelf facings, located in a particular location within a store, whether their items are positioned in a preferred location within a set of shelves, such as at eye level as opposed to higher or lower levels, etc.
he Item Detail page (not shown) may perform a process that allows a user to view information associated with an item, determine where the item is currently located in environment 110-1, and a time when the item was placed at that location. Items may be considered to be located at a particular physical location (e.g., a particular shelf) if the item is read by a single reader antenna 270, or on a "virtual shelf' if the item is read by multiple reader antennae 270 that are associated with each other in a relationship table, such as a tblRelatedEPC table included in database 215.
The View SKU Out of Limits page 418 allows a user to view information associated with one or more item types that are currently over or under an allowable percentage of baseline inventory. The user may be able to filter a search by using the fields shown in Table V. Once the filter information is entered by the user, user interface 210 may display a search results for SKUs out of limits page (not shown).
This page may initiate a process (e.g., Web Service ISSAserv/Out of Stockasmx/ Outofimits SKUXML) that shows a user a current inventory for a given item or item type at a current location. Further, the process may also provide the baseline inventory value for that item at the specified location, and the difference the current inventory deviates above or below the desired baseline inventory. Furthermore, the process may display the allowable percentage over and under for a given SKU and location. This out of limits information may be used by ISSA 200 to suggest which out-of-limits items to restock first based on expected sales information provided by a user and/or a software process that produces this information. ISSA 200 may also access current and historical sales data maintained in a memory device (e.g., database 215) to generate a report predicting expected times at which each item may become out of stock. Also, ISSA 200 may use various factors, such as pricing, seasonality, etc., to adjust the predicted information provided in the report.
The View Lost Sales page 420 may allow a user to view information associated with item types that have lost sales due to being out of stock. The user may be able to filter a search query for these SKUs using the fields listed in Table V. Once the filter information is entered, by a user, user interface 210 may display a search results for lost sales page (not shown). This page may initiate a sales estimation process that shows the user an estimate of the sales (e.g., in dollars) lost due to the items of the item type being out-of-stock. The estimate provided by the sales estimation process may be based on a comparison of inventory levels, sales volume (current and historical), and traditional correlation of sales events for similar types of items. For example, ISSA 200 may access inventory data, sales information, etc. from database 215 to perform the comparisons used by the sales estimation process. The estimate of out-of-stock lost sales may be also be based entirely on factors provided by a user (e.g., administrator, retailer manager, etc.) to describe substitution rates associated with the similar item types. Alternatively, ISSA 200 may be configured to train itself by recognizing trends associated with previous sales of these item types and mining it from a database including similar information.
The Misplaced SKUs page 422 may allow a user to view information associated with items that are currently positioned in an incorrect location within environment 110-1. The user may be able to filter a search for misplaced items using the fields in Table V. Once the filter information is provided by the user, interface 210 may display a search results for misplaced SKUs page. This page may initiate a process (e.g., Web Service ISSAserv/OutofStock.asmx/Misplaced SKUXML) that displays any current items that are misplaced and their current location in environment 110-1. The user may elect an item using, for example, the item's SKU information, from a list displayed on a display device to view the location of the selected SKU.
Stock level maintenance page 424 directs the user to pages (e.g., 426 and 428) that allow the user to configure and/or view current inventory arrangements in environment 110-1. The View Shelf Arrangement page 428 may allow a user to view information regarding any item in inventory 170 and their corresponding currently assigned locations in environment 110-1. The user may be able to filter a search using the fields in Table V. Once the filter information is entered by the user, user interface 210 may display a current shelf arrangements page (not shown). The arrangements page may perform a process (e.g., Web Service ISSAserv/OutofStock.asmx/SKU Arrangement) that shows items and their allowable locations (e.g., locations in environment 110-1 that are assigned to the respective items). ISSA 200 may access item price and/or sales velocity data from a database (e.g., database 215) to provide prioritized locations within environment 110 1 that items of certain types may be placed to promote increased sales and/or movement of these items.
The Set Shelf Arrangement page 426 may allow a user to set a location for certain types of items, a category of items, items provided by certain manufacturers, a specific SKU number, and a particular range of locations within environment 110-1 (e.g., an aisle, a gondola, and/or a shelf). Page 426 may also allow a user to set the baseline inventory for each item type. Further, environment 110-1 may implement planogram software, which is a plan (e.g., a diagram, picture, etc.) that describes how and where products should be placed on retail shelves and displays. A planogram analyzes space utilization, provides financial data, along with other reports that permit retailers and manufacturers to effectively plan, set-up and manage their businesses to maximize profitability of retail space. Accordingly, the set shelf arrangement page may be downloaded from a planogram program executed by environment 110-1. Likewise, ISSA 200 may allow the planogram program to update current inventory information using the interface page information provided by the inventory data provided by the pages in map 400. Also, the planogram routine may be incorporated into ISSA 200 for execution by IIMS 105.
The Shrinkage Control page 430 directs the user to shrinkage information provided by pages 432 and 434. The View Over Removed Inventory page 432 may allow a user to filter items by individual items, by a category of items, items provided by a particular manufacturer, by SKU numbers that are in locations within environment 110-1, by particular locations within environment 110-1 (e.g., an aisle, a gondola, and a shelf number). Page 432 may allow the user to view the requested items that have been removed from their designated locations in a determined quantity within a certain period of time that may be specified by the user. It also displays an Over Removed Inventory Results page (not shown). This page may initiate a process (e.g., Web Service ISSAserv/Shrinkage.asmx/Major Pull XML) that may show the location, item information, a time when a first item of the number of items was removed from the designated location, a time when a last item of the number of items was removed, and how many items were removed in that time period.
The View Actual vs. ERP Inventory page 434 may allow a user to receive information associated with items located in environment 110-1 that have a user defined percent variance over and/or under a defined inventory level. The user may filter a search of these items individually, by a category of items, by items provided by a particular manufacturer, and a SKU number that is in a location within environment 110-1, such as an aisle, a gondola, and a shelf number. Inventory page 434 may show an Actual vs. ERP Results page (not shown). This results page may initiate a process (e.g., Web Service ISSAserv/Shrinkage.asmx/Inventory Compare XML) that may show the physical inventory present in inventory 170, such as those items located on shelves, a business defined inventory (e.g., an ERP inventory), and the percentage variance between the two.
The Rapid Recall page 436 may direct the user to one or more pages (e.g., 438-442) that provide information associated with items that may have expired or are approaching an expiration date. The View Expired SKUs page 438 may allow a user to filter items individually, by a category of items, by items provided by a particular manufacturer, by a SKU number that may be in a location within environment 110-1, such as an aisle, a gondola, and a particular shelf: Page 438 may display an Expired SKUs Results page (not shown) that may initiate a process (e.g., Web Service ISSAserv/RapidRecall.asmx/Expired Products XML) that may show item descriptions, locations of items have that have expired, and a time period that these expired items have been located in their current location since their corresponding expiration dates.
The View Upcoming Expired SKUs page 440 may allow the user to filter items individually, by a category of items, by items provided by a particular manufacturer, by a SKU number that may be in a location within environment 110-1, such as an aisle, a gondola, and a particular shelf. Page 440 may allow a user to receive information regarding items that are going to expire within a certain period of time (e.g., minutes, hours, days, weeks, etc.). Further, page 440 may display an Upcoming Expired SKU Results page (not shown). This results page may perform a process (e.g., Web Service ISSAserv/RapidRecall.asmx/Expired Products XML) that may show the locations and associated items that are due to expire within the certain period of time for the given products based on the user defined filter.
The Find Serial Number page 442 may allow a user to view items within a certain serial number range. The user may be able to filter a search using the fields in Table V. Once the filter information is provided by the user, user interface 210 may display the Search Results for Live Inventory page, described above. This page may perform a process (e.g., Web Service ISSAserv/OutofStock.asmx/Get inventory XML) that provides information regarding items with corresponding serial numbers within the range specified by the user.
The Alerts page 444 may direct the user to one or more pages (e.g., pages 446-452) that allow the user to receive and/or set information associated with one or more types of inventory alerts. The Set SKU Inventory Alert page 446 may allow the user to set an alert configuration for items that drop below or go above a defined percentage of a base line inventory. Alert page 446 may allow the user to set the alert configuration for all items in inventory 170, for items of a particular type, for a category of items, for items provided by a manufacturer, and for particular SKU numbers that are positioned in particular locations within environment 110-1, such as an aisle, a gondola, and a particular shelf. Alert page 446 may initiate a process that performs the desired monitoring set by the user (e.g., Web Service ISSAserv/Alerts.asmx/New inventory AlertJob).
WE CLAIMS 1. My Invention "IMS- Inventory Management System" is a technique, systems, and articles of manufacture consistent with certain aspects related to the present invention collect item information from bar-code/RFID tags attached to items in an inventory. The invented technique also uses the collected item information to perform various inventory management processes and the inventory management processes may include determining, reporting, and providing corrective actions for one or more events associated with at least one of depletions of items in the inventory, changes in the design of items in the inventory, defects with one or more items, misplaced items, the movement of an unusual number of items within a short period of time, and malfunctions of one or more components included in the environment.The invented technique to manage growing product inventories, businesses have implemented perpetual type inventory management systems, which are systems that use Point of Sale (POS) data on products sold, invoicing data, and historical data on inventory audits or cycle counts (e.g., periodic inventory counts of products) to determine the inventory that exists within the walls of a retail store. The POS data generally refers to data generated at a checkout system (i.e., cash register). Based on the inventory level within the retail stores, products may be reordered from a manufacturer. Alternatively, the manufacturer and retailer may have an agreement that directs the manufacturer to preemptively deliver products according to the terms of the agreement. Ideally, inventory is replenished in a manner such that inventory arrives at the retail store just before existing stock levels are exhausted. 2. According to claims# the invention is to a technique, systems, and articles of manufacture consistent with certain aspects related to the invention collect item information from bar-code/RFID tags attached to items in an inventory and if any type of error available then automatic give the notification. 3. According to claiml,2# the invention is to the invented technique also uses the collected item information to perform various inventory management processes and the inventory management processes may include determining, reporting, and providing corrective actions for one or more events associated with at least one of depletions of items in the inventory, changes in the design of items in the inventory, defects with one or more items, misplaced items, the movement of an unusual number of items within a short period of time, and malfunctions of one or more components included in the environment. 4. According to claiml,3# the invention is to the invented technique to manage growing product inventories, businesses have implemented perpetual type inventory management systems, which are systems that use Point of Sale (POS) data on products sold, invoicing data, and historical data on inventory audits or cycle counts (e.g., periodic inventory counts of products) to determine the inventory that exists within the walls of a retail store. 5. According to claiml,2,3# the invention is to the POS data generally refers to data generated at a checkout system (i.e., cash register). Based on the inventory level within the retail stores, products may be reordered from a manufacturer. 6. According to claiml,2,3,5# the invention is to the alternatively, the manufacturer and retailer may have an agreement that directs the manufacturer to preemptively deliver products according to the terms of the agreement. Ideally, inventory is replenished in a manner such that inventory arrives at the retail store just before existing stock levels are exhausted.
Date: 22/8/2020
Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University)
FOR Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) TOTAL NO OF SHEET: 07 NO OF FIG.: 07 24 Aug 2020 2020101951
FIG. 1: IS A BLOCK DIAGRAM OF AN EXEMPLARY SYSTEM CONSISTENT WITH CERTAIN ASPECTS RELATED TO THE PRESENT INVENTION.
FOR Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) TOTAL NO OF SHEET: 07 NO OF FIG.: 07 24 Aug 2020 2020101951
FIG. 2: IS A BLOCK DIAGRAM OF AN EXEMPLARY ENVIRONMENT CONSISTENT WITH CERTAIN ASPECTS RELATED TO THE PRESENT INVENTION.
FOR Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) TOTAL NO OF SHEET: 07 NO OF FIG.: 07 24 Aug 2020 2020101951
FIG. 3: IS A FLOWCHART OF AN EXEMPLARY EPC WRITER PROCESS CONSISTENT WITH CERTAIN ASPECTS RELATED TO THE PRESENT INVENTION.
FOR Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) TOTAL NO OF SHEET: 07 NO OF FIG.: 07 24 Aug 2020 2020101951
FIG. 4: IS A BLOCK DIAGRAM OF AN EXEMPLARY INTERFACE MAP CONSISTENT WITH CERTAIN ASPECTS RELATED TO THE PRESENT INVENTION.
FOR Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) TOTAL NO OF SHEET: 07 NO OF FIG.: 07 24 Aug 2020 2020101951
FIG. 5: IS A FLOWCHART OF AN EXEMPLARY INVENTORY ANALYSIS PROCESS CONSISTENT WITH CERTAIN ASPECTS RELATED TO THE PRESENT INVENTION.
FOR Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) TOTAL NO OF SHEET: 07 NO OF FIG.: 07 24 Aug 2020 2020101951
FIG. 6: IS A FLOWCHART OF AN EXEMPLARY SHRINKAGE PROCESS CONSISTENT WITH CERTAIN ASPECTS RELATED TO THE PRESENT INVENTION.
FOR Dr. Eknath B. Khedkar (Director Dr D Y Patil School of Management, Lohegaon, Pune and Former Vice Chancellor Ajeenkya D Y Patil University) TOTAL NO OF SHEET: 07 NO OF FIG.: 07 24 Aug 2020 2020101951
FIG. 7: IS A FLOWCHART OF AN EXEMPLARY RECALL PROCESS CONSISTENT WITH CERTAIN ASPECTS RELATED TO THE PRESENT INVENTION.
AU2020101951A 2020-08-24 2020-08-24 IMS- Inventory Management System: INTELLIGENT MART SELLING AND INVENTORY MANAGEMENT SYSTEM Ceased AU2020101951A4 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2020101951A AU2020101951A4 (en) 2020-08-24 2020-08-24 IMS- Inventory Management System: INTELLIGENT MART SELLING AND INVENTORY MANAGEMENT SYSTEM

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
AU2020101951A AU2020101951A4 (en) 2020-08-24 2020-08-24 IMS- Inventory Management System: INTELLIGENT MART SELLING AND INVENTORY MANAGEMENT SYSTEM

Publications (1)

Publication Number Publication Date
AU2020101951A4 true AU2020101951A4 (en) 2020-10-01

Family

ID=72608238

Family Applications (1)

Application Number Title Priority Date Filing Date
AU2020101951A Ceased AU2020101951A4 (en) 2020-08-24 2020-08-24 IMS- Inventory Management System: INTELLIGENT MART SELLING AND INVENTORY MANAGEMENT SYSTEM

Country Status (1)

Country Link
AU (1) AU2020101951A4 (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113915842A (en) * 2021-10-20 2022-01-11 海信(山东)冰箱有限公司 Refrigerator and food material monitoring method thereof
CN115496444A (en) * 2022-09-26 2022-12-20 重庆大学 Method and system for intelligent distribution management of storeroom
CN116523474A (en) * 2023-06-29 2023-08-01 四川金投科技股份有限公司 Cash box state control method and system based on Internet of things and edge calculation
CN116862195A (en) * 2023-08-08 2023-10-10 芜湖青穗信息科技有限公司 Storage intelligent robot system based on internet of things
CN118244706A (en) * 2024-02-01 2024-06-25 恒昌重工(山东)有限公司 Intelligent production management system for steel structure products

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113915842A (en) * 2021-10-20 2022-01-11 海信(山东)冰箱有限公司 Refrigerator and food material monitoring method thereof
CN115496444A (en) * 2022-09-26 2022-12-20 重庆大学 Method and system for intelligent distribution management of storeroom
CN115496444B (en) * 2022-09-26 2023-06-09 重庆大学 Warehouse intelligent allocation management method and system
CN116523474A (en) * 2023-06-29 2023-08-01 四川金投科技股份有限公司 Cash box state control method and system based on Internet of things and edge calculation
CN116523474B (en) * 2023-06-29 2023-09-08 四川金投科技股份有限公司 Cash box state control method and system based on Internet of things and edge calculation
CN116862195A (en) * 2023-08-08 2023-10-10 芜湖青穗信息科技有限公司 Storage intelligent robot system based on internet of things
CN116862195B (en) * 2023-08-08 2023-12-26 芜湖青穗信息科技有限公司 Storage intelligent robot system based on internet of things
CN118244706A (en) * 2024-02-01 2024-06-25 恒昌重工(山东)有限公司 Intelligent production management system for steel structure products

Similar Documents

Publication Publication Date Title
US8321302B2 (en) Inventory management system
CA2474254C (en) Inventory management system
AU2020101951A4 (en) IMS- Inventory Management System: INTELLIGENT MART SELLING AND INVENTORY MANAGEMENT SYSTEM
US8049621B1 (en) Method and apparatus for remote merchandise planogram auditing and reporting
KR102057001B1 (en) Product management system and Method of store using POS system
US7240027B2 (en) Method and apparatus for monitoring the flow of items through a store or warehouse
US20050149414A1 (en) RFID system and method for managing out-of-stock items
US7853477B2 (en) RF-based electronic system and method for automatic cross-marketing promotional offers and check-outs
JP2005515947A5 (en)
WO2003061366A2 (en) Inventory management system
US20050043857A1 (en) System for inventory control and capturing and analyzing consumer buying decisions
EP1342203A2 (en) System and method for using radio frequency identification in retail operations
JP2003288646A (en) Customer transaction data system and transaction data managing method
AU2011213713B2 (en) Inventory management system
US10846721B2 (en) Method and system to reduce food waste and control prices in retail
JP4227823B2 (en) Customer guidance system
AU2024220082A1 (en) Information processing system, information processing method, and program management
JP2002167047A (en) Method and system of stock management through network
US20090050698A1 (en) Sales Tool
US20070265943A1 (en) Product management system, product management apparatus, and product management method
US20070203809A1 (en) Method and apparatus for regulating store inventory
RU108171U1 (en) PRODUCT FLOW MANAGEMENT SYSTEM IN A LARGE TRADE COMPLEX
WO2022081518A2 (en) Methods and systems for retail environments
US20230306497A1 (en) Methods and apparatus for integrating retail applications and retail operational subsystems, and optimizing operation of same
JP2002373267A (en) System, server, method, program for intermediating supply and demand of merchandise, recording medium in which the program is recorded, information terminal for retail store, application for retail store, recording medium in which the application is recorded, application for wholesaler and recording medium in which the application is recorded

Legal Events

Date Code Title Description
FGI Letters patent sealed or granted (innovation patent)
MK22 Patent ceased section 143a(d), or expired - non payment of renewal fee or expiry