CN112907319A

CN112907319A - Online shop commodity selling method and device and terminal

Info

Publication number: CN112907319A
Application number: CN202110127216.4A
Authority: CN
Inventors: 李喆
Original assignee: Beijing Ruili Zhongyi Software Co ltd
Current assignee: Beijing Ruili Zhongyi Software Co ltd
Priority date: 2021-01-29
Filing date: 2021-01-29
Publication date: 2021-06-04

Abstract

The method comprises the steps of creating a large-area commodity summary table, creating a shop commodity sales list, establishing an association relation between each shop commodity sales list and the large-area commodity summary table, obtaining commodities required by a user by each shop, matching the commodities required by the user through the large-area commodity summary table and pushing the commodities required by the user to the user when the commodities required by the user are not found in the shop commodity sales list. The application can realize 'same commodity, multi-store sale', improve the exposure of the commodity, give full play to the advantages of multiple stores and multiple markets, help the stores to widen the sale channels, realize the richness of the commodity and improve the drainage.

Description

Online shop commodity selling method and device and terminal

Technical Field

The application belongs to the technical field of inventory management, and particularly relates to a method, a device and a terminal for selling online shop commodities.

Background

In an electronic commerce transaction platform, an online store may distribute information (including various kinds of description information and the like) of a transaction object (for example, a commodity, a service and the like) to the transaction platform. And also sets the stock quantity of the objects according to the quantity of the saleable objects thereof, an online sales plan, and the like. In the related art, when stock information of a commodity object is stored, it is general that one commodity object is stored in a form of one record, and the same commodity object may include a plurality of skus (minimum sales attributes, for example, for mobile phone commodities, there are white skus, black skus, and the like).

In the related art, in the e-commerce transaction platform, each online store maintains its own sku, which results in poor exposure of commodities, difficult drainage and small coverage, and if commodities in one online store are sold in multiple stores at the same time, an abnormal situation of "one object is sold for multiple purposes" may occur.

Disclosure of Invention

In order to overcome the problems that in an electronic commerce transaction platform, each online shop maintains own sku, so that exposure of commodities is poor, drainage is difficult, coverage is small, and abnormal conditions of multiple selling of one commodity can occur if commodities in one online shop are sold in multiple shops at the same time, the application provides a method, a device and a terminal for selling the commodities in the online shops.

In a first aspect, the present application provides a method for selling online store merchandise, comprising:

creating a large area commodity summary table;

establishing a shop sale commodity list, and establishing an association relation between each shop sale commodity list and a large-area commodity summary table;

each store acquires the commodity required by the user, and when the store finds the commodity required by the user, the commodity required by the user is matched through the large-area commodity summary table and pushed to the unchecked user in the commodity sales list of the store.

Further, matching out the commodity required by the user through the large area commodity summary table and pushing the commodity required by the user to the user comprises the following steps:

searching corresponding commodities in the large-area commodity summary table, and screening a plurality of shops with the commodities required by the user;

and selecting an optimal shop from the plurality of shops, and pushing the commodity required by the user in the optimal shop to the user.

Further, the establishing of the association relationship between the detailed list of the commodities sold in each store and the regional commodity summary list comprises:

generating a commodity unique code for each commodity in the shop sale commodity list;

and establishing an association relation between the commodity unique code of each commodity and the identification of the corresponding commodity in the regional commodity summary table.

Further, before creating the large area commodity summary table, the method further includes:

the sales area is divided into a plurality of main areas, each of which includes a plurality of stores.

Further, the method also comprises the following steps: and establishing an inventory price table, wherein the inventory price table comprises the price of the sales commodity.

Further, the method also comprises the following steps:

determining a price for the item for sale, comprising:

searching whether the large area where the sales commodity is located has inventory;

if yes, determining the price of the sales commodity according to the stock price;

otherwise, the price of the sales commodity is determined according to the prices of the corresponding sales commodities in the rest of the large areas.

Further, the determining the price of the goods for sale comprises:

judging whether the sales commodity is supplied in a single shop;

if so, taking the price of the corresponding sales commodity in the single shop as the price of the sales commodity;

otherwise, taking the average value of the prices of the corresponding sales commodities in the shops as the price of the sales commodity.

Further, the method also comprises the following steps:

acquiring new commodities and corresponding offers laid by each shop;

judging whether the corresponding quoted price is abnormal or not;

if no abnormity exists, putting the commodity on shelf;

otherwise, the commodity is put off shelf.

In a second aspect, the present application provides an online store merchandising apparatus comprising:

the system comprises a first creation module, a second creation module and a third creation module, wherein the first creation module is used for creating a large-area commodity summary table;

the second creating module is used for creating a shop sales commodity list and establishing an association relation between each shop sales commodity list and the regional commodity summary table;

and the sharing module is used for obtaining the commodity required by the user from each store, matching the commodity required by the user through the large-area commodity summary table and pushing the matched commodity to the user when the commodity required by the user is not found in the commodity sales list of the store.

In a third aspect, the present application provides a terminal, comprising:

the online store merchandise sales device according to the second aspect.

The technical scheme provided by the embodiment of the application can have the following beneficial effects:

according to the online store commodity selling method, device and terminal provided by the embodiment of the invention, the large-area commodity summary table is created, the store commodity detail table is created, the association relation is established between each store commodity detail table and the large-area commodity summary table, each store acquires the commodity required by the user, when the commodity required by the user is not found in the store commodity detail table, the commodity required by the user is matched through the large-area commodity summary table and pushed to the user, the store sale can be realized, the exposure of the commodity is improved, the advantages of multiple stores and multiple markets are fully played, the store channel is widened, the commodity enrichment is realized, and the drainage is improved.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.

Drawings

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

Fig. 1 is a flowchart of a method for selling online store commodities according to an embodiment of the present application.

Fig. 2 is a flowchart of a method for selling online store commodities according to another embodiment of the present application.

FIG. 3 is a flow chart of another method for selling online store products according to one embodiment of the present application.

Fig. 4 is a flowchart of a method for selling online store products according to another embodiment of the present application.

FIG. 5 is a flow chart of another method for selling online store products according to one embodiment of the present application.

FIG. 6 is a flow chart of another method for selling online store products according to one embodiment of the present application.

Fig. 7 is a functional configuration diagram of an online store merchandise sales device according to an embodiment of the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be described in detail below. It is to be understood that the embodiments described are only a few embodiments of the present application and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the examples given herein without making any creative effort, shall fall within the protection scope of the present application.

Fig. 1 is a flowchart of an online store merchandise sales method according to an embodiment of the present application, and as shown in fig. 1, the online store merchandise sales method includes:

s11: creating a large area commodity summary table;

s12: establishing a shop sale commodity list, and establishing an association relation between each shop sale commodity list and a large-area commodity summary table;

s13: and each store acquires the commodity required by the user, and when the commodity required by the user is not found in the commodity sales list of the store, the commodity required by the user is matched through the large-area commodity summary list and pushed to the user.

The traditional stores cannot realize inventory sharing, each online store maintains own sku in an e-commerce transaction platform, so that the product exposure is poor, the flow guiding is difficult, the coverage range is small, and the abnormal condition of 'one object and multiple sales' may occur if the products in one online store are sold in multiple stores at the same time.

In the embodiment, a large-area commodity summary table is created, a shop sales commodity list is created, an association relation is established between each shop sales commodity list and the large-area commodity summary table, each shop acquires a commodity required by a user, and when the commodity required by the user is not found in the shop sales commodity list, the commodity required by the user is matched through the large-area commodity summary table and pushed to the user, so that 'same commodity and multi-shop sales' can be realized, the exposure of the commodity is improved, the advantages of multiple shops and multiple markets are fully exerted, the shop is helped to widen the sales channels, and the commodity is abundant.

Fig. 2 is a flowchart of an online store merchandise sales method according to another embodiment of the present application, and as shown in fig. 2, the online store merchandise sales method includes:

s21: dividing a sales area into a plurality of large areas, wherein each large area comprises a plurality of shops;

the large area is divided according to the logistics coverage, goods supply and other factors in each market. And the markets in the same large area can realize inventory sharing.

The online shop is a network organization which is set up on a third-party sales platform through company authorization and aims at the platform visitor to expose, popularize and sell commodities. Each online shop is in the stock sharing system and needs to have a unique shop code;

each online shop corresponds to a market, the market is a collective unit of offline supply, respective commercial tenants are independently managed, and each market is in the inventory sharing system and has a unique market code;

the merchants directly provide commodities through market permission for independent individual users sold in shops on the market line, and each merchant only belongs to a certain market;

the product sold by the online shop has uniqueness in the unique code value Sku of the third party sales platform.

S22: creating a large area commodity summary table;

and providing commodity information tables for online sale in all markets at regular time or irregular time, creating commodity summary tables in different large areas according to logistics coverage areas of various markets after feasibility analysis is performed by related personnel, and recording the data of the commodity summary tables into an inventory sharing system after data processing and integration.

S23: creating a shop sales commodity list, and generating a commodity unique code for each commodity in the shop sales commodity list;

s24: and establishing an association relation between the commodity unique code of each commodity and the identification of the corresponding commodity in the regional commodity summary table.

The markets covered in the same large area correspond to respective online shops, the shop sales commodity list is determined by the shop operation, and all commodities in the shop sales commodity list are contained in the commodity summary table.

And after the sales commodity detail list is created, performing commodity construction verification operation on the background, and generating a commodity unique code (sku) on each commodity on the sales platform after verification is completed.

After sku of all commodities is generated, recording the sku into an inventory sharing system, and establishing an association relation with a commodity summary table of the system; the market goods are distinguished from the rest of the market goods in the large area by the database field.

S25: each shop acquires a commodity required by a user, searches a corresponding commodity in the large-area commodity summary table when the commodity required by the user is not found in the commodity sales list of the shop, and screens out a plurality of shops with the commodity required by the user;

s26: and selecting an optimal shop from the plurality of shops, and pushing the commodity required by the user in the optimal shop to the user.

The optimal shop is a shop matched by integrating factors such as the stock in the shop and the distance between the shop and the user.

And for the normal splitting of the same specification commodity among different shops, the system adopts a unified commodity library. For example, a common commodity dictionary is added with 3 catties of Chinese cabbages, in order to distribute 3 catties of orders of online stores to merchants in an optimized market, the collected commodity specifications of different markets are required to be consistent, and the splitting and distribution of commodities among the markets and the merchants are facilitated. As shown in fig. 3, the basic commodity type is determined in the public commodity library, and the commodities with the same specification are determined to be sold and distributed in the enclosed area according to the association relationship between the commodities and the area where the market is located.

In the embodiment, by dividing large areas and market areas, realizing many-to-many association between sales channels and purchase channels and adopting a strategy of 'same area and stock', multi-exhibition and drainage of commodities and supply of multiple merchants are realized, the sales data of the commodities are effectively improved, a complete stock synchronization and order distribution strategy is used, the risk of 'one object and multiple sales' is avoided, the market merchants are helped to widen the sales channels, the shops are helped to realize abundant commodities, and pain points such as poor commodity exposure, difficult drainage, small coverage and the like are solved.

Fig. 4 is a flowchart of an online store merchandise sales method according to another embodiment of the present application, and as shown in fig. 4, the online store merchandise sales method includes:

s41: an inventory price table is established, which includes prices for the items sold.

S42: determining a price for the item for sale;

in some embodiments, determining a price for selling the item includes:

s421: searching whether the large area where the sales commodity is located has inventory;

s422: if yes, determining the price of the sales commodity according to the stock price;

s423: otherwise, the price of the sales commodity is determined according to the prices of the corresponding sales commodities in the rest of the large areas.

Determining a price for the item for sale, further comprising:

judging whether the sales commodities are supplied in a single shop or not;

if so, taking the price of the corresponding sale commodity in the single shop as the price of the sale commodity;

S43: acquiring new commodities and corresponding offers laid by each shop;

s44: judging whether the corresponding quoted price is abnormal or not;

s45: if no abnormity exists, putting the commodity on shelf;

s46: otherwise, the commodity is put off shelf.

Each store updates the prices and the stocks of the commodities sold in the store every day, and as shown in fig. 5, the price updating process comprises the following steps: firstly, judging whether the sold commodity has supply in the market of the large area, if so, taking the price from the corresponding market, and if not, determining the price of the sold commodity according to the rest markets in the large area. And acquiring the commodities sold by the shop and the corresponding quotation, judging whether the quotation is reasonable, updating the prices of the commodities if the quotation is reasonable, and putting the commodities off shelves if the quotation is not reasonable. As shown in fig. 6, the inventory update process includes: firstly, judging whether a sold commodity is supplied in the market of the local large area, if so, taking the stock from the local large area, judging whether the shop quotation is reasonable, if so, counting the stock of a merchant into effective stock, gathering the effective stock and then synchronizing the effective stock to all shops in the large area when a plurality of shops supply goods, and synchronizing the effective stock to all shops in the local large area when the exclusive shop supplies goods; if the quoted price is unreasonable, the shop stock accounts for invalid stock and does not perform synchronous operation any more; if the large area does not supply goods, the goods are put off shelf.

In the embodiment, the perfect commodity pricing strategy is used, the rationality of the selling price of the online shop is ensured on the premise of coordinating and guaranteeing the benefits of merchants, companies, platforms, consumers and the like, and the abnormal condition of 'one commodity and multiple selling' is avoided by timely updating the inventory information and orders of commodities in the shop and intercepting and dispatching the orders in different time periods.

An embodiment of the present invention provides an online store merchandise sales device, as shown in a functional configuration diagram of fig. 7, including:

a first creating module 71, configured to create a large area commodity summary table;

a second creating module 72, configured to create a store sales commodity list, and establish an association relationship between each store sales commodity list and a large area commodity summary table;

and the sharing module 73 is used for obtaining the commodity required by the user from each store, matching the commodity required by the user through the regional commodity summary table and pushing the matched commodity to the user when the commodity required by the user is not found in the commodity sales list of the store.

In this embodiment, a large area commodity summary table is created through a first creating module, a shop sales commodity list is created through a second creating module, an association relation is established between each shop sales commodity list and the large area commodity summary table, a sharing module obtains a commodity required by a user in each shop, and when the commodity required by the user is not found in the shop sales commodity list, the commodity required by the user is matched through the large area commodity summary table and pushed to the user, so that the 'same commodity and multi-shop sales' can be realized, the exposure of the commodity is improved, the advantages of multiple shops and multiple markets are fully played, the shop is helped to widen sales channels, and the richness of the commodity is realized.

The present embodiment provides a terminal, including:

the online shop merchandising apparatus according to the above embodiment.

In some embodiments, the terminal includes an IntelliJ IDEA development environment using JAVA development language, and software architectures such as jeecgbot, MySql, Redis, RabbitMQ, Mybatis, Jpush, Shiro, Swagger, etc.

It is understood that the same or similar parts in the above embodiments may be mutually referred to, and the same or similar parts in other embodiments may be referred to for the content which is not described in detail in some embodiments.

It should be noted that, in the description of the present application, the terms "first", "second", etc. are used for descriptive purposes only and are not to be construed as indicating or implying relative importance. Further, in the description of the present application, the meaning of "a plurality" means at least two unless otherwise specified.

Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and the scope of the preferred embodiments of the present application includes other implementations in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present application.

It should be understood that portions of the present application may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.

It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.

In addition, functional units in the embodiments of the present application may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional component mode. The integrated module, if implemented in the form of a software functional component and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.

The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc.

In the description herein, reference to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the application. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.

Although embodiments of the present application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present application, and that variations, modifications, substitutions and alterations may be made to the above embodiments by those of ordinary skill in the art within the scope of the present application.

It should be noted that the present invention is not limited to the above-mentioned preferred embodiments, and those skilled in the art can obtain other products in various forms without departing from the spirit of the present invention, but any changes in shape or structure can be made within the scope of the present invention with the same or similar technical solutions as those of the present invention.

Claims

1. An online store merchandise sales method, comprising:

creating a large area commodity summary table;

and each shop acquires the commodity required by the user, and when the commodity required by the user is not found in the commodity sales list of the shop, the commodity required by the user is matched through the large-area commodity summary list and pushed to the user.

2. The online store commodity selling method according to claim 1, wherein the matching of the commodity demanded by the user through the large area commodity summary table and the pushing to the user comprises:

3. The online store commodity selling method according to claim 1, wherein the associating each store commodity list with the regional commodity summary table comprises:

4. The online store merchandise sales method of claim 1, wherein before creating the large area merchandise summary table, further comprising:

5. The online store merchandise sales method of claim 4, further comprising: and establishing an inventory price table, wherein the inventory price table comprises the price of the sales commodity.

6. The online store merchandise sales method of claim 5, further comprising:

determining a price for the item for sale, comprising:

7. The online store merchandise sales method of claim 6, wherein the determining a price for the merchandise sold comprises:

judging whether the sales commodity is supplied in a single shop;

8. The online store merchandise sales method of claim 6, further comprising:

acquiring new commodities and corresponding offers laid by each shop;

judging whether the corresponding quoted price is abnormal or not;

if no abnormity exists, putting the commodity on shelf;

otherwise, the commodity is put off shelf.

9. An online store merchandising apparatus, comprising:

10. A terminal, comprising:

the online store merchandising apparatus of claim 9.