CN117495424A

CN117495424A - FBA (film base station) head management method, system, equipment and storage medium

Info

Publication number: CN117495424A
Application number: CN202311846912.6A
Authority: CN
Inventors: 崔浩军; 郑志坚
Original assignee: Shenzhen Irobotbox Technology Co ltd
Current assignee: Shenzhen Irobotbox Technology Co ltd
Priority date: 2023-12-29
Filing date: 2023-12-29
Publication date: 2024-02-02

Abstract

The present application relates to the field of computer technologies, and in particular, to a method, a system, an apparatus, and a storage medium for FBA header management, where the method for FBA header management includes: acquiring FBA inventory ledger data input by an Amazon platform, and storing the FBA inventory ledger data into a preset first storage space; determining whether the batch number data in the first storage space contains target data stored in a preset second storage space, and if the batch number data contains the target data, determining the target data type of the batch number data according to the mapping relation between the target data and the data type; and adjusting the head record data stored in the preset fourth storage space according to the target data type, the number of goods and the preset adjustment operation set stored in the third storage space. The method and the device can improve the accuracy of the head management calculation based on the technical means.

Description

FBA (film base station) head management method, system, equipment and storage medium

Technical Field

The present disclosure relates to the field of computer technologies, and in particular, to a method, a system, an apparatus, and a storage medium for FBA header management.

Background

FBA (fulfillment by Amazon) the amazon logistics service refers to that the amazon opens a platform thereof to third-party sellers, brings the stock thereof into the amazon global logistics network, provides the services of picking, packaging and terminal distribution for the amazon, and generally relates to the transportation of goods and the calculation of head-end cost data in the transportation process during the service.

The conventional method for calculating the head cost is divided into two types, wherein one type is to generate the head after the package of the stock order is shipped, and the other type is to generate the head after the commodity circulation merchant of the stock order confirms the account checking; however, in practice, the two kinds of timing for generating the header have defects, and in the process from the local warehouse to the FBA warehouse, there may be problems that inventory loss causes inconsistent receiving and sending numbers, orders are divided into a plurality of packages, packages which are shipped first arrive later, and the like; even if the Amazon warehouse confirms the goods received, the inventory is lost, damaged, returned and the like, when the statistics calculation of the head stroke is performed manually, the abnormal conditions cannot be controlled, repeated correction is required manually, labor is consumed, errors are easy to occur, and when the number of the goods is too large, the statistics calculation of the head stroke is performed manually, and the condition of mistakes in recording possibly exists, so that the head stroke data is wrong.

Disclosure of Invention

The main purpose of the present application is to provide a method, a system, a device and a storage medium for managing an FBA header, which aim to solve the technical problem of low accuracy of the existing method for manually performing header cost data calculation.

In order to achieve the above object, the present application provides an FBA header management method, including:

acquiring FBA inventory ledger data input by an Amazon platform, and storing the FBA inventory ledger data into a preset first storage space, wherein the FBA inventory ledger data comprises the number of goods and batch number data;

determining the identification data in the stored batch number data, and determining the mapping relation between the preset identification data and the data type stored in a preset second storage space;

determining a target data type corresponding to the identification data according to the mapping relation;

according to the target data type, the goods quantity and the adjustment operation set stored in the preset third storage space, adjusting the head stroke record data stored in the preset fourth storage space, wherein the head stroke record data comprise a plurality of first head stroke batch record data and head stroke expense data corresponding to the first head stroke batch record data respectively, and the first head stroke batch record data comprise batch head stroke quantity.

Optionally, in a possible embodiment, the target data type includes: the stock warehouse entry data type, the FBA stock ledger data further comprises: the FBA prepares the cargo ID of the cargo;

the step of adjusting the head record data stored in the preset fourth storage space according to the target data type, the number of goods and the preset adjustment operation set stored in the third storage space comprises the following steps:

when the data type is the stock-in data type, the target adjustment operation corresponding to the stock-in data type is intensively determined in the adjustment operation set stored in a preset third storage space, wherein the target adjustment operation is to increase the head record data stored in a preset fourth storage space;

newly creating first head batch record data, and assigning the value of the number of goods to the number of batch heads in the new first head batch record data;

searching first head cost data corresponding to a single SKU in a stock order corresponding to the goods ID, and calculating the head cost data according to the first head cost data and the batch head number;

and storing the new first head batch record data and the head expense data in the head record data in an associated mode so as to execute the operation of adding the head record data stored in the preset fourth storage space.

Optionally, in a possible embodiment, the target data type includes: checking the data type in a warehouse;

the step of adjusting the head record data stored in the preset fourth storage space according to the target data type, the number of goods and the preset adjustment operation set stored in the third storage space, further comprises:

when the data type is a warehouse inventory data type, comparing the target head number in the head record data stored in the preset fourth storage space with the target inventory number in the FBA inventory ledger data;

when the target stock quantity is larger than the target head quantity, determining target adjustment operation corresponding to the warehouse inventory data type in a preset adjustment operation set stored in a third storage space, and calculating a first difference value between the target stock quantity and the target head quantity, wherein the target adjustment operation is to increase head record data stored in a preset fourth storage space;

newly creating first head batch record data, and assigning the value of the first difference value to the batch head number in the new first head batch record data;

Acquiring second head cost data of a target head batch corresponding to the new first head batch record data;

and storing new first head batch record data and the second head expense data in the head record data in a correlated way so as to execute the operation of adding the head record data stored in the preset fourth storage space.

Optionally, in a possible embodiment, after the step of comparing the target number of heads in the head record data stored in the preset fourth storage space with the target number of inventory in the FBA inventory ledger data, the method further includes:

when the target stock quantity is smaller than the target head stroke quantity, determining target adjustment operation corresponding to the warehouse inventory data type in a preset adjustment operation set stored in a third storage space, wherein the target adjustment operation is to deduct head stroke record data stored in a preset fourth storage space;

determining second head batch record data with earliest time in the head record data, and calculating a second difference value between the target head number and the target stock number;

and deducting the number of the head strokes equal to the second difference value from the number of the batch head strokes of the second head stroke batch record data so as to execute the operation of deducting the head stroke record data stored in the preset fourth storage space.

Optionally, in a possible embodiment, the target data type includes: the type of data in storage;

when the data type is a warehouse-in data type, the target adjustment operation corresponding to the warehouse-in data type is determined in a set of adjustment operations stored in a preset third storage space, wherein the target adjustment operation is to increase the head record data stored in a preset fourth storage space;

Optionally, in a possible embodiment, the target data type includes: deducting the data type;

when the data type is a deduction data type, determining a target adjustment operation corresponding to the deduction data type in a set of adjustment operations stored in a preset third storage space, wherein the target adjustment operation is to deduct head record data stored in a preset fourth storage space;

determining the second head batch record data in the head record data;

and deducting the number of the head strokes which is equal to the number of the goods in the second head stroke batch record data so as to execute the deduction operation of the head stroke record data stored in the preset fourth storage space.

Optionally, in a possible embodiment, the method further includes:

acquiring inventory ledger general ledger data input by an Amazon platform, wherein the inventory ledger general ledger data records the total inventory quantity in an FBA warehouse in a report form;

Comparing the total stock quantity with the total head quantity in the head record data, and calculating a target absolute value of a difference value between the total stock quantity and the total head quantity;

if the total stock quantity is smaller than the total head quantity, determining the second head batch record data in the head record data, and deducting the head quantity equal to the target absolute value from the second head batch record data so as to deduct the head record data stored in a preset fourth storage space;

if the total stock quantity is larger than the total head quantity, newly creating first head batch record data, assigning the value of the target absolute value to the batch head quantity in the new first head batch record data, acquiring second head cost data of a target head batch corresponding to the new first head batch record data, and storing the new first head batch record data and the second head cost data in the head batch record data in an associated mode so as to increase the head record data stored in a preset fourth storage space.

In addition, in order to achieve the above object, the present application further provides an FBA header management system, which is a virtual device, comprising:

The data acquisition module is used for acquiring FBA inventory ledger data input by the Amazon platform and storing the FBA inventory ledger data into a preset first storage space, wherein the FBA inventory ledger data comprises the number of goods and batch number data;

the type determining module is used for determining the identification data in the stored batch number data and determining the mapping relation between the preset identification data and the data type stored in the preset second storage space; determining a target data type corresponding to the identification data according to the mapping relation;

the record adjustment module is used for adjusting the head record data stored in the preset fourth storage space according to the target data type, the goods quantity and the adjustment operation set stored in the preset third storage space, wherein the head record data comprises a plurality of first head batch record data and head expense data corresponding to the first head batch record data, and the first head batch record data comprises batch head quantity.

In addition, to achieve the above object, the present application further provides an FBA header management apparatus, comprising: a memory, a processor and a computer program stored on the memory and executable on the processor, which when executed by the processor, performs the steps of the FBA header management method as described above.

The present application also provides a storage medium, which is a computer readable storage medium, and on which a computer program is stored, the computer program implementing the steps of the FBA header management method as described above when being executed by a processor.

The application provides an FBA (fiber Bragg Grating) head management method, an FBA head management system, FBA head management equipment and a storage medium, wherein the FBA head management method comprises the following steps: acquiring FBA inventory ledger data input by an Amazon platform, and storing the FBA inventory ledger data into a preset first storage space, wherein the FBA inventory ledger data comprises the number of goods and batch number data; determining the identification data in the stored batch number data, and determining the mapping relation between the preset identification data and the data type stored in a preset second storage space; determining a target data type corresponding to the identification data according to the mapping relation; according to the target data type, the goods quantity and the adjustment operation set stored in the preset third storage space, adjusting the head stroke record data stored in the preset fourth storage space, wherein the head stroke record data comprise a plurality of first head stroke batch record data and head stroke expense data corresponding to the first head stroke batch record data respectively, and the first head stroke batch record data comprise batch head stroke quantity.

Compared with the conventional technical means that the head is generated after the package delivery of the stock order is manually carried out or the head is generated after the check-out is confirmed by a stock order logistics merchant, the FBA head management method of the application can acquire the FBA stock ledger from the Amazon platform in real time, then determine the data type of the batch number data according to the batch number data in the FBA stock ledger, and accordingly, the first head batch record data and the head expense data are pertinently adjusted.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description, serve to explain the principles of the application.

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required to be used in the description of the embodiments or the prior art will be briefly described below, and it will be obvious to those skilled in the art that other drawings can be obtained from these drawings without inventive effort.

Fig. 1 is a schematic structural diagram of an FBA header management device in a device hardware operating environment according to an embodiment of the present application;

fig. 2 is a schematic flow chart of an implementation of a first embodiment of the FBA header management method of the present application;

FIG. 3 is a stock flow chart of a first embodiment of the FBA header management method of the present application;

fig. 4 is a flowchart related to a second embodiment of the FBA header management method according to the present application;

fig. 5 is a flowchart related to a third embodiment of the FBA header management method according to the present application;

fig. 6 is a flowchart related to a fifth embodiment of the FBA header management method according to the present application;

fig. 7 is a schematic diagram of functional modules related to an FBA header management system according to an embodiment of the present application.

The realization, functional characteristics and advantages of the present application will be further described with reference to the embodiments, referring to the attached drawings.

Detailed Description

It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.

It should be noted that, FBA (fulfillment by Amazon), amazon logistics service refers to that amazon opens its platform to third-party sellers, brings its stock into amazon global logistics network, and provides services of picking, packaging and terminal distribution for the amazon, and in the service process, it generally involves calculation of head-end cost data in the transportation and transportation process of goods.

In view of the above problems, the present application provides an FBA header management method, system, device and storage medium, where the FBA header management method includes: acquiring FBA inventory ledger data input by an Amazon platform, and storing the FBA inventory ledger data into a preset first storage space, wherein the FBA inventory ledger data comprises the number of goods and batch number data; determining whether the batch number data in the first storage space contains target data stored in a preset second storage space, and if the batch number data contains the target data, determining a target data type of the batch number data according to a mapping relation between the target data and the data type; according to the target data type, the goods quantity and the adjustment operation set stored in the preset third storage space, adjusting the head stroke record data stored in the preset fourth storage space, wherein the head stroke record data comprise a plurality of first head stroke batch record data and head stroke expense data corresponding to the first head stroke batch record data respectively, and the first head stroke batch record data comprise batch head stroke quantity.

The following description of the embodiments of the present application will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are only some, but not all, of the embodiments of the present application. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments herein without making any inventive effort, are intended to be within the scope of the present application.

Referring to fig. 1, fig. 1 is a schematic structural diagram of an FBA header management device in a device hardware running environment according to an embodiment of the present application.

The terminal device according to the embodiment of the present invention may be a data storage control terminal, a PC, a portable computer, or the like in the FBA header management system that executes the FBA header management method of the present application.

As shown in fig. 1, the FBA header management apparatus may include: a processor 1001, such as a CPU, memory 1005, and a communication bus 1002. Wherein a communication bus 1002 is used to enable connected communication between the processor 1001 and a memory 1005. The memory 1005 may be a high-speed RAM memory or a stable memory (non-volatile memory), such as a disk memory. The memory 1005 may also optionally be a storage device separate from the processor 1001 described above.

Optionally, the FBA header management device may further include a user interface 1003, a network interface 1004, a WiFi module, and the like. The user interface may comprise a Display, an input sub-module such as a Keyboard (Keyboard), and optionally may comprise a standard wired interface, a wireless interface. The network interface may optionally include a standard wired interface, a wireless interface (e.g., WIFI interface).

It will be appreciated by those skilled in the art that the FBA head management device structure shown in fig. 1 does not constitute a limitation of the FBA head management device and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components.

As shown in fig. 1, an operating system, a network communication module, a user interface module, and a computer program may be included in the memory 1005, which is a type of computer-readable storage medium. The operating system is a program that manages and controls the FBA header management device hardware and software resources, supporting the execution of computer programs, as well as other software and/or programs. The network communication module is used to implement communication between the components within the memory 1005 and with other hardware and software in the FBA header management system.

In the FBA header management apparatus shown in fig. 1, a processor 1001 is configured to execute a computer program stored in a memory 1005, and to perform the following operations:

Further, the processor 1001 may call a computer program stored in the memory 1005, and further perform the following operations:

determining the second head batch record data in the head record data;

Based on the above-described structure, various embodiments of an FBA header management method are presented.

In a first embodiment of the FBA header management method of the present application, please refer to fig. 2, fig. 2 is a flowchart illustrating a first embodiment of the FBA header management method of the present application.

Embodiments of the present invention provide embodiments of FBA header management methods, it being noted that although a logical order is shown in the flow chart, in some cases the steps shown or described may be performed in an order different than that shown or described herein. In this embodiment, the execution body of the FBA header management method is an FBA header management system, and for convenience of description, the execution body is omitted from description of each embodiment. In this embodiment, the FBA header management method includes:

Step S10, FBA inventory ledger data input by an Amazon platform are obtained, and the FBA inventory ledger data are stored in a preset first storage space, wherein the FBA inventory ledger data comprise the number of goods and batch number data;

in this embodiment, referring to fig. 3, fig. 3 is a stock flow chart related to the first embodiment of the FBA head management method of the present application, as shown in fig. 3, when the FBA warehouse needs to make a stock, the system will first create an FBA stock order, then send the FBA stock order to a local warehouse-FBA warehouse and/or an overseas warehouse-FBA warehouse (i.e. a local warehouse and/or an overseas warehouse that supplies the FBA warehouse), then the local warehouse-FBA warehouse and/or the overseas warehouse-FBA warehouse package the stock according to the stock order, then weigh and ship the stock, and transport the stock to the FBA warehouse, and the FBA warehouse receives the stock, where the head cost data refers to a transportation cost generated by sending the stock order from the local warehouse to the FBA warehouse or the overseas warehouse to the FBA.

In this embodiment, the amazon platform stores a collection of information related to sales, returns, and stock of the commodities on the amazon platform, and the FBA stock ledger includes information such as customer order information of the target FBA warehouse, lot number data of the lot of the commodities, number of the commodities, type of the commodities, number of the commodities, and the like, and information about actions performed by the lot of the commodities, such as ex-warehouse, in-warehouse, and the like.

In this embodiment, since the conventional method of generating the header after the shipment of the package of the stock order, if the package is damaged or lost during the shipment, there is a problem that the number of header is not equal to the shipment number of the FBA bins, if the shipment order is different from the shipment order due to the unreliability during the shipment, there is a problem that the header is not aligned with the package, that is, the method of generating the header after the shipment of the package of the stock order causes neither the number nor the time of generating the header.

Therefore, in this embodiment, in order to solve the above-mentioned problem, it is proposed to modify the timing of the header calculation into that after the FBA bin receives the goods, the header is calculated according to the received goods, that is, the system acquires the FBA inventory ledger data of the FBA bin in real time in the amazon platform through a preset interface, so as to avoid the problem that the number and time of the generated header are not aligned due to the damage, loss or different delivery order and receiving order of the goods in the transportation process.

In this embodiment, the preset interface is an interface that can call the FBA inventory ledger data of the FBA cabin in the amazon platform, and the interface type can be various, which is not limited herein.

Step S20, determining the stored identification data in the batch number data, and determining the mapping relation between the preset identification data and the data type stored in a preset second storage space;

step S30, determining a target data type corresponding to the identification data according to the mapping relation;

in this embodiment, the lot number includes data for identifying the action performed by the lot, the equipment memory stores identification data corresponding to each data type, for example, the end of the number is a, which indicates that the lot is a spare and warehouse entry, and the mapping relationship between the target data and the data type is one-to-one, for example, the a corresponds to the spare and warehouse entry data type, the B corresponds to the warehouse inventory data type, and the data type may include spare and warehouse entry data, warehouse inventory data, return and warehouse entry data, order removal data, transfer data, delivery and warehouse exit data, and the like.

The lot number data may also include identification data that does not belong to preset identification data, which indicates that the lot is not of a data type that can be automatically processed, and an error report may be generated for manual verification by business personnel.

In this embodiment, before header record generation is performed on the FBA inventory ledger data, the data type of the FBA inventory ledger data needs to be determined, so that different header processing methods are adopted for different services, the problem that a large amount of manpower resources are consumed for manually checking the data type is avoided, and the automatic classification processing of the data by adopting a program greatly improves the processing efficiency and accuracy.

Step S40, adjusting the header record data stored in the preset fourth storage space according to the target data type, the number of goods and the adjustment operation set stored in the preset third storage space, where the header record data includes a plurality of first header batch record data and header cost data corresponding to each of the first header batch record data, and the first header batch record data includes a batch header number.

In this embodiment, the preset first storage space, the preset second storage space, the preset third storage space, and the preset fourth storage space may be storage spaces allocated for storing the data in the terminal device, and the form and size of the storage spaces may be determined according to actual situations, which is not limited herein.

In this embodiment, since the conventional method for generating the head after checking is confirmed by the stock order merchant, the head calculation under different scenes is not considered, resulting in inaccurate head number and cost calculation.

Therefore, in this embodiment, in order to solve the above-mentioned problem, different header processing methods are adopted for different data types, so as to cover the problem of header calculation in multiple scenarios, and based on the data types of the FBA inventory ledger data, a corresponding header processing method is adopted to generate a header record, so as to increase the coverage of header calculation and further improve the accuracy of header calculation.

Specifically, the system acquires real-time data of the FBA inventory ledger data through the interface, and calculates the head amount according to the data type of the FBA inventory ledger data, compared with the head amount which is calculated after the conventional stock order is shipped, the head amount is the shipping amount, in the present application, the system judges according to Amazon inventory classification, and the head amount is based on the actual Amazon FBA warehouse receiving amount. The time for generating the head and the batch quantity of the head are more accurate. In addition, in the conventional header calculation method, the system only performs header batch number calculation according to customer order ex-warehouse, but the actual FBA inventory deduction types include various: customer order dish shipment, remove order destruction, remove the shipment, warehouse inventory depletion shipment, warehouse transfer shipment these, in addition the shop is unauthorized or authorized to lose efficacy probably to lead to corresponding customer order stock quantity deduction untimely, the manual work needs to consume a large amount of time to carry out repeated correction, still probably produce the mistake in the correction process, finally lead to quantity calculation inaccurate, therefore dock Amazon's stock ledger, automatic according to the shipment detail that stock ledger returned carries out the head stroke quantity deduction efficiency higher and more accurate.

Further, based on the first embodiment of the FBA header management method of the present application described above, a second embodiment of the FBA header management method of the present application is proposed.

In a second embodiment of the FBA header management method of the present application, the target data types include: the stock warehouse entry data type, the FBA stock ledger data further comprises: the FBA prepares the cargo ID of the cargo;

in the step S40, the step of adjusting the header record data stored in the preset fourth storage space according to the target data type, the number of the goods and the adjustment operation set stored in the preset third storage space includes:

step A10, when the data type is a stock-in data type, determining a target adjustment operation corresponding to the stock-in data type in a set of adjustment operations stored in a preset third storage space, wherein the target adjustment operation is to increase head record data stored in a preset fourth storage space;

step A20, newly creating first head batch record data, and assigning the value of the goods quantity to the batch head quantity in the new first head batch record data;

step A30, searching first head cost data corresponding to a single SKU in a stock order corresponding to the goods ID, and calculating the head cost data according to the first head cost data and the batch head number;

And step A40, storing the new first head batch record data and the head expense data in the head batch record data in a correlated way so as to execute the operation of adding the head batch record data stored in the preset fourth storage space.

In this embodiment, the cargo ID (identity number, identity document) refers to the identity of the cargo, and has uniqueness, and SKU (minimum stock unit, stock Keeping Unit) is the minimum unit of cargo count, such as a piece, a bag, and the like.

In this embodiment, please refer to fig. 4, fig. 4 is a flowchart related to a second embodiment of the FBA header management method of the present application, as shown in fig. 4, when header calculation is performed on a stock-in-stock, FBA inventory ledger data is first obtained, then it is determined whether the data type of the FBA inventory ledger data is the in-stock type of the FBA stock-in, if so, a header batch record data is generated, the header of the batch of the stock is recorded, the value of the stock quantity is assigned to the batch header quantity, then the header cost data of each SKU of the stock is obtained through the FBA stock-in-stock ID, the header cost data of the batch can be calculated according to the header cost data of each SKU of the stock and the header quantity of the batch, and then the obtained cost is returned to the customer order, which is convenient for the business personnel to check, and the header record data and the header cost data are added into the system. Therefore, the problem of head number or time error caused by the problem in the process of stock transportation can be avoided.

The FBA warehouse stores a batch of goods, wherein the batch of goods comprises 10 goods, after FBA inventory ledger data of the goods warehouse is obtained, first head-stroke batch record data corresponding to the batch of goods is generated, the record comprises 10 head-strokes, the system can inquire head-stroke expense data of each piece of goods in the transportation process in a warehouse order through goods ID of the goods, and then the head-stroke expense data is returned to a customer order for service personnel to check.

Further, based on the first embodiment and the second embodiment of the FBA header management method of the present application described above, a third embodiment of the FBA header management method of the present application is proposed.

In a third embodiment of the FBA header management method of the present application, the target data types include: checking the data type in a warehouse;

in the step S40, the step of adjusting the header record data stored in the preset fourth storage space according to the target data type, the number of goods and the adjustment operation set stored in the preset third storage space further includes:

step B10, when the data type is a warehouse inventory data type, comparing the target head number in the head record data stored in the preset fourth storage space with the target inventory number in the FBA inventory ledger data;

Step B20, when the target stock quantity is greater than the target head quantity, determining a target adjustment operation corresponding to the warehouse inventory data type in a preset adjustment operation set stored in a third storage space, and calculating a first difference value between the target stock quantity and the target head quantity, wherein the target adjustment operation is to increase head record data stored in a preset fourth storage space;

step B30, newly creating first head batch record data, and assigning the value of the first difference value to the batch head number in the new first head batch record data;

step B40, obtaining second head cost data of the target head batch corresponding to the new first head batch record data;

and step B50, storing the new first head batch record data and the second head expense data in the head record data in a correlated way so as to execute the operation of adding the head record data stored in the preset fourth storage space.

Further, in a possible embodiment, after the step of comparing the target number of heads in the head record data stored in the preset fourth storage space with the target number of inventory in the FBA inventory ledger data in the step B10, the method further includes:

Step B60, when the target stock quantity is smaller than the target head quantity, determining target adjustment operation corresponding to the warehouse inventory data type in a centralized manner in adjustment operation stored in a preset third storage space, wherein the target adjustment operation is to deduct head record data stored in a preset fourth storage space;

step B70, determining second head batch record data with earliest time in the head record data, and calculating a second difference value between the target head number and the target stock number;

and step B80, deducting the number of head ranges equal to the second difference value from the number of head ranges of the batch of head ranges of the second head range batch record data so as to execute the deduction operation of the head range record data stored in the preset fourth storage space.

It should be noted that, in this embodiment, the target inventory number in the FBA inventory ledger data may be the inventory number in a certain period of time, or may be the inventory number of the batch, the target header number is the header number corresponding to the target inventory number, if the target inventory number in the FBA inventory ledger data is greater than the batch header number, the FBA inventory ledger data is the inventory count data, the inventory count is the phenomenon that the real number is greater than the account book inventory count or the object is not accounts when checking the property, if the target inventory number in the FBA inventory ledger data is less than the batch header number, the inventory count data is the inventory count data, and the inventory count is the phenomenon that the real number is less than the account book inventory count or the object is found in the property checking process.

In this embodiment, since the conventional head calculation is performed only when the goods are delivered, there may be a case that the number of heads is not identical to the number of goods, and thus, head adjustment is also required for the scenes of inventory and inventory. Referring to fig. 5, fig. 5 is a flowchart of a third embodiment of the FBA inventory management method according to the present application, as shown in fig. 5, when performing inventory calculation for a warehouse, FBA inventory ledger data is acquired first, then it is determined whether the data type of the FBA inventory ledger data in the FBA inventory ledger data is the type of the warehouse inventory data, and it is also required to determine whether the inventory type is inventory or inventory depletion, and when inventory is greater than the inventory, it is required to generate more than one first inventory lot record data, record the last inventory, and acquire the inventory cost data of the goods of the last inventory lot, and return the cost to the customer order. In addition, if the number of the more than one shipment is not just the last head lot, the head cost data of the last head lot is sequentially acquired in the order from near to far in time. Similarly, when inventory is smaller than the number of heads, the heads need to be deducted, and the earliest head batch record, i.e. the number of heads equal to the number of inventory in the second head batch record, is deleted according to time sequence. Therefore, the head calculation scene of warehouse inventory can be covered, and head quantity errors are avoided.

Illustratively, upon inventory, a greater number of 7 inventory units are inventory, a first head-end batch record is generated, the heads of the 7 inventory units are recorded, and the head-end cost data for the 7 inventory units in the last head-end batch is obtained and the cost returned to the customer order. In the case of inventory depletion, 13 inventory items are counted, and in the FBA warehouse, there are 12-month 3-day batches, wherein the remaining number of inventory items is 5, 12-month 4-day batches, wherein the remaining number of inventory items is 10, 12-month 5-day batches, wherein the remaining number of inventory items is 10, wherein the 12-month 3-day batch is the one with the earliest remaining number, and in the case of deducting the head, the first-day batch is deducted from the 12-month 3-day batch, and after 5 pieces are deducted, the other 8 pieces are deducted from the current earliest remaining number, namely the 12-month 4-day batch.

Further, based on the first embodiment, the second embodiment, and the third embodiment of the FBA header management method of the present application described above, a fourth embodiment of the FBA header management method of the present application is proposed.

In a fourth embodiment of the FBA header management method of the present application, the target data types include: the type of data in storage;

Step C10, when the data type is a warehouse-in data type, determining a target adjustment operation corresponding to the warehouse-in data type in a preset adjustment operation set stored in a third storage space, wherein the target adjustment operation is to increase the head record data stored in a preset fourth storage space;

step C20, newly creating first head batch record data, and assigning the value of the goods quantity to the batch head quantity in the new first head batch record data;

step C30, obtaining second head cost data of the target head batch corresponding to the new first head batch record data;

and step C40, storing the new first head batch record data and the second head expense data in the head record data in a correlated way so as to execute the operation of adding the head record data stored in the preset fourth storage space.

In this embodiment, when the data type of the FBA inventory ledger data is other than the stock warehouse entry, first header batch record data is generated, the header number of the batch is recorded, header cost data of the nearest header batch is obtained according to the sequence from near to far in time, and the header cost data is returned to the customer order for the service personnel to check, wherein the warehouse entry includes the customer return warehouse entry and the transfer warehouse entry.

Further, in one possible embodiment, the target data types include: deducting the data type;

step D10, when the data type is a deduction data type, determining a target adjustment operation corresponding to the deduction data type in a set of adjustment operations stored in a preset third storage space, wherein the target adjustment operation is to deduct head record data stored in a preset fourth storage space;

step D20, determining the second head batch record data in the head record data;

and step D30, deducting the number of the head strokes which is equal to the number of the goods in the second head stroke batch record data so as to execute the operation of deducting the head stroke record data stored in the preset fourth storage space.

In this embodiment, the deduction data further includes a shipment or removal order, when the data type of the FBA inventory ledger data is the deduction data, the header is deducted, and according to the first-in first-out principle, the earliest header batch record is deleted according to the time sequence, that is, the number of the header equal to the number of the shipment or the removal of the shipment in the removal order in the second header batch record, where the shipment includes transferring shipment and order delivery shipment. Therefore, a plurality of ex-warehouse or warehouse-in head calculation scenes can be covered, and head quantity errors are avoided.

Further, in one possible embodiment, the ex-warehouse comprises: order delivery and warehouse-out data;

in the step D20, before the step of determining the second header batch record data in the header record data, the method further includes:

when the data type is order delivery ex-warehouse data, establishing order weak matching connection between the FBA inventory ledger data and an Amazon delivery report;

acquiring a platform order number from the Amazon distribution report based on the weak matching connection, and judging whether a target order corresponding to the platform order number is a multi-channel order or not;

if the target order is a multi-channel order, acquiring a tracking number in the Amazon distribution report, and acquiring a client order number associated with the tracking number in the Amazon distribution report;

and if the target order is not a multi-channel order, acquiring a client order number corresponding to the platform order number from the Amazon distribution report.

In this embodiment, the system will first match the customer order because the order dispatch ex-warehouse type of data cannot match the customer order. When matching customer orders, the amazon distribution report and the inventory ledger need to be established with an order weak matching connection, and as an example, the specific implementation logic is as follows: firstly, in the Amazon delivery report, according to the same data of SellerID (Amazon seller number), amazon-order-id (platform order number), shift-date (delivery time), SKU (channel SKU), shift-count (delivery country), full-center-id (Amazon operation center id), tracking-number (tracking number), it is required to collect quality-delivery data first, and because the order delivery platform generates a plurality of delivery report data, the system needs to collect all delivery data first and then de-match; then, a weak matching relationship is established again with respect to SellerID, fulfillment-center-id, shift-Date, estimated-arrival-Date range (estimated arrival Time), SKU, number in the matching Amazon distribution report, using the SellerID, fulfillment Center (Amazon operation center), date and Time (inventory ledger generation Time), MSKU (channel SKU), quality (number of in-warehouse) in the inventory ledger details of the order distribution.

After matching the order, the system finally judges whether the amazon-order-id is a multi-channel order, wherein the platform order number of the multi-channel order is S0 at the beginning, so if the order number is S0 at the beginning, the system judges that the order is the multi-channel order, and if the order is the multi-channel order, the system can de-associate the client order number through a tracking-number; if not a multi-channel order, the system then disassociates the client order number of the Amazon platform through the Amazon-order-id.

Finally, the system deducts the head number of the lot with the earliest remaining number, and ensures that each customer order can obtain accurate head calculation cost according to the first-in first-out rule.

In addition, the names of the above fields may be displayed differently in different systems or different reports, without affecting the specific meaning of the fields.

Further, based on the first embodiment, the second embodiment, the third embodiment, and the fourth embodiment of the FBA header management method of the present application described above, a fifth embodiment of the FBA header management method of the present application is proposed.

In a fifth embodiment of the FBA header management method of the present application, the FBA header management method of the present application further includes:

step E10, acquiring inventory ledger data input by an Amazon platform, wherein the inventory ledger data records the total inventory quantity in an FBA warehouse in a report form;

In this embodiment, the header data correction may be performed once every month No. 1, that is, the inventory ledger general ledger is downloaded with every system No. 1, and the time point is not limited herein.

Step E20, comparing the total stock quantity with the total head quantity in the head record data, and calculating a target absolute value of a difference value between the total stock quantity and the total head quantity;

step E30, if the total number of the stock is smaller than the total number of the head strokes, determining the second head stroke batch record data in the head stroke record data, and deducting the head stroke number equal to the target absolute value from the second head stroke batch record data so as to deduct the head stroke record data stored in a preset fourth storage space;

and E40, if the total stock quantity is larger than the total head quantity, newly creating first head batch record data, assigning the value of the target absolute value to the batch head quantity in the new first head batch record data, acquiring second head cost data of a target head batch corresponding to the new first head batch record data, and storing the new first head batch record data and the second head cost data in the head batch record data in an associated mode so as to increase the head record data stored in a preset fourth storage space.

In this embodiment, referring to fig. 6, fig. 6 is a flowchart related to a fifth embodiment of the FBA head management method of the present application, as shown in fig. 6, when performing head data correction, the system first obtains an inventory ledger general ledger report, then compares the inventory number in the inventory classification report with the head number in an ERP (enterprise resource planning, enterprise Resources Planning) system, if the inventory number is greater than the head number, the system automatically generates a head Cheng Pici, obtains the head cost data of the last batch, and returns the head cost data to the customer order, and if the inventory number is less than the head number, the system deducts the head cost of the batch with the earliest remaining number according to the first-in first-out principle. Therefore, the number of heads and the number of goods can be ensured to be equal, and the problem that the number of heads and the number of goods are different due to damage and loss of goods in the FBA bin is avoided.

In addition, referring to fig. 7, fig. 7 is a schematic diagram of functional modules of an FBA header management system according to the present application, and the present application further provides an FBA header management system, where the FBA header management system includes:

the data acquisition module 10 is configured to acquire FBA inventory ledger data input by the amazon platform, and store the FBA inventory ledger data into a preset first storage space, where the FBA inventory ledger data includes a number of goods and lot number data;

The type determining module 20 is configured to determine the identification data in the stored batch number data, and determine a mapping relationship between preset identification data and a data type stored in a preset second storage space; determining a target data type corresponding to the identification data according to the mapping relation;

the record adjustment module 30 is configured to adjust, according to the target data type, the number of goods, and the adjustment operation set stored in the preset third storage space, the header record data stored in the preset fourth storage space, where the header record data includes a plurality of first header batch record data and header cost data corresponding to each of the first header batch record data, and the first header batch record data includes a batch header number.

Optionally, the data types include: the target data types include: the stock warehouse entry data type, the FBA stock ledger data further comprises: the FBA prepares the cargo ID of the cargo; the record adjustment module is further configured to:

when the data type is the stock-in data type, the target adjustment operation corresponding to the stock-in data type is intensively determined in the adjustment operation set stored in a preset third storage space, wherein the target adjustment operation is to increase the head record data stored in a preset fourth storage space; newly creating first head batch record data, and assigning the value of the number of goods to the number of batch heads in the new first head batch record data; searching first head cost data corresponding to a single SKU in a stock order corresponding to the goods ID, and calculating the head cost data according to the first head cost data and the batch head number; and storing the new first head batch record data and the head expense data in the head record data in an associated mode so as to execute the operation of adding the head record data stored in the preset fourth storage space.

Optionally, the target data types include: checking the data type in a warehouse; the record adjustment module is further configured to:

when the data type is a warehouse inventory data type, comparing the target head number in the head record data stored in the preset fourth storage space with the target inventory number in the FBA inventory ledger data; when the target stock quantity is larger than the target head quantity, determining target adjustment operation corresponding to the warehouse inventory data type in a preset adjustment operation set stored in a third storage space, and calculating a first difference value between the target stock quantity and the target head quantity, wherein the target adjustment operation is to increase head record data stored in a preset fourth storage space; newly creating first head batch record data, and assigning the value of the first difference value to the batch head number in the new first head batch record data; acquiring second head cost data of a target head batch corresponding to the new first head batch record data; and storing new first head batch record data and the second head expense data in the head record data in a correlated way so as to execute the operation of adding the head record data stored in the preset fourth storage space.

Optionally, the record adjustment module is further configured to:

when the target stock quantity is smaller than the target head stroke quantity, determining target adjustment operation corresponding to the warehouse inventory data type in a preset adjustment operation set stored in a third storage space, wherein the target adjustment operation is to deduct head stroke record data stored in a preset fourth storage space; determining second head batch record data with earliest time in the head record data, and calculating a second difference value between the target head number and the target stock number; and deducting the number of the head strokes equal to the second difference value from the number of the batch head strokes of the second head stroke batch record data so as to execute the operation of deducting the head stroke record data stored in the preset fourth storage space.

Optionally, the target data types include: the type of data in storage; the record adjustment module is further configured to:

when the data type is a warehouse-in data type, the target adjustment operation corresponding to the warehouse-in data type is determined in a set of adjustment operations stored in a preset third storage space, wherein the target adjustment operation is to increase the head record data stored in a preset fourth storage space; newly creating first head batch record data, and assigning the value of the number of goods to the number of batch heads in the new first head batch record data; acquiring second head cost data of a target head batch corresponding to the new first head batch record data; and storing new first head batch record data and the second head expense data in the head record data in a correlated way so as to execute the operation of adding the head record data stored in the preset fourth storage space.

Optionally, the target data types include: deducting the data type; the record adjustment module is further configured to:

when the data type is a deduction data type, determining a target adjustment operation corresponding to the deduction data type in a set of adjustment operations stored in a preset third storage space, wherein the target adjustment operation is to deduct head record data stored in a preset fourth storage space; determining the second head batch record data in the head record data; and deducting the number of the head strokes which is equal to the number of the goods in the second head stroke batch record data so as to execute the deduction operation of the head stroke record data stored in the preset fourth storage space.

Optionally, the FBA header management system further comprises:

the head data correction module is used for acquiring inventory ledger general ledger data input by the Amazon platform, wherein the inventory ledger general ledger data records the total inventory quantity in the FBA warehouse in a report form; comparing the total stock quantity with the total head quantity in the head record data, and calculating a target absolute value of a difference value between the total stock quantity and the total head quantity; if the total stock quantity is smaller than the total head quantity, determining the second head batch record data in the head record data, and deducting the head quantity equal to the target absolute value from the second head batch record data so as to deduct the head record data stored in a preset fourth storage space; if the total stock quantity is larger than the total head quantity, newly creating first head batch record data, assigning the value of the target absolute value to the batch head quantity in the new first head batch record data, acquiring second head cost data of a target head batch corresponding to the new first head batch record data, and storing the new first head batch record data and the second head cost data in the head batch record data in an associated mode so as to increase the head record data stored in a preset fourth storage space.

The specific implementation manner of the FBA header management system in the present application is substantially the same as that of each embodiment of the above-mentioned FBA header management method, and will not be repeated here.

Furthermore, the present application proposes a storage medium, which is a computer-readable storage medium, on which a computer program is stored, which computer program, when being executed by a processor, implements the steps of the FBA header management method of the present application as described above.

The specific embodiments of the storage medium in the present application are substantially the same as the embodiments of the FBA header management method described above, and are not described herein.

It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.

The foregoing embodiment numbers of the present application are merely for describing, and do not represent advantages or disadvantages of the embodiments.

From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk), comprising several instructions for causing a terminal device (which may be a mobile phone, a computer, a server, etc.) to perform the method described in the embodiments of the present application.

The foregoing description is only of the preferred embodiments of the present application, and is not intended to limit the scope of the claims, and all equivalent structures or equivalent processes using the descriptions and drawings of the present application, or direct or indirect application in other related technical fields are included in the scope of the claims of the present application.

Claims

1. An FBA header management method, comprising:

2. The FBA header management method according to claim 1, wherein the target data type comprises: the stock warehouse entry data type, the FBA stock ledger data further comprises: the FBA prepares the cargo ID of the cargo;

3. The FBA header management method according to claim 2, wherein the target data type comprises: checking the data type in a warehouse;

4. The FBA header management method according to claim 3, further comprising, after the step of comparing a target number of header pieces in header record data stored in a preset fourth storage space with a target number of inventory in the FBA inventory ledger data:

5. The FBA header management method according to claim 4, wherein the target data type comprises: the type of data in storage;

6. The FBA header management method according to claim 5, wherein the target data type comprises: deducting the data type;

determining the second head batch record data in the head record data;

7. The FBA header management method according to claim 6, characterized in that the method further comprises:

8. An FBA header management system, wherein a set of adjustment operations and header record data of an FBA warehouse are stored in the FBA header management system, the FBA header management system comprising:

9. An FBA header management apparatus, characterized in that the FBA header management apparatus comprises: memory, a processor, wherein the memory has stored thereon a computer program which, when executed by the processor, implements the steps of the FBA header management method as claimed in any one of claims 1 to 7.

10. A storage medium, characterized in that the storage medium is a computer-readable storage medium, on which a computer program is stored, which computer program, when being executed by a processor, implements the steps of the FBA header management method according to any one of claims 1 to 7.