CN110895782B

CN110895782B - Method and device for processing out-of-stock data, computer equipment and storage medium

Info

Publication number: CN110895782B
Application number: CN201911075867.2A
Authority: CN
Inventors: 杨启; 杨程成; 刘建洋; 殷晓莹; 黄瑾
Original assignee: Suning Cloud Computing Co Ltd
Current assignee: Suning Cloud Computing Co Ltd
Priority date: 2019-11-06
Filing date: 2019-11-06
Publication date: 2022-11-25
Anticipated expiration: 2039-11-06
Also published as: CN110895782A

Abstract

The application relates to a method for processing out-of-stock data. The method comprises the following steps: acquiring first out-of-stock state data; querying a preset goods information database, and acquiring goods detail data corresponding to each goods identification information in the first out-of-stock state data and a reference category to which each goods identification information corresponds to the goods; according to the goods shortage parameters of the goods corresponding to the goods identification information, generating a first goods shortage rate of the goods corresponding to the goods identification information and a second goods shortage rate of the standard category of the goods corresponding to the goods identification information; generating second goods shortage state data according to the goods detail data, the first goods shortage rate and the second goods shortage rate; and when a data display request of the terminal is received, displaying the second stock-out rate data on a user interface. According to the method and the device, the first out-of-stock state data are processed through the pre-constructed cargo information database, the second out-of-stock state data containing the out-of-stock rate are obtained, data processing of the out-of-stock data is achieved, and the processing efficiency of the out-of-stock data is improved.

Description

Method and device for processing out-of-stock data, computer equipment and storage medium

Technical Field

The present application relates to the field of computer application technologies, and in particular, to a method and an apparatus for processing out-of-stock data, a computer device, and a storage medium.

Background

Shopping is an indispensable part of daily life of people, and the shopping habits of residents in China are greatly changed along with the change of times. With the rapid development of online shopping, online shopping population is rapidly expanding from young people to middle-aged and old people. The development of internet technology and the rise of mobile terminals of mobile phones further promote online shopping. In the actual operation process, various shopping platforms often have the situation of out-of-stock, and especially some shopping platforms with larger quantity are easy to have the situation of out-of-stock of a certain area or a certain goods under the situation that the goods for sale are more in category and the number of the contained single goods is also more.

Among the present technical scheme, the condition to the goods short of stock can only be through artifical short of stock information to the goods source handling that summarizes, because the data volume is great, it is lower to handle data efficiency through Excel, and business personnel need handle short of stock data daily, and is extremely consuming time, and single needs 2 hours or even longer time to handle short of stock data daily, seriously influences the efficiency of the processing of short of stock data.

Disclosure of Invention

In view of the above, it is desirable to provide a method, an apparatus, a computer device, and a storage medium for processing out-of-stock data, which can automatically generate out-of-stock status data including an out-of-stock rate of a cargo, improve the processing efficiency of the out-of-stock data, and save labor.

A method of processing out-of-stock data, the method comprising:

acquiring first out-of-stock state data, wherein the first out-of-stock state data comprises cargo identification information of a plurality of cargos and first out-of-stock parameters of cargos corresponding to the cargo identification information;

inquiring a preset goods information database to obtain goods detail data corresponding to each goods identification information and a reference category of goods corresponding to each goods identification information;

generating a first goods shortage rate of goods corresponding to each goods identification information and a second goods shortage rate corresponding to each reference type according to each first goods shortage parameter;

generating second goods shortage state data according to goods detail data corresponding to the goods identification information, the first goods shortage rate and the second goods shortage rate;

and when a data display request of the terminal is received, displaying the second stock-out rate data on a user interface.

In one embodiment, after the acquiring the first stock out status data, the method further comprises:

creating a target task according to the first stock out state data and generating task identification information of the target task;

data segmentation is carried out on the first out-of-stock state data to obtain a plurality of data groups, each data group comprises a plurality of data records, and each data record comprises cargo identification information and a first out-of-stock parameter corresponding to each cargo identification information;

adding grouping identification information to each data group according to the task identification information and storing the grouping identification information;

the method for inquiring the preset goods information database to obtain the goods detail data corresponding to the goods identification information and the reference category of the goods corresponding to the goods identification information comprises the following steps:

acquiring a current data packet according to the packet identification information;

extracting goods identification information contained in each data record in the current data packet;

and querying the cargo information database according to the cargo identification information to obtain cargo detail data corresponding to each cargo identification information in the current data grouping and a reference category to which the cargo corresponding to each cargo identification information belongs.

In one embodiment, the first out-of-stock parameter includes a first invalid visitor number and a first total visitor number of the goods detail page in a specified time period, and the generating a first out-of-stock rate of the goods corresponding to each piece of goods identification information and a second out-of-stock rate corresponding to each reference category according to the out-of-stock parameter corresponding to each piece of goods identification information includes:

determining a first shortage rate of the goods corresponding to each goods identification information according to the first invalid number of visitors and the first total number of visitors corresponding to each goods identification information;

and determining a second shortage parameter corresponding to each reference type according to the first shortage parameter corresponding to each cargo identification information, and determining a second shortage rate of the reference type according to the second shortage parameter of the reference type.

In one embodiment, the determining, according to the first shortage parameter corresponding to each cargo identification information, the second shortage parameter corresponding to each reference category, and determining, according to the second shortage parameter of the reference category, the second shortage rate of the reference category includes:

acquiring all goods identification information under the current reference category, and acquiring a first invalid visitor number and a first total visitor number 12' corresponding to each piece of goods identification information;

determining a second invalid number of access persons corresponding to the current reference category in a specified time period according to the first invalid number of access persons corresponding to each piece of goods identification information;

determining a second total number of visitors corresponding to the current reference category in a specified time period according to the first total number of visitors corresponding to each piece of goods identification information;

and determining a second shortage rate corresponding to the current reference category according to a second invalid number of visitors and a second total number of visitors corresponding to the current reference category in a specified time period.

In one embodiment, the querying a preset goods information database to obtain goods detail data corresponding to each piece of goods identification information and a reference category to which the goods corresponding to each piece of goods identification information belong includes:

inquiring a first mapping relation between the cargo identification information and the cargo detail data in the cargo information database according to the cargo identification information to obtain cargo detail data corresponding to each cargo identification information;

inquiring a second mapping relation between the cargo identification information and the reference category in the cargo information database according to the cargo identification information to obtain the reference category to which the cargo corresponding to each cargo identification information belongs and the category information of each reference category;

the step of generating second out-of-stock state data according to the cargo detail data corresponding to the cargo identification information, the first out-of-stock rate and the second out-of-stock rate comprises the following steps:

and generating second stock shortage state data according to the cargo detail data corresponding to each cargo identification information, the first stock shortage rate, the category information of each reference category and the second stock shortage rate corresponding to each reference category.

In one embodiment, the displaying the second stock out rate data on a user interface when a data display request of a terminal is received includes:

and converting the second stock shortage state data into a stock shortage rate report according to a preset template, and displaying the stock shortage rate report on a user interface when a data display request of a terminal is received.

In one embodiment, the querying a preset cargo information database to obtain detailed cargo data corresponding to each piece of cargo identification information and a reference category to which the cargo corresponding to each piece of cargo identification information belongs includes:

when the goods detail data corresponding to the goods identification information does not exist in the goods information database, or when the reference category to which the goods corresponding to the goods identification information belongs does not exist in the goods information database, outputting prompt information.

An apparatus for processing out-of-stock data, the apparatus comprising:

the system comprises an acquisition module, a storage module and a display module, wherein the acquisition module is used for acquiring first out-of-stock state data, and the first out-of-stock state data comprises cargo identification information of a plurality of cargos and first out-of-stock parameters of cargos corresponding to the cargo identification information;

the query module is used for querying a preset cargo information database to obtain cargo detail data corresponding to each cargo identification information and a reference category of the cargo corresponding to each cargo identification information;

the generating module is used for generating a first stock shortage rate of the goods corresponding to each piece of goods identification information and a second stock shortage rate corresponding to each reference type according to each first stock shortage parameter;

the processing module is used for generating second stock shortage state data according to the cargo detail data corresponding to each cargo identification information, the first stock shortage rate and the second stock shortage rate;

and the output module is used for displaying the second stock out rate data on a user interface when receiving a data display request of the terminal.

A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of any of the above-described embodiments of the method when executing the computer program.

A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of the embodiments described above.

According to the processing method and device of the out-of-stock data, the computer equipment and the storage medium, the first out-of-stock state data is obtained, and the first out-of-stock state data comprises the goods identification information of a plurality of goods and the first out-of-stock parameters of the goods corresponding to the goods identification information of each goods; querying a preset goods information database to obtain goods detail data corresponding to each piece of goods identification information and a reference category of goods corresponding to each piece of goods identification information; according to the goods shortage parameters corresponding to the goods identification information, a first goods shortage rate of goods corresponding to the goods identification information and a second goods shortage rate corresponding to each reference category are generated; generating second goods shortage state data according to the goods detail data, the first goods shortage rate and the second goods shortage rate corresponding to the goods identification information; and when a data display request of the terminal is received, displaying the second stock-out rate data on a user interface. According to the goods information data processing method and device, the first goods shortage state data are processed through the pre-constructed goods information database, the first goods shortage rate of goods corresponding to each goods identification information and the second goods shortage rate corresponding to each reference type are obtained according to the first goods shortage state data, data processing of the goods shortage data is achieved, the goods shortage state data containing the goods shortage rates are generated, and the processing efficiency of the goods shortage data is improved.

Drawings

FIG. 1 is a system architecture diagram of a system for processing out-of-stock data in an exemplary embodiment of the present application;

FIG. 2 is a diagram illustrating an exemplary embodiment of a method for processing out-of-stock data;

FIG. 3 is a flow chart illustrating a method for processing out-of-stock data as provided in an exemplary embodiment of the present application;

FIG. 4 is a flow chart illustrating a method for processing out-of-stock data as provided in an exemplary embodiment of the present application;

FIG. 5 is a network topology diagram of a merchandise system provided in an exemplary embodiment of the present application;

FIG. 6 is a flow chart of a method of processing backorder data provided in an exemplary embodiment of the present application;

FIG. 7 is a timing diagram of a third system synchronizing second back-order system data to a fourth system as provided in an exemplary embodiment of the present application;

fig. 8 is a block diagram of a device for processing stock out data provided in an exemplary embodiment of the present application;

fig. 9 is a block diagram of a device for processing stock out data provided in an exemplary embodiment of the present application;

fig. 10 is an internal structural diagram of a computer device provided in an exemplary embodiment of the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

Referring to fig. 1, fig. 1 is a system architecture diagram of a system for processing out-of-stock data according to an embodiment. The processing method of the out-of-stock data is executed by the processing system of the out-of-stock data. As shown in fig. 1, the processing system of the stock out data includes a first system, a second system, a third system, a fourth system, and an ftp (file transfer protocol) server. The method for processing the out-of-stock data is executed by jointly participating in a first system, a second system, a third system, a fourth system and an ftp server.

Specifically, the first system is used for receiving first stock out state data imported by a salesman, performing data verification on the first stock out state data, and sending the first stock out state data passing the verification to the second system.

The second system is used for receiving the first stock out state data sent by the first system, creating a target task according to the first stock out state data, feeding back task identification information to the first system after setting task identification information for the target task, enabling the first system to perform data segmentation on the first stock out state data after receiving the task identification information to obtain data packets, and uploading the data packets to an ftp server for caching.

The second system is further used for sequentially acquiring each data packet from the ftp server, matching the data in each data packet with data in a preset goods information database in the second system to obtain goods detail data and a reference category to which goods corresponding to each goods identification information belong, further calculating a first goods shortage rate of the goods corresponding to each goods identification information and a second goods shortage rate corresponding to each reference category according to the goods detail data and the reference category to which the goods corresponding to each goods identification information belong, and generating second goods shortage state data according to the goods detail data, the first goods shortage rate and the second goods shortage rate corresponding to each goods identification information.

The third system is used for acquiring second stock out state data in the second system and synchronizing the second stock out state data to the fourth system according to a preset data synchronization strategy.

And the fourth system is used for carrying out data conversion on the second stock out state data, converting the second stock out state data into a stock out rate report according to a preset template and displaying the report on a terminal user interface.

Referring to fig. 2, fig. 2 is a schematic application environment diagram of a method for processing out-of-stock data according to an exemplary embodiment of the present application. As shown in fig. 2, the system for processing the out-of-stock data includes a data processing server 100 and a terminal 101. The data processing server 100 communicates with the terminal 101 through the network 102.

The data processing server 100 is configured to receive the first out-of-stock state data, process the first state data according to a preset cargo information database to obtain second out-of-stock state data including an out-of-stock rate, and output the second out-of-stock state data to the terminal 102 for display. The data processing server 100 may be implemented as a stand-alone server or as a server cluster comprised of a plurality of servers.

The terminal 101 is configured to send a data display request to the data processing server 100, receive the second out-of-stock status data fed back by the data processing server 100, and display the second out-of-stock status data. The terminal 101 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, desktop computers, and the like.

The network 102 is used to implement a network connection between the data processing server 100 and the terminal 102. Specifically, the data processing server 100 sends the second stock out status data to the terminal 101 for presentation through the network 103.

In one embodiment, as shown in fig. 3, a method for processing out-of-stock data is provided, which is described by taking the method as an example applied to the data processing server in fig. 2, and includes the following steps:

s11, acquiring first goods shortage state data, wherein the first goods shortage state data comprise goods identification information of a plurality of goods and first goods shortage parameters of the goods corresponding to the goods identification information.

In this application, the first stock out status data includes, but is not limited to: time of import data, goods identification information, goods name, warehouse nickname, and backorder parameters. The goods identification information may be a goods ID. The out-of-stock parameters comprise valid ipv (number of views on the goods details page) invalid ipv and total ipv. The effective ipv uv refers to the visit volume of the goods detail page when each good is in a good state in a specified time period, the ineffective ipv refers to the visit volume of the goods detail page when each good is in a no-good state in the specified time period, and the total ipv refers to the total visit volume of the goods detail page in the specified time period.

In one possible design, an invalid ipv includes an invalid amount of access to the good in each city of sale for a specified period of time. Similarly, the total ipv uv includes the amount of visits the goods have made in the various sales cities during the specified time period. Specifically, the invalid ipv uv and the total ipv uv of the goods in each sales city and in a specified time period may be obtained for each goods.

S12, querying a preset goods information database to obtain goods detail data corresponding to each piece of goods identification information and a reference category to which the goods corresponding to each piece of goods identification information belong.

In the present application, a cargo information database is constructed in advance. The goods information database comprises the mapping relation between the goods identification information and the goods detail data, and also comprises the reference category to which the goods corresponding to the goods identification information belong. According to the method and the system, cargo detail data corresponding to the cargo identification information and a reference category of the cargo corresponding to the cargo identification information are obtained by inquiring the cargo information database.

Specifically, the cargo detail data includes item data, which includes but is not limited to: data cycle, goods code, class number, class name, commodity group number, commodity group name, brand number, brand name, goods name, city code, and city name.

In this application, reference categories of goods include, but are not limited to, brands and groups of goods. The goods information database comprises brands and commodity groups to which goods belong corresponding to each piece of goods identification information.

And S13, generating a first stock shortage rate of the goods corresponding to each goods identification information and a second stock shortage rate corresponding to each reference type according to the stock shortage parameters corresponding to each goods identification information.

In the application, the first stock shortage rate and the second stock shortage rate are determined and obtained by the stock shortage parameters.

And S14, generating second goods shortage state data according to the goods detail data, the first goods shortage rate and the second goods shortage rate corresponding to the goods identification information.

In the application, the goods detail data, the first out-of-stock rate and the second out-of-stock rate corresponding to each piece of goods identification information are subjected to data summarization to generate second out-of-stock state data.

And S15, when a data display request of the terminal is received, displaying the second stock out rate data on a user interface.

Referring to fig. 4, in one embodiment, after the obtaining of the first stock out status data, the method further includes:

and S16, creating a target task according to the first out-of-stock state data, generating task identification information of the target task, carrying out data segmentation on the first out-of-stock state data to obtain a plurality of data groups, wherein each data group comprises a plurality of data records, each data record comprises cargo identification information and a first out-of-stock parameter corresponding to each cargo identification information, and adding and storing group identification information to each data group according to the task identification information.

Further, the aforementioned querying a preset cargo information database to obtain detailed cargo data corresponding to each piece of cargo identification information and a reference category to which the cargo corresponding to each piece of cargo identification information belongs includes the steps of:

s12', obtaining a current data packet according to the packet identification information, extracting goods identification information contained in each data record in the current data packet, and querying a goods information database according to the goods identification information to obtain goods detail data corresponding to each goods identification information in the current data packet and a reference type of goods corresponding to each goods identification information.

In the application, the data processing server cuts the first stock out state data into a plurality of data packets, adds packet identification information to each data packet, and uploads each data packet added with the packet identification information to the ftp server for storage. Furthermore, when processing each data packet in the target task, the data processing server sequentially takes out each data packet from the ftp server and processes the data packet.

In the application, the salesman terminal imports the first stock out state data to the data processing server in batches. The first stock out state data imported each time is used as a target task. In the process of receiving the first stock out state data of the current batch, whether the first stock out state data of the current batch are received completely or not is judged, the target task is established for the first stock out state data of the batch after the first stock out state data of the current batch are received completely, task identification information is added for the target task, the target task is uniquely identified, and the target task is conveniently processed subsequently.

Specifically, the first out-of-stock state data in the application comprises a plurality of data records, each data record comprises goods identification information and out-of-stock parameters corresponding to the goods identification information, and the out-of-stock parameters comprise effective ipv, ineffective ipv and total ipv. Specifically, each data record may include: goods id, import date, goods name, warehouse nickname, valid ipvuv, invalid ipvuv, and total ipvuv.

Furthermore, after the data processing server creates the target task according to the first stock out state data of the current batch, data segmentation is performed on the first stock out state data corresponding to the target task. Specifically, when data segmentation is performed, the first out-of-stock state data is segmented into a preset number of data packets. Since the first out-of-stock state data includes a plurality of data records, the plurality of data records are included in the data packet formed after cutting. For example, taking the imported first stock out state data as an original file containing 30 ten thousand data records as an example, the original file is cut into 6 data packets by using a cutting tool of excel, each data packet contains 5 ten thousand data records, and each data record includes goods identification information, import date, goods name, warehouse nickname, valid ipv uv, invalid ipv uv and total ipv uv.

Further, adding grouping identification information to each data grouping after cutting. Specifically, group identification information is added to each data group according to the task identification information of the current target task and the current timestamp. And respectively uploading the data packets added with the packet identification information to an ftp server for storage. And the ftp server stores all the data packets and the packet identification information of each data packet under the current target task.

Further, when the current target task is executed, the data packets are sequentially taken out from the ftp server according to the packet identification information of the data packets for data processing. When processing, each data record in each data packet is processed in turn. Specifically, for each data record, the cargo identification information in the data record is obtained, the cargo identification information is matched with the data in the cargo information database, and cargo detail data corresponding to the cargo identification information and a reference category to which the cargo corresponding to each cargo identification information belongs are obtained. When the matching of the goods identification information and the data in the goods information database is unsuccessful, prompt information is output to prompt service personnel.

Due to the fact that file flow is large and the occupied system memory is large, the data caching is carried out by the ftp server, the first out-of-stock state data are subjected to data segmentation, the data are stored in the ftp server after being segmented into the data groups, and when data processing is carried out subsequently, the data groups are sequentially taken out from the ftp server to be processed, and burden of an internal system is reduced.

In one embodiment, the querying a preset goods information database to obtain the goods detail data corresponding to each piece of goods identification information and the reference category to which the goods corresponding to each piece of goods identification information belong includes:

inquiring a first mapping relation between the cargo identification information and the cargo detail data in the cargo information database according to the cargo identification information to obtain cargo detail data corresponding to each cargo identification information; and querying a second mapping relation between the cargo identification information and the reference category in the cargo information database according to the cargo identification information to obtain the reference category to which the cargo corresponding to each cargo identification information belongs and the category information of each reference category.

According to the goods detail data, the first stock out rate and the second stock out rate that each goods identification information corresponds, generate second stock out state data, include:

and generating second shortage state data according to the cargo detail data corresponding to each cargo identification information, the first shortage rate, the category information of each reference category and the second shortage rate corresponding to each reference category.

In the present application, a cargo information database is constructed in advance. Specifically, the cargo information database includes a first mapping relationship between the cargo identification information and the cargo detail data and a second mapping relationship between the cargo identification information and the reference category. The second mapping relation further includes category information of each reference category.

Specifically, the reference category in the present application includes a brand category and a commodity group category. Among these are brand categories, such as siemens brand and brand of the united states. A commodity group category such as a washing machine category and a refrigerator category. The category information includes category information of brand categories and category information of commodity group categories. Category information for brand categories includes, but is not limited to: data cycle, item number, item name, commodity group number, commodity group name, brand number, brand name, cargo name, city code, and city name. The category information of the merchandise group category includes, but is not limited to: data cycle, category number, category name, commodity group number, commodity group name, city code, and city name.

Specifically, the second out-of-stock status data includes the following data content:

the first goods information comprises first goods detail data of each goods and a first goods shortage rate of each goods.

And secondly, category information of each brand category and a second stock out rate of each brand category.

And thirdly, the category information of each commodity group category and the second stock out rate of each commodity group category.

In one possible design, the first stock out rate comprises a stock out rate of each item in each city of sale and the second stock out rate comprises a stock out rate of each benchmark category in each city of sale.

In one possible design, the cargo information database is stored in the first system, and the data server calls the cargo information database in the first system to obtain cargo detail data corresponding to each piece of cargo identification information and a reference category to which the cargo corresponding to each piece of cargo identification information belongs.

In one embodiment, the generating a first out-of-stock rate of the goods corresponding to each goods identification information and a second out-of-stock rate corresponding to each reference category according to the out-of-stock parameter corresponding to each goods identification information includes:

determining a first shortage rate of the goods corresponding to each goods identification information according to the first invalid number of visitors and the first total number of visitors corresponding to each goods identification information; and determining a second shortage parameter corresponding to each reference type according to the first shortage parameter corresponding to each cargo identification information, and determining a second shortage rate of the reference type according to the second shortage parameter of the reference type.

Specifically, the first ratio of the number of invalid visitors to the total number of visitors in the specified time period is calculated, and the first ratio is used as the first goods shortage rate of the goods corresponding to the goods identification information.

In one embodiment, the determining a second out-of-stock parameter corresponding to each reference category according to the first out-of-stock parameter corresponding to each cargo identification information, and determining a second out-of-stock rate of the reference category according to the second out-of-stock parameter of the reference category includes:

acquiring all goods identification information under the current standard category, and acquiring a first invalid visitor number and a first total visitor number corresponding to each goods identification information; determining a second invalid number of access persons corresponding to the current reference category in a specified time period according to the first invalid number of access persons corresponding to each piece of goods identification information; determining a second total number of visitors corresponding to the current standard category in a specified time period according to the first total number of visitors corresponding to each piece of goods identification information; and determining a second shortage rate corresponding to the current reference category according to a second invalid visitor number and a second total visitor number corresponding to the current reference category in the specified time period.

Specifically, the sum of the number of first invalid visitors corresponding to each piece of goods identification information is calculated, and a second invalid visitors corresponding to the current standard category in the appointed time period is obtained. And calculating the sum of the first total visitor number corresponding to each piece of goods identification information to obtain a second total visitor number corresponding to the current standard category in the appointed time period. And calculating a second ratio of a second invalid visitor number and a second total visitor number corresponding to the current reference type in the specified time period, and taking the second ratio as a second shortage rate of the current reference type.

In this application, what input is first out of stock state data, and the final output second out of stock state data, wherein second out of stock state data specifically includes: the goods detail data of each goods, the first stock out rate of each goods, the reference type of each goods and the second stock out rate of each reference type.

It should be noted that, in the present application, when calculating the first stock shortage rate of each cargo and the second stock shortage rate of each reference category, the following two schemes may be specifically included:

firstly, when the first system receives the first goods shortage state data, the first goods shortage rate of each goods is calculated according to the first goods shortage parameters in the first goods shortage state data, the second system performs calculation of the second goods shortage rate of each reference type, finally the first goods shortage rate calculated by the first system is sent to the second system, and the second system performs the step of generating second goods shortage state data according to the goods detail data, the first goods shortage rate and the second goods shortage rate corresponding to the identification information of each goods.

After receiving the first goods shortage state data, the first system sends the first goods shortage state data to the second system, the second system determines goods detail data corresponding to each goods identification information and a reference type to which the goods belong corresponding to each goods identification information, the second system calculates a first goods shortage rate of each goods and a second goods shortage rate of each reference type, and further the second system executes a step of generating second goods shortage state data according to the goods detail data corresponding to each goods identification information, the first goods shortage rate and the second goods shortage rate.

The brand category of the goods corresponding to each goods identification information in the first goods shortage state data is obtained by inquiring the goods information database. Further, the goods with the same brand are classified into one type, namely a brand category, and invalid ipv uv and total ipv uv of the brand category are determined. Specifically, the sum of the invalid ipv of each goods in the brand category is determined to obtain the invalid ipv of the brand category, and the total ipv of each goods in the brand category is determined to obtain the total ipv of the brand category. A second stock out rate for the brand category is further determined from the invalid ipvuv and the total ipvuv for the brand category.

Similarly, the goods information database is inquired to obtain the commodity group category of each goods corresponding to the goods identification information in the first goods shortage state data. Further, the goods belonging to the same commodity group in the first stock out state data are classified into a commodity group category, and the invalid ipvuv and the total ipvuv of the commodity group category are determined. Further, a second stock out rate for the group of items category is determined based on the invalid ipvuv and the total ipvuv for the group of items category.

In one embodiment, when the data presentation request from the terminal is received, presenting the second stock out rate data on the user interface includes:

and converting the second stock shortage state data into a stock shortage rate report according to a preset template, and displaying the stock shortage rate report on a user interface when receiving a data display request of the terminal.

In the application, the third system is configured to obtain the second out-of-stock state data from the second system after the second system generates the second out-of-stock state data, and synchronize the second out-of-stock state data to the fourth system according to a preset data synchronization policy. And the fourth system is used for carrying out data conversion on the second stock out state data, converting the second stock out state data into a stock out rate report according to a preset template and displaying the report on a terminal user interface.

Specifically, a preset data synchronization policy is pre-established in the third system, where the data synchronization policy includes pre-established switching tasks and execution times of the switching tasks, and for example, the data synchronization policy may be set to execute the switching tasks once every preset time period. And the third system synchronizes the second stock out state data to the fourth system according to the data synchronization strategy.

And further, after receiving the second back-order state data, the fourth system converts the second back-order state data into a back-order rate report according to a preset template. And when the fourth system receives a data display request of the terminal, displaying the stock shortage rate report containing the second stock shortage state data on the user interface.

In a possible application scenario, the method for processing the out-of-stock data can be applied to stock management of commodities on a cat-ning working platform. Specifically, the first system of this application is maoning work platform, and the second system is maoning commodity system, and the third system is big data platform, and the fourth system is hundred chuan platforms.

Specifically, the maoning work platform receives first goods shortage state data imported by the service, verifies the first goods shortage state data, and sends the verified first goods shortage state data to the maoning commodity system. And after receiving the first out-of-stock state data, the cat goods system creates a target task for the first out-of-stock state data and feeds back task identification information of the target task to the cat work platform. And the Cat Ning working platform cuts the data of the first stock shortage state data after receiving the feedback information, and uploads the cut data to the ftp server in a grouping mode.

Further, the maoning commodity system sequentially takes out all data packets from the ftp server for processing, matches the data of all the data packets with the data in the goods information database to obtain goods detail data corresponding to all the goods identification information and a reference category to which the goods corresponding to all the goods identification information belong, calculates a first stock shortage rate of the goods corresponding to all the goods identification information and a second stock shortage rate corresponding to all the reference categories according to the goods detail data and the reference category to which the goods corresponding to all the goods identification information belong, and generates second stock shortage state data according to the goods detail data, the first stock shortage rate and the second stock shortage rate corresponding to all the goods identification information.

Further, the big data platform acquires second shortage state data from the cat-Ning commodity system, synchronizes the second shortage state data to the Baichuan platform according to a preset data synchronization strategy, and the Baichuan platform makes the second shortage state data into a shortage rate report and displays the shortage rate report on a terminal user interface.

Referring to fig. 5, fig. 5 is a network topology diagram of a merchandise system according to an embodiment. Fig. 5 includes a first system, a second system, and a fifth system.

The first system is used for receiving first stock out state data imported by a salesman, carrying out data verification on the first stock out state data and sending the first stock out state data passing the verification to the second system.

The second system is used for receiving the first stock out state data sent by the first system, creating a target task according to the first stock out state data, feeding back task identification information to the first system after setting task identification information for the target task, enabling the first system to carry out data segmentation on the first stock out state data after receiving the task identification information to obtain data packets, and uploading the data packets to the ftp system for caching.

The second system is further used for sequentially acquiring each data packet from the ftp server, matching the data in each data packet with data in a preset goods information database in the second system to obtain goods detail data and a reference category to which goods corresponding to each goods identification information belong, further calculating a first stock shortage rate of the goods corresponding to each goods identification information and a second stock shortage rate corresponding to each reference category of the first-level goods according to the goods detail data and the reference category to which the goods corresponding to each goods identification information belong, and generating second stock shortage state data according to the goods detail data, the first stock shortage rate and the second stock shortage rate corresponding to each goods identification information.

The fifth system is a background system for managing user rights, notices, setting corresponding parameters and the like. The fifth system is a system used by an administrator, and the administrator manages the processing system of the stock out data of the application through the system. For example, the size of the data packet in the present application may be configured by the fifth system, that is, when the first system cuts the first out-of-stock state data, the size of the data packet generated after cutting may be configured by the fifth system. And the first system acquires the size of the pre-configured cut data packet in the fifth system to cut the data of the first stock out state data.

In one embodiment, the querying the preset cargo information database to obtain the cargo detail data corresponding to each piece of cargo identification information and the reference category to which the cargo corresponding to each piece of cargo identification information belongs includes:

when the goods detail data corresponding to the goods identification information does not exist in the goods information database, or the reference category to which the goods belong does not exist in the goods information database, the prompt information is output.

Referring to fig. 6, fig. 6 is a flowchart illustrating a method for processing stock out data according to an embodiment. As shown in fig. 6, the first system receives the first stock out status data and sends the first stock out status data to the second system. And after judging that the data import is finished, the second system creates a target task of the imported data according to the first stock out state data, adds task identification information for the target task and feeds the task identification information back to the first system. And after receiving the feedback information, the first system performs data cutting on the first stock out state data, and uploads the cut data packets to an ftp server for caching.

Further, the second system takes out the data packet from the ftp server for processing, matches the data of the data packet with the data in a preset goods information database to obtain goods detail data corresponding to each piece of goods identification information and a reference category to which the goods belong corresponding to each piece of goods identification information, and generates a first goods shortage rate of the goods corresponding to each piece of goods identification information and a second goods shortage rate corresponding to each reference category according to each first goods shortage parameter; and generating and storing second goods shortage state data according to the goods detail data, the first goods shortage rate and the second goods shortage rate corresponding to each piece of goods identification information, feeding back a message for generating the second goods shortage state data to the first system, and updating the execution state of the target task.

Further, the first system may initiate a request for an execution state of the target task to the second system, and the second system may feed back the execution record of the target task to the first system after querying the execution record in the cargo information database.

Referring to fig. 7, fig. 7 is a timing diagram illustrating the third system synchronizing the second back-order system data to the fourth system according to an embodiment. As shown in fig. 7, the third system includes a first word system and a second sub-system. After the third system acquires the second back-order state data from the second system, the first word system and the second subsystem in the third system are responsible for synchronizing the second back-order state data to the fourth system.

Specifically, the developer creates a hive (data warehouse tool) temporary table and a partition table of the second stock out state data through the first subsystem, authorizes the query authority of the second system to the first subsystem, and creates an exchange task through the first subsystem, wherein the exchange task is used for synchronizing the second stock out state data to the fourth system.

Furthermore, the first subsystem firstly empties data in the hive temporary table and deletes partitions in the partition table when executing the exchange task each time, format conversion is carried out on the second shortage state data and then the second shortage state data is stored in the hive temporary table, the data in the temporary table is stored in the partition table, so that the fourth system can conveniently obtain the second shortage state data from the partition table in hours, further convert the second shortage state data into a shortage rate report and display the shortage rate report on a terminal user interface.

In one embodiment, as shown in fig. 8, there is provided a device for processing stock out data, including:

the obtaining module 11 is configured to obtain first out-of-stock state data, where the first out-of-stock state data includes cargo identification information of multiple cargos and a first out-of-stock parameter of each cargo corresponding to the cargo identification information;

the query module 12 is configured to query a preset cargo information database to obtain cargo detail data corresponding to each piece of cargo identification information and a reference category to which the cargo corresponding to each piece of cargo identification information belongs;

the generating module 13 is configured to generate a first stock shortage rate of the goods corresponding to each piece of goods identification information and a second stock shortage rate corresponding to each reference category according to each first stock shortage parameter;

the processing module 14 is configured to generate second out-of-stock state data according to the detailed goods data, the first out-of-stock rate, and the second out-of-stock rate corresponding to each piece of goods identification information;

and the output module 15 is configured to display the second stock out rate data on the user interface when receiving a data display request of the terminal.

Referring to fig. 9, in one embodiment, the apparatus further includes:

the segmentation module 16 is configured to create a target task according to the first out-of-stock state data, generate task identification information of the target task, perform data segmentation on the first out-of-stock state data to obtain a plurality of data packets, where each data packet includes a plurality of data records, each data record includes cargo identification information and a first out-of-stock parameter corresponding to each cargo identification information, and add and store group identification information to each data packet according to the task identification information.

A query module 12, comprising:

the first query unit is used for acquiring the current data packet according to the packet identification information; extracting goods identification information contained in each data record in the current data packet; and querying a cargo information database according to the cargo identification information to obtain cargo detail data corresponding to each cargo identification information in the current data packet and a reference category to which the cargo corresponding to each cargo identification information belongs.

In one embodiment, the first out-of-stock parameter includes a first number of invalid visitors and a first total visitors of the goods detail page in a specified time period, and the generating module 13 includes:

the first generation unit is used for determining a first shortage rate of the goods corresponding to each piece of goods identification information according to the first invalid number of visitors and the first total number of visitors corresponding to each piece of goods identification information; and determining second stock shortage parameters corresponding to the reference categories according to the first stock shortage parameters corresponding to the goods identification information, and determining second stock shortage rates of the reference categories according to the second stock shortage parameters of the reference categories.

In one embodiment, the generating module 13 includes:

the second generation unit is used for acquiring all goods identification information under the current standard category and acquiring a first invalid visitor number and a first total visitor number corresponding to each goods identification information; determining a second invalid number of access persons corresponding to the current reference category in a specified time period according to the first invalid number of access persons corresponding to each piece of goods identification information; determining a second total visitor number corresponding to the current reference category in a specified time period according to the first total visitor number corresponding to each piece of goods identification information; and determining a second shortage rate corresponding to the current reference category according to a second invalid visitor number and a second total visitor number corresponding to the current reference category in the specified time period.

In one embodiment, the query module 12 includes:

the second query unit is used for querying a first mapping relation between the cargo identification information and the cargo detail data in the cargo information database according to the cargo identification information to obtain the cargo detail data corresponding to each cargo identification information; inquiring a second mapping relation between the goods identification information and the reference category in the goods information database according to the goods identification information to obtain the reference category to which the goods belong and category information of each reference category corresponding to each goods identification information;

the processing module 14 includes:

and the processing unit is used for generating second stock shortage state data according to the cargo detail data corresponding to each cargo identification information, the first stock shortage rate, the category information of each reference category and the second stock shortage rate corresponding to each reference category.

In one embodiment, the output module 15 includes:

and the output unit is used for converting the second stock shortage state data into a stock shortage rate report according to a preset template, and displaying the stock shortage rate report on a user interface when receiving a data display request of the terminal.

In one embodiment, the query module 12 includes:

and the prompting unit is used for outputting prompting information when the goods detail data corresponding to the goods identification information does not exist in the goods information database or when the reference category to which the goods belong corresponding to the goods identification information does not exist in the goods information database.

In one embodiment, a computer device is provided, which may be a service processing server, and the internal structure thereof may be as shown in fig. 10. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide the determining and controlling capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of processing out-of-stock data. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.

In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:

querying a preset goods information database to obtain goods detail data corresponding to each piece of goods identification information and a reference category of goods corresponding to each piece of goods identification information;

generating second goods shortage state data according to the goods detail data, the first goods shortage rate and the second goods shortage rate corresponding to each goods identification information;

and when a data display request of the terminal is received, displaying the second stock out rate data on a user interface.

In one embodiment, after the processor executes the computer program to implement the above-mentioned step of acquiring the first stock out status data, the following steps are also implemented:

creating a target task according to the first out-of-stock state data and generating task identification information of the target task;

when the processor executes the computer program to realize the steps of querying the preset goods information database to obtain goods detail data corresponding to each piece of goods identification information and the reference category of the goods corresponding to each piece of goods identification information, the following steps are specifically realized:

and querying a cargo information database according to the cargo identification information to obtain cargo detail data corresponding to each cargo identification information in the current data packet and a reference category to which the cargo corresponding to each cargo identification information belongs.

In an embodiment, the first out-of-stock parameter includes a first number of invalid visits and a first total number of visits of the goods detail page in a specified time period, and the processor executes a computer program to implement the step of generating a first out-of-stock rate of goods corresponding to each goods identification information and a second out-of-stock rate corresponding to each reference category according to the out-of-stock parameter corresponding to each goods identification information, which is specifically implemented as follows:

and determining second stock shortage parameters corresponding to the reference categories according to the first stock shortage parameters corresponding to the goods identification information, and determining second stock shortage rates of the reference categories according to the second stock shortage parameters of the reference categories.

In one embodiment, when the processor executes the computer program to implement the steps of determining the second out-of-stock parameter corresponding to each reference category according to the first out-of-stock parameter corresponding to each piece of goods identification information, and determining the second out-of-stock rate of the reference category according to the second out-of-stock parameter of the reference category, the following steps are specifically implemented:

acquiring all goods identification information under the current standard category, and acquiring a first invalid visitor number and a first total visitor number corresponding to each goods identification information;

determining a second total number of visitors corresponding to the current standard category in a specified time period according to the first total number of visitors corresponding to each piece of goods identification information;

and determining a second shortage rate corresponding to the current reference category according to a second invalid visitor number and a second total visitor number corresponding to the current reference category in the specified time period.

In an embodiment, when the processor executes the computer program to implement the step of querying the preset cargo information database to obtain the cargo detail data corresponding to each piece of cargo identification information and the reference category to which the cargo belongs corresponding to each piece of cargo identification information, the following steps are specifically implemented:

inquiring a second mapping relation between the goods identification information and the reference category in the goods information database according to the goods identification information to obtain the reference category to which the goods belong and the category information of each reference category corresponding to each goods identification information;

according to the detailed data of the goods corresponding to each piece of goods identification information, the first stock shortage rate and the second stock shortage rate, second stock shortage state data are generated, and the method comprises the following steps:

In one embodiment, when the processor executes the computer program to perform the above step of displaying the second stock out rate data on the user interface when receiving the data display request from the terminal, the following steps are specifically performed:

when no goods detail data corresponding to the goods identification information exists in the goods information database, or when no reference category corresponding to the goods and belonging to the goods exists in the goods information database, prompt information is output.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above may be implemented by hardware that is instructed by a computer program, and the computer program may be stored in a non-volatile computer-readable storage medium, and when executed, may include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), rambus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

All possible combinations of the technical features in the above embodiments may not be described for the sake of brevity, but should be considered as being within the scope of the present disclosure as long as there is no contradiction between the combinations of the technical features.

The above examples only express several embodiments of the present application, and the description thereof is more specific and detailed, but not to be construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims

1. A method of processing out-of-stock data, the method comprising:

generating second goods shortage state data according to the goods detail data corresponding to the goods identification information, the first goods shortage rate and the second goods shortage rate;

2. The method of claim 1, wherein after said obtaining first stock out status data, the method further comprises:

the querying of the preset goods information database to obtain the goods detail data corresponding to each goods identification information and the reference category to which the goods corresponding to each goods identification information belong includes:

3. The method of claim 1, wherein the first stock out parameter comprises a first invalid visitor count and a first total visitor count of the goods detail page in a specified time period, and the generating a first stock out rate of the goods corresponding to each piece of goods identification information and a second stock out rate corresponding to each reference category according to the stock out parameter corresponding to each piece of goods identification information comprises:

4. The method according to claim 3, wherein the determining a second stock out parameter corresponding to each reference category according to the first stock out parameter corresponding to each cargo identification information, and determining a second stock out rate of the reference category according to the second stock out parameter of the reference category comprises:

and determining a second stock shortage rate corresponding to the current reference type according to a second invalid visitor number and a second total visitor number corresponding to the current reference type in a specified time period.

5. The method of claim 1, wherein the querying a preset cargo information database to obtain cargo detail data corresponding to each piece of cargo identification information and a reference category to which the cargo corresponding to each piece of cargo identification information belongs comprises:

the step of generating second out-of-stock state data according to the detailed goods data corresponding to the goods identification information, the first out-of-stock rate and the second out-of-stock rate comprises the following steps:

and generating second out-of-stock state data according to the cargo detail data corresponding to the cargo identification information, the first out-of-stock rate, the category information of each reference category and the second out-of-stock rate corresponding to each reference category.

6. The method according to claim 1, wherein the presenting the second stock out rate data to a user interface when receiving a data presentation request of a terminal comprises:

7. The method of claim 1, wherein the querying a preset cargo information database to obtain cargo detail data corresponding to each cargo identification information and a reference category to which the cargo corresponding to each cargo identification information belongs comprises:

when the goods detail data corresponding to the goods identification information does not exist in the goods information database, or when the standard category of the goods corresponding to the goods identification information does not exist in the goods information database, outputting prompt information.

8. An apparatus for processing out-of-stock data, the apparatus comprising:

the generating module is used for generating a first stock shortage rate of the goods corresponding to each goods identification information and a second stock shortage rate corresponding to each reference type according to each first stock shortage parameter;

the processing module is used for generating second out-of-stock state data according to the cargo detail data corresponding to each cargo identification information, the first out-of-stock rate and the second out-of-stock rate;

9. A computer arrangement comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor realizes the steps of the method for processing out-of-stock data according to any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method for processing out-of-stock data according to any one of claims 1 to 7.