Method, device, apparatus and computer-readable medium for processing warehouse data

Abstract

The present invention discloses a method, device, equipment and computer-readable medium for processing warehouse data, and relates to the field of computer technology. A specific implementation of the method includes: based on the data processing cycle, updating the grade item quantity of items stored in the warehouse in the logistics platform; querying and obtaining the price of the item in the database, and obtaining the warehouse quantity of the item from the warehouse management system through the database; in the logistics platform, determining the deductible quantity of the item according to the warehouse quantity of the item and the deductible coefficient of the item; through the logistics platform, sending the grade item quantity of the item, the price of the item and the deductible quantity of the item to the claim system, so as to create a list of warehouse data processing to realize the claim for the item. This implementation can improve the efficiency of processing warehouse data and ensure the normal operation of the warehouse.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, device, equipment and computer-readable medium for processing warehouse data. Background Art

[0002] Warehouses are used to store and keep goods. Traditional warehousing refers to the use of warehouses to store and take out various materials and related facilities and equipment. Modern warehousing refers to adding in-warehouse processing, sorting, and in-warehouse packaging to traditional warehousing. Warehousing is one of the important links in production and commodity circulation, and is also an important link in logistics activities.

[0003] In the process of implementing the present invention, the inventors found that there are at least the following problems in the prior art: as the number and types of items in the warehouse increase, it is difficult to avoid damage or loss of items, and warehouse losses are often handled manually, resulting in low efficiency in processing warehouse data and affecting the normal operation of the warehouse. Summary of the invention

[0004] In view of this, embodiments of the present invention provide a method, apparatus, device and computer-readable medium for processing warehouse data, which can improve the efficiency of processing warehouse data and ensure the normal operation of the warehouse.

[0005] To achieve the above object, according to one aspect of an embodiment of the present invention, a method for processing warehouse data is provided, comprising:

[0006] Based on the data processing cycle, the level item quantity of the items stored in the warehouse is updated in the logistics platform;

[0007] Querying and obtaining the price of the item in a database, and obtaining the inventory quantity of the item from a warehouse management system through the database;

[0008] In the logistics platform, the deductible quantity of the item is determined according to the warehousing quantity of the item and the deductible coefficient of the item;

[0009] Through the logistics platform, the grade and quantity of the items, the price of the items and the deductible quantity of the items are sent to the claims system to create a list of processing warehouse data to realize claims for the items.

[0010] Based on the data processing cycle, the level and quantity of items stored in the warehouse are updated in the logistics platform, including:

[0011] According to the damage status of the item and / or the loss status of the item, determine and upload the grade and quantity of the item to the logistics platform;

[0012] Based on the data processing cycle, the level item quantity of the items stored in the warehouse is updated in the logistics platform according to the level item quantity of the uploaded items.

[0013] The querying and obtaining the price of the item in the database, and obtaining the storage quantity of the item from the warehouse management system through the database, include:

[0014] Sending a price inquiry request to the database through the logistics platform, and obtaining the price of the item in the database based on the item identifier in the price inquiry request;

[0015] The warehouse management system sends the warehouse quantity of the items to the database;

[0016] A request for querying the quantity of goods in storage is sent to the database through the logistics platform, and the quantity of goods in storage is obtained in the database based on the item identifier of the request for querying the quantity of goods in storage.

[0017] In the logistics platform, the deductible quantity of the item is determined according to the warehousing quantity of the item and the deductible coefficient of the item, including:

[0018] The logistics platform obtains the deductible coefficient of the item from the item deductible instruction in response to the item deductible instruction;

[0019] In the logistics platform, the deductible quantity of the items is calculated according to the warehousing quantity of the items and the deductible coefficient of the items.

[0020] The logistics platform sends the grade and quantity of the item, the price of the item and the deductible quantity of the item to the claim system to create a list of processing warehouse data to realize the claim for the item, including:

[0021] Pushing the grade and quantity of the item, the price of the item and the deductible quantity of the item to the claim system through the logistics platform;

[0022] In the claims system, creating a list of the processing warehouse data based on the grade item quantity of the item, the price of the item and the deductible quantity of the item;

[0023] Based on the identification of the item, a list of the processing warehouse data is sent.

[0024] In the claim settlement system, creating a list of the processing warehouse data based on the grade item quantity of the item, the price of the item and the deductible quantity of the item includes:

[0025] In the claim settlement system, according to the number of graded items of the item, the accumulated number of low-grade items is determined;

[0026] The accumulated number of low-grade items is less than or equal to the deductible number of the items, and a list of the processing warehouse data is created according to the deductible amount of the items, and the deductible amount of the items is determined based on the price of the items.

[0027] In the claim settlement system, creating a list of the processing warehouse data based on the grade item quantity of the item, the price of the item and the deductible quantity of the item includes:

[0028] In the claim settlement system, according to the number of graded items of the item, the accumulated number of low-grade items is determined;

[0029] The cumulative number of low-grade items is greater than the deductible number of the items, and the claim amount is determined according to the deductible number of the items and the cumulative number of low-grade items;

[0030] Based on the price of the item and the claim quantity, a list of the processing warehouse data is created.

[0031] According to a second aspect of an embodiment of the present invention, there is provided a device for processing warehouse data, comprising:

[0032] An update module, for updating the level item quantity of items stored in the warehouse in the logistics platform based on a data processing cycle;

[0033] A query module, used to query and obtain the price of the item in the database, and obtain the inventory quantity of the item from the warehouse management system through the database;

[0034] A determination module, used to determine the deductible quantity of the item in the logistics platform according to the warehousing quantity of the item and the deductible coefficient of the item;

[0035] The processing module is used to send the grade and quantity of the items, the price of the items and the deductible quantity of the items to the claim system through the logistics platform to create a list of processing warehouse data to realize the claim for the items.

[0036] According to a third aspect of an embodiment of the present invention, there is provided an electronic device for processing warehouse data, comprising:

[0037] one or more processors;

[0038] a storage device for storing one or more programs,

[0039] When the one or more programs are executed by the one or more processors, the one or more processors implement the above method.

[0040] According to a fourth aspect of an embodiment of the present invention, there is provided a computer-readable medium on which a computer program is stored, and when the program is executed by a processor, the method as described above is implemented.

[0041] One embodiment of the above invention has the following advantages or beneficial effects: based on the data processing cycle, the number of graded items stored in the warehouse is updated in the logistics platform; the price of the item is queried and obtained in the database, and the number of items in storage is obtained from the warehouse management system through the database; in the logistics platform, the number of deductible items of the item is determined according to the number of items in storage and the deductible coefficient of the item; through the logistics platform, the number of graded items of the item, the price of the item and the deductible number of the item are sent to the claim system to create a list of warehouse data for processing to realize the claim for the item. The logistics platform, the warehouse management system, the database and the claim platform create and process the list of warehouse data through interactive information to realize the claim for the item. The above process does not require human participation and can be automatically executed based on the data processing cycle. Therefore, the efficiency of processing warehouse data can be improved to ensure the normal operation of the warehouse.

[0042] The further effects of the above-mentioned non-conventional optional manner will be described below in conjunction with the specific implementation manner. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] The accompanying drawings are used to better understand the present invention and do not constitute an improper limitation of the present invention.

[0044] Figure 1 is a schematic diagram of the main flow of a method for processing warehouse data according to an embodiment of the present invention;

[0045] Figure 2 is a schematic diagram of a process of updating the item level of an item stored in a warehouse according to an embodiment of the present invention;

[0046] Figure 3 is a schematic diagram of a process for obtaining the price and storage quantity of an item according to an embodiment of the present invention;

[0047] Figure 4 is a schematic diagram of a process for determining the deductible quantity of an item according to an embodiment of the present invention;

[0048] Figure 5 is a flow chart of sending warehouse data to a claims settlement system to realize item claims settlement according to an embodiment of the present invention;

[0049] Figure 6is a schematic diagram of a process of creating a list of processed warehouse data according to an embodiment of the present invention;

[0050] Figure 7 is another flowchart of creating a list of processing warehouse data according to an embodiment of the present invention;

[0051] Figure 8 is an interactive schematic diagram of processing warehouse data according to an embodiment of the present invention;

[0052] Fig. 9 is a schematic diagram of the main structure of a device for processing warehouse data according to an embodiment of the present invention;

[0053] Fig.10 is an exemplary system architecture diagram to which embodiments of the present invention may be applied;

[0054] Fig.11 It is a schematic diagram of the structure of a computer system of a terminal device or a server suitable for implementing an embodiment of the present invention. DETAILED DESCRIPTION

[0055] The following is a description of exemplary embodiments of the present invention in conjunction with the accompanying drawings, including various details of the embodiments of the present invention to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present invention. Similarly, for clarity and conciseness, the description of well-known functions and structures is omitted in the following description.

[0056] Warehouse data includes inbound and outbound data, etc. Warehouses also include various types. From the perspective of use, they can be divided into shared warehouses and independent warehouses. Shared warehouses are a warehousing model formed with the development of community group buying. In order to improve the timeliness of distribution, suppliers will store goods in shared warehouses close to the central warehouse in advance and deliver the goods to the central warehouse in batches.

[0057] In view of the possibility of damaged or lost goods in the shared warehouse, it is necessary to make claims to the merchant for the lost or damaged goods. Currently, claims for shared warehouses are made through merchant complaints, work order feedback, etc. In practice, the claim amount is filled in manually by the customer service, which is not objective for both the merchant and the warehouse. It can be seen that the efficiency of processing warehouse data is low, which affects the normal operation of the warehouse.

[0058] In order to solve the technical problem of low efficiency in processing warehouse data, the following technical solution in the embodiment of the present invention can be adopted.

[0059] See also Figure 1 , Figure 11 is a schematic diagram of the main flow of the method for processing warehouse data according to an embodiment of the present invention. The logistics platform, warehouse management system, database and claim settlement platform create a list of processed warehouse data through interactive information to realize the claim settlement of items. Figure 1 As shown, the specific steps include:

[0060] S101. Based on the data processing cycle, the level and quantity of items stored in the warehouse are updated in the logistics platform.

[0061] The warehouse is used to store items. As an example, the warehouse stores 100 items A, 50 items B, and 20 items C. Items are stored in the warehouse. Since the items in the warehouse are constantly entering and leaving the warehouse, it is difficult to avoid damage and loss. The technical solution in the embodiment of the present invention is adopted to process warehouse data to realize claims for damaged or lost items.

[0062] For a warehouse, the items stored in the warehouse will change over time. A data processing cycle is set for processing warehouse data. That is, a plan for processing warehouse data is executed within the data processing cycle. As an example, the data processing cycle is set to a natural month. As another example, the data processing cycle is set to a natural year.

[0063] In an embodiment of the present invention, the level and quantity of items in the warehouse are stored in the logistics platform. The warehouse includes an independent warehouse and a shared warehouse. It is understandable that the items in the shared warehouse belong to different suppliers, and the damage or loss of the items needs to be compensated for the items and the suppliers. The scheme in the embodiment of the present invention is adopted to realize the compensation for the items in the shared warehouse by processing the warehouse data. That is, the item level of the items stored in the shared warehouse is updated in the logistics platform.

[0064] See also Figure 2 , Figure 2 1 is a flow chart of updating the item level of items stored in a warehouse according to an embodiment of the present invention. Specifically, the following steps are included:

[0065] S201. According to the damage status and / or loss status of the items, determine and upload the level and quantity of the items to the logistics platform.

[0066] When the warehouse operator inspects the items in the warehouse and finds that the items are damaged and / or lost, the number of items in the level will be updated. The level is a parameter used to identify the storage status of the items. As an example, the levels include level one, level two, and level three. Level one indicates that the outer packaging of the item is not damaged; level two indicates that the outer packaging of the item is damaged; and level three indicates that the item is lost. It can be seen that as the level decreases, the item status becomes worse and worse.

[0067] Tier Item Quantity is the quantity of the item in the tier. As an example, Tier 1 Quantity is 10 pieces; Tier 2 Quantity is 3 pieces; Tier 3 Quantity is 1 piece.

[0068] Specifically, the operator determines and uploads the level and quantity of the item to the logistics platform according to the damaged state and / or lost state of the item. As an example, the operator logs in to the logistics platform through the client, and then uploads the level and quantity of the item to the logistics platform through the client. The client is set on the mobile terminal.

[0069] S202. Based on the data processing cycle, the level item quantity of the items stored in the warehouse is updated in the logistics platform according to the level item quantity of the uploaded items.

[0070] During the data processing cycle, the logistics platform updates the number of graded items. Specifically, during the data processing cycle, the number of graded items has been stored in the logistics platform. The item platform updates the number of graded items in the warehouse based on the number of graded items uploaded.

[0071] As an example, the original level item quantity of the items in the warehouse is 10 pieces of level 1. Based on the uploaded level item quantity of 10 pieces of level 2, the item level of the items in the warehouse is updated to 10 pieces of level 2.

[0072] exist Figure 2 In the embodiment, the level and quantity of items in the logistics platform are updated according to the data processing cycle to determine the status of the items in the warehouse.

[0073] S102: Query and obtain the price of the item in the database, and obtain the inventory quantity of the item from the warehouse management system through the database.

[0074] The price of the item is stored in the database, and the price of the item is obtained by querying the database. In addition, the storage quantity of the item obtained from the warehouse management system is stored in the database, so the storage quantity of the item is also obtained by querying the database.

[0075] See also Figure 3 , Figure 3 This is a schematic diagram of a process for obtaining the price and storage quantity of an item according to an embodiment of the present invention. Specifically, the following steps are included:

[0076] S301. Send a price inquiry request to a database through a logistics platform, and obtain the price of the item in the database based on the item identifier in the price inquiry request.

[0077] The price of the item is stored in the database. A price query request is sent to the database through the logistics platform, and the price query request includes the item ID. In the database, the price of the item is obtained based on the item ID in the price query request. The item ID includes the stock keeping unit (SKU).

[0078] In the embodiment of the present invention, the price of the item is recorded in the database. Generally speaking, the price of the item will change with holidays and production dates. In order to improve the accuracy of the price of the item, the price of the item can be determined in the following manner. The average discounted price of the item during the data processing period. As an example, the data processing period is one month. The price of the item = the sum of the discounted prices of the items per day in a month / the number of days in a month.

[0079] S302: The warehouse management system sends the inventory quantity of the items to the database.

[0080] The warehouse management system includes the inbound and outbound data of the items stored in the warehouse. The warehouse management system can periodically send the inbound quantity of the items to the database. It is understandable that the inbound quantity of the items and the price of the stored items are stored in the database.

[0081] S303: Send a request for querying the incoming quantity to the database through the logistics platform, and obtain the incoming quantity of the item in the database based on the item identifier in the request for querying the incoming quantity.

[0082] The database stores the incoming quantity of items. In order to obtain the incoming quantity of items, the logistics platform sends a query request for the incoming quantity to the database. The incoming quantity request includes an item identifier. As an example, the item identifier includes a SKU.

[0083] In the database, the incoming quantity of the item is obtained based on the item identifier of the incoming quantity request.

[0084] exist Figure 3 In the embodiment, in response to the request, the logistics platform obtains the price of the item and the inventory quantity of the item from the database.

[0085] S103. In the logistics platform, the deductible quantity of the items is determined according to the warehousing quantity of the items and the deductible coefficient of the items.

[0086] The logistics platform records the grade, quantity, price and warehousing process of the items in the warehouse. The warehouse is responsible for the damage and / or loss of items, but if the items are damaged or modified within a certain quantity, the warehouse does not need to compensate, which is considered normal loss of items.

[0087] Then, it is necessary to determine the deductible quantity of the items. Specifically, in the logistics platform, the deductible quantity of the items is determined according to the inventory quantity of the items and the deductible coefficient of the items.

[0088] See also Figure 4 , Figure 4 This is a flow chart of determining the deductible quantity of items according to an embodiment of the present invention. It specifically includes the following steps:

[0089] S401. The logistics platform responds to the item deductible instruction and obtains the item deductible coefficient from the item deductible instruction.

[0090] The deductible coefficient of the item can be obtained from the item deductible instruction. Specifically, the logistics platform obtains the deductible coefficient of the item from the item deductible instruction in response to the item deductible instruction. As an example, the deductible system of the item can be determined based on the category of the item. For example, the deductible system of fresh items is 10%; the deductible coefficient of daily necessities is 5%; and the deductible coefficient of electronic products is 3%.

[0091] S402. In the logistics platform, the deductible quantity of the items is calculated according to the inventory quantity of the items and the deductible coefficient of the items.

[0092] In the logistics platform, the deductible quantity of the items needs to be calculated. Specifically, the deductible quantity of the items is calculated according to the inventory quantity of the items and the deductible coefficient of the items. As an example, the product of the inventory quantity of the items and the deductible coefficient of the items is used as the deductible quantity of the items.

[0093] exist Figure 4 In an embodiment, in response to an item deductible instruction, deductible data for the item is determined.

[0094] S104. Send the item grade, item quantity, item price and item deductible quantity to the claim system through the logistics platform to create a list of processed warehouse data to realize the claim for the item.

[0095] After obtaining the number of graded items, the number of items in storage, the price of items, and the number of items exempt from deductible, the logistics platform can send the above warehouse data to the claims system. It is understandable that the logistics platform obtains warehouse data through interaction with the database and warehouse management system. Then, the claims system creates a list of processed warehouse data to realize claims for damaged and / or lost items.

[0096] See also Figure 5 , Figure 5 The flowchart of sending warehouse data to the claim settlement system to realize item claim settlement according to an embodiment of the present invention is shown in FIG. The flowchart specifically includes the following steps:

[0097] S501. Push the item grade, item quantity, item price and item deductible quantity to the claims system through the logistics platform.

[0098] In an embodiment of the present invention, the claim system is responsible for processing the claim of items. First, the warehouse data is pushed to the claim system through the logistics platform. It is understandable that during the data processing cycle, the logistics platform can actively push the warehouse data to the claim system. Among them, the warehouse data includes: the grade and quantity of the items, the price of the items, and the deductible quantity of the items.

[0099] Specifically, through the logistics platform, according to the identification of the items, the grade and quantity of the items, the price of the items and the deductible quantity of the items are pushed to the claims system.

[0100] S502. In the claims system, a list of processing warehouse data is created based on the grade and quantity of the items, the price of the items, and the deductible quantity of the items.

[0101] In the claims system, a list of processing warehouse data is created based on the grade of the item, the grade item quantity, the price of the item, and the deductible quantity of the item.

[0102] The following is a list of two situations where we create and process warehouse data.

[0103] See also Figure 6 , Figure 6 1 is a flow chart of creating a list of warehouse data for processing according to an embodiment of the present invention. Specifically, the following steps are included:

[0104] S601. In the claims settlement system, the cumulative number of low-level items is determined according to the number of items of the same grade.

[0105] In the claims system, within a data processing cycle, the number of accumulated low-level items can be determined according to the number of items of the item level. For example, the number of items of level 2 is 2; the number of items of level 3 is 3, and the accumulated number of low-level items is 5.

[0106] S602: The accumulated number of low-grade items is less than or equal to the deductible number of items. A list of processing warehouse data is created according to the deductible amount of the items. The deductible amount of the items is determined based on the price of the items.

[0107] If the cumulative number of low-level items is less than or equal to the deductible number of items, it means that the item loss is within the normal range, and a list of warehouse data processing can be established according to the deductible of the items. The deductible of the item is determined based on the price of the item. As an example, if the price of the item is less than 1,000 yuan, the deductible of the item is 0; if the price of the item is higher than 1,000 yuan, the deductible of the item is 100.

[0108] exist Figure 6 In the embodiment, if the accumulated number of low-grade items is less than or equal to the deductible number of items, a list of processing warehouse data is created according to the deductible amount of the items.

[0109] See also Figure 7 , Figure 7 4 is a flowchart of another method for creating a list of processing warehouse data according to an embodiment of the present invention.

[0110] S701. In the claims settlement system, the cumulative number of low-level items is determined according to the number of items of the item grade.

[0111] In the claims system, within a data processing cycle, the cumulative number of low-level items can be determined according to the number of items of the same grade.

[0112] S702: The cumulative number of low-grade items is greater than the deductible number of items, and the claim amount is determined according to the deductible number of items and the cumulative number of low-grade items.

[0113] If the cumulative number of low-grade items is greater than the deductible number of items, it means that the loss of items is not within the normal range and the claim amount needs to be determined. Specifically, the claim amount is determined according to the deductible number of items and the cumulative number of low-grade items. That is, the claim amount is equal to the difference between the cumulative number of low-grade items and the deductible number of items.

[0114] S703: Based on the price of the item and the claim amount, a list of warehouse data to be processed is created. The product of the price of the item and the claim amount is used as the claim amount, and a list of warehouse data to be processed is created, and the warehouse data to be processed includes the claim amount.

[0115] exist Figure 7 In the embodiment, if the accumulated number of low-grade items is greater than the deductible number of items, a list of processing warehouse data is created based on the price and claim quantity of the items.

[0116] The following is for Figure 6 and Figure 7 The technical solution in is described exemplarily.

[0117] The data processing cycle is a natural month. If the current date is February, the warehouse data for January will be processed on February 1. For item A, the inventory in the warehouse is 20,000 pieces, and the deductible coefficient is 0.0003, so the deductible quantity is 6 pieces.

[0118] If 8 low-grade items are submitted for the first time, 6 of the 8 items A can be exempted from claim in the claim system, and the other 2 items A can be claimed normally. That is, for the 6 low-grade items, a list of warehouse data for processing is created according to the deductible of item A. For the remaining 2 low-grade items, a list of warehouse data for processing is created according to the price and claim quantity of item A.

[0119] In the same month, 8 low-grade items are submitted again. Since the deductible quantity has been used up, item A will no longer be deducted in January. For the 8 low-grade items, create a list of warehouse data for processing according to the price and claim quantity of item A.

[0120] S503. Send a list of processed warehouse data based on the identification of the item.

[0121] According to the identification of the items, a list of processed warehouse data is sent to the warehouse management party.

[0122] exist Figure 5 In the embodiment, the claim settlement for low-grade items is implemented in combination with the deductible data of the items.

[0123] See also Figure 8 , Figure 8 It is an interactive schematic diagram of processing warehouse data according to an embodiment of the present invention. Figure 8 It involves logistics platform, database, warehouse management system and claims system.

[0124] First, the warehouse management system sends the incoming data of the items to the database. On the logistics platform, the item level and quantity are updated.

[0125] The logistics platform sends a price query request to the database to obtain the price of the item from the database. The logistics platform sends a storage quantity query request to the database to obtain the storage quantity of the item from the database.

[0126] The item platform sends the item grade, item quantity, item price and item deductible quantity to the claims system to create a list of processed warehouse data to realize claims for the items.

[0127] In the above embodiment, based on the data processing cycle, the number of graded items stored in the warehouse is updated in the logistics platform; the price of the item is queried and obtained in the database, and the number of items in storage is obtained from the warehouse management system through the database; in the logistics platform, the deductible number of the item is determined according to the number of items in storage and the deductible coefficient of the item; through the logistics platform, the number of graded items, the price of the item and the deductible number of the item are sent to the claim system to create a list of warehouse data for processing to realize the claim for the item. The logistics platform, warehouse management system, database and claim platform create a list of warehouse data for processing through interactive information to realize the claim for the item. The above process does not require human participation and can be automatically executed based on the data processing cycle. Therefore, the efficiency of processing warehouse data can be improved to ensure the normal operation of the warehouse.

[0128] See also Fig. 9 , Fig. 9 is a schematic diagram of the main structure of the device for processing warehouse data according to an embodiment of the present invention. The device for processing warehouse data can implement a method for processing warehouse data, such as Fig. 9 As shown, the device for processing warehouse data specifically includes:

[0129] An updating module 901, for updating the level item quantity of items stored in the warehouse in the logistics platform based on the data processing cycle;

[0130] A query module 902 is used to query and obtain the price of the item in the database, and obtain the storage quantity of the item from the warehouse management system through the database;

[0131] The determination module 903 is used to determine the deductible quantity of the item according to the storage quantity of the item and the deductible coefficient of the item in the logistics platform;

[0132] The processing module 904 is used to send the grade and quantity of the item, the price of the item and the deductible quantity of the item to the claim system through the logistics platform to create a list of processing warehouse data to realize the claim for the item.

[0133] In one embodiment of the present invention, the updating module 901 is specifically used to determine and upload the grade item quantity of the item to the logistics platform according to the damage status of the item and / or the loss status of the item;

[0134] Based on the data processing cycle, the level item quantity of the items stored in the warehouse is updated in the logistics platform according to the level item quantity of the uploaded items.

[0135] In one embodiment of the present invention, the query module 902 is specifically configured to send a price query request to the database through the logistics platform, and obtain the price of the item in the database based on the item identifier in the price query request;

[0136] The warehouse management system sends the warehouse quantity of the items to the database;

[0137] A request for querying the quantity of goods in storage is sent to the database through the logistics platform, and the quantity of goods in storage of the item is obtained in the database based on the item identifier of the request for querying the quantity of goods in storage.

[0138] In one embodiment of the present invention, the determination module 903 is specifically configured for the logistics platform to obtain the deductible coefficient of the item from the item deductible instruction in response to the item deductible instruction;

[0139] In the logistics platform, the deductible quantity of the items is calculated according to the warehousing quantity of the items and the deductible coefficient of the items.

[0140] In one embodiment of the present invention, the processing module 904 is specifically used to push the grade item quantity of the item, the price of the item and the deductible quantity of the item to the claim system through the logistics platform;

[0141] In the claims system, creating a list of the processing warehouse data based on the grade item quantity of the item, the price of the item and the deductible quantity of the item;

[0142] Based on the identification of the item, a list of the processing warehouse data is sent.

[0143] In one embodiment of the present invention, the processing module 904 is specifically used to determine the cumulative number of low-level items according to the number of graded items of the items in the claim settlement system;

[0144] The accumulated number of low-grade items is less than or equal to the deductible number of the items, and a list of the processing warehouse data is created according to the deductible amount of the items, and the deductible amount of the items is determined based on the price of the items.

[0145] In one embodiment of the present invention, the processing module 904 is specifically used to determine the cumulative number of low-level items according to the number of graded items of the items in the claim settlement system;

[0146] The cumulative number of low-grade items is greater than the deductible number of the items, and the claim amount is determined according to the deductible number of the items and the cumulative number of low-grade items;

[0147] Based on the price of the item and the claim quantity, a list of the processing warehouse data is created.

[0148] Fig.10 An exemplary system architecture 1000 is shown to which the method for processing warehouse data or the apparatus for processing warehouse data according to the embodiments of the present invention can be applied.

[0149] like Fig.10 As shown, the system architecture 1000 may include terminal devices 1001, 1002, 1003, a network 1004, and a server 1005. The network 1004 is used to provide a medium for communication links between the terminal devices 1001, 1002, 1003 and the server 1005. The network 1004 may include various connection types, such as wired, wireless communication links, or optical fiber cables, etc.

[0150] Users can use terminal devices 1001, 1002, 1003 to interact with server 1005 through network 1004 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 1001, 1002, 1003, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, social platform software, etc. (only as examples).

[0151] The terminal devices 1001 , 1002 , and 1003 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, and desktop computers, etc.

[0152] The server 1005 may be a server that provides various services, such as a backend management server (only an example) that provides support for shopping websites browsed by users using the terminal devices 1001, 1002, and 1003. The backend management server may analyze and process the received data such as product information query requests, and feed back the processing results (such as target push information, product information - only an example) to the terminal device.

[0153] It should be noted that the method for processing warehouse data provided in the embodiment of the present invention is generally executed by the server 1005 , and accordingly, the device for processing warehouse data is generally set in the server 1005 .

[0154] It should be understood that Fig.10 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.

[0155] Reference below Fig.11 , which shows a schematic diagram of the structure of a computer system 1100 of a terminal device suitable for implementing an embodiment of the present invention. Fig.11The terminal device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0156] like Fig.11 As shown, the computer system 1100 includes a central processing unit (CPU) 1101, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1102 or a program loaded from a storage part 1108 into a random access memory (RAM) 1103. In the RAM 1103, various programs and data required for the operation of the system 1100 are also stored. The CPU 1101, the ROM 1102, and the RAM 1103 are connected to each other via a bus 1104. An input / output (I / O) interface 1105 is also connected to the bus 1104.

[0157] The following components are connected to the I / O interface 1105: an input section 1106 including a keyboard, a mouse, etc.; an output section 1107 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 1108 including a hard disk, etc.; and a communication section 1109 including a network interface card such as a LAN card, a modem, etc. The communication section 1109 performs communication processing via a network such as the Internet. A drive 1110 is also connected to the I / O interface 1105 as needed. A removable medium 1111, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 1110 as needed, so that a computer program read therefrom is installed into the storage section 1108 as needed.

[0158] In particular, according to the embodiments disclosed in the present invention, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present invention include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 1109, and / or installed from the removable medium 1111. When the computer program is executed by the central processing unit (CPU) 1101, the above-mentioned functions defined in the system of the present invention are executed.

[0159] It should be noted that the computer-readable medium shown in the present invention may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present invention, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present invention, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, optical cable, RF, etc., or any suitable combination of the above.

[0160] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present invention. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0161] The modules involved in the embodiments of the present invention may be implemented by software or hardware. The modules described may also be set in a processor, for example, it may be described as: a processor includes an update module, a query module, a determination module and a processing module. The names of these modules do not constitute a limitation on the modules themselves in some cases, for example, the update module may also be described as "used to update the level and quantity of items stored in the warehouse in the logistics platform based on the data processing cycle".

[0162] As another aspect, the present invention further provides a computer-readable medium, which may be included in the device described in the above embodiment; or may exist independently without being assembled into the device. The above computer-readable medium carries one or more programs, and when the above one or more programs are executed by a device, the device includes:

[0163] Based on the data processing cycle, the level item quantity of the items stored in the warehouse is updated in the logistics platform;

[0164] Querying and obtaining the price of the item in a database, and obtaining the inventory quantity of the item from a warehouse management system through the database;

[0165] In the logistics platform, the deductible quantity of the item is determined according to the warehousing quantity of the item and the deductible coefficient of the item;

[0166] Through the logistics platform, the grade and quantity of the items, the price of the items and the deductible quantity of the items are sent to the claims system to create a list of processing warehouse data to realize claims for the items.

[0167] According to the technical solution of the embodiment of the present invention, based on the data processing cycle, the number of graded items stored in the warehouse is updated in the logistics platform; the price of the item is queried and obtained in the database, and the number of items in storage is obtained from the warehouse management system through the database; in the logistics platform, the number of deductible items of the item is determined according to the number of items in storage and the deductible coefficient of the item; through the logistics platform, the number of graded items of the item, the price of the item and the deductible number of the item are sent to the claim system to create a list of warehouse data for processing to realize the claim for the item. The logistics platform, the warehouse management system, the database and the claim platform create a list of warehouse data for processing through interactive information to realize the claim for the item. The above process does not require human participation and can be automatically executed based on the data processing cycle. Therefore, the efficiency of processing warehouse data can be improved to ensure the normal operation of the warehouse.

[0168] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may occur depending on design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for processing warehouse data, characterized in that: include: Based on the data processing cycle, updating the number of graded items of items stored in the warehouse in the logistics platform includes: determining and uploading the number of graded items of the items to the logistics platform according to the damaged state of the items and / or the lost state of the items; based on the data processing cycle, updating the number of graded items of the items stored in the warehouse in the logistics platform according to the uploaded number of graded items of the items; Querying and obtaining the price of the item in a database, and obtaining the inventory quantity of the item from a warehouse management system through the database; In the logistics platform, the deductible quantity of the item is determined according to the warehousing quantity of the item and the deductible coefficient of the item; Through the logistics platform, the grade item quantity, price of the item and deductible quantity of the item are sent to the claim system to create a list of processing warehouse data to realize claims for the item, including: in the claims system, according to the grade item quantity of the item, the cumulative number of low-grade items is determined; if the cumulative number of low-grade items is less than or equal to the deductible quantity of the item, the list of processing warehouse data is created according to the deductible amount of the item, and the deductible amount of the item is determined based on the price of the item.

2. The method for processing warehouse data according to claim 1, characterized in that: The querying and obtaining the price of the item in the database, and obtaining the storage quantity of the item from the warehouse management system through the database, include: Sending a price inquiry request to the database through the logistics platform, and obtaining the price of the item in the database based on the item identifier in the price inquiry request; The warehouse management system sends the warehouse quantity of the items to the database; A request for querying the quantity of goods in storage is sent to the database through the logistics platform, and the quantity of goods in storage is obtained in the database based on the item identifier of the request for querying the quantity of goods in storage.

3. The method for processing warehouse data according to claim 1, characterized in that: In the logistics platform, the deductible quantity of the item is determined according to the warehousing quantity of the item and the deductible coefficient of the item, including: The logistics platform obtains the deductible coefficient of the item from the item deductible instruction in response to the item deductible instruction; In the logistics platform, the deductible quantity of the items is calculated according to the warehousing quantity of the items and the deductible coefficient of the items.

4. The method for processing warehouse data according to claim 1, characterized in that: The logistics platform sends the grade and quantity of the item, the price of the item and the deductible quantity of the item to the claim system to create a list of processing warehouse data to realize the claim for the item, including: Pushing the grade and quantity of the item, the price of the item and the deductible quantity of the item to the claim system through the logistics platform; In the claims system, creating a list of the processing warehouse data based on the grade item quantity of the item, the price of the item and the deductible quantity of the item; Based on the identification of the item, a list of the processing warehouse data is sent.

5. The method for processing warehouse data according to claim 4, characterized in that: In the claim settlement system, creating a list of the processing warehouse data based on the grade item quantity of the item, the price of the item and the deductible quantity of the item includes: In the claim settlement system, according to the number of graded items of the item, the accumulated number of low-grade items is determined; The cumulative number of low-grade items is greater than the deductible number of the items, and the claim amount is determined according to the deductible number of the items and the cumulative number of low-grade items; Based on the price of the item and the claim quantity, a list of the processing warehouse data is created.

6. A device for processing warehouse data, characterized in that: include: An update module, for updating the level item quantity of items stored in the warehouse in the logistics platform based on a data processing cycle; A query module, used to query and obtain the price of the item in the database, and obtain the inventory quantity of the item from the warehouse management system through the database; A determination module, used to determine the deductible quantity of the item in the logistics platform according to the warehousing quantity of the item and the deductible coefficient of the item; A processing module, used to send the grade and quantity of the item, the price of the item and the deductible quantity of the item to the claim settlement system through the logistics platform, so as to create a list of processing warehouse data to realize the claim settlement for the item; The processing module is further used to: in the claim settlement system, determine the cumulative number of low-grade items according to the number of graded items of the item; if the cumulative number of low-grade items is less than or equal to the deductible number of the item, create a list of the processing warehouse data according to the deductible amount of the item, and the deductible amount of the item is determined based on the price of the item; The update module is also used to: determine and upload the level item quantity of the item to the logistics platform according to the damage status of the item and / or the loss status of the item; based on the data processing cycle, update the level item quantity of the item stored in the warehouse in the logistics platform according to the uploaded level item quantity of the item.

7. An electronic device for processing warehouse data, characterized in that: include: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 5.

8. A computer readable medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 5 is implemented.

Images