Inventory tracking

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 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 item inventory level from the store inventory database module, and bypassing the store inventory cache, or (b) requesting the item inventory level from a backend inventory management module, and the backend inventory cache.

A computer implemented inventory cache management system comprising:

• an inventory cache, further comprising:
• a backend inventory cache and a backend inventory management module located at one or more warehouse locations;
• a store inventory cache and a store inventory database module located at a retail location different from the one or more warehouse locations;
• and
• a data ingestion layer;
• an inventory core database, adapted to store a first item inventory level quantity;
• an inventory management application module;
• one or more processors;
• and
• memory storing one or more programs to be executed by the one or more processors, the one or more programs comprising instructions for:
• at the backend inventory management module, receiving and storing the first item inventory level quantity located at the one or more warehouse locations;
• at the 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 to a predetermined first item high threshold;
• when the first item inventory level quantity is less than the predetermined first item high threshold, transmitting a first Limited Stock Alert to the 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 the store inventory cache;
• at the store inventory cache, storing a second inventory status corresponding to the second item inventory level quantity;
• request the first item inventory level quantity from the inventory core database when transmitting the first Limited Stock Alert fails;
• at a front end server, receiving a data request for an item from a user computing device;
• transmit an inventory status indicator to an e-commerce website provided to the user computing device at the front end server in response to the data request for the item from the user computing device from the front end server;
• in response to receiving the data request, determining when the data request for the item is 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 of 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, 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.