CN116308670A

CN116308670A - Method and system for supplementing goods based on appointed delivery time

Info

Publication number: CN116308670A
Application number: CN202310311276.0A
Authority: CN
Inventors: 王志超; 卢东辉; 胡伟; 陈寿宝; 王振
Original assignee: Shenzhen Meiyunji Network Technology Co ltd
Current assignee: Shenzhen Meiyunji Network Technology Co ltd
Priority date: 2023-03-21
Filing date: 2023-03-21
Publication date: 2023-06-23

Abstract

The application discloses a method for supplementing goods based on appointed delivery time, which comprises the steps of obtaining FBA inventory data of goods and setting delivery logistics and logistics time length of the goods sent to an FBA warehouse from a pre-stored warehouse; setting average daily sales, interval days and safety days of the commodity, and enabling the sum of the interval days and the safety days to be multiplied by the average daily sales to be equal to the target inventory; setting designated commodity delivery time t and calculating corresponding replenishment quantity Nt, wherein the replenishment quantity Nt refers to the commodity replenishment quantity required by the FBA when the commodity replenished at time t arrives at the FBA warehouse and the stock quantity of the FBA is equal to the target stock Q6; and generating a replenishment suggestion according to the delivery time t and the corresponding replenishment quantity Nt, or determining a suggested replenishment quantity Nj according to the replenishment quantity Nt and the logistics duration, and then generating the replenishment suggestion according to the suggested replenishment quantity Nj. The algorithm and the corresponding system can restock or splice goods without being lower than the safety stock, so that the number of restocking of single goods each time can be reduced, and the logistics cost and the stock cost are reduced.

Description

Method and system for supplementing goods based on appointed delivery time

Technical Field

The present disclosure relates to the field of computer technologies, and in particular, to a commodity replenishment method based on target inventory, a replenishment method based on multiple commodities, a replenishment method based on specified delivery time, and systems corresponding to the methods.

Background

With the rise of global electronic commerce, international retail trade is rapidly developed, a large number of domestic small and medium-sized electronic commerce sellers expand retail business to foreign markets, and a large number of domestic high-quality and low-cost commodities are sold to foreign markets through foreign electronic commerce platforms (such as Amazon, yi Bei ebay, shopping interest Wish, dried small shrimps Shupe, lazada and the like). With the development of cross-border business, an e-commerce ERP system (which may be simply referred to as "e-commerce ERP", "ERP system" or "system") developed based on ERP software is gradually developed. The electronic commerce ERP system can be deeply connected with the electronic commerce platform, so that middle and small electronic commerce sellers in China can be helped to uniformly manage overseas shops, the obstacle caused by language difference is solved, one operator can manage hundreds of electronic shops at the same time, and the operation efficiency of the shops is greatly improved.

The e-commerce ERP system accesses and controls a store of the e-commerce platform through a set rule, processes dynamic data of each link of store operation, manages numerous and complicated data, and meets the operation convenience requirements of multiple types of users (sellers); therefore, all functional modules of the existing commercial ERP system are in the stage of gradually updating and perfecting functions, the function algorithms and rules formulated by all software enterprises when the software enterprises develop from the ERP system of the household appliances are basically different, and all functional modules continuously develop new versions along with the change of the user demands so as to be compatible with more use scenes.

Taking an ERP system for managing Amazon E-commerce platform shops as an example, the FBA replenishment suggestion module calculates proper replenishment time and replenishment quantity according to sales volume data, warehouse data, logistics aging and other data of the commodities, and provides the replenishment time and replenishment quantity for operators in a replenishment suggestion mode; the replenishment proposal is closely related to commodity, sales, purchasing, logistics and warehouse data, is an important link of the commodity sales and stock management of the electronic commerce, and can lead to commodity sales and stock interruption when the replenishment is not timely carried out, and more stock expenses (such as purchasing expenses and warehouse costs) are required to be input when the replenishment quantity is too large, so that the fund operation efficiency is reduced.

The replenishment proposal of the existing ERP system mainly supplements the goods according to a fixed replenishment period, and when the stock of the FBA warehouse is lower than the safety stock, replenishment quantity= (logistics ageing + safety days + replenishment period) daily average sales quantity-FBA stock is started, and the periodic replenishment mode has strong time concept, is convenient for taking the fixed ship period of the cross-border logistics as the delivery time of the replenishment, and realizes regular replenishment. However, the periodic replenishment method cannot flexibly adjust the replenishment date and the replenishment quantity corresponding to different dates, is generally applicable to only commodity with stable sales (commodity of fine type), the method is not suitable for the new online commodity with unstable sales volume, and the commodity with large whole sales volume but small single commodity sales volume (commodity of shop type); in addition, the replenishment proposal of the existing ERP system usually reminds replenishment on the replenishment day, and the replenishment is required to be performed immediately on the replenishment day of the proposal of the replenishment proposal, so that the replenishment rhythm is inconvenient for operators to control; the number of restocking recommendations currently available may include sales of merchandise during logistical aging, resulting in multiple restocking of merchandise.

In addition, when the current replenishment suggestion calculates the replenishment date and the replenishment quantity, the influence of factors such as the lowest delivery amount, the lowest purchase amount, the purchase time length and the logistics time length of a delivery object stream on the replenishment cannot be considered in a targeted manner, so that the replenishment suggestion and the actual delivery scene have large deviation, a delivery plan and a purchase plan cannot be directly generated, and manual correction is needed.

The conventional replenishment proposal mainly calculates the delivery time and replenishment quantity of a single commodity, and cannot simultaneously replenish a plurality of commodities and give corresponding proposal. In addition, the existing restocking advice is typically restocking according to the time when the FBA inventory is lowered to the safety inventory or restocking based on a fixed period, and cannot be delivered in advance or delayed, nor can the corresponding restocking quantity advice be given according to the delivery time t specified by the user.

Other technical problems related to the present application are further described below. The foregoing is merely provided to facilitate an understanding of the principles of the present application and is not intended to represent all of the prior art.

Disclosure of Invention

The main purpose of the application is to provide a commodity replenishment method and an electronic commerce ERP system based on target stock quantity, so that commodity replenishment cost is reduced, flexibility of commodity replenishment of shops is improved, and commodity replenishment advice can be suitable for commodity replenishment of shop type. In addition, the application also provides a method and a system for supplementing goods based on a plurality of commodities, and a supplementation suggestion is provided for the goods splice or simultaneous supplementation of the plurality of commodities; and providing a replenishment method based on the designated delivery time and a system thereof, which are used for providing corresponding replenishment advice when the user designates the delivery time.

In order to achieve the above objective, the present application proposes a commodity replenishment method based on target inventory, which is used for a replenishment suggestion module of an e-commerce ERP system or an e-commerce platform system, and is characterized in that the replenishment method comprises the following steps:

step S1: acquiring data access rights of store commodities and acquiring FBA inventory data of the commodities, wherein the FBA inventory data comprises FBA inventory Q1, FBA in-stock quantity Q11 and FBA in-transit quantity Q12 at the current time T0, and setting a shipping stream of the commodities from a pre-stored warehouse to the FBA warehouse and a logistics duration T2 of the corresponding shipping stream;

step S2: setting daily average sales quantity X and safety days T32 of the commodity, and taking the product of the safety days T32 and the daily average sales quantity X as a safety stock Q5 of the commodity; setting the interval number of days T31 or the target inventory Q6 of the commodity, so that the sum of the interval number of days T31 and the safety number of days T32 multiplied by the average daily sales X is equal to the target inventory Q6, wherein the interval number of days T31 is used for adjusting the delivery frequency of the commodity replenishment, and the target inventory Q6 is constant and larger than the safety inventory Q5;

step S3: calculating a temporary replenishment date tx of the commodity sent to the FBA warehouse from a pre-stored warehouse based on the FBA inventory Q1, the safety inventory Q5, the daily sales volume X and the logistics time length T2, wherein the temporary replenishment date tx refers to the replenishment time of the replenishment commodity just reaching the FBA warehouse on the day when the FBA inventory Q1 is lowered to the safety inventory Q5, and the FBA inventory Q1 lowers the daily sales volume X daily;

Step S4: calculating temporary replenishment quantity Nx based on target inventory Q6 of the commodity, temporary replenishment date tx, daily average sales quantity X and logistics duration T2, wherein the temporary replenishment quantity Nx refers to the commodity replenishment quantity required by the FBA on the day when the commodity arrives at the FBA bin and is equal to the target inventory Q6 in the inventory quantity Q11;

step S5: generating a replenishment suggestion A according to the temporary replenishment date tx and the temporary replenishment quantity Nx, and generating a delivery suggestion according to the temporary replenishment date tx and the temporary replenishment quantity Nx by the replenishment suggestion A;

or further determining the recommended replenishment date tj according to the temporary replenishment quantity Nx, determining the recommended replenishment quantity Nj according to the recommended replenishment date tj, and generating a replenishment recommendation B according to the recommended replenishment date tj and the recommended replenishment quantity Nj.

Additional features and technical effects of the present application are set forth in the description that follows. The technical problem solving thought and related product design scheme of the application are as follows:

in order to reduce the stock cost of goods, the current common solution is to improve the estimated accuracy of average sales on daily or reduce the number of safety days so as to reduce the number of goods for additional stock, and the scheme is difficult to accurately control the stock number of goods for paving goods with unstable sales. The applicant finds that by increasing the delivery frequency of the commodities, the commodities for stock can be controlled to arrive at the FBA warehouse in batches after delivery, so that the commodities for delivery are controlled to be in an in-transit state most of the time, the quantity of the commodities stored in the FBA warehouse after actual delivery is small, namely, the in-transit quantity of the FBA is larger than the in-transit quantity of the FBA, and the storage quantity of the commodities in the warehouse can be reduced by controlling and increasing the delivery frequency.

Based on the strategy for improving the delivery frequency, the applicant puts forward the concepts of interval days and target inventory, and the estimated sales of commodities in interval days and safety days are used as the target inventory, so that the replenishment quantity is determined according to the unified target inventory every time. The number of days of the interval refers to the estimated interval time of two adjacent shipments when the commodity is shipped by a certain stream, and the estimated interval time is used as the initial reference time of commodity shipment. The number of days of interval is used for adjusting the delivery frequency of the replenishment; for the same logistics, the number of interval days is generally set to be constant, and the smaller the number of interval days is, the higher the shipping frequency required for the commodity is, and the larger the number of interval days is, the lower the shipping frequency required for the commodity is. The number of days of the interval is the interval time between two shipments of the commodity before and after the commodity in an ideal state, and the shipment time of each commodity in an actual scene can be changed and calculated based on the target inventory.

The method comprises the following steps: setting smaller interval days (the interval days are generally smaller than logistics ageing), enabling the commodity to send out relatively smaller quantity each time of replenishment, improving the replenishment frequency of the commodity, and controlling the stock quantity of the FBA after each batch of replenishment commodity reaches the FBA warehouse to be equal to the fixed target stock; the restocking date of each restocking and the interval time between restocking can also be determined by the time the FBA inventory reaches the safety inventory. The target inventory of the same commodity is a fixed constant, and the target inventory is another reference inventory index that is outside the safety inventory of the FBA warehouse. As shown in fig. 4, the target inventory is larger than the safety inventory, and the target inventory= (safety days+interval days) ×daily sales.

According to the replenishment method based on the target stock, the target stock is used as the quantity standard of each replenishment, so that the quantity of the FBA in the stock is restored to the quantity of the target stock after each replenishment, namely the FBA stock is always between the safety stock and the target stock in theory, and the accurate control of the FBA stock is enhanced. Compared with the existing replenishment proposal, the method has the advantages that the current time or the future time can be flexibly selected as the replenishment time based on the replenishment proposal of the target inventory, and the corresponding commodity replenishment quantity is calculated; the time for the commodity to reach the FBA bin can be controlled according to the logistics ageing of each commodity delivery logistics and the corresponding interval days, the delivery time interval of two commodity replenishment before and after is shortened, the actual storage quantity of the commodity in the FBA bin is reduced, the commodity preparation cost is greatly reduced, the risk of commodity breakage is reduced, and the recovery time of the commodity breakage is shortened; after the commodity replenishment time is flexibly adjusted, different commodities can be spliced and shipped on the same day, so that the replenishment method can be suitable for commodity replenishment of a shop type (namely a shop type with a large commodity variety and a small single commodity sales amount) and new online commodity replenishment with unstable sales amount, and is suitable for operation and use of novice users. On the other hand, as the new proposal is more timely for replenishment, the original interval days and the safety days can be set lower when the basic parameters of commodity replenishment advice are set, thereby further reducing the quantity of the FBA warehouse for commodity. The influence of the estimated deviation of the average daily sales on the recommended replenishment quantity is reduced. Other embodiments and technical effects are set forth below.

Further, the application also provides a commodity replenishment method based on a plurality of commodities and a corresponding system, which are used for a replenishment suggestion module of an e-commerce ERP system or an e-commerce platform system, and the commodity replenishment suggestion module comprises the steps of adding commodities needing replenishment to a replenishment suggestion list, setting the logistics duration T2 and the minimum delivery amount N5 of each commodity, selecting the delivery time td, taking the commodity delivered in the current day td as the commodity to be spliced, calculating the total replenishment amount Nd of the commodity to be spliced, and generating a replenishment suggestion when Nd is more than or equal to N5; when Nd is smaller than N5, taking the commodity shipped after td time as a pre-assembled commodity, and determining the commodity needing to be assembled according to the assembled priority level of each pre-assembled commodity; and when the total replenishment quantity of all the goods to be spliced and the pre-spliced goods at the time td is still smaller than N5, delaying the delivery time td until the total delivery quantity of the goods to be spliced and the pre-spliced goods is more than or equal to N5, and then generating replenishment advice.

Specific embodiments are set forth below. Compared with the prior replenishment suggestion module, the replenishment time and replenishment quantity of single commodities can be calculated, and the replenishment of a plurality of commodities can not be performed simultaneously. Therefore, each replenishment of single commodity can be less than the minimum delivery amount N5, so that the user can select the logistics with low speed, multiple minimum starting amount and low freight cost while reducing the commodity replenishment amount, and the replenishment cost is greatly saved. The goods are delivered by adopting the goods splicing mode, so that the integral goods supplementing frequency of the goods is improved, the delivery quantity of single goods in batches can be reduced, and the single goods cannot reach the lowest delivery quantity of logistics and are delivered in a delayed mode. The replenishment method based on the plurality of commodities can replenish or splice the commodities without being lower than a safety stock, so that most of the commodities can be shipped every day.

Further, the application also provides a replenishment method and a replenishment system based on the appointed delivery time, wherein the replenishment proposal module is used for the e-commerce ERP system or the e-commerce platform system, and corresponding replenishment proposal is provided after the user appoints the delivery time. The technical scheme idea of replenishment based on appointed delivery time is that the commodity delivery quantity Nt at each appointed delivery time t is determined based on a target inventory Q6, and the commodity replenishment method comprises the steps of acquiring FBA inventory data of the commodity and setting delivery logistics and logistics time length of the commodity sent to an FBA warehouse from a pre-stored warehouse; setting average daily sales, interval days and safety days of the commodity, and enabling the sum of the interval days and the safety days to be multiplied by the average daily sales to be equal to the target inventory; setting designated commodity delivery time t and calculating corresponding replenishment quantity Nt, wherein the replenishment quantity Nt refers to the commodity replenishment quantity required by the FBA when the commodity replenished at time t arrives at the FBA warehouse and the stock quantity of the FBA is equal to the target stock Q6; and then generating a replenishment proposal according to the delivery time t and the corresponding replenishment quantity Nt. Specific embodiments are set forth below.

The replenishment method based on the appointed delivery time can replenish or splice goods without being lower than the safety stock, so that most goods can be delivered every day; because the goods are restocked at the appointed delivery time in the future, various goods to be restocked can be uniformly delivered, the number of each restocking of a single commodity is reduced through commodity combination, the time of twice delivery of the commodity before and after the commodity is shortened, and the logistics cost and the stock cost are correspondingly reduced.

The replenishment suggestion module of the present application may be used in an e-commerce ERP system or an e-commerce platform system (e.g., amazon, ariba, yi Bei, etc. e-commerce platform systems) to execute the operation instructions included in each algorithm of the replenishment suggestion module.

Further, the application also provides a server, the server comprises a memory, a processor, the replenishment suggestion module and the system thereof are stored in the memory, and the processor can run operation instructions and corresponding algorithms of the replenishment suggestion module and the system thereof.

Further, the application also provides a computer device, which comprises a memory and a processor, wherein the replenishment suggestion module and the system thereof are stored in the memory, and the processor can run the operation instructions of the e-commerce ERP system and execute the function implementation method of each function module.

The following is stated: for simplifying the description, the application mainly describes related technical schemes based on an Amazon platform, and it is to be noted that the e-commerce platform related to the application can be other e-commerce platforms besides Amazon. Referring to fig. 1, the e-commerce ERP system of the present application includes one or more of a commodity module, a sales module, a purchasing module, a logistics module, a warehouse module, a financial module, an advertisement module, a customer service module, a tool module, a rights management module, a data module, and other functional modules, where each functional module may be mutually fused, may also exist independently, or may be a sub-module of one functional module as another functional module. Operators of the ERP system of the present application may also be referred to as store managers, sellers, operators, or users, whose identity is not strictly defined unless specifically stated.

In the application, the names of the days, the delivery period, the duration, the aging period and the like are all industry habitual names, and all represent the meaning of the duration, such as safety days, interval days, saleable days, purchasing delivery period, purchasing duration, stock aging period and the like, and the default time unit is the day; when the actual application scenario involves other time units, the other time units may be converted into days or days may be converted into other time units. In the application, the term "shipping" and the term "replenishment" are both industry habitual names and have the same meaning.

The future time t in the present application may include the time of day of the calculation, because the time of day of the calculation has not yet ended, the sales data of the day of the calculation has not yet come out, and the sales of the day may be regarded as future sales data. In this application, "commodity" and "product" are both commonly referred to in the art, and the meaning of the two are the same and are not distinguished.

Meaning and description of e-commerce domain nouns in this application (letters other than english words and field symbols in this application are case-insensitive):

(1) FBA (Fulfilment by Amazon) is that the seller sends the commodity to the Amazon operation center, the Amazon is responsible for storing and managing the commodity, picking up and packaging the commodity, providing quick delivery and providing service related to returning and changing the commodity; in the application, the FBA generally refers to that a seller transports goods to an e-commerce platform operation center, and the e-commerce platform is responsible for providing relevant services such as inventory management, packaging, distribution, customer service and the like; correspondingly, in the present application, the FBA warehouse generally refers to an e-commerce platform warehouse (i.e., an e-commerce platform operation center warehouse).

(2) The local warehouse is a warehouse of a commodity purchasing place, delivery and quality inspection are completed in the local warehouse after commodity purchasing, and if the seller finishes purchasing the commodity and directly delivers the commodity from the supplier warehouse, the supplier warehouse is the local warehouse; overseas bins refer to transit warehouses close to the FBA bins, sellers store commodities in the overseas bins in advance, and when the FBA bins are out of stock, the overseas bins can be shipped to the FBA bins, so that the replenishment time of the FBA bins is shortened, and the storage cost is reduced; the local bin and the overseas bin are both pre-stored warehouses of the commodity; when the local warehouse comprises a plurality of warehouses at different positions, the commodities in the warehouses can be summarized to one of the local warehouses, and then the warehouses are uniformly shipped from the summarized local warehouse, and because the logistics ageing among the local warehouses is generally within 1 day or within 2 days, the time is short, when the commodity is shipped from the local warehouses, the commodity replenishment proposal can be calculated according to only one local warehouse.

(3) The head process refers to a transportation process of sending commodities from a local warehouse to an FBA warehouse or from the local warehouse to an overseas warehouse; the in-transit refers to a physical distribution state in which the commodity is still in transit after shipment and has not yet reached the destination warehouse.

(4) ERP (Enterprise Resource Planning) is enterprise resource planning, and may also be referred to herein as ERP systems.

(5) ASIN (Amazon standard identification number) is the commodity number of the amazon platform, which in this application may be broadly referred to as the commodity number of the e-commerce platform; SKU (Stock Keeping Unit) refers to inventory commodity codes; SPU (Standard Product Unit) the standardized product units; MSKU (Merchant Stock Keeping Unit) refers to online commodity coding.

(6) The ideal state is the replenishment state of the commodity, such as abundant inventory, consistent actual sales and daily sales X, on-time delivery and arrival of the commodity, no shortage and disconnection.

(7) Other nouns are explained in the following table (table one):

sequence number	Field name	Field symbol	Field description
				1	Historical sales	X1	Refers to the historical daily sales of commodities Magnitude.
2	Estimating sales	X2	Based on historical sales or Historical sales and denoising pins Estimating the future of the commodity Daily sales for a certain period of time Values.
				3	Noise reduction sales	X3	Means that the commodity is at a certain time History pin in inter-range After denoising the amount Daily sales value of (3).
4	Average sales	X	Refers to a future time period Averaging of in-estimated sales Values.
				5	FBA inventory	Q11	Finger has arrived and stored Number of goods in FBA bin Amount of the components.
6	FBA on-road volume	Q12	The finger has been sent to the FBA bin Is used for determining the quantity of the goods in transit, Comprising a slave local bin and- Or overseas warehouse to FBA Number of articles in transit in the warehouse Amount of the components.
				7	FBA inventory	Q1	FBA inventory = FBA in Pool + FBA in-transit volume
8	Availability of current FBA inventory Days of sale	T41	Commodity at present time FBA inventory on average Quantitative calculated FBA Inventory of days available for sale when Front FBA inventory marketable Days = FBA inventory/day Average sales
				9	Days of safety	T32	Finger FBA bin commodity security Days available for sale as defending Article breaking in FBA warehouse While the buffer is set A compartment; when the commodity is available for sale Days less thanDays of safety At this time, the commodity starts replenishment.
10	Days of interval	T31	Means that something is adopted by the commodity Adjacent two times during stream delivery At the predicted intervals of delivery At the expected interval Interval as goods delivery Initial reference time, interval Day-to-day number for regulating quotient Delivery frequency of product replenishment The rate.
				11	Safety stock	Q5	Safety stock = safety Day average sales
12	Target inventory	Q6	Target stock= (safety) Days + days of interval) Average sales
				13	Current date	t0	Day referring to the current time And (5) a period.
14	Expiration date for sale	t05	Marketable expiration date = Current date + current Marketable days of FBA inventory Number of digits
				15	Overseas bins can be used	Q32	Means that it has arrived overseas A bin and can be used for sending to Goods of any destination Stock quantity.
16	Overseas warehouse occupancy	Q31	Means that it has arrived overseas Warehouse and has determined delivery Commodity inventory of destination Amount of the components.
				17	Overseas warehouse in transit	Q33	Refers to the product which is sent to overseas Number of articles in transit in the warehouse Amount of the components.
18	Overseas warehouse stock	Q3	Overseas warehouse inventory = overseas Cabin occupation + overseas cabin Use + overseas warehouse in transit
				19	When overseas is used for sending out FBA Long length	T22	Delivery to overseas warehouse The length of time required for the FBA cartridge, the unit is day.
20	Overseas warehouse to FBA shipment Day of the day	tn3	Refers to the distribution of goods from overseas cabins Delivery date to FBA warehouse And (5) a period.
				21	Overseas warehouse quantity of FBA warehouse	N3	Refers to the distribution of goods from overseas cabins Shipping number to FBA warehouse Amount of the components.
22	Local bin availability	Q22	Meaning that it has arrived at the local site A bin and can be used for sending to Goods of any destination Stock quantity.
				23	Local bin occupancy	Q21	Meaning that it has arrived at the local site Warehouse and has determined delivery Commodity inventory of destination Amount of the components.
24	Purchasing plan amount	Q231	Meaning that the operator has already Placing an order to a supplier and number of goods not yet shipped Amount of the components.
				25	Purchasing on-road quantity	Q232	Refers to from a supplier warehouse Goods to local warehouse The number of outstanding goods.
26	Quality to be checked	Q233	Refers to from a supplier warehouse To the local siteGoods in the warehouse Has arrived and has not been completed Number of quality checks.
				27	Quantity to be processed	Q234	Refers to from a supplier warehouse Processing to local warehouse The goods are already arrived and the quality is good Checking is completed and has not been completed Number of processes.
28	Local warehouse in transit	Q23	Local warehouse on-way = procurement Planning quantity + purchasing in-transit Quantity+quantity to be inspected+added Work load
				29	Local warehouse storage	Q2	Local bin inventory = local Warehouse occupancy + local warehouse Amount of processing to be performed
30	Time length of purchase plan	T11	Refers to purchasing personnel ordering Required for the supplier to receive the order Duration of time, default unit is A day; time length of purchase plan Can be in commodity module Set up or set up in lists of goods And (5) modifying.
				31	Purchasing date	T12	Refers to shipping from suppliers When needed to the local bin Long (including generation and other links) Time), default unit is And (3) days.
32	Duration of quality inspection	T13	Refers to purchasing goods to get to the goods (after arriving at the pre-store warehouse) When required for quality inspection Long, the default unit is day.
				33	Processing time length	T14	Quality control for arriving goods Post-commodity further processing (e.g. labelling, repackaging) Fitting etc.) for a desired period of time, the default unit is day.
34	When the local bin sends out overseas bin Long length	T21	Refers to local warehouse delivery to sea The length of time required by the outer bin, the default unit is day.
				35	When the local warehouse sends out the FBA warehouse Long length	T22	Indicating local warehouse delivery to The length of time required for the FBA cartridge, The default unit is day.
36	Single lowest purchase quantity	N4	Refers to every time a commodity is allowed The most purchased from the supplier Small order quantity.
				37	Minimum delivery volume	N5	Refers to every time a commodity is allowed Delivery from a pre-stored warehouse The starting amount of the material flow.
38	Local hair overseas hair Goods day	tn2	Refers to local warehouse distribution of commodity Delivery date to overseas warehouse And (5) a period.
				39	Local hair FBA hair Goods day	tn1	Refers to local warehouse distribution of commodity Delivery date to FBA warehouse And (5) a period.
40	Local hair overseas amount	N2	Refers to local warehouse distribution of commodity Shipping number to overseas warehouse Amount of the components.
				41	Local hair-warehouse FBA warehouse quantity	N1	Refers to local warehouse distribution of commodity Shipping number to FBA warehouse Amount of the components.
42	Suggesting date of purchase	t01	I.e. when starting purchasing Suggesting purchasing date as Subtracting the local warehouse shipping date Time of acquisition of time length of purchase Between, or suggest purchases The day is the current time.
				43	Suggesting minimum purchase quantity	N6	Indicate that a certain replenishment proposal is needed Suggested acquisition when to be purchased Number of purchased goods.
44	Time of purchase	T1	Purchasing duration = purchasing meter Time length of drawing + purchasing date of delivery + Duration of quality inspection
				45	Period of stock	T	Stock cycle = time of purchase Length + length of stream + vending Duration when no purchase is needed And when the purchasing time is zero.
46	Logistics duration	T2	Refers to commodity from pre-store bin Required for warehouse delivery to FBA warehouse Is pre-stored with the logistics time length of (2) The warehouse comprises a local warehouse And/or overseas bins.
				47	Current FBA inventory arrival Safety stock for vending days Number of digits	T42	FBA referring to the current time Inventory Q1 arrives at secure warehouse Commercial products available when Q5 is stored Days, t42=q1/X- T32
48	Current time of	t0	When the restocking is currently calculated Relative to future time t In other words, the current time is t Time of =0.
				49	Future time of day	t	Refers to after the current time No time occurred.
50	Stock ageing	T4	Stock time-effect = purchase Duration + duration of the stream; T4=T1+T2
				51	temporary replenishment date	tx	Refers to stock drop in FBA Low to safety stock The goods for daily replenishment just reach When the FBA bin is used for replenishing goods And (3) the room(s).
52	Temporary replenishment quantity	Nx	Refers to the temporary replenishment day Commodity arrival of tx restocking FBA on the same day of FBA warehouse Inventory quantity equal to target inventory Required commodity replenishment Number of parts.
				53	Quantity of restocking at future time	Nt	Refers to at the future time t Commodity arrival for replenishment FBA (fiber Bragg Grating) binOn the same day of FBA Inventory quantity equal to target inventory Required commodity replenishment Number of parts. [ i.e., in the absence of ] Time of arrival t restocking quantity A commodity of Nt, where Batch replenishment commodity arrival On the day of the FBA warehouse, FBA At a pool quantity equal to the target pool And (5) storing. ' s of
54	FBA library for current time Storing the articles	Q1”	Commodity at present time FBA inventory quantity, field The symbol is Q1' or Q1.
				55	Pre-stored warehouse sending FBA warehouse Delivery date of (C)	tn	Refers to the delivery from a pre-stored warehouse Temporary replenishment of FBA bins Daily, pre-stored warehouse available Is a local warehouse or overseas And (5) a bin.
56	Suggesting a replenishment date	tj	Refers to certain FBA bin replenishment Suggested final suggested supplement The date of goods.
				57	Suggesting replenishment quantity	Nj	Refers to certain FBA bin replenishment Suggested final suggested supplement And (5) cargo amount.

The denoising is to take a value again according to a specific rule so as to eliminate or weaken the influence of abnormal data in original data on conventional data, for example, taking a value fixedly or according to weight percentage for historical sales data in a certain time, or taking an average value after removing the highest value and the lowest value, or taking an average value of historical sales outside a specific time period. The various fields, field symbols and their definitions may be understood with reference to the patent drawings.

Referring to fig. 3 and 4, the purchase time of the commodity is t01, the replenishment start time is t02, the time for the FBA stock to reach the target stock is t03 (t 03 is also the expected arrival time of the replenishment of the commodity), the time for the FBA stock to reach the safety stock is t04, and the current FBA stock marketable expiration date is t05.

FBA may be pre-sale inventory or after-sale inventory access values for FBA when inventory is actually calculated; the FBA pre-sales inventory refers to a certain batch of goods sent from a local warehouse or overseas warehouse to the FBA warehouse, the batch of goods arrives at the starting moment of the day of the FBA warehouse (i.e. the moment of 0:00 of the day), and the quantity of the FBA warehouse left by the original saleable inventory is the initial inventory quantity; FBA after-market inventory refers to a batch of commodity sent from a local or overseas warehouse to the FBA warehouse that arrives at the end of the day of the FBA warehouse (i.e., 24:00 hours of the day), the quantity of FBA warehouse remaining in raw saleable inventory, as a terminal inventory quantity, FBA after-market inventory = FBA pre-market inventory-daily average sales quantity.

Each field symbol in this application represents a corresponding field, and is used for simplifying and distinguishing the representation of the field, and does not limit the corresponding field to use the field symbol.

In the application, when calculating the stock quantity or goods delivery and arrival time, mainly considering the scenes larger and smaller, the scenes equal to each other can be classified as the scenes larger than each other or the scenes equal to each other can be classified as the scenes smaller than each other. Warehouse occupancy refers to the number of items within the warehouse for which a shipping destination has been determined; warehouse availability refers to the number of items within a warehouse that are available for any destination.

In the present application, setting of parameters of each field may be manually inputting or selecting a corresponding parameter value, or may be obtaining an existing parameter value of a related functional module, or may be a value calculated by other parameters.

Drawings

The accompanying drawings are included to provide a further understanding of the application and are not to be construed as limiting the application; the content shown in the drawings can be real data of the embodiment, and belongs to the protection scope of the application.

FIG. 1 is a schematic diagram of a function module of an e-commerce ERP system in an embodiment of the present application;

FIG. 2 is a schematic diagram of a restocking process and inventory types of warehouses according to an embodiment of the present application;

FIG. 3 is a schematic diagram of the duration of each stage of the stock cycle in one embodiment of the present application;

FIG. 4 is a schematic diagram of a change in inventory of commodity FBAs at zero throughput for an embodiment of the present application;

FIG. 5 is a schematic diagram of a change in inventory of a commodity FBA when the amount of travel is not zero in one embodiment of the present application;

FIG. 6 is a schematic flow chart of a method for replenishing goods based on a target stock quantity in an embodiment of the present application;

FIG. 7 is a schematic illustration of the logistics distribution of three shipping methods in accordance with an embodiment of the present application;

FIG. 8 is a schematic flow chart of a method for replenishing goods based on multiple goods in an embodiment of the present application;

FIG. 9 is a flow chart of a method for restocking based on a specified shipping time in one embodiment of the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the following detailed description of the embodiments of the present application is given with reference to the accompanying drawings. 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.

Referring to fig. 7, the present application proposes a commodity replenishment method based on target inventory, which is used for a replenishment suggestion module of an e-commerce ERP system or an e-commerce platform system. In an embodiment of the present application, the method for replenishing includes steps S1 to S5 as follows.

Step S1: the method comprises the steps of obtaining data access rights of store commodities, and obtaining FBA inventory data (one or more data) of the commodities, wherein the FBA inventory data comprise FBA inventory Q1 at the current time T0, FBA in-stock quantity Q11 and FBA in-transit quantity Q12 (Q1=Q11+Q12), and setting a commodity delivery flow from a pre-store warehouse to an FBA warehouse and a physical distribution time length T2 of a corresponding commodity delivery flow.

In a related embodiment, shipping logistics of a plurality of commodities can be preset, including an initial logistics and an emergency logistics, the priority order of each logistics can be adjusted, and the replenishment suggestion module calculates shipping time and shipping quantity by adopting the shipping logistics with the highest priority level, and can conveniently select corresponding logistics under different application scenes by presetting the plurality of logistics; a material flow with longer material flow time (low speed) and low freight rate is usually used as an initial material flow (such as a shipping material flow), and a material flow with shorter material flow time (high speed) and higher freight rate is usually used as an emergency material flow (such as an air material flow); usually, the initial logistics is used as a default logistics of commodity replenishment, the priority level of the default logistics is highest, when the commodity is prejudged to be broken, the emergency logistics can be set as the highest priority level, and the arrival time of the commodity replenishment commodity is shortened through the emergency logistics, so that the commodity is prevented from being broken at the corresponding time. When a plurality of shipping streams are preset, the minimum shipping amount N5 and the logistics duration T2 of each shipping stream are set accordingly.

Step S2: setting a daily average sales quantity X and a safety days T32 of the commodity, and taking the product of the safety days T32 and the daily average sales quantity X as a safety stock Q5 of the commodity (namely Q5=T32X); and sets the number of interval days T31 or the target inventory Q6 of the commodity such that the sum of the number of interval days T31 and the number of safety days T32 multiplied by the average daily sales X is equal to the target inventory Q6 (i.e., q6= (t31+t21) ×x). When setting the number of interval days or the target inventory of the commodity, the target inventory may be calculated by inputting the number of interval days, or the number of interval days may be calculated by inputting the target inventory. The number of interval days T31 can be set to a corresponding number of days by referring to the logistics duration T2 of the logistics, for example, T31=T2/m can be set to a value that is more than or equal to 2, the larger m is indicative of the higher commodity delivery frequency, the smaller m is indicative of the lower commodity delivery frequency, and the fact that the commodity delivery is needed for several times approximately in the time range of the logistics duration T2 can be primarily judged according to the logistics duration T2 and the interval days T31; in other embodiments, the value m < 1 can be also taken to improve the FBA inventory of the commodity. Theoretically, the lower the number of days of interval, the shorter the interval time between the front shipment and the rear shipment of the commodity; typically, the number of days of separation T31 is less than the logistics duration T12 of the shipping logistics; the number of days T31 is used to adjust the delivery frequency of the replenishment of the commodity, the target stock Q6 is a constant and is larger than the safety stock Q5, and the target stock is a fixed constant and does not change due to the replenishment time.

Step S3: calculating a temporary replenishment date tx of the commodity sent to the FBA warehouse from a pre-stored warehouse based on the FBA inventory Q1, the safety inventory Q5, the daily sales volume X and the logistics time length T2, wherein the temporary replenishment date tx refers to the replenishment time of the replenishment commodity just reaching the FBA warehouse on the day when the FBA inventory Q1 is lowered to the safety inventory Q5, and the FBA inventory Q1 lowers the daily sales volume X daily; that is, on the day that FBA inventory Q1 drops to safety inventory Q5, restocked merchandise arrives just in FBA bin on temporary restocking day tx; tx=t0+ (Q1/X-T32-T2), Q1 is the FBA inventory for the current time T0.

In practical applications, the FBA inventory quantity of the commodity is usually taken by day, and the value or the input value of the inventory may adopt pre-sale inventory and after-sale inventory, so that the inventory data may deviate by day according to the value mode, and the corresponding FBA inventory may deviate by day, so that the FBA inventory Q1 is lowered to the safe inventory Q5, and the FBA inventory Q1 is lowered to the safe inventory Q5 for replenishment on the day when the FBA inventory Q1 is lowered to the safe inventory Q5, or for replenishment on the next day when the FBA inventory Q1 is lowered to the safe inventory Q5. Accordingly, in the present application, the fact that a certain stock A is reduced to a certain stock B means that the stock A is reduced to A1 at a certain time in the future, so that A1 satisfies A1 is less than or equal to B, and B-A1 is less than or equal to average daily sales X; the corresponding restocking time may be understood as the time that restocking merchandise arrives at the FBA warehouse on the day inventory a is lowered to equal inventory B or the next day inventory a is lowered to equal inventory B.

The time for FBA inventory Q1 to drop to a value equal to safety inventory Q5 (Q1/X-T32) may be an integer (e.g., day 18.00) or may contain a fraction (e.g., day 18.66); in a related implementation, the restocking time can be determined according to whether Q1/X-T32 is an integer: when Q1/X-T32 is an integer time value, judging that the restocking commodity arrives at the FBA bin on the day when the stock A is reduced to be equal to the stock B; when Q1/X-T32 is a fractional time value, it is determined that the restocking item arrives at the FBA silo the next day that inventory A is lowered to be equal to inventory B.

Step S4: calculating temporary replenishment quantity Nx based on target inventory Q6 of the commodity, temporary replenishment date tx, daily average sales quantity X and logistics duration T2, wherein the temporary replenishment quantity Nx refers to the commodity replenishment quantity required by the FBA on the day when the commodity arrives at the FBA bin and is equal to the target inventory Q6 in the inventory quantity Q11; that is, on the temporary restocking day tx, the restocking quantity Nx of the commodity, on the day that the batch of restocking commodity arrives at the FBA warehouse, the FBA warehouse quantity is equal to the target inventory.

The commodity of the replenishment Nx arrives at the FBA bin at tx+t2, the FBA at tx+t2 day is calculated as the FBA in-stock quantity q11″ with q11+q12+nx- (tx+t2-T0) X, and according to the definition q11 "=q6, nx=q6- (q11+q12) + (tx+t2-T0) X, where Q11 and Q12 are the FBA in-stock quantity and FBA in-transit quantity at the current time T0, respectively. It can also be understood that nx=q6- (q11+q12), where Q11 and Q12 are the FBA inventory and FBA inventory at tx+t2 times, respectively. In actual calculation, the stock quantity of the FBA reaching the current day of the FBA warehouse can be pre-sale stock or after-sale stock; the FBA inventory on the day (tx+t2) when the restocking commodity arrives at the FBA warehouse is a theoretical value calculated based on the daily sales X, and the quantity of the commodity is increased or decreased without the factors such as actual sales change or return. In other embodiments, the temporary restocking amount Nx may be the number of restocking products required when restocking is performed on the temporary restocking date tx and the restocking products arrive at the FBA warehouse on the same time as the FBA inventory Q1 on the current day of the FBA warehouse.

Step S5: generating a replenishment suggestion A according to the temporary replenishment date tx and the temporary replenishment quantity Nx, and generating a delivery suggestion according to the temporary replenishment date tx and the temporary replenishment quantity Nx by the replenishment suggestion A; or, the replenishment proposal is not generated temporarily, the recommended replenishment date tj is further determined according to the temporary replenishment quantity Nx, the recommended replenishment quantity Nj is determined according to the recommended replenishment date tj, and the replenishment proposal B is generated according to the recommended replenishment date tj and the recommended replenishment quantity Nj.

The delivery proposal of the replenishment proposal A directly adopts replenishment time and replenishment quantity calculated according to the target stock quantity, and the delivery proposal of the replenishment proposal B further adjusts the replenishment time and the replenishment quantity based on the calculation result of the replenishment proposal A, thereby improving the calculation accuracy.

Further, step S1 may further include: the purchasing time period T1 of the commodity (purchasing time period=purchasing plan time period+purchasing delivery period+quality inspection time period+processing time period) and the lowest delivery amount N5 of the delivery logistics are acquired. In a specific embodiment, if there is no field for the lowest shipment or no field value for the lowest shipment is set, then n5=1 per time is defaulted. Step S3 may further include: calculating the number of days T41 available for the current FBA inventory, wherein the calculation formula is T41=Q1/X, and calculating the number of days T42 available for the current FBA inventory to reach the safety inventory, wherein the calculation formula is T42=Q1/X-T32.

In step S5, when the proposed replenishment date tj is further determined according to the temporary replenishment quantity Nx, the proposed replenishment date tj and the proposed replenishment quantity Nj are calculated to follow the replenishment rule R1, and the replenishment rule R1 calculates the proposed replenishment date tj through step P1, and step P1 includes steps P11 to P13 as follows.

Step P11: the preliminary replenishment date tj 'is calculated, and the calculation formula is tj' =t0+ (T42-T2). That is, the preliminary restocking date tj' is temporary data for estimating the number of commodities that can be shipped from a pre-stored warehouse on the restocking date.

Step P12: and calculating the inventory quantity Qx of the pre-stored warehouse on the same day tj'. The Qx can be obtained by calculation according to inventory data of a pre-stored warehouse at the current time and daily average sales quantity X, and can also obtain corresponding inventory data on the day of tj ', wherein the Qx comprises the commodity quantity which is in the in-transit state at the current time but can reach the FBA warehouse on the day of tj'; the pre-stored warehouse can be the current warehouse or overseas warehouse, and when commodity replenishment rules are set, the corresponding pre-stored warehouse is determined by setting different logistics delivery modes, as shown in fig. 7.

Step P13: further determining replenishment recommendation parameters (recommended replenishment date tj, recommended replenishment quantity Nj, recommended purchase date t01, recommended minimum purchase quantity N6) according to the numerical values of Qx, nx and N5, wherein the parameters comprise scenes A, B, C respectively:

(1) Scene a: when T41> T2, T42> T2,

if Qx is greater than or equal to Nx, tj=t0+ (T42-T2), where the proposed restocking amount nj=q6-Q1 ', Q1' is the original FBA inventory of tj on the day (the original FBA inventory on the day refers to the FBA inventory before restocking on the day, and the commodity restocked on the day increases the in-transit inventory of Nj, i.e., Q1' does not contain the number of commodity restocked on the day of tj), the commodity is not required to be purchased, the proposed purchasing day T01 is empty or none, and the proposed minimum purchasing amount N6 is zero or empty;

if Qx is less than Nx and Qx is more than or equal to N5, tj=t0+ (T42-T2), the recommended replenishment quantity Nj=Qx ', qx' is the inventory quantity of the warehouse prestored on the tj day, commodity purchasing is not needed, the purchasing day T01 is recommended to be empty or not, and the recommended lowest purchasing quantity N6 is recommended to be zero or empty;

if Qx < Nx and Qx < N5, then tj, nj, T01, N6 are further determined from T42, T2, and T1, including:

(1) if T42-T2 is more than or equal to T1, tj=t0+ (T42-T2-T1), at this time, the recommended replenishment quantity Nj=Q6-Q1 ', Q1' is the original FBA inventory of tj on the day, the commodity is required to be purchased, the purchasing date t01=tj-T1, and the minimum purchasing quantity N6=Nj-Qx ';

(2) if T42-T2< T1, tj=t0+t1, where the recommended replenishment quantity nj=q6-q1 ', Q1' is tj for the current FBA inventory, commodity purchase is required, t01=t0 is recommended, the lowest purchasing quantity n6=nj-Qx ' is recommended, i.e. commodity is purchased immediately, and the commodity is purchased after the purchased commodity arrives at the pre-stored warehouse, so as to reduce the logistics cost.

(2) Scene B: when T41> T2, T42< T2,

if Qx is greater than or equal to Nx, tj=t0, and the recommended replenishment quantity Nj=Q6-Q1 ', Q1' is the original FBA inventory of tj on the day, commodity purchasing is not needed, the purchasing date t01 is empty or not, and the recommended minimum purchasing quantity N6 is zero or empty;

if Qx is less than Nx and Qx is more than or equal to N5, tj=t0, the recommended replenishment quantity Nj=Qx ', qx' is the inventory quantity of the warehouse prestored on the day tj, commodity is not required to be purchased, the purchasing day t01 is recommended to be empty or not, and the recommended lowest purchasing quantity N6 is recommended to be zero or empty;

if Qx < Nx and Qx < N5, tj=t0+t1, then the recommended replenishment quantity nj=q6-Q1 ', Q1' is the original FBA inventory on the tj day, the commodity needs to be purchased, the purchasing day t01=t0, and the lowest purchasing quantity n6=nj-Qx '.

(3) Scene C: when T41 is less than T2,

The replenishment rule R1 for calculating the proposed replenishment date tj determines three scenes (scenes A, B, C) according to the size relation among T41, T2 and T42, subdivides each scene into a plurality of sub-scenes based on Qx, nx and N5, determines a value formula of the proposed replenishment date tj through Qx matching with the corresponding sub-scenes, and calculates new proposed replenishment date tj and other replenishment proposal parameters; the delivery time, delivery quantity, purchasing time and purchasing quantity can be flexibly determined through the replenishment rule R1, so that delivery and purchasing are more timely, and computer software programming is facilitated. In addition, the goods replenishment rule R1 can further adjust the temporary goods replenishment day tx and the temporary goods replenishment quantity Nx, and improves the calculation accuracy of the goods replenishment method based on the target inventory under the subdivision scene, so that the method is compatible with more application scenes, for example, the method can be used for goods replenishment of a shop type, goods replenishment of a fine type and a shop type, and new online goods replenishment with unstable sales volume, and is also suitable for operation and use by novice users.

In other embodiments, when one or more parameters according to which the replenishment rules R1 are calculated are specified or calculated by other rules, other replenishment suggestion parameters may be calculated according to the value logic of the scenes a, B, and C. For example, when the replenishment time is specified, the proposed replenishment quantity Nj, the proposed purchasing date t01 and the proposed lowest purchasing quantity N6 can be continuously calculated according to the replenishment rules R1; for example, when the inventory quantity Qx of the pre-stored warehouse on the same day of the initial replenishment date tj 'or tj' is calculated by adopting other rules, the proposed replenishment date tj, the proposed replenishment quantity Nj, the proposed purchasing date t01 and the proposed lowest purchasing quantity N6 can be continuously calculated according to the replenishment logic and purchasing logic of the replenishment rule R1; or when the restocking date and the restocking quantity are determined, the recommended purchasing date t01 and the recommended minimum purchasing quantity N6 can be calculated through purchasing logic of the restocking rule R1.

If the number of pre-stored warehouse items is abundant: in scenario a, the full shipment of the day will not be out of stock; in scenario B, the current foot shipment would be out of stock but not out of stock; in scenario C, the full shipment will be cut off on the same day. The absence of a shipment means that the FBA warehouse is in stock but the FBA inventory is below the safe inventory, and the absence of a shipment means that the FBA inventory is zero.

In other embodiments, when determining the proposed replenishment date tj, the proposed replenishment quantity Nj, the proposed purchase date t01, or the proposed minimum purchase quantity N6 of the commodity, the proposed replenishment date tj, the proposed purchase date t01, or the proposed minimum purchase quantity N6 may be calculated according to the scene a, the scene B, or the scene C alone, or one or more sub-scenes thereof alone, or a plurality of sub-scenes may be combined into a new scene to be calculated, or only a part of calculation logic of each sub-scene is adopted; it is also possible to calculate only the recommended replenishment date tj in each sub-scene of step P1, calculate only the recommended replenishment quantity Nj in each sub-scene of step P1 as step P2, and calculate only the recommended purchase date t01 and/or the recommended minimum purchase quantity N6 in each sub-scene of step P1 as step P3. Then, based on step P1, step P2, or step P3, a replenishment proposal B is generated, which may be one or more of a proposed replenishment date tj, a proposed replenishment quantity Nj, a proposed purchase date t01, and a proposed minimum purchase quantity N6. The replenishment recommendation B generates a shipping recommendation according to the recommended replenishment date tj and the recommended replenishment quantity Nj, and generates a purchasing recommendation according to the recommended purchasing date t01 and the recommended minimum purchasing quantity N6. The replenishment recommendation A generates a shipping recommendation according to the temporary replenishment date tx and the temporary replenishment quantity Nx, and then further determines a recommended purchasing date t01 and a recommended minimum purchasing quantity N6 according to the replenishment rule R1 to regenerate a purchasing recommendation. The delivery advice and the purchase advice of the replenishment advice are displayed in a replenishment advice list of the replenishment advice module; the replenishment suggestion list is used as a main interface of the replenishment suggestion module and is used for setting, calculating and monitoring parameters of each field.

Further, the restocking suggestion module generates a shipping plan according to the shipping suggestion of the restocking suggestion A or the restocking suggestion B, and the restocking suggestion module generates a purchase plan according to the purchase suggestion of the restocking suggestion A or the restocking suggestion B. After the replenishment proposal module creates the purchase plan and/or the delivery plan, the inventory data of the product is updated again, and the replenishment proposal is generated next based on the updated data.

The recommended lowest purchase quantity N6 is the least commodity quantity recommended to be purchased on the recommended purchase date t01, and when in actual purchase, the factors such as product price change, warehouse capacity change, seasonal sales change and the like can be comprehensively evaluated, and some commodities are purchased and pre-stored in a local warehouse or overseas warehouse. Suggesting minimum purchase amount N6 generally requires more than a single minimum purchase amount N4; and when N6 is less than N4, purchasing according to the number of the N4 commodities. In particular embodiments, if there is no single lowest purchase field or no single lowest purchase field value is set, then n4=1 per time by default.

In one embodiment, in order to simplify the calculation in step P1, the Qx value may be changed to the current time t0 to pre-store the commodity inventory in the warehouse, and other calculation methods in step P1 are unchanged, so as to calculate the recommended replenishment date, the recommended replenishment quantity, the recommended purchasing date, and the recommended minimum purchasing quantity close to the actual scene more quickly.

In one embodiment, the time period during which the logistics cannot be shipped and/or the time period during which the suppliers cannot purchase may be set in advance in the restocking suggestion module. If the restocking advice module has previously set a shipment-disabled period (from time Ta1 to time Ta 2), then it is further determined whether the advice restocking day tj is located in the shipment-disabled period. When tj is located in the period of no shipment, then the recommended replenishment date is adjusted to be the day (Ta 1-1) before the start of the period, and the recommended replenishment quantity is adjusted to Nj+ (Ta 2-tj) X; when tj is not located in the no-shipment time period, then the suggested restocking date tj and the suggested restocking amount Nj are not adjusted.

If the replenishment recommendation module presets a non-purchasing period (from time Tb1 to time Tb 2), then it is further determined whether the recommendation purchase date t01 is in the non-purchasing period. When t01 is located in the period of time of non-purchasing, then the purchasing date is recommended to be adjusted to be the day (Tb 1-1) before the beginning of the period of time, and the lowest purchasing quantity is recommended to be adjusted to be N6+ (Tb 2-t 01) X; when t01 is not located in the non-procurement capable period, then the recommended procurement date t01 and the recommended minimum procurement quantity N6 are not adjusted.

In one embodiment, the replenishment suggestion module may further set a commodity replenishment and purchase time reminder, and when a replenishment is reminded in Tc1 days in advance, the system will remind the user of timely replenishment in Tc1 days before the arrival of the proposed replenishment date tj; when the early Tc2 days are set to remind of purchasing, the early Tc2 days system which arrives at the proposed purchasing date t01 reminds the user of timely purchasing, so that the user can coordinate delivery and purchasing matters in advance.

In an embodiment, the replenishment recommendation module re-acquires FBA inventory data of the commodity at regular intervals, and after the FBA inventory data is updated, the corresponding temporary replenishment date tx, temporary replenishment amount Nx, recommended replenishment date tj or recommended replenishment amount Nj is recalculated according to the new FBA inventory data, so as to improve the accuracy of the replenishment quantity of the commodity. For example, the result of calculation by the current time restocking suggestion module is 200 commodities of the next wednesday, then the FBA inventory database data of the commodities is obtained every day before the next wednesday arrives, at this time, the calculation result of the next day restocking suggestion module is 185 commodities of the next wednesday, and the calculation result of the third day restocking suggestion module is 205 commodities of the next wednesday because there is a deviation between the actual daily sales amount and the daily average sales amount X of the commodities. The updating of the FBA inventory data may be to synchronize the data of the commodity store in the replenishment proposal module, or may be to update the in-transit data of the commodity individually.

The current FBA inventory arrives at the safe inventory for the reasons such as not timely replenishment, failed replenishment or actual sales larger than average daily sales X, and the number of days T42 for sale is smaller than the logistic time period T2, and the temporary replenishment day tx is a negative value and does not conform to the actual replenishment scenario. Therefore, the replenishment recommendation module automatically calculates the daily T42 value according to T42 = Q1/X-T32, judges the sizes of T42 and T2, and reminds operators to timely replenish or recommend to use logistics replenishment faster than the logistics time length T2 when T42-T2 is less than 0.

In an embodiment, referring to fig. 7 and fig. 2-3, the pre-stored warehouse includes a local warehouse and an overseas warehouse, three shipping manners exist for the commodity from the pre-stored warehouse to the FBA warehouse, different shipping manners are selected to obtain a corresponding pre-stored warehouse and a target warehouse of the logistics transportation destination, and the target warehouse is the FBA warehouse in steps S1-S5 and steps P1-P3. The overseas bin is not used in the delivery mode A, the pre-stored warehouse of the commodity is a local bin, the target warehouse is an FBA bin, the commodity is directly sent to the FBA bin from the local bin, at the moment, T2=T23, and the commodity replenishment proposal is calculated according to steps S1-S5 and/or steps P1-P3. The overseas bin and the local bin are used for delivering goods to the FBA bin in the delivery mode B, goods are delivered to the FBA bin from the overseas bin preferentially during replenishment, at the moment, T2 = T22, and replenishment time and replenishment quantity are calculated according to steps S1-S5 and/or steps P1-P3; when the overseas warehouse is insufficient in inventory, the local warehouse is shipped to the overseas warehouse, at the moment, t2=t23, and the commodity replenishment proposal is calculated according to steps S1-S5 and/or steps P1-P3. The shipping mode C transfers overseas bins from the local bins firstly, then ships from the overseas bins to the FBA bins, and when the goods are replenished, the goods are preferentially shipped from the overseas bins to the FBA bins, at the moment, T2=T22, and the replenishment time and the replenishment quantity are calculated according to steps S1-S5 and/or steps P1-P3; when the overseas warehouse is insufficient in inventory, the inventory is sent from the local warehouse to the overseas warehouse for transfer and then sent to the FBA warehouse, at the moment, T2=T21+T22, and commodity replenishment suggestions are calculated according to steps S1-S5 and/or steps P1-P3.

Case a: as shown in fig. 5, if the shipping logistics duration t2=30 days for a commodity, the average sales x=10 pieces/day, the interval days t31=15 days, the safety days t32=5 days, the current time t0=0, and the FBA inventory q1=450 pieces at the current time (wherein FBA is at inventory Q11=150, and FBA is at inventory Q12=300; the on-road commodity sent from the local warehouse to the FBA warehouse includes lot a and lot B, the lot a has shipped 150 commodities over the first 20 days, the lot B has shipped 150 commodities over the first 5 days, the lot a has shipped 10 days later to the commodity, and the lot B has shipped 25 days later to the commodity).

At this time, it is calculated as: (1) Safety stock q5=t32×x=50, target stock q6= (t31+t21) ×x=200; (2) The current FBA inventory number of days available for sale t41=q1/x=45 days, the current FBA inventory number of days available for sale t42=q1/X-t32=40 days to the safety inventory; (3) Temporary replenishment date tx=t0+ (Q1/X-T32-T2) =10 days (i.e. replenishment after 10 days), temporary replenishment amount Nx is represented by the formula nx=nx=q6- (q11+q12) + (tx+t2-T0) ×150. Thus, if the local bin inventory is abundant, the system recommends 150 products to be shipped from the local bin after 10 days, i.e., the replenishment proposal A. If the number of local warehouse commodities is insufficient, the replenishment date can be further adjusted based on various scenes of the replenishment rule R1.

In an embodiment, referring to fig. 8, the present application further provides a replenishment method and a corresponding system based on a plurality of commodities, which are used for a replenishment suggestion module of an e-commerce ERP system or an e-commerce platform system, wherein the replenishment method includes steps Q1 to Q6 as follows.

Step Q1: the method comprises the steps of obtaining data access rights of store commodities, adding one or more commodities needing to be restocked to a restocking suggestion list of a restocking suggestion module, wherein the restocking suggestion list obtains FBA inventory data of each commodity, sets a commodity delivery flow from a pre-stored warehouse to an FBA warehouse and obtains a physical distribution time length T2 and a minimum delivery amount N5 of the corresponding commodity delivery flow, and the restocking suggestion list calculates suggested restocking days tj and suggested restocking amounts Nj of each commodity sent from the pre-stored warehouse to the FBA warehouse according to a preset restocking rule R1. In the present application, the unit of the minimum shipment amount N5 is a unit of quantity, and when the minimum shipment amount of the commodity is limited by other units such as volume or weight, the other units of the minimum shipment amount need to be converted into the unit of quantity and then commodity splice calculation is performed.

Step Q2: and selecting a certain delivery time td (which may be the current time or a future time), acquiring (screening or other modes) commodities with tj=td in the replenishment proposal list according to td and delivery logistics, wherein the quantity of all the commodities to be spliced is Ya, the commodities to be spliced are delivered from the same pre-stored warehouse to the FBA warehouse by adopting the same delivery logistics, and calculating the total replenishment quantity Nd of all the commodities to be spliced. Nd is the sum of recommended restocking amounts for each commodity to be spliced in td, such as case B: the commodity replenishment recommendation list calculates according to a preset replenishment rule R1 to obtain commodities which are recommended to be shipped at td, wherein the recommended replenishment amounts are Nj1, nj2 and Nj3 respectively, the daily average sales amounts are Xa1, xa2 and Xa3 respectively, then the commodities A1, A2 and A3 serve as commodities to be spliced, and Nd=Nj1+Nj2+Nj 3. When ya=0, indicating that no commodity is required to be shipped on the same day, nd=0, the process may be directly changed from the step Q2 to the step Q4.

Step Q3: according to Nd and N5, primarily judging the goods sharing mode of the goods, when Nd is more than or equal to N5, conforming to the goods sharing condition, generating a goods supplementing suggestion C, wherein the goods supplementing suggestion C is to ship all Ya goods to be spliced at td time, and the suggested goods supplementing amount of each goods to be spliced is the suggested goods supplementing amount of td time (for example, in case B, the goods supplementing suggestion C is to ship all goods A1, A2 and A3 to be spliced at td time, and the suggested goods supplementing amounts are Nj1, nj2 and Nj3 respectively); and when Nd is less than N5, the matching condition is not met, and the step Q4 is executed.

Step Q4: and acquiring commodities which are shipped after td time from a replenishment list according to the shipment logistics to serve as pre-assembled commodities, wherein the number Yb of all the pre-assembled commodities is determined, and the assembled priority level of each pre-assembled commodity is determined according to an assembled rule R2. The goods sharing rule R2 may determine the goods sharing priority level of each pre-shared goods according to the sequence of the suggested goods sharing day tj, where the goods sharing priority level of the pre-shared goods is high and the goods sharing priority level of the post-shared goods is low; when a plurality of commodities need to be restocked in the same restocking day, commodity restocking priority with large restocking quantity is high; when a plurality of commodities on the same replenishment day need replenishment and the replenishment amount is the same, it is determined that the commodity sales priority level for the commodity with a large daily sales amount is high or the priority level is specified by the user. For example, in case B, the pre-spelled goods further include goods B1 and B2 suggested to be restocked at time tj=td+1, and goods C suggested to be restocked at time tj=td+2, then: (1) commodities B1, B2 and C are taken as pre-parquet commodities; (2) Since the replenishment times of the commodities B1 and B2 are earlier than that of the commodity C, the commodity splicing priority level of the commodities B1 and B2 is higher than that of the commodity C; (3) The goods B1 and B2 are restocked in td+1 day, the priority level can be further determined according to the recommended restocking amount Nj of the goods B1 and B2, if the recommended restocking amount of the goods B1 is larger than the recommended restocking amount of the goods B2, the priority level of the goods B1 is higher than the priority level of the goods B2, and the priority level sequence of the corresponding pre-restocking goods is B1> B2> C.

Step Q5: selecting all pre-spliced goods one by one according to the order of the splicing priority, calculating the required replenishment quantity Ne of the corresponding pre-spliced goods on td when the pre-spliced goods are replenished on the same day, superposing and calculating the total replenishment quantity Ne ' of the pre-spliced goods with Y names (Y is less than or equal to 1 and less than or equal to Yb) before the splicing priority, starting to take the value and calculation from Y=1, generating replenishment suggestion D when Ne ' +Nd is more than or equal to N5, continuing to take the value of Y next time when Ne ' +Nd is less than N5, adding 1 to each value of Y, recalculating the Ne ' of the pre-spliced goods with the next splicing priority, and stopping to continue taking the value of Y until Ne ' +Nd is more than or equal to N5 or stopping to continue taking the value of Y until Y=Yb; the delivery proposal of the replenishment proposal D is to deliver all Ya commodities to be spliced and pre-spliced commodities with the splicing priority of 1 st to Y th at td time, and the recommended replenishment amounts of the commodities to be spliced and the pre-spliced commodities are respectively the recommended replenishment amounts at td time; when y=yb, ne' +nd < N5, step Q6 is performed. Ne' is the sum of the restocking amounts of pre-restocked goods of the 1 st to the Y th names of the restocking priority levels at the time td.

For example, in case B, if the lowest shipping amount n5=500 of the shipping streams, the articles to be assembled are A1, A2, A3, the articles to be assembled are B1, B2, C (the priority order is B1> B2> C), and the recommended replenishment amounts Nj of the articles A1, A2, A3, B1, B2, C on the td day are 100, 180, 150, 120 according to the replenishment rules R1, respectively, and then it is calculated that: (1) Nd=300, where Nd < N5, one or more of the pre-parcels B1, B2, C need to be added for restocking; (2) Since the priority of B1 is first, when y=1, ne ' contains B1 commodities, ne ' =180, and when Ne ' +nd=480 < N5 does not meet the goods spelling condition, continuing the next value of Y; (3) When y=2, ne ' contains B1 and B2 commodities, ne ' =180+150=330, and Ne ' +nd=630 > N5, and the match condition is met, then the pre-match commodity only supplements the B1 and B2 commodities ranked 1-2, and the supplement suggestion D delivers five commodities A1, A2, A3, B1 and B2 at td, and the delivery amounts are 100, 180 and 150 respectively. If the lowest shipment amount n5=1000 of the shipment flows, then y=3, ne' +nd=750 < N5, at which point the splice condition is not met.

Step Q6: and (3) adjusting delivery time of the goods to be spliced and the goods to be pre-spliced to be te, wherein te > td, generating a replenishment suggestion E, wherein the delivery suggestion of the replenishment suggestion E is the suggested replenishment amount of the time when all Ya goods to be spliced and all Yb goods to be pre-spliced are delivered at te.

In the step Q6, the delivery time te is calculated based on td, te=td+m, the value of each to-be-spliced commodity and the total delivery quantity Nf of the pre-spliced commodity are taken one by one from m=1, nf calculates the recommended replenishment quantity and sum of each to-be-spliced commodity and the pre-spliced commodity in the te time according to the replenishment rule R1, and when Nf is more than or equal to N5, replenishment recommendation E is generated; and when Nf is less than N5, continuing to take the value of M next time, adding 1 to the value of M each time, recalculating the Nf value at te time, stopping M to continue taking the value until Nf is more than or equal to N5, and calculating to obtain the te value according to the last value of M.

In other embodiments, the value of M may be further limited, and when M is greater than or equal to the minimum safety days T32 '. Times.20%, the value of m=t32'. Times.20% (M < T32 '. Times.20%, the value of M is not adjusted), and the proposed replenishment quantity of each piece goods in the te time and the te time is continuously calculated, where T32' is the minimum value of the safety days T32 of each piece goods to be spliced and each piece goods to be pre-spliced; by further limiting the value of M, delayed shipping is avoided to reduce the risk of a cut-off. In other embodiments M may be other fixed percentages of T32', such as 5%, 10%, 15%, 25%, 30%, etc.

In steps Q1-Q6, the proposed restocking amount Nje of the to-be-spliced goods or the pre-spliced goods at the te time may be calculated based on the proposed restocking amount Njd at the td time, nje = Njd +m×xe, which is the daily average sales amount of the corresponding to-be-spliced goods or pre-spliced goods.

In step Q1, the proposed replenishment date tj and the proposed replenishment quantity Nj of each commodity are calculated by the replenishment rules R1, and the schemes corresponding to steps S1 to S5 may be adopted. Such as: acquiring FBA inventory data of each commodity, wherein the FBA inventory data comprises an FBA inventory Q1, an FBA inventory Q11 and an FBA inventory Q12 at the current time t 0; setting daily average sales quantity X and safety days T32 of each commodity, and taking the product of the safety days T32 and the daily average sales quantity X as a safety stock Q5 of the commodity; setting the interval number of days T31 or the target inventory Q6 of the commodity, so that the sum of the interval number of days T31 and the safety number of days T32 multiplied by the average daily sales X is equal to the target inventory Q6; the number of days available for sale for the current FBA inventory of each commodity, T41, t41=q1/X, is calculated, and the number of days available for sale for the current FBA inventory to reach the safety inventory, T42, t42=q1/X-T32, is calculated. Then, more accurate recommended replenishment days tj and recommended replenishment amounts Nj are obtained according to steps P11 to P13.

In steps Q1-Q6, each commodity of the same batch of parcels is typically a commodity with a volume or weight close to that of the commodity, and may be a small commodity (such as a small commodity for collecting express fee by piece). For large goods, only different goods with similar volumes and weights are generally assembled and shipped.

Case C: commodity A, B, C is sent from the local warehouse to the FBA warehouse using the same logistics, with the lowest shipment n5=1000/time, its daily average sales, the number of days of interval and the recommended replenishment date tj and the recommended replenishment quantity Nj according to replenishment rules R1 being respectively as follows: (1) daily sales x=50/day for commodity a, days T31 = 10 days apart, system advice tj = 3 days later restocking Nj = 500 commodity a; (2) daily sales x=40/day for commodity B, days T31=10 days apart, system advice tj=4 days later restocking nj=400 commodity B; (3) daily sales x=50/day for commodity C, days T31 = 10 days apart, system advice tj = 8 days later restocking Nj = 500 commodity C. If commodity a is selected to be shipped after td=3 days, since the shipment number of commodity a at td is smaller than N5, a splice is required, and the splice calculation process is as follows:

(1) Judging whether the commodity to be spliced meets the commodity splicing condition or not: only commodity A needs to be shipped on td, commodity A is taken as commodity A, and the total replenishment quantity Nd of commodity A is 500 and Nd is less than N5, so that all commodity A is needed.

(2) Basic calculation, if shipped on the day td=3, then:

goods B are shipped in advance of tj-td=1 day, and the average daily sales of X goods B are reduced every 1 day in advance, so that the shipping quantity of goods B on the day of td is Nj-X (tj-td) =400-40×1=360;

Goods C are shipped in advance of tj-td=5 days, and the average sales amount of X goods C per 1 day in advance is reduced, so the shipping amount of goods C on the day of td is Nj-X (tj-td) =500-50×5=250;

(3) Judging whether the pre-assembled goods commodity meets the assembled goods condition or not: the goods to be restocked after td are goods B and C, so the pre-split goods are goods B and C; since the proposed replenishment time of the commodity B is earlier than that of the commodity C, the commodity replenishment priority of the commodity B is higher than that of the commodity B, whether the commodity B added with the commodity to be pieced meets the shipment condition or not is judged, the total shipment quantity nf=500+360=860 of the commodities A and B on the td day is less than N5 at the moment, the commodity is not matched with the commodity replenishment requirement, and the commodity value of the next commodity replenishment priority is carried out, namely the commodity C with the second priority rank is calculated; at this time, the total shipment quantity nf=500+360+250=1110 of commodities A, B, C on the day td, nf is equal to or greater than N5, the splice condition is satisfied, and the replenishment proposal is generated, and the replenishment proposal is that the commodities A, B, C are shipped at the time td, and 500, 360 and 250 commodities are shipped respectively.

Further, if the lowest delivery amount in case C is changed to n5=1200 items/time, then all the articles to be assembled and the articles to be assembled do not meet the condition on td, the delivery time is adjusted to be te according to step Q6, and te can gradually verify whether the delivery per one post day meets the condition from te=td+1 until the articles to be assembled and the articles to be assembled meet the condition on post day for the first time, and the day that meets the condition for assembling for the first time is te time.

In one embodiment, the replenishment suggestion list has a parameter screening module, through which one or more field information of the shipping logistics, the suggested replenishment date, the suggested purchase date, the suggested shipping quantity range, and the shipping mode can be selected or set, and the eligible goods are screened out and displayed in the replenishment suggestion list. The replenishment suggestion list can also monitor the time for the goods in the list to be broken, and the parameter screening module can screen the goods broken in the time period after setting the time range for the broken goods. The restocking suggestion list may also include restocking calendars that calculate and identify the number of restocking items needed for a particular delivery day, facilitating the user's overall view of the restocking data needed for the items at a future time.

In an embodiment, referring to fig. 9, the present application further provides a restocking method based on a specified delivery time, which is used for a restocking suggestion module of an e-commerce ERP system or an e-commerce platform system, and the restocking method includes steps M1 to M4 as follows.

Step M1: acquiring data access rights of store commodities, adding the commodities needing to be restocked to a restocking suggestion list of the restocking suggestion module, wherein the restocking suggestion list acquires FBA inventory data of the commodities, the FBA inventory data comprise FBA inventory Q1, FBA in-stock quantity Q11 and FBA in-transit quantity Q12 at the current time T0, and a shipping stream of the commodities from a pre-stored warehouse to an FBA warehouse and a logistics duration T2 of the corresponding shipping stream are set.

Step M2: setting daily average sales quantity X and safety days T32 of the commodity, and taking the product of the safety days T32 and the daily average sales quantity X as a safety stock Q5 of the commodity; and setting the interval number of days T31 or the target stock Q6 of the commodity so that the sum of the interval number of days T31 and the safety number of days T32 multiplied by the average daily sales X is equal to the target stock Q6, wherein the interval number of days T31 is used for adjusting the delivery frequency of the commodity replenishment, and the target stock Q6 is constant and larger than the safety stock Q5.

In other embodiments, only the average daily sales X and the target inventory Q6 may be set in step P2, and the safety days T32, the interval days T31, and the safety inventory Q5 are not set or calculated to simplify the calculation; where the target inventory Q6 is a constant, Q6 is obtained by directly setting values or by calculating other parameters.

Step M3: setting designated commodity delivery time T, and calculating commodity replenishment quantity Nt of the commodity at the delivery time T based on target inventory Q6, delivery time T, daily average sales quantity X and logistics duration T2 of the commodity, wherein the replenishment quantity Nt is the commodity replenishment quantity required by the FBA on the same date when the commodity replenishment arrives at the FBA warehouse at the delivery time T, and the inventory quantity Q11 of the commodity is equal to the target inventory Q6. That is, at the designated shipping time t, the restocking quantity of Nt of the good, on the day the restocking batch arrives at the FBA silo, the FBA inventory is equal to the target inventory. When the temporary replenishment quantity Nt is calculated, the temporary replenishment quantity Nt is valued according to the formula Nt=Nx=Q6- (Q11+Q12) + (t+T2-T0), wherein Q11 and Q12 are respectively the FBA in-stock quantity and the FBA in-transit quantity of the current time T0.

Step M4: generating a replenishment suggestion A according to the delivery time t and the corresponding replenishment quantity Nt, and generating a delivery suggestion according to the delivery time t and the corresponding replenishment quantity Nt by the replenishment suggestion A; or determining the recommended replenishment quantity Nj according to the replenishment quantity Nt and the logistics duration T2, and then generating a replenishment recommendation B according to the recommended replenishment quantity Nj.

In step M3, setting the designated commodity shipment time t includes: and selecting commodities to be shipped at a specified time in the replenishment suggestion list (one or more commodities can be selected while the specified time is set in batches or one by one), and adjusting the shipment date of the selected commodities to be a fixed shipment time t by the shipment date adjustment function module. After the delivery time t is set, the replenishment suggestion list recalculates replenishment suggestions based on the designated commodity delivery time t, and the replenishment suggestion list displays the suggested replenishment amount and the suggested purchase amount of the designated delivery time t; the set delivery time can be modified by adjusting the delivery date function, and after the delivery time is modified, the replenishment proposal list recalculates the replenishment proposal based on the modified delivery time.

In other embodiments, the specified commodity shipment time t may be set to a fixed shipment date, such as a weekly or monthly fixed time shipment (e.g., a three weekly shipment, a 10 monthly shipment), after which the system automatically calculates the replenishment proposal for the next fixed time. The calculation of the replenishment amount for the specified shipping time may be the calculation of the replenishment amount for a time of day in the future, or the calculation of the replenishment amount for a time of day in the future.

In a related embodiment, in step M4, one or more of the recommended replenishment quantity Nj, the recommended purchasing date T01 and the recommended minimum purchasing quantity N6 are calculated according to the replenishment rule R1, compared with the replenishment recommendation parameter in step S5, the proposed replenishment quantity Nj, the recommended purchasing date T01 and the recommended minimum purchasing quantity N6 are calculated based on the calculation of the recommended purchasing date T1 in step S4 without calculating the recommended replenishment recommendation parameter, and the values of the proposed replenishment date T' and the recommended replenishment date tj are adjusted to the designated commodity delivery time T, and the value of the temporary replenishment quantity Nx is adjusted to Nt. The method specifically comprises the following steps:

in step M1, a purchase duration T1 of the commodity and a minimum shipment amount N5 of the shipment stream are acquired. In step M2, the number of days available for sale T41 of the current FBA inventory is calculated with the calculation formula t41=q1/X, and the number of days available for sale T42 of the current FBA inventory to the safety inventory is calculated with the calculation formula t42=q1/X-T32.

In step M4, the replenishment rules R1 are followed when determining the recommended replenishment quantity Nj based on the replenishment quantity Nt and the physical distribution time period T2, the replenishment rules R1 calculate the recommended replenishment quantity Nj, the recommended purchasing date T01, and the recommended minimum purchasing quantity N6 by step P1, and step P1 includes:

Step P12: calculating the inventory quantity Qx of a pre-stored warehouse on the same day of the appointed replenishment time t;

step P13: further determining replenishment proposal parameters according to the numerical values of Qx, nt and N5 comprises:

(1) Scene a: when T41> T2, T42> T2,

if Qx is greater than or equal to Nt, then the recommended replenishment quantity Nj=Q6-Q1 ', Q1' is the original FBA inventory on the day t, commodity purchasing is not needed, the recommended purchasing day t01 is empty or not, and the recommended minimum purchasing quantity N6 is zero or empty;

if Qx is less than Nt and Qx is more than or equal to N5, then the recommended replenishment quantity Nj=Qx, the commodity is not required to be purchased, the recommended purchasing date t01 is empty or none, and the recommended lowest purchasing quantity N6 is zero or empty;

if Qx < Nt and Qx < N5, then Nj, T01, N6 are further determined from T42, T2, and T1, including:

(1) if T42-T2 is more than or equal to T1, the recommended replenishment quantity Nj=Q6-Q1 ', Q1' is the original FBA inventory on the T day, the commodity is required to be purchased, the purchasing day t01=t-T1 is recommended, and the lowest purchasing quantity N6=Nj-Qx is recommended;

(2) if T42-T2< T1, the recommended replenishment quantity nj=q6-Q1 ', Q1' is the original FBA inventory on day T, the commodity needs to be purchased, the purchasing day t01=t0, and the minimum purchasing quantity n6=nj-Qx;

(2) Scene B: when T41> T2, T42< T2,

if Qx is less than Nt and Qx is less than N5, then the recommended replenishment quantity nj=q6-Q1 ', Q1' is the original FBA inventory on day t, the commodity needs to be purchased, the purchasing day t01=t0, and the lowest purchasing quantity n6=nj-Qx;

(3) Scene C: when T41 is less than T2,

if Qx < Nt and Qx < N5, then the recommended replenishment quantity nj=q6-Q1 ', Q1' is the original FBA inventory on day t, the commodity needs to be purchased, the purchasing day t01=t0, and the minimum purchasing quantity n6=nj-Qx.

In other embodiments of step M4, the proposed replenishment quantity Nj, the proposed date of purchase t01, or the proposed minimum amount of purchase N6 for the commodity may be determined as described in the embodiment of step S5, and may be calculated according to the scene a, the scene B, or the scene C alone, or according to one or more sub-scenes thereof alone, or may be calculated by combining a plurality of sub-scenes into a new scene, or may be calculated using only a part of the calculation logic of each sub-scene.

In one embodiment, in step M3, the designated commodity delivery time t may be set to be canceled, and when the designated commodity delivery time t is canceled, the replenishment recommendation list recalculates the replenishment date according to the safety stock Q5. Step M2 further includes calculating a temporary replenishment date tx for the merchandise from the pre-store warehouse to the FBA warehouse based on the FBA inventory Q1, the safety inventory Q5, the daily sales volume X and the logistics time period T2, wherein the temporary replenishment date tx refers to the replenishment time for the replenishment merchandise just reaching the FBA warehouse on the day when the FBA inventory Q1 is lowered to the safety inventory Q5, wherein the FBA inventory Q1 is lowered daily by the daily sales volume X. At this time, the recommended replenishment date tj, the recommended replenishment quantity Nj, the recommended purchase date t01, and the recommended minimum purchase quantity N6 may be redetermined according to steps S1-S5 and the replenishment rules R1, as described above.

The replenishment method based on the specified delivery time of the present application may be used to calculate the replenishment quantity, the purchasing time and the purchasing quantity required for the commodity at the specified delivery time td or the post-adjustment delivery time te in steps Q1 to Q6 of the replenishment method based on the plurality of commodities.

The replenishment proposal method can be applied to an e-commerce ERP system, and can also be used for an e-commerce platform to provide corresponding replenishment proposal for shops of the e-commerce platform; the method can also be applied to other systems which relate to the commodity and need to be restocked among different warehouses, wherein the pre-stored warehouse is a delivery warehouse, the FBA warehouse is a receiving warehouse, and other field names are correspondingly adjusted.

In this application, in order to better distinguish and identify the values of the corresponding fields in different application scenarios, the symbols of each field may be remarked as other approximate symbols. The letter identifiers in the restocking advice A, B, C, D, E or other labeled restocking advice in the present application are for simplifying the expression, so as to facilitate distinguishing the merchandise restocking advice obtained in different scenes, where each restocking advice is the restocking advice displayed in the restocking advice list in the corresponding scene, and is not meant to generate a plurality of restocking advice.

In an embodiment, the safety days T32 can be valued according to different scenes, for example, taking the fastest logistics ageing of T32 or more, ensuring timely replenishment when the safety days are lower than the safety stock; or taking an error value that T32 is larger than logistics ageing; or taking a deviation value of T32 which is larger than the sales variation; or take T32 to be greater than the procurement aging error value.

In one embodiment, the replenishment suggestion module is provided with a sales volume map, and the sales volume map is used for counting historical sales volume and estimated sales volume data of the corresponding commodity in a coordinate mode. The abscissa of the sales figures is the date, including the historical time, the current time and the future time; and the ordinate is sales of the commodity, the historical sales are displayed corresponding to the historical time, and the estimated sales are displayed corresponding to the current time and the future time. And carrying out weighting processing on sales data in different time periods according to the weight distribution of the historical sales data to obtain corresponding sales estimation values. The abscissa date of the sales map may be selected, such as yesterday, last 7 days, last 30 days, this month, last 6 months, this year, or a specific time range. Sales at different time points in the sales map are linked into sales curves of the commodity. In the sales map, the historical sales and the estimated sales of the commodity can be represented by different colors. The sales volume change curves of the commodity in the historical time, the current time and the future time are reflected through the sales volume graph, so that the historical sales volume and the estimated sales volume can be better presented, and a calculation formula of the estimated sales volume can be calibrated.

In a related embodiment, the sales map may also denoise the historical sales and display the estimated sales after denoising the historical sales. And eliminating the number of days of outage when denoising the historical sales, judging that the commodity is outage if the daily sales are 0 because the FBA is 0 in the stock quantity in the day, wherein the average sales of K days = total sales of K days/(K-K1), and K1 is the number of days of outage in the time of K days.

In one embodiment, the replenishment suggestion module records data (history data) of the daily average sales volume X and the actual sales volume, and calculates a percentage of deviation between the daily average sales volume X and the actual sales volume in a corresponding time period as reference data for optimizing replenishment suggestion. When the deviation of the average daily sales quantity X and the actual sales quantity exceeds a certain reference range or reference value, the system reminds a user to adjust the average daily sales quantity X or recommends the user to adopt a new average daily sales quantity X value so as to reduce the deviation of the average daily sales quantity and the actual sales quantity in the later period. Similarly, the replenishment suggestion module may record physical distribution time length T2 or purchase time length T1 and actual data (history data) corresponding to physical distribution time length or adoption time length, calculate a corresponding deviation, and when the deviation between the physical distribution time length T2 or purchase time length T1 and the actual data exceeds a certain reference range or reference value, remind the user of adjusting the physical distribution time length T2 or purchase time length T1, or recommend the user to adopt a new physical distribution time length or purchase time length value. Therefore, deviation between manually input data and actual data is reduced, and accuracy of the data is improved.

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 modifications made by the specification and drawings of the present application, or direct/indirect application in other related technical fields are included in the scope of the claims of the present application.

Claims

1. The utility model provides a replenishment method based on appointed delivery time, is used for the replenishment suggestion module of E-commerce ERP system or E-commerce platform system, its characterized in that, replenishment method includes following steps:

step M1: acquiring data access rights of store commodities, adding the commodities needing to be restocked to a restocking suggestion list of the restocking suggestion module, wherein the restocking suggestion list acquires FBA inventory data of the commodities, the FBA inventory data comprises FBA inventory Q1, FBA in-stock quantity Q11 and FBA in-transit quantity Q12 at the current time T0, and setting a shipping stream of the commodities from a pre-stored warehouse to an FBA warehouse and a logistics time length T2 of the corresponding shipping stream;

step M2: setting daily average sales quantity X and safety days T32 of the commodity, and taking the product of the safety days T32 and the daily average sales quantity X as a safety stock Q5 of the commodity; setting the interval number of days T31 or the target inventory Q6 of the commodity, so that the sum of the interval number of days T31 and the safety number of days T32 multiplied by the average daily sales X is equal to the target inventory Q6, wherein the interval number of days T31 is used for adjusting the delivery frequency of the commodity replenishment, and the target inventory Q6 is constant and larger than the safety inventory Q5;

Step M3: setting designated commodity delivery time T, and calculating commodity replenishment quantity Nt of the commodity at the delivery time T based on target inventory Q6, delivery time T, average daily sales quantity X and logistics duration T2 of the commodity, wherein the replenishment quantity Nt refers to the commodity replenishment quantity required by the fact that the current FBA of the commodity replenished at the delivery time T arrives at the FBA warehouse, and the inventory quantity Q11 of the commodity is equal to the target inventory Q6;

step M4: generating a replenishment suggestion A according to the delivery time t and the corresponding replenishment quantity Nt, and generating a delivery suggestion according to the delivery time t and the corresponding replenishment quantity Nt by the replenishment suggestion A;

or determining the recommended replenishment quantity Nj according to the replenishment quantity Nt and the logistics duration T2, and then generating a replenishment recommendation B according to the recommended replenishment quantity Nj.

2. The restocking method based on the specified delivery time as in claim 1, wherein the step M2 is adjusted to: setting average daily sales X and target inventory Q6, wherein the target inventory Q6 is constant, and Q6 is obtained by directly setting numerical values or calculating other parameters.

3. The restocking method based on specified delivery time as set forth in claim 1, wherein the temporary restocking amount Nt is calculated by taking a value of X according to the formula nt=nx=q6- (q11+q12) + (t+t2-T0), where Q11 and Q12 are the FBA in-stock amount and the FBA in-transit amount of the current time T0, respectively.

4. The method for restocking based on plural commodities according to claim 1, wherein in step M3, setting the designated commodity shipment time t includes: and selecting the commodity which needs to be shipped at the appointed time in the replenishment suggestion list, and adjusting the shipment date of the selected commodity to be a fixed shipment time t through the shipment date adjusting functional module.

5. The restocking method based on the specified delivery time as set forth in claim 4, wherein in the step M3, when the specified delivery time t of the commodity is set, the delivery times of the plurality of commodities can be set in batch; and/or the set delivery time can be modified by adjusting the delivery date function module, and after the delivery time is modified, the replenishment proposal list recalculates the replenishment proposal based on the modified delivery time.

6. The restocking method based on the specified delivery time as in claim 1, wherein the step M1 further comprises: acquiring the purchasing time length T1 of the commodity and the lowest delivery quantity N5 of the delivery logistics; step M2 further comprises: calculating the number of days T41 available for the current FBA inventory, wherein the calculation formula is T41=Q1/X, and calculating the number of days T42 available for the current FBA inventory to reach the safety inventory, wherein the calculation formula is T42=Q1/X-T32.

7. The restocking method based on the specified delivery time as set forth in claim 6, wherein in step M4, a restocking rule R1 is followed in determining the recommended restocking amount Nj from the restocking amount Nt and the logistics period T2, the restocking rule R1 calculates the recommended restocking amount Nj, the recommended purchasing date T01, and the recommended minimum purchasing amount N6 by step P1, the step P1 comprising:

(1) Scene a: when T41> T2, T42> T2,

(2) Scene B: when T41> T2, T42< T2,

(3) Scene C: when T41 is less than T2,

8. The restocking method based on the specified delivery time as set forth in claim 1, wherein in step M3, the specified commodity delivery time t is set to be canceled, and when the specified commodity delivery time t is canceled, the restocking advice list recalculates the restocking date based on the safety stock Q5.

9. The restocking method based on the specified delivery time as set forth in claim 8, wherein the step M2 further comprises calculating a temporary restocking date tx of the commodity from the pre-store warehouse to the FBA warehouse based on the FBA inventory Q1, the safety inventory Q5, the daily sales quantity X and the logistics period T2, the temporary restocking date tx being a restocking time when the restocking commodity just arrives at the FBA warehouse on the day when the FBA inventory Q1 is lowered to the safety inventory Q5, wherein the FBA inventory Q1 is lowered daily by the daily sales quantity X.

10. A system, wherein the system is an e-commerce ERP system or an e-commerce platform system, the system comprising a restocking advice module that executes the operational instructions contained in the restocking method of any one of claims 1-9 based on a specified shipping time.