Inventory tracking

Patent metadata

Field	Value
Publication number	US-10769583-B2
Application number	US-201815919142-A
Country	US
Kind code	B2
Filing date	Mar 12, 2018
Priority date	Jun 28, 2013
Publication date	Sep 8, 2020
Grant date	Sep 8, 2020

Abstract

The present disclosure extends to maintaining an item inventory status at an inventory cache management system. The inventory cache may be refreshed regularly by a threshold-based triggering mechanism. In embodiments, as item inventory breaches certain thresholds, the inventory cache may be refreshed with increased frequency to mitigate overselling or underselling scenarios and reduce overall network traffic for items having relatively high inventory levels.

First claim

What is claimed is:

1. A computer-implemented method of updating an inventory cache management system, comprising:
providing an e-commerce web site over an internet from a front end server to a user computing device, the e-commerce website comprising an inventory status indicator;
at a backend inventory management module, receiving and storing a first item inventory level quantity located at one or more warehouse locations;
at a store inventory database module, receiving and storing a second item inventory level quantity located at a retail store location different from the one or more warehouse locations;
at the backend inventory management module, comparing the first item inventory level quantity with a first item high threshold;
when the first item inventory level quantity is less than the first item high threshold, transmitting a first Limited Stock Alert from the backend inventory management module to a backend inventory cache;
at the backend inventory cache, storing a first inventory status corresponding to the first item inventory level quantity;
at the store inventory database module, comparing the second item inventory level quantity with a second item high threshold;
when the second item inventory level quantity is less than the second item high threshold, transmitting a second Limited Stock Alert from the store inventory database module to a store inventory cache;
at the store inventory cache, storing a second inventory status corresponding to the second item inventory level quantity;
at the front end server, receiving a data request for an item from the user computing device;
in response to receiving the data request, determining when the data request for the item is for data related to at least one of the first inventory status stored at the backend inventory cache or the second inventory status stored at the store inventory cache;
in response to determining that the data request for the item is for the data, calling the backend inventory cache or the store inventory cache for the data according to the data request;
in response to calling the backend inventory cache or the store inventory cache, receiving at least one response from the backend inventory cache or the store inventory cache to be combined into an aggregated inventory status;
transmitting the data related to the aggregated inventory status to the front end server for display at the e-commerce website on the user computing device as the inventory status indicator in response to the data request from the user computing device, wherein:
the inventory status indicator allows a user to purchase the item from a store inventory or a warehouse inventory; or
when the item is not available for purchase from the store inventory or the warehouse inventory, the inventory status indicator allows the user to place a backorder for the item based on a future inventory availability of the item in the store inventory or the warehouse inventory; and

when transmitting the data related to the aggregated inventory status to the front end server fails, when calling the backend inventory cache or the store inventory cache fails, or when receiving the at least one response from the backend inventory cache or the store inventory cache fails, at least one of (a) requesting the second item inventory level quantity from the store inventory database module, and bypassing the store inventory cache, or (b) requesting the first item inventory level quantity from the backend inventory management module, and bypassing the backend inventory cache.

2. The computer-implemented method of updating the inventory cache management system of claim 1 , further comprising:
from the front end server, transmitting the first inventory status for display at the e -commerce website on the user computing device.

3. The computer-implemented method of updating the inventory cache management system of claim 1 , further comprising:
transmitting the first item inventory level quantity to the backend inventory cache.

4. The computer-implemented method of updating the inventory cache management system of claim 1 , further comprising:
transmitting the second item inventory level quantity to the store inventory cache.

5. The computer-implemented method of updating the inventory cache management system of claim 1 , further comprising:
at the backend inventory management module, comparing the first item inventory level quantity with a medium threshold; and
when the first item inventory level quantity is less than the medium threshold, transmitting an Out of Stock Alert from the backend inventory management module to the backend inventory cache.

6. The computer-implemented method of updating the inventory cache management system of claim 5 , further comprising:
after transmitting the Out of Stock Alert from the backend inventory management module to the backend inventory cache, ceasing sales activities of the item associated with a first item inventory level quantity unit, until the first item inventory level quantity is above the medium threshold.

7. The computer-implemented method of updating the inventory cache management system of claim 1 , further comprising:
at the store inventory database module, comparing the second item inventory level quantity with a medium threshold; and
when the second item inventory level quantity is less than the medium threshold, transmitting an Out of Stock Alert from the store inventory database module to the store inventory cache.

8. The computer-implemented method of updating the inventory cache management system of claim 1 , further comprising:
transmitting a request to one of the backend inventory management module or the store inventory database module; and
receiving one of the first item inventory level quantity or the second item inventory level quantity in response to the request.

9. A computer-implemented method of maintaining a store item inventory system comprising:
providing an e-commerce web site over an internet from a front end server to a user computing device, the e-commerce website comprising an inventory status indicator;
at a store inventory database module, setting a high threshold for an item;
at the store inventory database module, receiving and storing a transaction confirmation completion;
at a store inventory database, updating an item inventory level located at a retail store location;
at the store inventory database module, comparing the item inventory level to the high threshold;
when the item inventory level is equal to or less than the high threshold, transmitting a first Limited Stock Alert from the store inventory database module to a store inventory cache;
at the store inventory cache, storing an item inventory status corresponding to the item inventory level located at the retail store location;
at the front end server, receiving a data request for the item from the user computing device;
in response to receiving the data request, receiving a backend inventory cache or the store inventory cache for data according to the data request;
in response to determining that the data request for the item is for the data, transmitting at least one response of the backend inventory cache or the store inventory cache to be combined into an aggregated inventory status;
coordinate presenting the aggregated inventory status to the front end server for display at the e-commerce website at the user computing device as the inventory status indicator in response to the data request from the user computing device, wherein the inventory status indicator allows a user to purchase the item from a store inventory or place a backorder for the item based on a future inventory availability of the item in the store inventory; and
when

Assignees

• Walmart Apollo Llc

Inventors

• Vasantham Madhavan Kandhadai
• Tare Vikrant
• Gupta Manish

Classifications

• G06Q10/0877

  by inventory control or reporting using inventory tracking or counting · CPC title

• G06Q10/0872 Primary

  using inventory planning · CPC title

• G06Q20/203

  Inventory monitoring · CPC title

• G06Q10/087 Primary

  Inventory or stock management, e.g. order filling, procurement or balancing against orders · CPC title