CN114595968A - Processing method of multi-stage dealer circulation data - Google Patents
Processing method of multi-stage dealer circulation data Download PDFInfo
- Publication number
- CN114595968A CN114595968A CN202210227537.6A CN202210227537A CN114595968A CN 114595968 A CN114595968 A CN 114595968A CN 202210227537 A CN202210227537 A CN 202210227537A CN 114595968 A CN114595968 A CN 114595968A
- Authority
- CN
- China
- Prior art keywords
- dealer
- warehouse
- information
- field
- name
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
Abstract
The embodiment of the invention relates to a method for processing multi-stage dealer circulation data, which comprises the following steps: constructing a dealer list; receiving the dispatching application information; inquiring the dealer list to obtain the name of the current superior dealer; when the name of the current superior dealer is matched with the name of the second dealer, allocating commodities to form a first batch of commodities; distributing commodity batch number information; shipping the first plurality of items from the second dealer store to the first dealer store; adding ex-warehouse information statistical records to the ex-warehouse information statistical table of the dealer; receiving the information of the goods entering a warehouse; newly adding warehousing information statistical records to a dealer warehousing information statistical table; checking the statistical records of the warehouse-out information and warehouse-in information with the same batch number to generate a first checking result; and if the first detection result is that the quantity is insufficient, performing replenishment processing on insufficient commodities, and performing punishment processing on the goods fleeing party for the dealer. By the method and the system, replenishment can be timely initiated when the delivery quantity is insufficient, and cross-class dealer channel conflict can be effectively prevented.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method for processing circulation data of a multi-stage dealer.
Background
Conventional dealer management systems only maintain dealer order and shipping information. Under the condition that the network structure of the distributor is flat, the processing mode can operate normally, but under the condition that the network of the distributor has more levels (such as a tobacco distributor network), the processing mode is difficult to meet specific requirements, such as timely initiating replenishment when the delivery quantity is insufficient, and effectively preventing cross-level distributor from channel conflict.
Disclosure of Invention
The invention aims to provide a processing method of multi-stage distributor circulation data, electronic equipment and a computer readable storage medium, which aim to overcome the defects of the prior art, and comprises the steps of building a distributor list according to a multi-stage distributor network structure, judging whether the application meets the grade requirement of the multi-stage distributor network based on the distributor list when the dispatching application information sent by the distributor is obtained, dispatching and delivering goods based on the dispatching application information under the condition that the condition is met, counting the ex-warehouse and in-warehouse information statistical records of the distributor, carrying out upper and lower circulation information inspection based on the ex-warehouse and in-warehouse information statistical records of the same batch, immediately initiating replenishment if the inspection result is insufficient in quantity, and immediately executing corresponding channel conflict punishment measures if the inspection result is channel conflict of the distributor. By the method and the system, replenishment can be timely initiated when the delivery quantity is insufficient, and cross-class dealer channel conflict can be effectively prevented.
In order to achieve the above object, a first aspect of the embodiments of the present invention provides a method for processing data of a multi-stage dealer flow, where the method includes:
constructing a dealer list;
receiving the dispatching application information sent by a first dealer; the shipment application information comprises a first dealer name, a second dealer name, a shipment commodity quantity, a first dealer warehouse location and a second dealer warehouse location;
inquiring the dealer list, and acquiring a superior dealer name matched with the first dealer name and recording the superior dealer name as a current superior dealer name; when the current upper-level dealer name is matched with the second dealer name, allocating commodities to form a first batch of commodities in a second dealer warehouse corresponding to the second dealer warehouse position according to the shunting commodity name and the shunting commodity quantity from the inventory of the second dealer corresponding to the second dealer name; distributing corresponding commodity batch number information to the first batch of commodities; the first batch of commodities carrying the commodity batch number information are delivered from the second dealer warehouse to a first dealer warehouse corresponding to the first dealer warehouse position; generating corresponding ex-warehouse information statistical records according to the ex-warehouse circulation information of the first batch of commodities, and adding the corresponding ex-warehouse information statistical records to a preset dealer ex-warehouse information statistical table;
receiving the information of warehousing of the goods sent by the first dealer; generating a corresponding warehousing information statistical record according to the arrival warehousing information, and adding the warehousing information statistical record to a preset dealer warehousing information statistical table;
carrying out the same-batch up-and-down circulation information inspection on the outbound information statistical records and the inbound information statistical records with the same batch number to generate corresponding first inspection results;
when the first inspection result is that the quantity is insufficient, corresponding insufficient commodity reissue processing is carried out;
and when the first inspection result is the dealer channel conflict, carrying out corresponding channel conflict punishment processing.
Preferably, the dealer list includes a plurality of dealer records; the dealer record comprises a dealer name field, a dealer grade field and a first superior dealer name field;
the dealer ex-warehouse information statistical table comprises a plurality of ex-warehouse information statistical records; the ex-warehouse information statistical record comprises a first batch number field, an ex-warehouse dealer name field, an ex-warehouse commodity name field, a lower-level dealer name field, an ex-warehouse time field, an ex-warehouse commodity total amount field and a first delivery-receiving warehouse location field; the first ship-to-ship store location field includes a first ship store location and a first ship store location;
the information of the arrived warehouse comprises the information of the batch number of the arrived commodities, the name information of the receiving dealer, the name information of the delivery dealer, the name information of the arrived commodities, the information of the arrived time, the quantity information of the arrived commodities, the position information of the warehouse of the receiving dealer and the position information of the warehouse of the delivery dealer;
the dealer warehousing information statistical table comprises a plurality of warehousing information statistical records; the warehousing information statistical record comprises a second batch number field, a warehousing dealer name field, a warehousing commodity name field, a second superior dealer name field, a warehousing time field, a warehousing commodity total amount field and a second delivery-receiving warehouse location field; the second ship to ship store location field includes a second ship store location and a second ship to store location.
Preferably, the constructing the dealer list specifically includes:
configuring dealer network information according to the dealer network architecture; the dealer network information includes a plurality of dealer information; the dealer information comprises name information, grade information and superior dealer name information;
polling each dealer information; during polling, recording the currently polled dealer information as current dealer information; and extracting the name information as a corresponding dealer name field, extracting the grade information as a corresponding dealer grade field, extracting the superior dealer name information as a corresponding first superior dealer name field, and forming a corresponding dealer record by the currently obtained dealer name field, the dealer grade field and the first superior dealer name field to be added to the dealer list.
Preferably, the generating of the corresponding ex-warehouse information statistical record according to the ex-warehouse circulation information of the first batch of goods adds the statistical record to a preset dealer ex-warehouse information statistical table, and specifically includes:
taking the commodity batch number information corresponding to the first batch of commodities as the corresponding first batch number field; taking the second dealer name corresponding to the first batch of commodities as the corresponding ex-warehouse dealer name field; and the name of the transfer commodity corresponding to the first batch of commodities is the corresponding ex-warehouse commodity name field; taking the first dealer name corresponding to the first batch of commodities as the corresponding lower-level dealer name field; taking the delivery time corresponding to the first batch of commodities as the corresponding ex-warehouse time field; taking the quantity of the goods-dispatching commodities corresponding to the first batch of commodities as a corresponding total quantity field of the ex-warehouse commodities; taking the first dealer warehouse position corresponding to the first batch of commodities as the corresponding first receiving warehouse position, taking the second dealer warehouse position corresponding to the first batch of commodities as the corresponding first sending warehouse position, and forming a corresponding first sending-receiving warehouse position field by the corresponding first sending warehouse position and the first receiving warehouse position; the obtained first batch number field, the ex-warehouse dealer name field, the ex-warehouse commodity name field, the subordinate dealer name field, the ex-warehouse time field, the ex-warehouse commodity total amount field and the first delivery-receiving warehouse location field form a corresponding ex-warehouse information statistical record; and adding the obtained ex-warehouse information statistical record into the dealer ex-warehouse information statistical table.
Preferably, the generating of the corresponding warehousing information statistical record according to the arrival warehousing information is added to a preset dealer warehousing information statistical table, and specifically includes:
taking the batch number information of the goods arriving in the warehouse information as the corresponding second batch number field; taking the name information of the goods receiving dealer of the goods arriving warehousing information as the corresponding warehousing dealer name field; the name information of the delivery dealer of the information of the delivery warehouse-in is used as a name field of the corresponding second superior dealer; the name information of the goods arriving in the warehouse is used as the corresponding name field of the warehouse goods; taking the arrival time information of the arrival warehousing information as the corresponding warehousing time field; taking the quantity information of the goods arriving in the warehouse as the corresponding total quantity field of the warehouse goods; taking the receiving dealer warehouse position information of the arriving warehouse-in information as a corresponding second receiving warehouse position, taking the delivery dealer warehouse position information of the arriving warehouse-in information as a corresponding second delivery warehouse position, and forming a corresponding second delivery-receiving warehouse position field by the corresponding second delivery warehouse position and the second receiving warehouse position; and the corresponding warehousing information statistical record is composed of the obtained second batch number field, the warehousing dealer name field, the warehousing commodity name field, the second superior dealer name field, the warehousing time field, the warehousing commodity total amount field and the second delivery-receiving warehouse location field; and adding the obtained warehousing information statistical record to the dealer warehousing information statistical table.
Preferably, the performing the same-batch up-and-down circulation information test on the outbound information statistical records and the inbound information statistical records with the same batch number to generate a corresponding first test result specifically includes:
recording the ex-warehouse information statistical records and the in-warehouse information statistical records with the same batch number as corresponding first ex-warehouse records and first in-warehouse records respectively; the first batch number field of the first ex-warehouse record is the same as the second batch number field of the first in-warehouse record;
identifying whether the ex-warehouse dealer name field of the first ex-warehouse record is the same as the second superior dealer name field of the first in-warehouse record; if the identification is different, setting the first flag bit as 1;
identifying whether the subordinate dealer name field of the first ex-warehouse record is the same as the in-warehouse dealer name field of the first in-warehouse record; if the identification is different, setting the second flag bit as 1;
identifying whether the ex-warehouse commodity name field of the first ex-warehouse record is the same as the in-warehouse commodity name field of the first in-warehouse record; if the identification is different, setting a third flag bit as 1;
identifying whether the total quantity field of the goods out of the first out-of-warehouse record is smaller than the total quantity field of the goods in warehouse of the first in-warehouse record; if the identification result is less than the first threshold value, setting the fourth flag bit to be 1;
identifying whether the first delivery warehouse location of the first delivery record is the same as the second delivery warehouse location of the first warehousing record; if the identification is different, setting the fifth flag bit as 1;
identifying whether the first receiving warehouse position of the first delivery record is the same as the second receiving warehouse position of the first delivery record; if the identification is different, setting the sixth flag bit as 1;
if the first, second, third, fourth, fifth or sixth flag bit is 1, setting the first inspection result as a dealer channel conflict; if the first, second, third, fourth, fifth and sixth flag bits are not 1, identifying whether the total quantity field of the ex-warehouse commodities of the first ex-warehouse record is larger than the total quantity field of the in-warehouse commodities of the first in-warehouse record, and if so, setting the first inspection result as insufficient quantity; and if the first, second, third, fourth, fifth and sixth flag bits are not 1, and the total quantity field of the ex-warehouse commodities of the first ex-warehouse record is equal to the total quantity field of the warehouse-in commodities of the first warehouse-in record, setting the first inspection result as passing the verification.
A second aspect of an embodiment of the present invention provides an electronic device, including: a memory, a processor, and a transceiver;
the processor is configured to be coupled to the memory, read and execute instructions in the memory, so as to implement the method steps of the first aspect;
the transceiver is coupled to the processor, and the processor controls the transceiver to transmit and receive messages.
A third aspect of embodiments of the present invention provides a computer-readable storage medium storing computer instructions that, when executed by a computer, cause the computer to perform the method of the first aspect.
The embodiment of the invention provides a processing method of circulation data of a multi-stage dealer, electronic equipment and a computer readable storage medium, wherein a dealer list is built according to a multi-stage dealer network structure, whether the request meets the level requirement of a multi-stage dealer network is judged on the basis of the dealer list when the dispatching request information sent by the dealer is obtained, dispatching and delivery are carried out on the basis of the dispatching request information under the condition that the condition is met, the statistical records of ex-warehouse and in-warehouse information of the dealer are counted, the statistical records of ex-warehouse and in-warehouse information of the same batch are checked, if the checking result is insufficient, replenishment is immediately initiated, and if the checking result is the dealer channeling, the corresponding channel conflict punishment measure is immediately executed. By the method and the system, replenishment can be timely initiated when the delivery quantity is insufficient, and cross-class dealer fleeing behavior is effectively prevented.
Drawings
Fig. 1 is a schematic diagram illustrating a processing method of multi-stage dealer flow data according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of an electronic device according to a second embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the present invention will be described in further detail with reference to the accompanying drawings, and it is apparent that the described embodiments are only a part of the embodiments of the present invention, not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Fig. 1 is a schematic view of a processing method for multi-level dealer flow data according to an embodiment of the present invention, as shown in fig. 1, the method mainly includes the following steps:
wherein the dealer list comprises a plurality of dealer records; the dealer record comprises a dealer name field, a dealer grade field and a first superior dealer name field;
the method specifically comprises the following steps: step 11, configuring dealer network information according to a dealer network architecture;
wherein the dealer network information includes a plurality of dealer information; the dealer information comprises name information, grade information and superior dealer name information;
step 12, polling the information of each dealer; during polling, recording current polled dealer information as current dealer information; and extracting name information as a corresponding dealer name field, extracting grade information as a corresponding dealer grade field, extracting upper-grade dealer name information as a corresponding first upper-grade dealer name field, and forming a corresponding dealer record by the currently obtained dealer name field, the dealer grade field and the first upper-grade dealer name field to add to the dealer list.
Here, each dealer record corresponds to an actual dealer in a dealer network; the name field of the dealer is the name of the dealer; the first grade in the dealer grade field is the highest grade, and the second grade, the third grade, the fourth grade and the like are sequentially arranged below the dealer grade field; because embodiments of the present invention do not allow for dealer cross-tier association, the first upper tier dealer name field should correspond to the dealer rank field of the dealer record for the dealer, which is the current dealer rank field-1 of the dealer record.
the dispatching application information comprises a first dealer name, a second dealer name, a dispatching commodity quantity, a first dealer warehouse position and a second dealer warehouse position.
Here, the first dealer is the dealer requiring the adjustment, and the embodiment of the present invention does not allow the peer dealer to perform the lateral distribution, so the name of the second dealer is also the superior dealer which the first dealer requests the adjustment.
the dealer ex-warehouse information statistical table comprises a plurality of ex-warehouse information statistical records; the ex-warehouse information statistical record comprises a first batch number field, an ex-warehouse dealer name field, an ex-warehouse commodity name field, a lower-level dealer name field, an ex-warehouse time field, an ex-warehouse commodity total amount field and a first delivery-receiving warehouse location field; the first ship-to-ship store location field includes a first ship store location and a first ship store location.
Here, the embodiment of the present invention defines that each dealer can only dispatch goods to the superior dealer defined in the dealer list, so the current superior dealer name and the second dealer name need to be compared, after the comparison is successful, the goods can be further distributed and sent according to the dispatch application information, and a shipment information statistical record is added to the dealer shipment information statistical table; it should be noted that, when the current upper-level dealer name does not match the second dealer name, the subsequent steps are stopped, and the shipment failure information is sent to the first dealer.
Further, the method for adding the warehouse-out information statistical record generated according to the warehouse-out circulation information of the first batch of commodities to the preset dealer warehouse-out information statistical table specifically comprises the following steps:
taking the commodity batch number information corresponding to the first batch of commodities as a corresponding first batch number field; taking the second dealer name corresponding to the first batch of commodities as a corresponding ex-warehouse dealer name field; the name of the goods to be adjusted corresponding to the first batch of goods is called as a corresponding ex-warehouse goods name field; taking the first dealer name corresponding to the first batch of commodities as a corresponding lower-level dealer name field; taking the delivery time corresponding to the first batch of commodities as a corresponding ex-warehouse time field; taking the quantity of the goods-transferring goods corresponding to the first batch of goods as a corresponding total quantity field of the goods out of the warehouse; taking the first dealer warehouse position corresponding to the first batch of commodities as a corresponding first receiving warehouse position, taking the second dealer warehouse position corresponding to the first batch of commodities as a corresponding first sending warehouse position, and forming a corresponding first sending-receiving warehouse position field by the corresponding first sending warehouse position and the first receiving warehouse position; and the obtained first lot number field, the ex-warehouse dealer name field, the ex-warehouse commodity name field, the subordinate dealer name field, the ex-warehouse time field, the ex-warehouse commodity total quantity field and the first delivery-receiving storehouse position field form a corresponding ex-warehouse information statistical record; and adding the obtained ex-warehouse information statistical record into the dealer ex-warehouse information statistical table.
Step 4, receiving the information of warehousing of the goods sent by the first dealer; generating corresponding warehousing information statistical records according to the warehousing information of the goods, and adding the corresponding warehousing information statistical records to a preset dealer warehousing information statistical table;
the information of the received goods warehouse comprises the information of the batch number of the received goods, the name information of a receiving dealer, the name information of a delivery dealer, the name information of the received goods, the arrival time information, the quantity information of the received goods, the position information of the warehouse of the receiving dealer and the position information of the warehouse of the delivery dealer;
the dealer warehousing information statistical table comprises a plurality of warehousing information statistical records; the warehousing information statistical record comprises a second batch number field, a warehousing dealer name field, a warehousing commodity name field, a second superior dealer name field, a warehousing time field, a warehousing commodity total amount field and a second delivery-receiving warehouse location field; the second ship-to-ship store location field includes a second ship store location and a second ship store location.
Further, generating a corresponding warehousing information statistical record according to the warehousing information of the arrived goods, and adding the warehousing information statistical record to a preset dealer warehousing information statistical table, wherein the warehousing information statistical record specifically comprises the following steps:
taking the batch number information of the goods arriving in the warehouse as a corresponding second batch number field; and the name information of the receiving dealer of the arrival warehousing information is used as a corresponding warehousing dealer name field; taking the name information of the delivery dealer of the information of the delivery warehouse-in as a corresponding name field of a second superior dealer; and the name information of the goods arriving in the warehouse is taken as the name field of the corresponding warehouse goods; taking the arrival time information of the arrival warehousing information as a corresponding warehousing time field; taking the quantity information of the goods arriving warehousing information as the corresponding warehousing goods total quantity field; taking the warehouse position information of the receiving dealer of the arriving warehousing information as a corresponding second receiving warehouse position, taking the warehouse position information of the delivery dealer of the arriving warehousing information as a corresponding second delivery warehouse position, and forming a corresponding second delivery-receiving warehouse position field by the corresponding second delivery warehouse position and the second receiving warehouse position; and the corresponding warehousing information statistical record is composed of the obtained second batch number field, the warehousing dealer name field, the warehousing commodity name field, the second superior dealer name field, the warehousing time field, the warehousing commodity total amount field and the second delivery-receiving warehouse location field; and adding the obtained warehousing information statistical record into a dealer warehousing information statistical table.
Step 5, carrying out the same-batch up-and-down circulation information inspection on the outbound information statistical records and the inbound information statistical records with the same batch number to generate corresponding first inspection results;
the method specifically comprises the following steps: step 51, recording the ex-warehouse information statistical records and the in-warehouse information statistical records with the same batch number as corresponding first ex-warehouse records and first in-warehouse records respectively;
the first batch number field of the first ex-warehouse record is the same as the second batch number field of the first in-warehouse record;
step 52, identifying whether the name field of the ex-warehouse dealer of the first ex-warehouse record is the same as the name field of the second superior dealer of the first in-warehouse record; if the identification is different, setting the first flag bit as 1;
if the ex-warehouse dealer name field is different from the second superior dealer name field, the fact that the warehousing party calls in the commodities of other sellers except the specified superior dealer is considered as the channel conflict, and the first flag is correspondingly set to be 1 so as to be convenient for the subsequent step to identify;
step 53, identifying whether the lower-level dealer name field of the first ex-warehouse record is the same as the in-warehouse dealer name field of the first in-warehouse record; if the identification is different, setting the second flag bit as 1;
if the name field of the subordinate dealer is different from that of the warehousing dealer, the warehousing party calls the commodities of other sellers except the specified superior dealer or the ex-warehouse party distributes the commodities to other sellers except the specified subordinate dealer, the situation is regarded as channel conflict, and the second flag bit is correspondingly set to be 1 so as to facilitate the identification of the subsequent steps;
step 54, identifying whether the ex-warehouse commodity name field of the first ex-warehouse record is the same as the warehousing commodity name field of the first warehousing record; if the identification is different, setting a third flag bit as 1;
if the ex-warehouse commodity name field is different from the in-warehouse commodity name field, the situation that the warehouse entry party calls the non-applied commodity is considered as a channel conflict, and the third flag bit is correspondingly set to be 1 so as to facilitate the identification of the subsequent steps;
step 55, identifying whether the total quantity field of the goods out of the first out-warehouse record is smaller than the total quantity field of the goods in warehouse of the first in-warehouse record; if the identification result is less than the first threshold value, setting the fourth flag bit to be 1;
here, if the total quantity field of the outgoing commodities is less than the total quantity field of the warehousing commodities, it is indicated that the warehousing party calls in the commodities of other vendors except the specified upper-level vendor, and this situation is regarded as a channel conflict, and correspondingly, the fourth flag bit is set to 1 for the subsequent step identification;
step 56, identifying whether the first delivery storehouse position of the first delivery record is the same as the second delivery storehouse position of the first warehousing record; if the identification is different, setting the fifth flag bit as 1;
if the first delivery warehouse position is different from the second delivery warehouse position, the delivery side does not carry out delivery according to the designated delivery address, the condition is regarded as channel conflict, and the fifth flag bit is correspondingly set to be 1 so as to be convenient for subsequent step identification;
step 57, identifying whether the first receiving warehouse position of the first delivery record is the same as the second receiving warehouse position of the first delivery record; if the identification is different, setting a sixth flag bit as 1;
if the first receiving warehouse position is different from the second receiving warehouse position, the warehousing party does not perform warehousing according to the specified delivery address, the situation is regarded as channel conflict, and the fifth flag bit is correspondingly set to be 1 for subsequent step identification;
step 58, if the first, second, third, fourth, fifth or sixth flag bit is 1, setting the first inspection result as the channel conflict of the dealer; if the first, second, third, fourth, fifth and sixth flag bits are not 1, identifying whether the total quantity field of the ex-warehouse commodities of the first ex-warehouse record is larger than the total quantity field of the in-warehouse commodities of the first in-warehouse record, and if so, setting a first inspection result as insufficient quantity; and if the first, second, third, fourth, fifth and sixth flag bits are not 1, and the total quantity field of the ex-warehouse commodities of the first ex-warehouse record is equal to the total quantity field of the in-warehouse commodities of the first in-warehouse record, setting the first inspection result as passing the verification.
Here, any one of 6 flag bits, i.e., the first, second, third, fourth, fifth, or sixth flag bit, is 1, which indicates that a dealer channel conflict occurs, and naturally, the first check result is set as a dealer channel conflict; the 6 flag bits of the first, second, third, fourth, fifth or sixth flag bit are all not 1, and the total quantity field of the outgoing commodities is greater than the total quantity field of the warehousing commodities, which indicates that the goods fleeing by the dealer does not occur, but the quantity of the commodities is insufficient in warehousing, and naturally, the first inspection result is set as the quantity shortage; and the 6 flag bits of the first, second, third, fourth, fifth or sixth flag bit are all not 1, and the total quantity field of the ex-warehouse commodities is the total quantity field of the warehouse-in commodities, which indicates that the goods fleeing of the dealer does not occur, and the number of the ex-warehouse and the warehouse-in are aligned without the need of replenishment, and at this time, the first inspection result is naturally set as the verification pass.
the method specifically comprises the following steps: recording the ex-warehouse information statistical records with the same batch number as a second ex-warehouse record, and recording the in-warehouse information statistical record as a second in-warehouse record; subtracting the warehousing commodity total field of the second warehousing record from the warehousing commodity total field of the second warehousing record to obtain a corresponding first replenishment quantity; applying a new batch product number for the replenishment; in the warehouse corresponding to the position of the first delivery warehouse of the second delivery record, a plurality of commodities of which the quantity is matched with the first replenishment quantity and of which the commodity name is matched with the delivery commodity name field of the second delivery record are selected to form a first batch of replenishment commodities from the stock under the distributor name corresponding to the delivery distributor name field of the second delivery record; sending the first batch of replenishment commodities to a dealer warehouse corresponding to the subordinate dealer name field of the second delivery record, wherein the warehouse is matched with the first receiving warehouse position field of the second delivery record; and then, newly adding a ex-warehouse information statistical record to the ex-warehouse information statistical table of the dealer according to the circulation information of the first replenishment commodities.
And 7, performing corresponding channel conflict punishment processing when the first inspection result is channel conflict of the distributor.
The method specifically comprises the following steps: when the first inspection result is the channel conflict of the dealer, the first channel conflict is marked as a channel conflict dealer and is included in a channel conflict dealer blacklist; and recalling the first batch of merchandise that has been distributed to the first merchant; and will cease to supply to the first merchant. It should be noted that once the dealer is blacklisted, it will not respond to any tuning application information initiated by the dealer, and will also advertise in the dealer network by way of blacklist.
Fig. 2 is a schematic structural diagram of an electronic device according to a second embodiment of the present invention. The electronic device may be a terminal device or a server for implementing the method of the embodiment of the present invention, or may be a terminal device or a server connected to the terminal device or the server for implementing the method of the embodiment of the present invention. As shown in fig. 2, the electronic device may include: a processor 301 (e.g., a CPU), a memory 302, a transceiver 303; the transceiver 303 is coupled to the processor 301, and the processor 301 controls the transceiving operation of the transceiver 303. Various instructions may be stored in memory 302 for performing various processing functions and implementing the processing steps described in the foregoing method embodiments. Preferably, the electronic device according to an embodiment of the present invention further includes: a power supply 304, a system bus 305, and a communication port 306. The system bus 305 is used to implement communication connections between the elements. The communication port 306 is used for connection communication between the electronic device and other peripherals.
The system bus 305 mentioned in fig. 2 may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The system bus may be divided into an address bus, a data bus, a control bus, and the like. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus. The communication interface is used for realizing communication between the database access device and other equipment (such as a client, a read-write library and a read-only library). The Memory may include a Random Access Memory (RAM) and may also include a Non-Volatile Memory (Non-Volatile Memory), such as at least one disk Memory.
The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), a Graphics Processing Unit (GPU), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components.
It should be noted that the embodiment of the present invention also provides a computer-readable storage medium, which stores instructions that, when executed on a computer, cause the computer to execute the method and the processing procedure provided in the above-mentioned embodiment.
The embodiment of the present invention further provides a chip for executing the instructions, where the chip is configured to execute the processing steps described in the foregoing method embodiment.
The embodiment of the invention provides a processing method of circulation data of a multi-stage dealer, electronic equipment and a computer readable storage medium, wherein a dealer list is built according to a multi-stage dealer network structure, whether the request meets the level requirement of a multi-stage dealer network is judged on the basis of the dealer list when the dispatching request information sent by the dealer is obtained, dispatching and delivery are carried out on the basis of the dispatching request information under the condition that the condition is met, the statistical records of ex-warehouse and in-warehouse information of the dealer are counted, the statistical records of ex-warehouse and in-warehouse information of the same batch are checked, if the checking result is insufficient, replenishment is immediately initiated, and if the checking result is the dealer channeling, the corresponding channel conflict punishment measure is immediately executed. By the method and the system, replenishment can be timely initiated when the delivery quantity is insufficient, and cross-class dealer fleeing behavior is effectively prevented.
Those of skill would further appreciate that the various illustrative components and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied in hardware, a software module executed by a processor, or a combination of the two. A software module may reside in Random Access Memory (RAM), memory, Read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are merely exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (8)
1. A method for processing data of a multi-stage dealer flow, the method comprising:
constructing a dealer list;
receiving the dispatching application information sent by the first dealer; the dispatching application information comprises a first dealer name, a second dealer name, a dispatching commodity quantity, a first dealer warehouse position and a second dealer warehouse position;
inquiring the dealer list, and acquiring a superior dealer name matched with the first dealer name and recording the superior dealer name as a current superior dealer name; when the current upper-level dealer name is matched with the second dealer name, allocating commodities to form a first batch of commodities in a second dealer warehouse corresponding to the second dealer warehouse position according to the shunting commodity name and the shunting commodity quantity from the inventory of the second dealer corresponding to the second dealer name; distributing corresponding commodity batch number information to the first batch of commodities; the first batch of commodities carrying the commodity batch number information are delivered from the second dealer warehouse to a first dealer warehouse corresponding to the first dealer warehouse position; generating corresponding ex-warehouse information statistical records according to the ex-warehouse circulation information of the first batch of commodities, and adding the corresponding ex-warehouse information statistical records to a preset dealer ex-warehouse information statistical table;
receiving the information of warehousing of the goods sent by the first dealer; generating a corresponding warehousing information statistical record according to the arrival warehousing information, and adding the warehousing information statistical record to a preset dealer warehousing information statistical table;
carrying out the same-batch up-and-down circulation information inspection on the outbound information statistical records and the inbound information statistical records with the same batch number to generate corresponding first inspection results;
when the first inspection result is that the quantity is insufficient, corresponding insufficient commodity reissue processing is carried out;
and when the first inspection result is the dealer channel conflict, carrying out corresponding channel conflict punishment processing.
2. The method of processing multi-level dealer flow data of claim 1,
the dealer list includes a plurality of dealer records; the dealer record comprises a dealer name field, a dealer grade field and a first superior dealer name field;
the dealer ex-warehouse information statistical table comprises a plurality of ex-warehouse information statistical records; the ex-warehouse information statistical record comprises a first batch number field, an ex-warehouse dealer name field, an ex-warehouse commodity name field, a lower-level dealer name field, an ex-warehouse time field, an ex-warehouse commodity total amount field and a first delivery-receiving warehouse location field; the first ship-to-ship store location field includes a first ship store location and a first ship store location;
the goods-receiving warehousing information comprises the goods-receiving batch number information, the goods-receiving distributor name information, the delivery distributor name information, the goods-receiving time information, the goods-receiving quantity information, the goods-receiving distributor warehouse position information and the delivery distributor warehouse position information;
the dealer warehousing information statistical table comprises a plurality of warehousing information statistical records; the warehousing information statistical record comprises a second batch number field, a warehousing dealer name field, a warehousing commodity name field, a second superior dealer name field, a warehousing time field, a warehousing commodity total amount field and a second delivery-receiving warehouse location field; the second ship-to-ship store location field includes a second ship store location and a second ship store location.
3. The method for processing the multi-stage dealer flow data according to claim 2, wherein the building of the dealer list specifically includes:
configuring dealer network information according to the dealer network architecture; the dealer network information includes a plurality of dealer information; the dealer information comprises name information, grade information and superior dealer name information;
polling each dealer information; during polling, recording the currently polled dealer information as current dealer information; and extracting the name information as a corresponding dealer name field, extracting the grade information as a corresponding dealer grade field, extracting the superior dealer name information as a corresponding first superior dealer name field, and forming a corresponding dealer record by the currently obtained dealer name field, the dealer grade field and the first superior dealer name field to be added to the dealer list.
4. The method for processing the multi-level dealer circulation data according to claim 2, wherein the step of generating the corresponding ex-warehouse information statistical record according to the ex-warehouse circulation information of the first batch of goods is added to a preset dealer ex-warehouse information statistical table, and specifically comprises the steps of:
taking the commodity batch number information corresponding to the first batch of commodities as the corresponding first batch number field; taking the second dealer name corresponding to the first batch of commodities as the corresponding ex-warehouse dealer name field; and the name of the modulation commodity corresponding to the first batch of commodities is called as the corresponding ex-warehouse commodity name field; taking the first dealer name corresponding to the first batch of commodities as the corresponding lower-level dealer name field; taking the delivery time corresponding to the first batch of commodities as the corresponding ex-warehouse time field; taking the quantity of the dispatching commodities corresponding to the first batch of commodities as the corresponding total quantity field of the ex-warehouse commodities; taking the first dealer warehouse position corresponding to the first batch of commodities as the corresponding first receiving warehouse position, taking the second dealer warehouse position corresponding to the first batch of commodities as the corresponding first sending warehouse position, and forming a corresponding first sending-receiving warehouse position field by the corresponding first sending warehouse position and the first receiving warehouse position; the obtained first batch number field, the ex-warehouse dealer name field, the ex-warehouse commodity name field, the subordinate dealer name field, the ex-warehouse time field, the ex-warehouse commodity total amount field and the first delivery-receiving warehouse location field form a corresponding ex-warehouse information statistical record; and adding the obtained ex-warehouse information statistical record into the dealer ex-warehouse information statistical table.
5. The method for processing the multi-level dealer circulation data according to claim 2, wherein the step of generating the corresponding warehousing information statistical record according to the arrival warehousing information and adding the warehousing information statistical record to a preset dealer warehousing information statistical table specifically comprises the steps of:
taking the batch number information of the goods arriving in the warehouse information as the corresponding second batch number field; taking the name information of the goods receiving dealer of the goods arriving warehousing information as the corresponding warehousing dealer name field; the name information of the delivery dealer of the information of the delivery warehouse-in is used as a name field of the corresponding second superior dealer; the name information of the goods arriving in the warehouse is used as the corresponding name field of the warehouse goods; taking the arrival time information of the arrival warehousing information as the corresponding warehousing time field; taking the quantity information of the goods arriving in the warehouse as the corresponding total quantity field of the warehouse goods; taking the receiving dealer warehouse position information of the arriving warehouse-in information as a corresponding second receiving warehouse position, taking the delivery dealer warehouse position information of the arriving warehouse-in information as a corresponding second delivery warehouse position, and forming a corresponding second delivery-receiving warehouse position field by the corresponding second delivery warehouse position and the second receiving warehouse position; and the corresponding warehousing information statistical record is composed of the obtained second batch number field, the warehousing dealer name field, the warehousing commodity name field, the second superior dealer name field, the warehousing time field, the warehousing commodity total amount field and the second delivery-receiving warehouse location field; and adding the obtained warehousing information statistical record to the dealer warehousing information statistical table.
6. The method for processing the multi-level dealer circulation data according to claim 2, wherein the performing the same-batch up-down circulation information test on the outbound information statistical record and the inbound information statistical record with the same batch number to generate a corresponding first test result specifically comprises:
recording the ex-warehouse information statistical records and the in-warehouse information statistical records with the same batch number as corresponding first ex-warehouse records and first in-warehouse records respectively; the first batch number field of the first ex-warehouse record is the same as the second batch number field of the first in-warehouse record;
identifying whether the ex-warehouse dealer name field of the first ex-warehouse record is the same as the second superior dealer name field of the first in-warehouse record; if the identification is different, setting the first flag bit as 1;
identifying whether the subordinate dealer name field of the first ex-warehouse record is the same as the in-warehouse dealer name field of the first in-warehouse record; if the identification is different, setting the second flag bit as 1;
identifying whether the ex-warehouse commodity name field of the first ex-warehouse record is the same as the in-warehouse commodity name field of the first in-warehouse record; if the identification is different, setting a third flag bit as 1;
identifying whether the total quantity field of the goods out of the first out-of-warehouse record is smaller than the total quantity field of the goods in warehouse of the first in-warehouse record; if the identification result is less than the first threshold value, setting the fourth flag bit to be 1;
identifying whether the first delivery warehouse location of the first delivery record is the same as the second delivery warehouse location of the first warehousing record; if the identification is different, setting the fifth flag bit as 1;
identifying whether the first receiving warehouse position of the first delivery record is the same as the second receiving warehouse position of the first delivery record; if the identification is different, setting a sixth flag bit as 1;
if the first, second, third, fourth, fifth or sixth flag bit is 1, setting the first inspection result as a dealer channel conflict; if the first, second, third, fourth, fifth and sixth flag bits are not 1, identifying whether the total quantity field of the ex-warehouse commodities of the first ex-warehouse record is larger than the total quantity field of the in-warehouse commodities of the first in-warehouse record, and if so, setting the first inspection result as insufficient quantity; and if the first, second, third, fourth, fifth and sixth flag bits are not 1, and the total quantity field of the ex-warehouse commodities of the first ex-warehouse record is equal to the total quantity field of the warehouse-in commodities of the first warehouse-in record, setting the first inspection result as passing the verification.
7. An electronic device, comprising: a memory, a processor, and a transceiver;
the processor is used for being coupled with the memory, reading and executing the instructions in the memory to realize the method steps of any one of claims 1-6;
the transceiver is coupled to the processor, and the processor controls the transceiver to transmit and receive messages.
8. A computer-readable storage medium having stored thereon computer instructions which, when executed by a computer, cause the computer to perform the method of any of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210227537.6A CN114595968B (en) | 2022-03-08 | 2022-03-08 | Processing method of multi-stage dealer circulation data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210227537.6A CN114595968B (en) | 2022-03-08 | 2022-03-08 | Processing method of multi-stage dealer circulation data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114595968A true CN114595968A (en) | 2022-06-07 |
| CN114595968B CN114595968B (en) | 2022-09-20 |
Family
ID=81809539
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210227537.6A Active CN114595968B (en) | 2022-03-08 | 2022-03-08 | Processing method of multi-stage dealer circulation data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114595968B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117009998A (en) * | 2023-08-29 | 2023-11-07 | 上海倍通医药科技咨询有限公司 | Data inspection method and system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106600292A (en) * | 2016-12-08 | 2017-04-26 | 上海尚源信息技术有限公司 | Commodity anti-bugsell management method |
| CN106846087A (en) * | 2016-12-20 | 2017-06-13 | 济南中维世纪科技有限公司 | Intelligent camera anti-channel conflict information |
| CN109165956A (en) * | 2018-08-10 | 2019-01-08 | 浙江艾希计算机科技有限公司 | Enterprise management system and data acquisition based on product big data utilize method |
| CN110751436A (en) * | 2019-09-30 | 2020-02-04 | 青岛富通万方物流有限公司 | Warehouse management system based on dynamic inventory management |
| CN111080196A (en) * | 2019-11-28 | 2020-04-28 | 江苏苏宁物流有限公司 | Method and system for processing warehouse arrival difference |
| CN111105257A (en) * | 2018-10-29 | 2020-05-05 | 北京国双科技有限公司 | Product data processing method and device |
| CN111260376A (en) * | 2020-01-07 | 2020-06-09 | 四川安创环保科技有限公司 | Titanium dioxide product anti-channel conflict method and system based on enterprise ERP system |
-
2022
- 2022-03-08 CN CN202210227537.6A patent/CN114595968B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106600292A (en) * | 2016-12-08 | 2017-04-26 | 上海尚源信息技术有限公司 | Commodity anti-bugsell management method |
| CN106846087A (en) * | 2016-12-20 | 2017-06-13 | 济南中维世纪科技有限公司 | Intelligent camera anti-channel conflict information |
| CN109165956A (en) * | 2018-08-10 | 2019-01-08 | 浙江艾希计算机科技有限公司 | Enterprise management system and data acquisition based on product big data utilize method |
| CN111105257A (en) * | 2018-10-29 | 2020-05-05 | 北京国双科技有限公司 | Product data processing method and device |
| CN110751436A (en) * | 2019-09-30 | 2020-02-04 | 青岛富通万方物流有限公司 | Warehouse management system based on dynamic inventory management |
| CN111080196A (en) * | 2019-11-28 | 2020-04-28 | 江苏苏宁物流有限公司 | Method and system for processing warehouse arrival difference |
| CN111260376A (en) * | 2020-01-07 | 2020-06-09 | 四川安创环保科技有限公司 | Titanium dioxide product anti-channel conflict method and system based on enterprise ERP system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117009998A (en) * | 2023-08-29 | 2023-11-07 | 上海倍通医药科技咨询有限公司 | Data inspection method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114595968B (en) | 2022-09-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109359759A (en) | Intelligence divides storehouse method, equipment and computer readable storage medium | |
| CN114595968B (en) | Processing method of multi-stage dealer circulation data | |
| CN107463593A (en) | Stock reduces method and its equipment | |
| CN112270541A (en) | Transaction wind control management method, device, equipment and system | |
| CN112668907A (en) | Logistics node management information processing method and device | |
| CN112070423A (en) | Stock pre-occupation method and device, electronic equipment and storage medium | |
| CN110084694B (en) | Order distribution method based on data processing and related equipment | |
| KR101842391B1 (en) | Method and system for device inventory management | |
| CN114268957A (en) | Abnormal business data processing method, device, server and storage medium | |
| CN111917659A (en) | Concurrent data transmission method, system, device and computer readable storage medium | |
| CN114418653B (en) | Anti-channel conflict processing method based on NFC (near field communication) label | |
| CN106548315A (en) | Display device, managing device and method and management system | |
| CN112793975B (en) | Goods warehousing method and device, electronic equipment and storage medium | |
| CN115102863A (en) | Method and device for dynamically configuring DPU (distributed processing Unit) hardware resource pool | |
| CN113298459A (en) | Order cross-border declaration method, system and device and computing equipment | |
| CN111260407B (en) | Logistics management system and order checking and price checking method | |
| CN113935683A (en) | Goods warehousing method and device | |
| CN115080250B (en) | Data processing method, device and system | |
| CN110969515A (en) | Order allocation method and device | |
| CN117408522B (en) | Tail payment risk early warning method, system and medium | |
| CN111445188A (en) | Goods inventory management method and device | |
| CN113888095B (en) | Inventory data processing method, system, electronic equipment and medium | |
| CN110177077A (en) | System of account processed offline method, apparatus, equipment and storage medium | |
| CN108492067A (en) | Information processing method and system | |
| CN112668963A (en) | Order generation method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |