CN116029797A - Sale management method, device, equipment and medium for retail commodity of electronic commerce - Google Patents
Sale management method, device, equipment and medium for retail commodity of electronic commerce Download PDFInfo
- Publication number
- CN116029797A CN116029797A CN202310173252.3A CN202310173252A CN116029797A CN 116029797 A CN116029797 A CN 116029797A CN 202310173252 A CN202310173252 A CN 202310173252A CN 116029797 A CN116029797 A CN 116029797A
- Authority
- CN
- China
- Prior art keywords
- commodity
- warehouse
- sales
- information
- selling
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000007726 management method Methods 0.000 title claims abstract description 36
- 238000012423 maintenance Methods 0.000 claims abstract description 67
- 238000006243 chemical reaction Methods 0.000 claims abstract description 24
- 238000013499 data model Methods 0.000 claims abstract description 20
- 238000000034 method Methods 0.000 claims abstract description 11
- 238000005259 measurement Methods 0.000 claims description 11
- 238000004590 computer program Methods 0.000 claims description 8
- 238000003860 storage Methods 0.000 claims description 4
- 238000004364 calculation method Methods 0.000 claims description 3
- 230000007480 spreading Effects 0.000 claims description 3
- 238000003892 spreading Methods 0.000 claims description 3
- 235000013399 edible fruits Nutrition 0.000 description 9
- 238000010586 diagram Methods 0.000 description 4
- 235000018481 Hylocereus undatus Nutrition 0.000 description 3
- 244000157072 Hylocereus undatus Species 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 241000282887 Suidae Species 0.000 description 2
- 235000012055 fruits and vegetables Nutrition 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000011218 segmentation Effects 0.000 description 2
- 238000005303 weighing Methods 0.000 description 2
- 241000238557 Decapoda Species 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 235000013372 meat Nutrition 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a sales management method, a device, equipment and a medium for retail goods of an electronic commerce, which relate to the technical field of retail electronic commerce, and the method comprises the following steps: s1, a sales data model setting step, which comprises the following steps: s11, acquiring the selling maintenance relation information of each selling commodity and the corresponding commodity which is delivered out of the warehouse, and generating a selling relation maintenance table according to the selling maintenance relation information; the sales relation maintenance table comprises main commodity attribute information and sales association relation information; the selling association relation information comprises the selling quantity of the selling commodities, the corresponding ex-warehouse quantity of the ex-warehouse commodities and the conversion rate of the ex-warehouse quantity; s2, acquiring the selling data information of the current selling commodity, and converting the ex-warehouse data information of the ex-warehouse commodity corresponding to the current selling commodity according to a selling relation maintenance table; the ex-warehouse data information comprises the number information of the ex-warehouse commodities. Through the technical scheme, the problems that the configuration of various commodities sold by the retail electronic commerce is complex and the inventory management difficulty is high at present can be solved.
Description
Technical Field
The invention relates to the technical field of retail electronic commerce, in particular to a sales management method, a device, equipment and a medium for retail electronic commerce.
Background
At present, in the field of retail electronic commerce, the method mainly comprises off-line cashing and various vending scenes of electronic commerce platforms containing segmented commodities and combined commodities.
In the production and life, most merchants want to sell special commodities individually, such as multi-dimensional selling of one commodity and unified selling of a plurality of commodities; the main purpose is to facilitate sales, improve sales channels and increase camping.
In the prior art, as customers increase and products are updated and iterated, a constant combination and segmentation mode in the sales modes cannot meet the demands; and even if corresponding changes are made, when the warehouse of the corresponding large manufacturer maintains inventory information of the commodity, a great deal of work and change are needed, and finally, the maintenance cost of the merchant is too high and the process is too complicated.
That is, sales are made in a simple self-matching form of the merchandise, which cannot meet the rapid changes of the current market, and ultimately affect the sales ability of the merchant.
Among the main problems are:
1. how quickly is the specific sales commodity relationship configured?
2. How do conversions between goods be handled?
3. How to conveniently maintain inventory of goods when selling special goods?
Therefore, it is important to have a convenient and flexible configuration of the sales relationship of the merchandise, and this problem is to be solved.
Disclosure of Invention
In order to solve the technical problems, the invention provides a sales management method, a device, equipment and a medium for retail goods of an electronic commerce, which are used for solving the problems of complex configuration and high inventory management difficulty of various goods sold by the electronic commerce at present.
In order to achieve the above object, the present invention provides a sales management method for retail goods of electronic commerce, comprising:
s1, a sales data model setting step, which comprises the following steps:
s11, acquiring sales maintenance relationship information of each sales commodity and corresponding ex-warehouse commodities, and generating a sales relationship maintenance table according to the sales maintenance relationship information; the sales relationship maintenance table comprises main commodity attribute information and sales association relationship information; the main commodity attribute information comprises sales commodity attribute information and corresponding ex-warehouse commodity attribute information; the selling association relation information comprises the selling quantity of the sold commodities, the corresponding ex-warehouse quantity of the ex-warehouse commodities and the conversion rate of the ex-warehouse quantity;
s2, acquiring the selling data information of the current selling commodity, and converting the ex-warehouse data information of the ex-warehouse commodity corresponding to the current selling commodity according to the selling relation maintenance table; the ex-warehouse data information comprises the number information of the ex-warehouse commodities.
Further, S1 further includes:
s12, acquiring first relation record snapshot information of each sales commodity and corresponding ex-warehouse commodities according to a first preset settlement time, and performing settlement processing on the sales ex-warehouse data information in the first preset settlement time according to the first relation record snapshot information.
Further, S2 specifically includes:
s211, when the current sales commodity is a split sales commodity, acquiring sales data of the split sales commodity;
s212, converting the ex-warehouse data information of each ex-warehouse commodity corresponding to the split sold commodity according to the vending data of the split sold commodity and the sales relation maintenance table;
s213 settles the actual vending and delivering data of each delivering commodity corresponding to the split vending commodity in the first preset settlement time according to the delivering data information of each delivering commodity corresponding to the split vending commodity and the first relation record snapshot information.
Further, S2 specifically includes:
s221, when the current sold commodity is a first combined sold commodity, acquiring the selling data of the first combined sold commodity; wherein the first type of combination vending commodity is a single type commodity in the combination vending commodity;
s222, converting the ex-warehouse data information of the combined sold commodity according to the selling data of the first combined sold commodity and the selling relation maintenance table;
s223, according to the information of the ex-warehouse data of the combined sold commodity and the first relation record snapshot information, settling the actual selling ex-warehouse data of the combined sold commodity within the first preset settlement time.
Further, the sales commodity attribute information includes a first measurement unit and a second measurement unit; wherein the first measurement unit is a main measurement unit;
s2 specifically comprises:
s201, converting the first ex-warehouse quantity of the ex-warehouse commodities corresponding to the current sales commodity according to the sales relation maintenance table; wherein the first number of exits matches a first unit of measure;
s202, calculating a second ex-warehouse number according to the first ex-warehouse number; wherein the second number of exits matches a second unit of measure.
Further, the ex-warehouse data information also comprises unit price information of the ex-warehouse commodity;
s2 specifically comprises:
s23, acquiring retail price information of all the ex-warehouse commodities corresponding to the current sales commodity, and calculating the ex-warehouse price of all the ex-warehouse commodities corresponding to the current sales commodity according to a preset unit price calculation rule;
wherein the preset unit price spreading rule comprises at least one of the following:
when the retail price information of all the goods to be delivered does not exist or is zero, the total amount of the currently sold goods is distributed to the goods to be delivered with the largest goods code;
when retail price information of a plurality of ex-warehouse commodities does not exist, the plurality of ex-warehouse commodities do not participate in price allocation, and other ex-warehouse commodities are allocated according to the retail price weight proportion;
when retail price information of all the goods to be delivered exists, all the goods to be delivered participate in price allocation and are allocated according to the proportion of retail price weights.
The invention also provides a sales management device for the retail goods of the electronic commerce, which comprises:
a sales data model setting unit including a sales relationship maintenance table generating unit for:
acquiring the selling maintenance relation information of each selling commodity and the corresponding commodity which is delivered out of the warehouse, and generating a selling relation maintenance table according to the selling maintenance relation information; the sales relationship maintenance table comprises main commodity attribute information and sales association relationship information; the main commodity attribute information comprises sales commodity attribute information and corresponding ex-warehouse commodity attribute information; the selling association relation information comprises the selling quantity of the sold commodities, the corresponding ex-warehouse quantity of the ex-warehouse commodities and the conversion rate of the ex-warehouse quantity;
the ex-warehouse data information conversion unit is used for acquiring the selling data information of the current selling commodity and converting the ex-warehouse data information of the ex-warehouse commodity corresponding to the current selling commodity according to the selling relation maintenance table; the ex-warehouse data information comprises the number information of the ex-warehouse commodities.
Further, the sales data model setting unit further includes a first relationship record snapshot information obtaining unit configured to:
acquiring first relation record snapshot information of each sales commodity and corresponding ex-warehouse commodity according to a first preset settlement time, and performing settlement processing on the sales ex-warehouse data information in the first preset settlement time according to the first relation record snapshot information.
The invention also provides a computer device, comprising a memory, a processor and a computer program, wherein the computer program is stored in the memory and can run on the processor, and the steps of the sales management method of the retail commodity of the electronic commerce are realized when the processor executes the computer program. The present invention further provides a computer-readable storage medium storing a computer program which, when executed by a processor, implements the steps of the aforementioned sales management method for e-commerce retail goods.
Compared with the prior art, the technical scheme provided by the invention has the following technical effects:
in the invention, in order to carry out sales management on retail goods of an electronic commerce, a sales data model is firstly set, and then the ex-warehouse data information of the ex-warehouse goods corresponding to the current sales goods is converted;
when a sales data model is set, acquiring sales maintenance relationship information of each sales commodity and corresponding ex-warehouse commodities, and generating a sales relationship maintenance table according to the sales maintenance relationship information; the sales relationship maintenance table comprises main commodity attribute information and sales association relationship information; the selling association relation information comprises the selling quantity of the selling commodities, the corresponding ex-warehouse quantity of the ex-warehouse commodities and the conversion rate of the ex-warehouse quantity;
then, acquiring the selling data information of the current selling commodity, and converting the ex-warehouse data information of the ex-warehouse commodity corresponding to the current selling commodity according to the selling relation maintenance table; wherein the ex-warehouse data information comprises the number information of the ex-warehouse commodities;
therefore, the same set of data model can be designed aiming at various selling modes in the prior art, and the ex-warehouse information of each ex-warehouse product is calculated according to the relation maintenance table in the data model;
therefore, merchants can quickly and conveniently configure the relationship between the split and combined commodities, so that sales volume is increased, customers are kept, and time cost is greatly reduced;
meanwhile, the warehouse is more clear to commodity warehouse-in and warehouse-out maintenance, so that the error problem can be reduced, the shipment efficiency can be improved, the detail record is clear, and the time and the efficiency can be greatly improved in the later checking process.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a schematic view of a class division vending scenario of a white pig in the prior art;
FIG. 2 is a schematic diagram of a prior art combined commodity vending scenario;
FIG. 3 is a flow chart of a method for managing sales of e-commerce retail products according to an embodiment of the invention;
fig. 4 is a schematic diagram of an overall flow of dividing a vending scene to convert information of a data to be delivered in an actual embodiment of the present invention;
FIG. 5 is a schematic diagram of a commodity sales configuration scheme according to an embodiment of the present invention;
fig. 6 is a block diagram showing a sales management apparatus for e-commerce retail goods according to the first embodiment of the present invention.
Detailed Description
In the prior art, the selling scene of the retail commodity of the electronic commerce comprises a segmented commodity selling scene and a combined commodity selling scene:
1. currently, three single commodity multi-dimensional vending/split vending scenarios are mainly included:
1. meat segmentation selling scene
(1) White pigs:
as shown in fig. 1, from the perspective of inventory management, the inventory is managed in weight or kg according to the white pigs, which is called as 'inventory management commodity';
(2) When the retail terminal is sold, the retail terminal is divided into divided commodities such as pig heads, spareribs, pig feet, front hip tips and the like, and pricing is carried out respectively;
(3) Putting each divided commodity on a client, and selling according to jin;
(4) At the customer service end, the split commodities can be put on a shelf to fix the total amount and sold in parts; such as: 400g of spareribs and pricing for 29 yuan; customers may buy several servings.
2. Fruit and vegetable classified selling
(1) Fruit: for example, from the perspective of inventory management, the warehousing, ex-warehouse and inventory checking are based on the fruit angle of the dragon fruit, and the measurement unit is usually jin or kg, and is called as 'inventory management commodity';
(2) Selling the fruits at the retail end in a time division manner, grading the fruits according to the fruit phase and the fruit size specification, and grading the fruits at different grades and pricing the fruits at different grades, wherein the fruits at each grade need to be displayed at the moment, and the customers order for purchase; when retail sales and settlement are carried out, the retail sales and settlement can be mapped to corresponding inventory management commodities without specific to the classified commodities;
(3) In an on-line mall, the fruits and vegetables can be sold in a plurality of selling units, such as boxes and individual selling units;
when the commodity is sold by box or by unit, the amount of the commodity on line can be determined by defining about jin or kg of the commodity (namely the conversion relation with a main record unit);
such as: 300g of dragon fruits are sold in one, and 6 yuan; the customer places an order and purchases 3, and the calculated amount is: 6-membered 3=18-membered; the estimated ex-warehouse weight is: 300g 3.
3. Weighing prepackaged vending
For weighing pre-packaged commodities (for example, 200g or 300g of dragon fruits, 400g of rape and 400g of sea shrimp), the selling is carried out on the market end (the information can be changed frequently).
2. Sales maintenance scenario in the form of combined commodity
As shown in fig. 2, the sales maintenance scenario is to buy a BCD model; the sales product is commodity A, and supports multiple attributes and multiple metering; the warehouse-out product is commodity B, C, D and supports multiple attributes and multiple metering.
Sales business logic is: the commodity A can only be configured with a group of products for delivery; after purchase a in the mall, the retail statement is converted to B, C, D when it is generated.
The two vending scenarios have the following problems in the conventional scheme at present:
1) The configuration of special sales products of the current merchants is complicated and low in efficiency, and cannot be rapidly adapted to the market.
2) The warehouse manager is confused with the records of the warehouse, and the number of records is problematic and has errors.
Therefore, the invention provides a sales management method, a device, equipment and a medium for retail goods of an electronic commerce to solve the problems.
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Embodiment one:
as shown in fig. 3, an embodiment of the present invention provides a sales management method for retail goods of an electronic commerce, including:
s1, a sales data model setting step, which comprises the following steps:
s11, acquiring the selling maintenance relation information of each selling commodity and the corresponding commodity which is delivered out of the warehouse, and generating a selling relation maintenance table according to the selling maintenance relation information;
the sales relation maintenance table comprises main commodity attribute information and sales association relation information;
the main commodity attribute information comprises sales commodity attribute information and corresponding ex-warehouse commodity attribute information;
the selling association relation information comprises the selling quantity of the selling commodities, the corresponding ex-warehouse quantity of the ex-warehouse commodities and the conversion rate of the ex-warehouse quantity;
s2, acquiring the selling data information of the current selling commodity, and converting the ex-warehouse data information of the ex-warehouse commodity corresponding to the current selling commodity according to a selling relation maintenance table; the ex-warehouse data information comprises the number information of the ex-warehouse commodities.
In a specific embodiment, in order to perform sales management on retail goods of an electronic commerce, a sales data model is set first, and then the ex-warehouse data information of the ex-warehouse goods corresponding to the current sales goods is converted;
when a sales data model is set, acquiring sales maintenance relationship information of each sales commodity and corresponding ex-warehouse commodities, and generating a sales relationship maintenance table according to the sales maintenance relationship information; the sales relation maintenance table comprises main commodity attribute information and sales association relation information; the selling association relation information comprises the selling quantity of the selling commodities, the corresponding ex-warehouse quantity of the ex-warehouse commodities and the conversion rate of the ex-warehouse quantity;
then, acquiring the selling data information of the current selling commodity, and converting the ex-warehouse data information of the ex-warehouse commodity corresponding to the current selling commodity according to a selling relation maintenance table; the ex-warehouse data information comprises the number information of the ex-warehouse commodities;
therefore, the same set of data model can be designed aiming at various selling modes in the prior art, and the ex-warehouse information of each ex-warehouse product is calculated according to the relation maintenance table in the data model;
therefore, merchants can quickly and conveniently configure the relationship between the split and combined commodities, so that sales volume is increased, customers are kept, and time cost is greatly reduced;
meanwhile, the warehouse is more clear for commodity warehouse-in and warehouse-out maintenance, so that the error problem can be reduced, the shipment efficiency can be improved, the detail record is clear, and the time and the efficiency can be greatly improved in the later checking process
In a practical embodiment, the same set of data models can be designed for dividing and combining two sales modes:
1. firstly, aiming at the maintenance relationship between the sales products and the warehouse-out products, recording the corresponding relationship by a table (namely a relationship maintenance table); the main commodity attribute contains commodity information of the products to be delivered and sold, such as measuring units, specifications, prices and the like; the relation attributes of the products to be delivered and the sales products include the quantity to be delivered, the sales quantity and the conversion rate.
2. Meanwhile, when sales are sold, the storage of relationship snapshots (namely relationship record snapshot information) needs to be increased;
the main functions are as follows: since the relationship between the sales items and the shipment items changes from time to time, it is necessary to deal with the shipment settlement problem with respect to the correspondence relationship before the already-sold products are held.
The data model mainly comprises three types of information:
firstly, attribute processing information of commodities; for example, multi-attribute multi-specification questions, price tax, for recording the conversion of the sales and sales, and taking retail price as an allocation condition;
secondly, the quantity is used for recording the settlement and the ex-warehouse quantity of the actual ex-warehouse products;
and thirdly, recording the state of settlement, delivery and the like of the delivered goods.
In a preferred embodiment, S1 further comprises:
s12, acquiring first relation record snapshot information of each sales commodity and corresponding ex-warehouse commodities according to the first preset settlement time, and performing settlement processing on the sales ex-warehouse data information in the first preset settlement time according to the first relation record snapshot information.
In a practical embodiment, it is necessary to increase the storage of a relationship snapshot (i.e., relationship record snapshot information) when selling a sales item.
The main functions are as follows: since the relationship between the sales items and the shipment items changes from time to time, it is necessary to deal with the shipment settlement problem with respect to the correspondence relationship before the already-sold products are held.
In a preferred embodiment, S2 specifically includes:
s211, when the current commodity is a split commodity, acquiring the commodity selling data of the split commodity;
s212, converting the ex-warehouse data information of each ex-warehouse commodity corresponding to the split commodity according to the vending data of the split commodity and the vending relation maintenance table;
s213 settles the actual vending and delivering data of each delivering commodity corresponding to the split vending commodity in the first preset settlement time according to the delivering data information of each delivering commodity corresponding to the split vending commodity and the first relation record snapshot information.
In a practical embodiment, as shown in fig. 4, when the current sales commodity is a split sales commodity, the conversion of the outgoing data information may be performed in the above steps.
In a preferred embodiment, S2 specifically includes:
s221, when the current commodity is a first type of combined commodity, acquiring the selling data of the first type of combined commodity; wherein the first type of the combined vending commodity is a single type commodity in the combined vending commodity;
s222, converting the ex-warehouse data information of the combined vending commodity according to the vending data of the first combined vending commodity and the vending relation maintenance table;
s223, according to the information of the out-of-stock data of the combined sold commodity and the first relation record snapshot information, settling the actual selling out-of-stock data of the combined sold commodity within a first preset settlement time.
In a practical embodiment, as shown in fig. 4, when the current sales commodity is the first type of combined sales commodity (i.e. the single type of commodity in the combined sales commodity), the conversion of the outgoing data information may be performed according to the above steps.
Therefore, the shopping of the user is more convenient and faster, the time is saved, the commodity selection difficulty is reduced, and the convenience is improved.
In a preferred embodiment, the sales commodity attribute information includes a first unit of measure and a second unit of measure; wherein the first measurement unit is a main measurement unit;
s2 specifically comprises:
s201, converting the first ex-warehouse quantity of the ex-warehouse commodities corresponding to the current sales commodities according to the sales relation maintenance table; the first ex-warehouse quantity is matched with the first metering unit;
s202, calculating a second ex-warehouse number according to the first ex-warehouse number; wherein the second number of exits matches the second unit of measure.
As shown in fig. 5, in a practical embodiment, for dividing and combining two sales modes, the two sales modes can be configured according to the sales requirement; and then carrying out conversion settlement processing of the database-outlet data information according to the management method.
In the specific conversion method, the number of each warehouse-out product is calculated according to the number conversion rate of the sales product files. Since only the products to be delivered are set in association with the main unit of the sales product, when other unit of the commodity is purchased, the number of main units of the sales product actually purchased is calculated according to the unit conversion rate, and then converted into the products to be delivered according to the main unit of the sales product.
For example, there are two units of measure for sales: number (as the primary measure), bin (e.g., 1 bin = 12); then the user purchasing 0.5 bins amounts to purchasing 6.
In a preferred embodiment, the ex-warehouse data information further includes ex-warehouse commodity price information;
s2 specifically comprises:
s23, acquiring retail price information of all the ex-warehouse commodities corresponding to the current sales commodity, and calculating the ex-warehouse price of all the ex-warehouse commodities corresponding to the current sales commodity according to a preset unit price calculation rule;
wherein the preset unit price spreading rule comprises at least one of the following:
when the retail price information of all the goods to be delivered does not exist or is zero, the total amount of the currently sold goods is shared to the goods to be delivered with the largest goods code;
when retail price information of a plurality of ex-warehouse commodities does not exist, the plurality of ex-warehouse commodities do not participate in price allocation, and other ex-warehouse commodities are allocated according to the proportion of retail price weights;
when retail price information of all the goods to be delivered exists, all the goods to be delivered participate in price allocation and are allocated according to the proportion of retail price weights.
In a practical embodiment, the unit price of each product is converted according to the retail price of the product, and the specific logic is as follows:
1) If all the goods to be delivered are not provided with retail price in the goods price book or are all provided with 0, the total amount is directly distributed to the goods with the largest goods code.
2) If some of the products are not provided with retail price, the other products are not participated in price allocation, and other products are allocated according to the proportion of retail price weight.
3) If all the products to be delivered are set with retail price, all the products to be delivered participate in price allocation, and the price allocation is carried out according to the proportion of retail price weights.
In practical application, specific examples are as follows:
as shown in table 1 or fig. 2, the number of sales commodity and the number of ex-warehouse commodity are compared with each other:
TABLE 1
As shown in table 2, the relationship between the membership value of the sales commodity and the member value of the delivery commodity:
TABLE 2
As shown in table 3, the customer's purchase demand for sales commodity a:
TABLE 3 Table 3
As shown in table 4, the conversion control relationship between the sales commodity and the ex-warehouse commodity:
TABLE 4 Table 4
Wherein, according to the retail price of the products to be delivered and the unit price of each product to be delivered, the specific conversion logic is as follows:
1) If all the goods to be delivered are not provided with retail price in the goods price book or are all provided with 0, the total amount is directly distributed to the goods with the largest goods code.
2) If some of the products are not provided with retail price, the other products are not participated in price allocation, and other products are allocated according to the proportion of retail price weight.
3) If all the products to be delivered are set with retail price, all the products to be delivered participate in price allocation, and the price allocation is carried out according to the proportion of retail price weights.
In summary, the sales management method for the retail commodity of the electronic commerce provided by the embodiment of the invention has the following advantages:
a) Merchants can quickly and easily configure the relationships of split and combined goods, increasing sales volume, retaining customers, and greatly reducing time costs.
b) The user shopping is more convenient, saves time, reduces commodity selection difficulty, promotes convenience.
c) The warehouse is more clear to commodity warehouse-in and warehouse-out maintenance, can reduce the error problem, improve shipment efficiency, clear in detail record, can greatly promote time and efficiency when later checking.
It should be noted that, although the steps in the flowchart are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least a portion of the steps in the flowcharts may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, the order in which the sub-steps or stages are performed is not necessarily sequential, and may be performed in turn or alternately with at least a portion of the sub-steps or stages of other steps or other steps.
Embodiment two:
as shown in fig. 6, the embodiment of the present invention further provides a sales management apparatus for retail goods of an electronic commerce, where the management apparatus includes:
a sales data model setting unit including a sales relationship maintenance table generating unit for:
acquiring the selling maintenance relation information of each selling commodity and the corresponding commodity which is delivered out of the warehouse, and generating a selling relation maintenance table according to the selling maintenance relation information; the sales relation maintenance table comprises main commodity attribute information and sales association relation information; the main commodity attribute information comprises sales commodity attribute information and corresponding ex-warehouse commodity attribute information; the selling association relation information comprises the selling quantity of the selling commodities, the corresponding ex-warehouse quantity of the ex-warehouse commodities and the conversion rate of the ex-warehouse quantity;
the ex-warehouse data information conversion unit is used for acquiring the selling data information of the current selling commodity and converting the ex-warehouse data information of the ex-warehouse commodity corresponding to the current selling commodity according to the selling relation maintenance table; the ex-warehouse data information comprises the number information of the ex-warehouse commodities.
In a preferred embodiment, the sales data model setting unit further includes a first relationship record snapshot information acquisition unit for:
acquiring first relation record snapshot information of each sales commodity and corresponding ex-warehouse commodity according to the first preset settlement time, and performing settlement processing on the sales ex-warehouse data information in the first preset settlement time according to the first relation record snapshot information.
For specific limitations of the above apparatus, reference may be made to the limitations of the method described above, which are not repeated here.
It should be noted that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.
Claims (10)
1. A sales management method for e-commerce retail goods, comprising:
s1, a sales data model setting step, which comprises the following steps:
s11, acquiring sales maintenance relationship information of each sales commodity and corresponding ex-warehouse commodities, and generating a sales relationship maintenance table according to the sales maintenance relationship information; the sales relationship maintenance table comprises main commodity attribute information and sales association relationship information; the main commodity attribute information comprises sales commodity attribute information and corresponding ex-warehouse commodity attribute information; the selling association relation information comprises the selling quantity of the sold commodities, the corresponding ex-warehouse quantity of the ex-warehouse commodities and the conversion rate of the ex-warehouse quantity;
s2, acquiring the selling data information of the current selling commodity, and converting the ex-warehouse data information of the ex-warehouse commodity corresponding to the current selling commodity according to the selling relation maintenance table; the ex-warehouse data information comprises the number information of the ex-warehouse commodities.
2. The method for sales management of e-commerce retail goods of claim 1, wherein S1 further comprises:
s12, acquiring first relation record snapshot information of each sales commodity and corresponding ex-warehouse commodities according to a first preset settlement time, and performing settlement processing on the sales ex-warehouse data information in the first preset settlement time according to the first relation record snapshot information.
3. The method for sales management of e-commerce retail goods according to claim 2, wherein S2 specifically comprises:
s211, when the current sales commodity is a split sales commodity, acquiring sales data of the split sales commodity;
s212, converting the ex-warehouse data information of each ex-warehouse commodity corresponding to the split sold commodity according to the vending data of the split sold commodity and the sales relation maintenance table;
s213 settles the actual vending and delivering data of each delivering commodity corresponding to the split vending commodity in the first preset settlement time according to the delivering data information of each delivering commodity corresponding to the split vending commodity and the first relation record snapshot information.
4. A method of sales management of e-commerce retail products according to claim 2 or 3, wherein S2 specifically comprises:
s221, when the current sold commodity is a first combined sold commodity, acquiring the selling data of the first combined sold commodity; wherein the first type of combination vending commodity is a single type commodity in the combination vending commodity;
s222, converting the ex-warehouse data information of the combined sold commodity according to the selling data of the first combined sold commodity and the selling relation maintenance table;
s223, according to the information of the ex-warehouse data of the combined sold commodity and the first relation record snapshot information, settling the actual selling ex-warehouse data of the combined sold commodity within the first preset settlement time.
5. The sales management method of e-commerce retail goods according to claim 1, wherein the sales goods attribute information includes a first measurement unit and a second measurement unit; wherein the first measurement unit is a main measurement unit;
s2 specifically comprises:
s201, converting the first ex-warehouse quantity of the ex-warehouse commodities corresponding to the current sales commodity according to the sales relation maintenance table; wherein the first number of exits matches a first unit of measure;
s202, calculating a second ex-warehouse number according to the first ex-warehouse number; wherein the second number of exits matches a second unit of measure.
6. The sales management method of e-commerce retail goods of claim 5, wherein the ex-warehouse data information further comprises ex-warehouse goods unit price information;
s2 specifically comprises:
s23, acquiring retail price information of all the ex-warehouse commodities corresponding to the current sales commodity, and calculating the ex-warehouse price of all the ex-warehouse commodities corresponding to the current sales commodity according to a preset unit price calculation rule;
wherein the preset unit price spreading rule comprises at least one of the following:
when the retail price information of all the goods to be delivered does not exist or is zero, the total amount of the currently sold goods is distributed to the goods to be delivered with the largest goods codes;
when retail price information of a plurality of ex-warehouse commodities does not exist, the plurality of ex-warehouse commodities do not participate in price allocation, and other ex-warehouse commodities are allocated according to the retail price weight proportion;
when retail price information of all the goods to be delivered exists, all the goods to be delivered participate in price allocation, and the price allocation is carried out according to the proportion of retail price weights.
7. A sales management apparatus for e-commerce retail goods, the management apparatus comprising:
a sales data model setting unit including a sales relationship maintenance table generating unit for:
acquiring the selling maintenance relation information of each selling commodity and the corresponding commodity which is delivered out of the warehouse, and generating a selling relation maintenance table according to the selling maintenance relation information; the sales relationship maintenance table comprises main commodity attribute information and sales association relationship information; the main commodity attribute information comprises sales commodity attribute information and corresponding ex-warehouse commodity attribute information; the selling association relation information comprises the selling quantity of the sold commodities, the corresponding ex-warehouse quantity of the ex-warehouse commodities and the conversion rate of the ex-warehouse quantity;
the ex-warehouse data information conversion unit is used for acquiring the selling data information of the current selling commodity and converting the ex-warehouse data information of the ex-warehouse commodity corresponding to the current selling commodity according to the selling relation maintenance table; the ex-warehouse data information comprises the number information of the ex-warehouse commodities.
8. The sales management apparatus for e-commerce retail goods according to claim 7, wherein the sales data model setting unit further comprises a first relationship record snapshot information acquisition unit operable to:
acquiring first relation record snapshot information of each sales commodity and corresponding ex-warehouse commodity according to a first preset settlement time, and performing settlement processing on the sales ex-warehouse data information in the first preset settlement time according to the first relation record snapshot information.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor, when executing the computer program, implements the steps of the sales management method of e-commerce retail goods according to any one of claims 1-6.
10. A computer readable storage medium storing a computer program, wherein the computer program when executed by a processor implements the steps of the sales management method of an e-commerce retail product of any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310173252.3A CN116029797A (en) | 2023-02-28 | 2023-02-28 | Sale management method, device, equipment and medium for retail commodity of electronic commerce |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310173252.3A CN116029797A (en) | 2023-02-28 | 2023-02-28 | Sale management method, device, equipment and medium for retail commodity of electronic commerce |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116029797A true CN116029797A (en) | 2023-04-28 |
Family
ID=86074184
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310173252.3A Pending CN116029797A (en) | 2023-02-28 | 2023-02-28 | Sale management method, device, equipment and medium for retail commodity of electronic commerce |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116029797A (en) |
Citations (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003323564A (en) * | 2002-05-07 | 2003-11-14 | Kurita Shuppan Hanbai Kk | Sales system |
| KR20060065974A (en) * | 2004-12-11 | 2006-06-15 | 안주영 | The method of operating an on-line marketplace separated the functions of goods supply/delivery and on-line shopping mall management/marketing/sales |
| CN201570086U (en) * | 2009-11-20 | 2010-09-01 | 上海实甲电子科技有限公司 | Ultra-high frequency radio-frequency identifying retail terminal management machine system |
| CN103593787A (en) * | 2013-10-25 | 2014-02-19 | 宁夏天纵泓光余热发电技术有限公司 | Meat commodity sales system and method |
| JP2015185098A (en) * | 2014-03-26 | 2015-10-22 | 株式会社クローズアップ | distribution management system |
| CN107203904A (en) * | 2017-05-19 | 2017-09-26 | 武汉弗赅科技有限公司 | The Dynamic Pricing method and system of merchandising |
| CN108932636A (en) * | 2018-07-05 | 2018-12-04 | 上海信颐信息技术有限公司 | A kind of commodity retail prediction technique and equipment |
| CN109800242A (en) * | 2018-12-26 | 2019-05-24 | 广州联业商用机器人科技股份有限公司 | A kind of processing method and system of sales data |
| CN110046969A (en) * | 2019-04-24 | 2019-07-23 | 北京上古彩科技股份有限公司 | Dispense marketing system and Correlation method for data processing method |
| CN110084963A (en) * | 2019-04-23 | 2019-08-02 | 苏州昇德智能科技有限公司 | The real-time positioning of intelligence retail and message management methods and system |
| CN110689290A (en) * | 2018-07-06 | 2020-01-14 | 北京京东尚科信息技术有限公司 | Commodity selling method and device |
| CN110706019A (en) * | 2019-09-03 | 2020-01-17 | 苏宁云计算有限公司 | Effective price tag pushing method and device, computer equipment and storage medium |
| CN112365321A (en) * | 2020-11-23 | 2021-02-12 | 江苏菜先生网络科技有限公司 | Method for realizing effective supervision and identification of fresh electronic commerce platform multi-merchant commodities |
| CN112785354A (en) * | 2021-03-09 | 2021-05-11 | 广东便捷神科技股份有限公司 | Commodity recommendation system for retail management platform |
| CN114037497A (en) * | 2021-11-18 | 2022-02-11 | 广州市智蓝电子商务有限公司 | Intelligent commodity management method, equipment and medium |
| CN114693345A (en) * | 2022-03-17 | 2022-07-01 | 上海禹璨信息技术有限公司 | Information processing method, device, equipment and storage medium |
| CN115170221A (en) * | 2022-05-19 | 2022-10-11 | 上海识致信息科技有限责任公司 | Commodity information aggregation method and device and electronic equipment |
| CN115668259A (en) * | 2020-04-23 | 2023-01-31 | 甲骨文国际公司 | Automatic clustering prediction model |
-
2023
- 2023-02-28 CN CN202310173252.3A patent/CN116029797A/en active Pending
Patent Citations (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003323564A (en) * | 2002-05-07 | 2003-11-14 | Kurita Shuppan Hanbai Kk | Sales system |
| KR20060065974A (en) * | 2004-12-11 | 2006-06-15 | 안주영 | The method of operating an on-line marketplace separated the functions of goods supply/delivery and on-line shopping mall management/marketing/sales |
| CN201570086U (en) * | 2009-11-20 | 2010-09-01 | 上海实甲电子科技有限公司 | Ultra-high frequency radio-frequency identifying retail terminal management machine system |
| CN103593787A (en) * | 2013-10-25 | 2014-02-19 | 宁夏天纵泓光余热发电技术有限公司 | Meat commodity sales system and method |
| JP2015185098A (en) * | 2014-03-26 | 2015-10-22 | 株式会社クローズアップ | distribution management system |
| CN107203904A (en) * | 2017-05-19 | 2017-09-26 | 武汉弗赅科技有限公司 | The Dynamic Pricing method and system of merchandising |
| CN108932636A (en) * | 2018-07-05 | 2018-12-04 | 上海信颐信息技术有限公司 | A kind of commodity retail prediction technique and equipment |
| CN110689290A (en) * | 2018-07-06 | 2020-01-14 | 北京京东尚科信息技术有限公司 | Commodity selling method and device |
| CN109800242A (en) * | 2018-12-26 | 2019-05-24 | 广州联业商用机器人科技股份有限公司 | A kind of processing method and system of sales data |
| CN110084963A (en) * | 2019-04-23 | 2019-08-02 | 苏州昇德智能科技有限公司 | The real-time positioning of intelligence retail and message management methods and system |
| CN110046969A (en) * | 2019-04-24 | 2019-07-23 | 北京上古彩科技股份有限公司 | Dispense marketing system and Correlation method for data processing method |
| CN110706019A (en) * | 2019-09-03 | 2020-01-17 | 苏宁云计算有限公司 | Effective price tag pushing method and device, computer equipment and storage medium |
| CN115668259A (en) * | 2020-04-23 | 2023-01-31 | 甲骨文国际公司 | Automatic clustering prediction model |
| CN112365321A (en) * | 2020-11-23 | 2021-02-12 | 江苏菜先生网络科技有限公司 | Method for realizing effective supervision and identification of fresh electronic commerce platform multi-merchant commodities |
| CN112785354A (en) * | 2021-03-09 | 2021-05-11 | 广东便捷神科技股份有限公司 | Commodity recommendation system for retail management platform |
| CN114037497A (en) * | 2021-11-18 | 2022-02-11 | 广州市智蓝电子商务有限公司 | Intelligent commodity management method, equipment and medium |
| CN114693345A (en) * | 2022-03-17 | 2022-07-01 | 上海禹璨信息技术有限公司 | Information processing method, device, equipment and storage medium |
| CN115170221A (en) * | 2022-05-19 | 2022-10-11 | 上海识致信息科技有限责任公司 | Commodity information aggregation method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Abernathy et al. | Retailing and supply chains in the information age | |
| US8019643B2 (en) | System and method for incorporating packaging and shipping ramifications of net profit/loss when up-selling | |
| CN108074051B (en) | Inventory management method and device | |
| CN110880061A (en) | Commodity hand price risk supervision method and system | |
| CN109978443B (en) | Enterprise ERP and e-commerce platform data docking method and system and computer equipment | |
| CN112101986A (en) | Method and equipment for determining commodity readjustment requirement | |
| CN108573422B (en) | Inventory information processing method, device and system | |
| CN107392597A (en) | A kind of intelligent payment method, device and service system | |
| CN108600323B (en) | Multi-center data sharing system and using method thereof | |
| CN110009450B (en) | Order counting method and device for package commodities | |
| CN113763125A (en) | Method and device for generating purchase order about purchased goods | |
| JP2002167047A (en) | Method and system of stock management through network | |
| CN113191789A (en) | Goods distribution method and equipment based on second-hand scene | |
| KR101794936B1 (en) | Pricing method of imported fashion goods using weighting | |
| CN116029797A (en) | Sale management method, device, equipment and medium for retail commodity of electronic commerce | |
| CN117194764A (en) | Goods display method, equipment and medium based on multi-platform fusion mall | |
| CN113869987A (en) | Computer system for monitoring commodity price of e-commerce platform | |
| CN113689235A (en) | Method, system, medium and terminal device for pre-accounting profit of cross-border e-commerce product | |
| CN114548702A (en) | Supply chain modeling method and system based on platform operation mode and carbon transaction policy | |
| CN111354123A (en) | Goods delivery control method, system and device for vending machine | |
| JP2021089542A (en) | Method, system and program for adjusting number of ordered commodities | |
| CN114723354A (en) | Online business opportunity mining method, equipment and medium for suppliers | |
| CN112308671A (en) | Commodity package generation method, system and storage medium | |
| CN112967111A (en) | Online sales system of store | |
| JP5075960B2 (en) | Product display quantity management system, server and control program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20230428 |