IP Library Granted Patent US 12,417,433
Granted Patent B2
US 12,417,433 · App. 18/043,058 · Granted Sep 16, 2025

Warehousing data processing method and apparatus, medium, and electronic device

Inventor: Gaochun Xie (Beijing, CN)
Assignees: Beijing Wodong Tianjun Information Technology Co., Ltd.; BEIJING JINGDONG CENTURY TRADING CO., LTD.
G06Q10/087
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,417,433
App. No.
18/043,058
Granted
Sep 16, 2025
Kind
B2
Abstract

A method for processing warehousing data includes: obtaining attribute data of a preset object from a warehousing data table; determining safety inventory data of the preset object and target inventory data of the preset object according to the attribute data of the preset object; obtaining current inventory data of the preset object from the warehousing data table; determining, in response to that the current inventory data of the preset object is less than or equal to the safety inventory data of the preset object, a replenishment quantity of the preset object according to the target inventory data of the preset object and the current inventory data of the preset object; and sending the replenishment quantity of the preset object to a warehouse management system, causing the warehouse management system to perform replenishment according to the replenishment quantity of the preset object.

Claims (60)

1. A method for processing warehousing data, comprising:

obtaining, by a server, attribute data of a preset object from a warehousing data table;

determining, by the server, safety inventory data of the preset object according to the attribute data of the preset object;

determining, by the server, target inventory data of the preset object according to the attribute data of the preset object;

obtaining, by the server, current inventory data of the preset object from the warehousing data table;

determining, by the server in response to that the current inventory data of the preset object is less than or equal to the safety inventory data of the preset object, a replenishment quantity of the preset object according to the target inventory data of the preset object and the current inventory data of the preset object; and

sending, by the server, the replenishment quantity of the preset object to a warehouse management system, causing the warehouse management system to perform replenishment according to the replenishment quantity of the preset object;

wherein the attribute data of the preset object comprises any one or more of following items: an arrival time length for the replenishment of the preset object, a replenishment cycle of the preset object, average daily sales data of the preset object, number of days for preparation of the preset object, a display-on-shelf quantity of the preset object, and stocking inventory data of the preset object;

the method further comprising:

obtaining, by the server, sales data of the preset object in a historical time period from the warehousing data table; and

determining, by the server, the average daily sales data of the preset object according to the sales data of the preset object in the historical time period;

determining, by the server according to store information corresponding to the preset object, whether the store information is in a preset list; and

stopping, by the server in response to that the store information is in the preset list, sending the replenishment quantity of the preset object to the warehouse management system;

wherein the determining, by the server, the safety inventory data of the preset object according to the attribute data of the preset object comprises:

determining, by the server, sales data of the preset object in a first time period according to the arrival time length for the replenishment of the preset object, the replenishment cycle of the preset object, and the average daily sales data of the preset object, wherein the first time period is a sum of the arrival time length for the replenishment of the preset object and the replenishment cycle of the preset object;

determining, by the server, the safety inventory data of the preset object according to the sales data of the preset object in the first time period, the arrival time length for the replenishment of the preset object, the average daily sales data of the preset object, the display-on-shelf quantity of the preset object, and the stocking inventory data of the preset object, wherein the safety inventory data of the preset object is a maximum safety inventory data of the preset object.

2. The method of claim 1 , wherein the determining, by the server, the target inventory data of the preset object according to the attribute data of the preset object comprises:

determining, by the server, the target inventory data of the preset object according to the average daily sales data of the preset object, the arrival time length for the replenishment of the preset object, the replenishment cycle of the preset object, and the number of days for preparation of the preset object.

3. The method of claim 1 , further comprising:

obtaining, by the server, an adjusted replenishment quantity of the preset object by adjusting the replenishment quantity of the preset object according to a minimum order quantity of the preset object;

wherein sending, by the server, the replenishment quantity of the preset object to the warehouse management system comprises:

sending, by the server, the adjusted replenishment quantity of the preset object to the warehouse management system.

4. An electronic device comprising:

one or more processors; and

a storage device, configured to store one or more programs that, when executed by the one or more processors, cause the one or more processors to implement actions comprising:

obtain attribute data of a preset object from a warehousing data table;

determine safety inventory data of the preset object according to the attribute data of the preset object;

determine target inventory data of the preset object according to the attribute data of the preset object;

obtain current inventory data of the preset object from the warehousing data table;

determine, in response to that the current inventory data of the preset object is less than or equal to the safety inventory data of the preset object, a replenishment quantity of the preset object according to the target inventory data of the preset object and the current inventory data of the preset object; and

send the replenishment quantity of the preset object to a warehouse management system, causing the warehouse management system to perform replenishment according to the replenishment quantity of the preset object;

wherein the attribute data of the preset object comprises any one or more of following items: an arrival time length for the replenishment of the preset object, a replenishment cycle of the preset object, average daily sales data of the preset object, number of days for preparation of the preset object, a display-on-shelf quantity of the preset object, and stocking inventory data of the preset object;

wherein the one or more processors are further configured to:

obtain sales data of the preset object in a historical time period from the warehousing data table; and

determine the average daily sales data of the preset object according to the sales data of the preset object in the historical time period;

determine sales data of the preset object in a first time period according to the arrival time length for the replenishment of the preset object, the replenishment cycle of the preset object, and the average daily sales data of the preset object, wherein the first time period is a sum of the arrival time length for the replenishment of the preset object and the replenishment cycle of the preset object;

determine the safety inventory data of the preset object according to the sales data of the preset object in the first time period, the arrival time length for the replenishment of the preset object, the average daily sales data of the preset object, the display-on-shelf quantity of the preset object, and the stocking inventory data of the preset object, wherein the safety inventory data of the preset object is a maximum safety inventory data of the preset object;

determine, according to store information corresponding to the preset object, whether the store information is in a preset list; and

stop, in response to that the store information is in the preset list, sending the replenishment quantity of the preset object to the warehouse management system.

5. The electronic device of claim 4 , wherein the one or more processors are configured to:

determine the target inventory data of the preset object according to the average daily sales data of the preset object, the arrival time length for the replenishment of the preset object, the replenishment cycle of the preset object, and the number of days for preparation of the preset object.

6. The electronic device of claim 4 , wherein the one or more processors are further configured to:

obtain an adjusted replenishment quantity of the preset object by adjusting the replenishment quantity of the preset object according to a minimum order quantity of the preset object; and

send the adjusted replenishment quantity of the preset object to the warehouse management system.

7. A non-transitory computer-readable medium storing a computer program thereon, wherein the computer program is used for, when executed by a processor, implementing a method for processing warehousing data comprising:

obtaining attribute data of a preset object from a warehousing data table;

determining safety inventory data of the preset object according to the attribute data of the preset object;

determining target inventory data of the preset object according to the attribute data of the preset object;

obtaining current inventory data of the preset object from the warehousing data table;

determining, in response to that the current inventory data of the preset object is less than or equal to the safety inventory data of the preset object, a replenishment quantity of the preset object according to the target inventory data of the preset object and the current inventory data of the preset object; and

sending the replenishment quantity of the preset object to a warehouse management system, causing the warehouse management system to perform replenishment according to the replenishment quantity of the preset object;

wherein the attribute data of the preset object comprises any one or more of following items: an arrival time length for the replenishment of the preset object, a replenishment cycle of the preset object, average daily sales data of the preset object, number of days for preparation of the preset object, a display-on-shelf quantity of the preset object, and stocking inventory data of the preset object;

the method further comprising:

obtaining, by the server, sales data of the preset object in a historical time period from the warehousing data table; and

determining, by the server, the average daily sales data of the preset object according to the sales data of the preset object in the historical time period;

determining, by the server according to store information corresponding to the preset object, whether the store information is in a preset list; and

stopping, by the server in response to that the store information is in the preset list, sending the replenishment quantity of the preset object to the warehouse management system;

wherein the determining, by the server, the safety inventory data of the preset object according to the attribute data of the preset object comprises:

determining, by the server, sales data of the preset object in a first time period according to the arrival time length for the replenishment of the preset object, the replenishment cycle of the preset object, and the average daily sales data of the preset object, wherein the first time period is a sum of the arrival time length for the replenishment of the preset object and the replenishment cycle of the preset object;

determining, by the server, the safety inventory data of the preset object according to the sales data of the preset object in the first time period, the arrival time length for the replenishment of the preset object, the average daily sales data of the preset object, the display-on-shelf quantity of the preset object, and the stocking inventory data of the preset object, wherein the safety inventory data of the preset object is a maximum safety inventory data of the preset object.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 27, 2023
From: XIE, GAOCHUN
To: BEIJING WODONG TIANJUN INFORMATION TECHNOLOGY CO., LTD.; BEIJING JINGDONG CENTURY TRADING CO., LTD.
Reel/Frame 062806/0070 →
Priority Claims (1)
CN 202011032679.4 · Sep 27, 2020 · national
Continuity (1)
Related Publication 20240020633A1 · Jan 18, 2024
References Cited (23)
US 10872309B2 · Surendra · 2020 [cited by examiner]
US 20020072988A1 · Aram · 2002 [cited by examiner]
US 20060069598A1 · Schweitzer · 2006 [cited by examiner]
US 20180268368A1 · Chen et al. · 2018 [cited by applicant]
CN 106971249A · 2017 [cited by applicant]
CN 107256473A · 2017 [cited by applicant]
CN 107767203A · 2018 [cited by applicant]
CN 108269045A · 2018 [cited by applicant]
CN 109272265A · 2019 [cited by applicant]
CN 109285246A · 2019 [cited by applicant]
CN 109840734A · 2019 [cited by applicant]
CN 109993516A · 2019 [cited by applicant]
CN 110020817A · 2019 [cited by applicant]
CN 110689159A · 2020 [cited by applicant]
CN 111429048A · 2020 [cited by applicant]
JP 2000348016A · 2000 [cited by applicant]
JP 2003216216A · 2003 [cited by applicant]
JP 2007200185A · 2007 [cited by applicant]
International Search Report dated Jul. 27, 2021 of PCT International Application No. PCT/CN2021/091640. [cited by applicant]
Extended European Search Report dated Jul. 23, 2024 of European Application No. 21870800.6. [cited by applicant]
Decision of Rejection dated Sep. 19, 2024 of Chinese Application No. 202011032679.4. [cited by applicant]
2nd Office Action dated Aug. 22, 2023 for Japanese Application No. 2022-569256. [cited by applicant]
1st Office Action dated Feb. 4, 2024 for Chinese Application No. 202011032679.4. [cited by applicant]