IP Library Granted Patent US 12,307,421
Granted Patent B2
US 12,307,421 · App. 18/371,566 · Granted May 20, 2025

System and method for perpetual inventory management

Inventors: Greg A. Bryan (Centerton, AR); Cristy C. Brooks (Cassville, MO); David Blair Brightwell (Bella Vista, AR); Benjamin D. Enssle (Bella Vista, AR); Matthew A. Jones (Bentonville, AR); Jesse L. Eaton (Springdale, AR)
Assignee: Walmart Apollo, LLC
G06Q10/0875G06F16/2358G06Q10/06315
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,307,421
App. No.
18/371,566
Granted
May 20, 2025
Kind
B2
Abstract

A perpetual inventory (PI) value associated with the selected product and a last PI adjustment time that indicates when the retail store last adjusted the PI value are received. The PI value of the selected product is compared to the back room quantity value of the selected product, and a time when the back room quantity value becomes greater than the PI value for the selected product is determined. An adjustment to the PI of the selected product is blocked when the PI adjustment time is after the time. When the back room quantity value is greater than the PI value and the adjustment to the PI value is unblocked, the PI value is adjusted to be the back room quantity value.

Claims (35)

1. A system that is configured to manage perpetual inventory (PI) values of products in an access-controlled area of a retail store, the system comprising:

one or more sensors disposed in an access-controlled area of a retail store and positioned within the access-controlled area to obtain scans of products present in the access-controlled area of the retail store, the one or more sensors being coupled to an electronic network, wherein the access-controlled area is configured and arranged so as to block public access to the access-controlled area;

wherein the PI value changes as products are sold and physically removed from shelving or display units of the retail store and as products physically arrive in a shipment at the retail store, wherein the last PI adjustment time is measured from any time when the products were sold and removed from the retail store and when the shipment arrived;

a control circuit disposed at a central location separate from the retail store and coupled to the one or more sensors via the electronic network, the control circuit also being coupled to a plurality of other retail stores via the electronic network, the control circuit being configured to execute computer instructions, the computer instructions being effective to:

obtain the PI value and the last PI adjustment time from a database;

obtain the scans and analyze the scans to determine an access-controlled area quantity value for a selected product in the access-controlled area, wherein the access-controlled area quantity value indicates the amount of the selected product in the access-controlled area;

compare the PI value of the selected product to the access-controlled area quantity value of the selected product, and determine a time when the access-controlled area quantity value becomes greater than the PI value for the selected product;

block the adjustment to the PI value of the selected product when the last PI adjustment time is after the time or when an indication of blocking a similar PI adjustment has been received from any of the plurality of other retail stores via the electronic network;

when the access-controlled area quantity value is greater than the PI value and the adjustment to the PI value is unblocked, adjust the PI value to be the access-controlled area quantity value, and transmit the adjusted PI value to the retail store via the electronic network.

2. The system of claim 1 , wherein the access-controlled area comprises a backroom of the retail store.

3. The system of claim 1 , wherein the computer instructions are effective to, when a PI adjustment for the selected product has been blocked in a second retail store because of an audit, block the PI adjustment for the selected product.

4. The system of claim 1 , wherein when the adjustment to the PI value is unblocked, the control circuit sends a message to send at least some of the selected product to a distribution center or another retail store.

5. The system of claim 1 , wherein when the adjustment to the PI value is unblocked, the control circuit sends an alert message to a store employee.

6. The system of claim 1 , wherein the access-controlled area quantity value comprises a backroom quantity value.

7. The system of claim 6 , wherein the control circuit only processes the records after a predetermined number of records is received.

8. The system of claim 7 , wherein the number changes over time.

9. The system of claim 7 , wherein the number is fixed over time.

10. A method for managing perpetual inventory (PI) values of products in an access-controlled area of a retail store, the method comprising:

obtaining product scans of products by one or more sensors disposed at an access-controlled area of a retail store, the products being disposed within shelving units of the access-controlled area of the retail store, wherein the access-controlled area is configured and arranged so as to block public access to the access-controlled area, wherein the one or more sensors are positioned within the access-controlled area to obtain scans of the products at the shelving units;

wherein the PI value changes as products are sold and physically removed by customers from shelving or display units at the retail store and as products physically arrive in a shipment at the retail store, wherein the last PI adjustment time is measured from any time when the products were sold and removed from the retail store and when the shipment arrived;

connecting an electronic network to a control circuit and a plurality of other retail stores, the control circuit being disposed at a central location different from the retail store and the plurality of other retail stores;

at the control circuit:

obtaining the PI value and the last PI adjustment time from the database,

obtaining the scans and analyzing the scans to determine an access-controlled area quantity value for a selected product in the access-controlled area;

comparing the PI value of the selected product to the access-controlled area quantity value of the selected product, and determining a time when the access-controlled area quantity value becomes greater than the PI value for the selected product, wherein the access-controlled area quantity indicates the amount of the selected product in the access-controlled area;

blocking the adjustment to the PI value of the selected product when the last PI adjustment time is after the time or when an indication of blocking a similar PI adjustment has been received from any of the plurality of other retail stores via the electronic network;

when the access-controlled area quantity value is greater than the PI value and the adjustment to the PI value is unblocked, adjusting the PI value to be the access-controlled area quantity value, and transmitting the adjusted PI value to the retail store via a network.

11. The method of claim 10 , wherein the access-controlled area comprises a backroom of the retail store.

12. The method of claim 10 , further comprising, when a PI adjustment for the selected product has been blocked in a second retail store because of an audit, the control circuit blocks the PI adjustment for the selected product.

13. The method of claim 10 , wherein when the adjustment to the PI value is unblocked, the control circuit sends a message to send at least some of the selected product to a distribution center or another retail store.

14. The method of claim 10 , wherein when the adjustment to the PI value is unblocked, the control circuit sends an alert message to a store employee.

15. The method of claim 10 , wherein the access-controlled area quantity value comprises a backroom quantity value.

16. The method of claim 15 , wherein the control circuit only processes the records after a predetermined number of records is received.

17. The method of claim 16 , wherein the number changes over time.

18. The method of claim 16 , wherein the number is fixed over time.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 22, 2023
From: BRYAN, GREG A.; BROOKS, CRISTY C.; BRIGHTWELL, DAVID B.; ENSSLE, BENJAMIN D.; JONES, MATTHEW A.; EATON, JESSE L.
To: WALMART APOLLO, LLC
Reel/Frame 064994/0402 →
Continuity (4)
Continuation 17341549 · Jun 8, 2021
Continuation 15916829 · Mar 9, 2018
Provisional Application 62471420 · Mar 15, 2017
Related Publication 20240013148A1 · Jan 11, 2024
References Cited (187)
US 5392382A · Schoppers · 1995 [cited by applicant]
US 5544282A · Chen · 1996 [cited by applicant]
US 5963919A · Brinkley · 1999 [cited by applicant]
US 6681990B2 · Vogler · 2004 [cited by applicant]
US 6726099B2 · Becker · 2004 [cited by applicant]
US 6758403B1 · Keys · 2004 [cited by applicant]
US 6876991B1 · Owen · 2005 [cited by applicant]
US 6889165B2 · Lind · 2005 [cited by applicant]
US 7084769B2 · Bauer · 2006 [cited by applicant]
US 7222786B2 · Renz · 2007 [cited by applicant]
US 7370005B1 · Ham · 2008 [cited by applicant]
US 7401057B2 · Eder · 2008 [cited by applicant]
US 7480623B1 · Landvater · 2009 [cited by applicant]
US 7523065B2 · Eder · 2009 [cited by applicant]
US 7552066B1 · Landvater · 2009 [cited by applicant]
US 7580848B2 · Eder · 2009 [cited by applicant]
US 7616117B2 · Streeb · 2009 [cited by applicant]
US 7693757B2 · Zimmerman · 2010 [cited by applicant]
US 7788119B2 · Najmi · 2010 [cited by applicant]
US 7792709B1 · Trandal · 2010 [cited by applicant]
US 7950579B2 · Gray · 2011 [cited by applicant]
US 7954712B2 · Babcock · 2011 [cited by applicant]
US 8091782B2 · Cato · 2012 [cited by applicant]
US 8107736B2 · Brown · 2012 [cited by applicant]
US 8189855B2 · Opalach · 2012 [cited by applicant]
US 8191672B2 · Kondo · 2012 [cited by applicant]
US 8195533B1 · Mishra · 2012 [cited by applicant]
US 8224717B2 · Giacobbe · 2012 [cited by applicant]
US 8260456B2 · Siegel · 2012 [cited by applicant]
US 8321302B2 · Bauer · 2012 [cited by examiner]
US 8321303B1 · Krishnamurthy · 2012 [cited by applicant]
US 8346630B1 · McKeown · 2013 [cited by applicant]
US 8423431B1 · Rouaix · 2013 [cited by applicant]
US 8521620B2 · Livingston · 2013 [cited by applicant]
US 8577136B1 · Ascher · 2013 [cited by applicant]
US 8616822B2 · Winkler · 2013 [cited by applicant]
US 8732039B1 · Chen · 2014 [cited by applicant]
US 8965796B1 · Gala · 2015 [cited by applicant]
US 9120622B1 · Elazary · 2015 [cited by applicant]
US 9165277B2 · Jones · 2015 [cited by applicant]
US 9171278B1 · Kong · 2015 [cited by applicant]
US 9205886B1 · Hickman · 2015 [cited by applicant]
US 9280757B2 · Parpia · 2016 [cited by applicant]
US 9378484B1 · Russell · 2016 [cited by applicant]
US 9415935B1 · MacFarlane · 2016 [cited by applicant]
US 9758301B2 · Porat · 2017 [cited by applicant]
US 10019803B2 · Venable · 2018 [cited by applicant]
US 10089055B1 · Fryman · 2018 [cited by applicant]
US 10130177B2 · Jones · 2018 [cited by applicant]
US 10130232B2 · Atchley · 2018 [cited by applicant]
US 10138060B1 · Mantha · 2018 [cited by applicant]
US 10169738B2 · Jones · 2019 [cited by applicant]
US 10189642B2 · High · 2019 [cited by applicant]
US 10192157B2 · Cote · 2019 [cited by applicant]
US 10289990B2 · Rizzolo · 2019 [cited by applicant]
US 10311400B2 · Mascorro Medina · 2019 [cited by applicant]
US 10360548B2 · Brooks · 2019 [cited by applicant]
US 10373116B2 · Medina · 2019 [cited by applicant]
US 10453009B2 · Ulrich · 2019 [cited by applicant]
US 10467587B2 · Bogolea · 2019 [cited by applicant]
US 10489677B2 · Rzeszutek · 2019 [cited by applicant]
US 10505057B2 · Haist · 2019 [cited by applicant]
US 10546258B2 · Jones · 2020 [cited by applicant]
US 10552792B2 · Mattingly · 2020 [cited by applicant]
US 10558947B2 · Bryan · 2020 [cited by applicant]
US 10997552B2 · Bryan · 2021 [cited by applicant]
US 11055662B2 · Bryan · 2021 [cited by applicant]
US 11282157B2 · Bryan · 2022 [cited by applicant]
US 11449828B2 · Bryan · 2022 [cited by applicant]
US 11501251B2 · Bryan · 2022 [cited by applicant]
US 11715066B2 · Bryan · 2023 [cited by applicant]
US 11797929B2 · Bryan · 2023 [cited by examiner]
US 11816628B2 · Bryan · 2023 [cited by applicant]
US 11868960B2 · Bryan · 2024 [cited by applicant]
US 20010047293A1 · Waller · 2001 [cited by applicant]
US 20020138336A1 · Bakes · 2002 [cited by applicant]
US 20020174001A1 · Henry · 2002 [cited by applicant]
US 20030216969A1 · Bauer · 2003 [cited by applicant]
US 20030233277A1 · Saunders · 2003 [cited by applicant]
US 20040158507A1 · Meek · 2004 [cited by applicant]
US 20060157150A1 · Blakeslee · 2006 [cited by applicant]
US 20060184511A1 · Koo · 2006 [cited by applicant]
US 20070021864A1 · Mountz · 2007 [cited by applicant]
US 20070144991A1 · Hansl · 2007 [cited by applicant]
US 20070288439A1 · Rappaport · 2007 [cited by applicant]
US 20080077510A1 · Dielemans · 2008 [cited by applicant]
US 20080114651A1 · Jain · 2008 [cited by applicant]
US 20080120205A1 · Hoopes · 2008 [cited by applicant]
US 20080140491A1 · Jain · 2008 [cited by applicant]
US 20080255968A1 · Heinrichs · 2008 [cited by applicant]
US 20080270269A1 · Myers · 2008 [cited by applicant]
US 20080288595A1 · Liu · 2008 [cited by applicant]
US 20090060349A1 · Linaker · 2009 [cited by applicant]
US 20090063310A1 · Alonzo · 2009 [cited by applicant]
US 20090101713A1 · Ulrich · 2009 [cited by applicant]
US 20090157533A1 · Ohno · 2009 [cited by applicant]
US 20100023459A1 · Sundby · 2010 [cited by applicant]
US 20100095269A1 · Bouillet · 2010 [cited by applicant]
US 20100106609A1 · Sherman · 2010 [cited by applicant]
US 20100138037A1 · Adelberg · 2010 [cited by applicant]
US 20110093418A1 · Kwok · 2011 [cited by applicant]
US 20110131557A1 · Bouillet · 2011 [cited by applicant]
US 20120209734A1 · Brooks · 2012 [cited by applicant]
US 20120259655A1 · Madreperla · 2012 [cited by applicant]
US 20120310781A1 · Battle · 2012 [cited by applicant]
US 20130018696A1 · Meldrum · 2013 [cited by applicant]
US 20130124189A1 · Baldwin · 2013 [cited by applicant]
US 20130211870A1 · Lawson · 2013 [cited by applicant]
US 20140006131A1 · Causey · 2014 [cited by applicant]
US 20140006229A1 · Birch · 2014 [cited by applicant]
US 20140067634A1 · Sowder · 2014 [cited by applicant]
US 20140100769A1 · Wurman · 2014 [cited by applicant]
US 20140101088A1 · Hall · 2014 [cited by applicant]
US 20140122391A1 · Mugan · 2014 [cited by applicant]
US 20140143039A1 · Branton · 2014 [cited by applicant]
US 20140180865A1 · Argue · 2014 [cited by applicant]
US 20140201042A1 · Meyer · 2014 [cited by applicant]
US 20140247116A1 · Davidson · 2014 [cited by applicant]
US 20140344118A1 · Parpia · 2014 [cited by applicant]
US 20140379535A1 · Briet · 2014 [cited by applicant]
US 20150039373A1 · Anand · 2015 [cited by applicant]
US 20150154256A1 · McKenna · 2015 [cited by applicant]
US 20150178654A1 · Glasgow · 2015 [cited by applicant]
US 20150235157A1 · Avegliano · 2015 [cited by applicant]
US 20150242805A1 · Sakurai · 2015 [cited by applicant]
US 20150379366A1 · Nomura · 2015 [cited by applicant]
US 20160042315A1 · Field-Darragh · 2016 [cited by applicant]
US 20160114488A1 · Mascorro Medina · 2016 [cited by applicant]
US 20160132823A1 · Swafford · 2016 [cited by applicant]
US 20160132910A1 · Appel · 2016 [cited by applicant]
US 20160171428A1 · Gooijer · 2016 [cited by applicant]
US 20160371613A1 · Ulrich · 2016 [cited by applicant]
US 20170148005A1 · Murn · 2017 [cited by applicant]
US 20170155788A1 · Kobayashi · 2017 [cited by applicant]
US 20170193430A1 · Barreira Avegliano · 2017 [cited by applicant]
US 20170200106A1 · Jones · 2017 [cited by examiner]
US 20170277863A1 · Subra · 2017 [cited by applicant]
US 20170287038A1 · Krasadakis · 2017 [cited by applicant]
US 20180005174A1 · Dixon · 2018 [cited by applicant]
US 20180060804A1 · Cheruku · 2018 [cited by applicant]
US 20180089613A1 · Chen · 2018 [cited by applicant]
US 20180152884A1 · Hu · 2018 [cited by applicant]
US 20180268355A1 · Bryan · 2018 [cited by applicant]
US 20180268356A1 · Bryan · 2018 [cited by applicant]
US 20180268364A1 · Bryan · 2018 [cited by applicant]
US 20180268365A1 · Bryan · 2018 [cited by applicant]
US 20180268366A1 · Bryan · 2018 [cited by applicant]
US 20180268367A1 · Bryan · 2018 [cited by applicant]
US 20180268509A1 · Bryan · 2018 [cited by applicant]
US 20180341906A1 · Bryan · 2018 [cited by applicant]
US 20190057449A1 · Berd · 2019 [cited by applicant]
US 20190073775A1 · Lam · 2019 [cited by applicant]
US 20190149725A1 · Adato · 2019 [cited by applicant]
US 20190156821A1 · Zamora Duran · 2019 [cited by applicant]
US 20190215424A1 · Adato · 2019 [cited by applicant]
US 20190291954A1 · Lee · 2019 [cited by applicant]
US 20190303863A1 · Ghosh · 2019 [cited by applicant]
US 20200342561A1 · Bryan · 2020 [cited by applicant]
US 20200349499A1 · Bryan · 2020 [cited by applicant]
US 20210056506A1 · Bryan · 2021 [cited by applicant]
US 20210090015A1 · Bryan · 2021 [cited by applicant]
US 20210201255A1 · Bryan · 2021 [cited by applicant]
US 20210264360A1 · Bryan · 2021 [cited by applicant]
US 20210295253A1 · Bryan · 2021 [cited by applicant]
US 20230334422A1 · Bryan · 2023 [cited by applicant]
US 20240046205A1 · Bryan · 2024 [cited by applicant]
US 20240095672A1 · Bryan · 2024 [cited by applicant]
CA 2682886 · 2010 [cited by applicant]
CN 204270352U · 2015 [cited by applicant]
EP 1901215 · 2008 [cited by applicant]
WO 2015184286 · 2015 [cited by applicant]
WO 2016109251 · 2016 [cited by applicant]
“Improve Productivity and Customer Service in the Retail Store With Automated Inventory Management: The MC2100 in retail”; Zebra Technologies; Apr. 2015; pp. 1-6. [cited by applicant]
“Shelf Monitor”; Tech Mahindra; https://www.techmahindra.com/industries/Enterprise/retail_and_cpg/retail/solutions/shelf_monitor.aspx; 2016; pp. 1-1. [cited by applicant]
Angell, Robert C., “Control of State-Wide Liquor Inventories”, National Association of Cost Accountants; NACA Bulletin (pre-1986); Feb. 15, 1948; pp. 1-9. [cited by applicant]
Bourzac, Katherine; “A Robot Takes Stock”; https://www.technologyreview.com/s/428374/arobottakesstock/; Published Jun. 29, 2012; pp. 1-4. [cited by applicant]
Fraunhofer; “The flying inventory assistant”; http://www.fraunhofer.de/en/press/research-news/2014/december/the-flying-inventoryassistant.html; Published Dec. 1, 2014; pp. 1-3. [cited by applicant]
Gruen, Thomas W., et al.; “A Comprehensive Guide To Retail Out-of-Stock Reduction In the Fast-Moving Consumer Goods Industry”; 2007; 71 pgs. [cited by applicant]
Kang, Yun, et al.; “Information Inaccuracy in Inventory Systems—Stock Loss and Stockout”; Massachusetts Institute of Technology; Published Aug. 23, 2004; 29 pages. [cited by applicant]
Lowe's Home Improvement; “Lowe's Introduces LoweBot”; https://www.youtube.com/watch?v=hP3yfGHTXFo; Published on Aug. 30, 2016; pp. 1-10. [cited by applicant]
McClain, John O; Cornell University; “Simulating Inventory Control with Orders that Cross during Lead Time”; http://www.exinfm.com/excel%20files/Inventory_Simulation.xls; Mar. 22, 2002; pp. 1-60. [cited by applicant]
Moyer, Ted; TotalRetail; “5 Steps to Solving the Out-of-Stock Problem”; http://www.mytotalretail.com/article/5stepstosolvingtheoutofstockproblem/; Published Apr. 19, 2016; pp. 1-7. [cited by applicant]
SAP; “How to Set Up and Manage a Perpetual Inventory System”; SAP; Jun. 22, 2016; pp. 1-108. [cited by applicant]
Stuart, Sophia; “Meet Tally, the Robot That Knows What's on Store Shelves”; http://in.pcmag.com/roboticsautomation/99587/news/meettallytherobotthatknowswhatsonstoreshelves; Published Jan. 27, 2016; pp. 1-8. [cited by applicant]
Trujillo, Paul; “Walmart is Addressing Inventory Problems With a New System”; http://www.waspbarcode.com/buzz/walmart-2/; Nov. 15, 2016; pp. 1-7. [cited by applicant]
Vanian, Jonathan; “Target's New Robot Helper Is Busy At Work On Aisle 3”; http://fortune.com/2016/04/28/targettestingrobotinventorysimbe/; Published Apr. 28, 2016; pp. 1-8. [cited by applicant]
Wharton School; “Robot Assistants in Aisle 10: Will Shoppers Buy It?”; http://knowledge.wharton.upenn.edu/article/robots-aisle-10-will-shoppers-like/; Published Sep. 7, 2016; pp. 1-5. [cited by applicant]