CN112418760A

CN112418760A - O2O mode-based inventory management method for multiple warehouses and multiple sales channels

Info

Publication number: CN112418760A
Application number: CN202011309752.8A
Authority: CN
Inventors: 赵朝建
Original assignee: Beijing Deepexi Technology Co Ltd
Current assignee: Beijing Deepexi Technology Co Ltd
Priority date: 2020-11-20
Filing date: 2020-11-20
Publication date: 2021-02-26

Abstract

The invention discloses an inventory management method of a multi-warehouse and a multi-selling channel based on an O2O mode, which is used for logically abstracting rivers in the nature and establishing a mapping relation with the inventory problem of O2O, namely water corresponds to sku, the river flow corresponds to a warehouse, an outlet corresponds to a selling end and an inlet corresponds to a production purchasing end. Next, we map the business concepts, logical entities or actual entities in O2O into the river model one by one. The implementation logic of real-time updating, ex-warehouse or in-warehouse of the inventory: i.e. increasing inventory from the upstream inlet and decreasing inventory from the downstream outlet. The invention solves the problems of on-line and off-line inventory sharing in different channels and different shops and different levels, real-time synchronization of the inventory in different channels and shops and the like.

Description

O2O mode-based inventory management method for multiple warehouses and multiple sales channels

Technical Field

The invention relates to the technical field of inventory management, in particular to an inventory management method of a multi-warehouse and a multi-sale channel based on an O2O mode.

Background

In the new retail era, the business model of O2O is ubiquitous in multiple merchants in different industries, and uniform management of inventory is the biggest difficulty and challenge in order to solve the problems of uniform online and offline integration, data communication and marketing. The sales ends of a merchant fall into category 2. The first is that the channel is off-line, and different shops are available in different cities and different regions all over the country. The other is an online channel which is divided into a third-party channel (such as a Tianmao channel, a Jingdong channel, a Mei Tuo channel and the like) and a self-operation channel (such as a self-built micro mall channel, a small program and the like). The management of the inventory is more and more diversified for different channels, such as inventory sharing of multiple channels, inventory sharing of different shops under the same channel, exclusive inventory of different shops or channels, and the like. Real-time inventory data, online and offline sharing, real-time, etc. are all challenging.

Accordingly, the prior art is deficient and needs improvement.

Disclosure of Invention

The invention provides an inventory management method of a multi-warehouse and a multi-sale channel based on an O2O mode, which aims to solve the technical problems that: online and offline, different channels and different stores, inventory sharing issues at different levels, etc.

The technical scheme of the invention is as follows: a multi-warehouse and multi-sale-channel inventory management method based on an O2O model comprises the following steps:

step 1: based on logical abstraction of rivers in nature, a mapping relation is established with the inventory of O2O, namely water corresponds to sku, the rivers correspond to a warehouse, an outlet corresponds to a sales end, and an inlet corresponds to a production purchasing end;

step 2: mapping the business concepts, logic entities or actual entities in O2O into the river model one by one;

and step 3: mapping concepts related to the O2O inventory scene into a river model, wherein the formation relationship is as follows: the main river is connected with a plurality of branch drifters, the upstream is provided with a plurality of afflux branches, and the downstream is provided with a plurality of outlet branches;

and 4, step 4: mapping concepts related to the O2O inventory scene to a model after a river model for further abstraction and refinement, wherein the core objects are a warehouse and a sku; mixing the raw materials in a ratio of 1: n, establishing a corresponding relation between the warehouse and the sku;

and 5: performing data modeling on all involved logic concepts in O2O, wherein the overall data model is divided into 3 layers from the lower layer to the upper layer: a material object warehouse layer, a channel warehouse layer and a shop warehouse layer; the plurality of physical bins are gathered to an abstract channel bin, and the abstract channel bin is distributed to the plurality of shop bins according to different proportions;

step 6: for the real-time update of the inventory, the implementation logic of the warehouse-out or warehouse-in is as follows: adding stock from an upstream entrance, and warehousing and updating from bottom to top; and reducing the stock from a downstream outlet, and updating the stock after the stock is discharged from the top to the bottom.

In the above, the service concept in O2O in step 2 includes:

warehouse: store house: a physical store which can be sold to the outside is referred to, and the store is used as a store warehouse; a material object bin: refers to a warehouse which is independently established in certain areas; channel storage: a virtual warehouse corresponding to a certain sales channel; a shop cabin: a virtual warehouse corresponding to a specific shop under a certain sales channel;

and (4) stock: exclusive inventory: sales inventory exclusive to a certain store; sharing the inventory: a plurality of stores can share inventory for sale; virtual inventory: virtual sales inventory corresponding to the virtual warehouse; and (3) physical inventory: actual stock quantity corresponding to the real object;

a selling end: and (3) online channel: a third party mall, an on-line mall; and (3) offline channel: a store;

a supply end: a material object bin: refers to a warehouse which is independently established in certain areas; store house: refers to a physical store that can be sold to the outside as a store warehouse.

In the above, the step 4 further includes the steps of:

modeling the warehouse: establishing a corresponding relation between the store 1 and the store 1 in the 2-layer model; building a store warehouse 2 and a Guangzhou warehouse in a physical warehouse in the 3-layer model; and establishing a channel bin and a shop bin in the virtual bin, wherein the channel bin corresponds to a plurality of different shop bins, and each different shop bin distributes inventory occupying a corresponding proportion according to different configuration proportions.

In the above, the step 5 further includes the steps of:

the number of certain sku x is set to be respectively in three object bins of R1, R2 and R3, and the corresponding number is rc1, rc2 and rc 3; three physical bins of R1, R2 and R3 are supplied as a virtual channel V1, the total number of the virtual bins corresponding to the virtual channel V1 is vc1, the sharing number of the virtual bins is share1, and the exclusive number allocated to stores is single 1; the virtual channel V1 corresponds to 2 different shops, S1 and S2, the sharing proportion is W, Y, exclusive stocks of S1 and S2 are shop _ single1 and shop _ single2, and the corresponding saleable stocks are sc1 and sc 2; the corresponding quantity calculation formula is as follows:

vc1＝rc1+rc2+rc3；

vc1＝share1+single1

single1＝shop_single1+shop_single2

sc1＝share1×W+shop_single1

sc2＝share1×Y+shop_single2

in the above, the step 6 further includes the steps of:

if x stock is added to a sku of the object bin R1, the update is as follows:

rc1＝rc1+x

rc1 changes also update its associated V1, and S1, S2, store S1 sell x numbers of skus, then:

shop_single1＝shop_single1-x

while updating the single1 of the channel bin associated therewith.

The invention solves the following technical problems: 1. on-line and off-line, different channels and different stores, inventory sharing problem at different levels; 2. the problem of real-time synchronization of the stocks of different channels and shops; 3. multiple warehouses and multiple sales channels, stock over-selling, and inaccurate stock calculation; 4. the O2O service scene is complex, and the inventory management boundary is not clear; 5. the problem of diversified stock configuration of different shops and channels; 6. the multiple warehouses around the country support the inventory problem of multiple sales channels around the country.

Drawings

Fig. 1 is a map of a river in an embodiment of the present invention.

Fig. 2 is a schematic diagram illustrating the mapping relationship between the inventory problem of O2O in the embodiment of the present invention.

FIG. 3 is a relational diagram formed by mapping concepts involved in an O2O inventory scenario into a river model in an embodiment of the invention.

Fig. 4 is a schematic diagram of a river model after further abstraction and refinement in an embodiment of the present invention.

FIG. 5 models a warehouse in an embodiment of the invention.

FIG. 6 is a data modeling of all involved logical concepts in O2O in an embodiment of the invention.

Fig. 7 is a schematic diagram of logic for implementing warehouse-out or warehouse-in the embodiment of the present invention.

FIG. 8 is a flow chart of the method of the present invention.

Detailed Description

In order to facilitate an understanding of the invention, the invention is described in more detail below with reference to the accompanying drawings and specific examples. Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used herein, the term "and/or" includes any and all combinations of one or more of the associated listed items.

One embodiment of the present invention provides an inventory management method for multiple warehouses and multiple sales channels based on an O2O model, which is referred to herein as a river algorithm, and the river algorithm is an inventory management algorithm for simulating the behavior of a river and solving the problems of multiple warehouses and multiple sales channels. The baseline feeling is derived from rivers in nature. As shown in fig. 1, a river map of fig. 1 shows that there are a plurality of inflowing branches and a plurality of outflowing branches in one river. The water in the river is natural in any section at any time, and has no logic problem because the river conforms to the objective natural law. The inventory issues corresponding to our O2O model are similar in nature.

In the inventory management method of multi-warehouse and multi-sale channel based on O2O model in the present invention, as shown in FIG. 8, the method specifically includes the following steps

Step 1: based on logical abstraction of rivers in nature, a mapping relation is established with an inventory problem of O2O as shown in FIG. 2, namely water corresponds to sku, rivers correspond to warehouses, outlets correspond to sales ends, and inlets correspond to production purchasing ends. Therefore, the problem of the inventory and the river are logically abstracted, and one-to-one correspondence is realized.

Step 2: and mapping the business concepts, the logic entities or the actual entities in the O2O into the river model one by one. O2O has several concepts or entities:

1. storage house

Store house: refers to a physical store that can be sold to the outside as a store warehouse.

A material object bin: refers to a warehouse separately established in some areas.

Channel storage: refers to a virtual warehouse corresponding to a certain sales channel.

A shop cabin: the virtual warehouse corresponds to a specific shop under a certain sales channel.

2. Stock keeping

Exclusive inventory: a store has exclusive sales inventory.

Sharing the inventory: multiple stores can share inventory for sale.

Virtual inventory: virtual sales inventory corresponding to the virtual bin.

And (3) physical inventory: actual inventory quantity corresponding to the real object.

3. Sales terminal

And (3) online channel: a third party shopping mall and an on-line shopping mall.

And (3) offline channel: a store.

4. Supply end

And step 3: the concepts involved in the O2O inventory scenario are mapped into a river model, and the relationship is formed as shown in FIG. 3: the main river connects a plurality of branch drifts, with a plurality of inflowing branches at the upstream and a plurality of outlet branches at the downstream.

The mapping of concepts involved in the O2O inventory scenario to the river model has the following characteristics:

1. adding from inlet and reducing from outlet

sku is increased from the physical warehouse and decreased from the sales channel.

2. The first is adding the bin and the second is subtracting the bin

The water flows in first, and the water flows out. Therefore, sku needs to be increased first to be sold, and the problem of stock over-selling is also prevented.

3. Exclusive occurs at the very front end and sharing occurs at the previous level

The water in each river section is exclusive to the outlet, the water cannot flow backwards, and the water above the water can flow downwards. Therefore, in the inventory model, the exclusive inventory is in the front-end warehouse, the shared inventory is in the upper-level inventory, and when the lower inventory is insufficient, the upper-level inventory naturally flows into the lower-level inventory according to the width (configuration ratio) of the river channel.

4. First flow exclusive and then flow shared

The water is always firstly discharged from the water tank, and the water in the previous stage flows down. So the inventory is consumed exclusively and then shared.

5. Percentage, fixed value

The size of the reservoir represents an exclusive fixed amount of inventory, while the width of the river represents the proportion of the inventory that is allocated.

6. When a new flow comes in, the share stays at the previous stage and exclusively flows into the next stage

The newly inflowing water flows downwards along the natural law. New added or new depleted stock flows in and out naturally according to this model.

7. Updating inflow and outflow in real time, adding bin from top to bottom, subtracting bin from bottom to top

When water flows from the upper part, the water is required to flow downwards dynamically, and the process is real-time. The increase or decrease of inventory is also a real-time process.

8. Delays are objectively inevitable, accepted and ignored;

the water flowing from upstream to downstream is time consuming, so the increase in inventory is delayed when it can be sold at the point of sale, which is understood to be a delay in the transmission of network data. And delay is essentially inevitable, being an objective fact, one accepting such objective fact, because it must not be accepted, it is present certainly, and the other ignoring its presence, because such delay does not have any effect. For example, the newly inflowing water does not reach the downstream because of delay, and the downstream, namely no water can flow out, which accords with objective facts and logic rules.

And 4, step 4: the concepts involved in the O2O inventory scenario are mapped to the model of the river for further abstraction and refinement, as shown in FIG. 4: the core objects are only 2: warehouse and sku; mixing the raw materials in a ratio of 1: n, establishing a corresponding relation between the warehouse and the sku;

modeling the warehouse:

all warehouses, whether actually existing warehouses or virtual warehouses, are only different warehouse types, are abstracted into a warehouse in a unified way, and sku exists in different warehouses. The sales modes are divided into 2 scenes: firstly, the online store is directly sold, namely the store is used as a sales channel, and the modeling is a 2-layer model; different shops in different online channels sell directly, namely different shops serve as different selling channels, and the modeling is a 3-layer model; the modeling method of the warehouse in the invention is shown in fig. 5, and in fig. 5, the corresponding relation between the store 1 and the store 1 is established in a 2-layer model; building a store warehouse 2 and a Guangzhou warehouse in a physical warehouse in the 3-layer model; and establishing a channel bin and a shop bin in the virtual bin, wherein the channel bin corresponds to a plurality of different shop bins, and each different shop bin distributes inventory occupying a corresponding proportion according to different configuration proportions.

And 5: data modeling is performed on all logic concepts involved in O2O, as shown in fig. 6, the overall data model is divided into 3 layers, and the following steps are performed from the lower layer to the upper layer: a material object warehouse layer, a channel warehouse layer and a shop warehouse layer. The multiple physical bins are collected into an abstract channel bin, and the abstract channel bin is distributed to correspond to the multiple store bins according to different proportions.

Examples are as follows:

the number of certain sku x is set to be respectively in three object bins of R1, R2 and R3, and the corresponding number is rc1, rc2 and rc 3; three physical bins of R1, R2 and R3 are supplied as a virtual channel V1, the total number of the virtual bins corresponding to the virtual channel V1 is vc1, the shared number is share1, and the exclusive number allocated to stores is single 1; the virtual channel V1 corresponds to 2 different shops, S1 and S2, the sharing proportion is W, Y, exclusive stocks of S1 and S2 are shop _ single1 and shop _ single2, and the corresponding saleable stocks are sc1 and sc 2; the corresponding quantity calculation formula is as follows:

vc1＝rc1+rc2+rc3；

vc1＝share1+single1

single1＝shop_single1+shop_single2

sc1＝share1×W+shop_single1sc2＝share1×Y+shop_single2

when the virtual channel V1 is corresponding to 2 different stores, S1 and S2, the sharing proportion is 20% and 30% respectively, and the exclusive stocks of S1 and S2 are shop _ single1 and shop _ single2, and the corresponding sellable stocks are sc1 and sc 2; the corresponding quantity calculation formula is as follows:

sc1＝share1×20％+shop_single1

sc2＝share1×30％+shop_single2

step 6: the implementation logic for real-time updating, ex-warehouse or in-warehouse of the inventory is shown in fig. 7: namely, stock is added from an upstream entrance, and the warehouse is updated from bottom to top; and reducing the stock from a downstream outlet, and updating the stock after the stock is discharged from the top to the bottom.

If x stock is added to a sku of the object bin R1, the update is as follows:

rc1＝rc1+x

rc1 changes also update their associated V1, S1, S2, etc.; store S1 sells x number of skus, then:

shop_single1＝shop_single1-x

while updating the single1 of the channel bin associated therewith.

The technical features mentioned above are combined with each other to form various embodiments which are not listed above, and all of them are regarded as the scope of the present invention described in the specification; also, modifications and variations may be suggested to those skilled in the art in light of the above teachings, and it is intended to cover all such modifications and variations as fall within the true spirit and scope of the invention as defined by the appended claims.

Claims

1. A multi-warehouse and multi-sale-channel inventory management method based on an O2O model is characterized by comprising the following steps:

2. The inventory management method as recited in claim 1 in which said business concept in O2O in step 2 comprises:

3. The inventory management method as recited in claim 2 in which said step 4 further includes the steps of:

4. The inventory management method as recited in claim 3, characterized in that said step 5 further comprises the steps of:

vc1＝rc1+rc2+rc3

vc1＝share1+single1

single1＝shop_single1+shop_single2

sc1＝share1×W+shop_single1

sc2＝share1×Y+shop_single2。

5. the inventory management method as recited in claim 4 wherein said step 6 further comprises the steps of:

if x stock is added to a sku of the object bin R1, the update is as follows:

rc1＝rc1+x

shop_single1＝shop_single1-x

while updating the single1 of the channel bin associated therewith.