CN113538116A - Door type household on-line customized one-key quotation system and method - Google Patents
Door type household on-line customized one-key quotation system and method Download PDFInfo
- Publication number
- CN113538116A CN113538116A CN202111086809.7A CN202111086809A CN113538116A CN 113538116 A CN113538116 A CN 113538116A CN 202111086809 A CN202111086809 A CN 202111086809A CN 113538116 A CN113538116 A CN 113538116A
- Authority
- CN
- China
- Prior art keywords
- commodity
- price
- quotation
- door
- user
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0611—Request for offers or quotes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0621—Item configuration or customization
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a door type home online customized one-key quotation system and a method, wherein the system comprises a commodity price basic database, a commodity quotation front-end page, a one-key quotation operation module and an ERP system order processing module; according to the method, basic price parameters of the door type home furnishing are stored in advance and standardized, corresponding parameters of commodities are displayed on a front-end page in a linkage mode, accurate prices are fed back to a user in real time at one time, and information is thrown to an order processing module of an ERP system. The invention realizes the online customization of one-key quotation for the family home customized by the user, improves the experience of the user for customizing the commodity, ensures that the processes of order audit and production management in the subsequent ERP system become very quick, and greatly improves the running efficiency of the whole product customization process.
Description
Technical Field
The invention relates to the technical field of data processing systems or methods, in particular to a door type home online customization one-key quotation system and method.
Background
Door type house, such as various built-in timber doors, glass doors, aluminum alloy doors, window frame bealock, door pocket etc. as a part of house adornment, have wide market demand. With the pursuit of consumers on the home style, the taste and the consumption habit, the door home customization requirements tend to be more personalized, such as type, style, color, configuration, additional process and the like, and the choice is large. Meanwhile, under the popularization of internet marketing, the traditional offline ordering of door-type household products is changed into the online ordering and ordering by one key of a user, the offline family decoration service is enjoyed, the user experience is improved, and the inevitable trend of the e-commerce industry is achieved.
However, due to the complexity of door-type home furnishing, a user needs to obtain an accurate price after selecting and purchasing a customized door product, and the accurate customized order is placed to reach a back-end production department, so that manual participation of multiple links is often required, and the efficiency is low. Some customized home enterprises establish an online shopping mall system at the front end and an ERP management system at the rear end, but data association among the systems is not tight, so that the problems of high efficiency and accuracy of ordering by a user in online customization are difficult to solve, accurate price can be provided for the user only by manual intervention processing once or for many times, and online customization cannot be carried out efficiently in real time.
Disclosure of Invention
The invention provides a door type household online customization one-key quotation system and method aiming at the problems in the prior art, which realize that a user customizes the door type household online one-key to obtain accurate price through data correlation and intelligent operation of a commodity online customization system and an ERP system, and displays the price on a front-end mall page in real time, so that the user can immediately decide whether to customize an order, and the order directly enters production until delivery is completed after payment of the order, thereby forming a closed loop of order service. In order to achieve the purpose, the technical scheme provided by the invention is as follows:
a door type home online customized one-key quotation system comprises: the commodity price basic database is used for storing standardized commodity basic parameters and numerical values, prices and formula attribute information thereof; the commodity quotation front-end page is used for acquiring the commodity demand data customized by the user and presenting a price calculation result; the one-key quotation operation module is used for inquiring the commodity price basic database data and carrying out autonomous price operation; and the ERP system order processing module is used for receiving the quotation result of the commodity quotation front-end page and processing the household order business information and the production information of the department.
The door type home online customization one-key quotation system is characterized in that price basic parameters required by door type home commodity quotation supplied to a user are all stored in a commodity price basic database in advance and are standardized, after a commodity quotation front-end page obtains the requirement of the user for customizing door type home orders, multidimensional linkage parameter matching is automatically completed through a one-key quotation operation module, the price is calculated, and accurate prices are fed back to the user in real time on the commodity quotation front-end page at one time.
Further, the goods price base database includes: the commodity basic parameter library is used for storing the category parameters of door type home, such as size, color, process, line sleeving, hardware, hole site and the like; the commodity parameter configuration library is used for storing numerical attributes of various parameters of the door type home, including whether the door type home is presented under the conditions of classification, name and type, numerical range and reference value; the commodity price configuration library is used for storing various parameter price attributes of the door type home, including standard price and standard exceeding price under the condition that the classification, the name and the type accord with the standard price; and the commodity formula set library is used for storing door type household formula attributes, including whether to participate in operation and the position in the formula under the condition that the classification, the name and the type accord with the conditions.
A door type home online customization one-key quotation method comprises the following steps: step A, establishing and maintaining a commodity price basic database, and realizing that all price basic parameters required by door type home offer are stored in advance and standardized; b, acquiring user customized commodity information from a front-end page of the commodity quotation, triggering multi-dimensional query with a commodity price basic database, and realizing linkage display of page parameters; step C, acquiring a user quotation instruction from a front page of the commodity quotation, triggering a one-key quotation operation module to calculate the price in real time, and feeding back the accurate price to the user in real time at one time; and D, throwing a user order placing instruction and customized commodity quotation information to the ERP system order processing module, and transferring order business information and production arrangement information.
Further, the step a specifically includes: a1, establishing a commodity basic parameter library, including the types of size, color, process, line sleeving, hardware, hole site and the like and parameters under the types; step A2, establishing a commodity parameter configuration library, and setting the numerical attributes of each parameter, including whether the parameter is presented under the condition that the classification, the name and the type accord with, the numerical range and the reference value; step A3, establishing a commodity price configuration library, and setting price attributes of each parameter, including standard price and standard exceeding price under the condition that the classification, the name and the type accord with; step A4, establishing a commodity formula set library, and setting the formula attributes of each parameter, including whether to participate in the operation and the position in the formula under the condition that the classification, the name and the type accord with the conditions; step A5, adjusting and maintaining the database according to the supply and demand changes of the door type household goods, and keeping all price basic parameters required by the quotation stored in advance and standardized.
Specifically, the commodity classification includes a no-paint class, a baking paint class, and the like; the names of the products comprise wood doors, glass doors and the like, and the types comprise single-door doors, double-door doors, primary-secondary doors, invisible doors, double-sliding doors, three-sliding doors, four-sliding doors and the like.
Specifically, the commodity parameter sizes comprise package frame height, package frame width and package frame thickness, the colors are divided into a non-paint series and a baking paint series, the baking paint series is divided into a mixed oil series, a veneer A series, a veneer B series and the like, the process comprises edge number, opening modes, a flat plate, deep carving, glass, gold drawing and the like, the sleeving lines comprise single-package sleeving lines and double-package sleeving lines, hardware comprises a lock, a hinge, a door stopper and the like, and the hole positions comprise a door handle hole, a hinge hole, an intelligent lock hole and the like.
Specifically, when the parameters are all within the standard range, the standard price is: the unit price is high, wide, thick and door type coefficient, when the parameter exceeds the standard, the exceeding price which needs to be added is: (ultra-wide unit price + ultra-high unit price + ultra-thick unit price) over-standard coefficient.
Further, the step B specifically includes: step B1, obtaining user classification, commodity name and type selection information in sequence from the front page of the commodity quotation, and combining the information into commodity details; step B2, generating a customized commodity unique ID according to the commodity details, and establishing a commodity page configuration parameter linkage multidimensional model; step B3, carrying out multidimensional query on the commodity price basic database to realize the initialization of commodity page configuration parameters; and step B4, displaying the corresponding parameter information of the customized commodity on the front page of the mall, and acquiring the parameter data set or selected by the user.
Further, the step B3 specifically includes:
b31, establishing a commodity page configuration parameter table corresponding to the unique ID of the customized commodity, carrying out consolidation and differentiation by the processing center of the operation module through a data multi-matrix queue and a BOX structure according to the classification doorClass, the commodity name doorTitle and the type doorType longitudinally (namely, vertically distributed acquisition), acquiring a primary N Linkage (Linkage) result from a commodity parameter configuration library, and transversely (namely, horizontally distributed acquisition) associating the corresponding secondary N Linkage result according to the primary N result to obtain selectable parameters of the customized commodity, including color, process, hardware, accessories and the like;
b32, establishing a commodity price configuration table corresponding to the customized commodity unique ID, wherein the commodity price configuration table comprises two categories of a paint-free door local price configuration table and a paint baking door local price configuration table, an operation module is used for carrying out integration and differentiation according to a category doorClass, a commodity name doorTitle and a type doorType through a data multi-matrix queue and a BOX structure to obtain a first-level N basic price (BaseScript) result, Linkage (Linkage) is carried out, ID relevance is generated when the result is matched with the basic price (BaseScript) result, and the package frame height, the package frame width and the wall thickness range and the reference value of a correlation formula are input;
b33, establishing a hardware and hole site price configuration table corresponding to the unique ID of the customized commodity, and obtaining M independent unit prices by the operation module through a multi-matrix queue, so that integration of the database and a commodity front-end quotation page is completed, and online dynamic display of customized commodity custom parameters is realized.
Further, the step C specifically includes: step C1, acquiring the basic price under each parameter from the commodity price basic database, and displaying the standard price before the commodity does not refer to the customization demand on the webpage at the front end of the commodity quotation; step C2, according to the quotation instruction of the user, obtaining the input value of each parameter of the customized commodity, carrying out matching recombination operation, and generating a price calculation formula corresponding to the unique ID of the customized commodity; step C3, automatically calculating the accurate price of the customized commodity according to the price calculation formula corresponding to the customized commodity and the corresponding parameter input value; and step C4, feeding back the accurate price to the user on the front page of the commodity quotation in real time to obtain the order placing instruction of the user.
Further, the step C2 specifically includes:
c21, determining the household goods of the door type selected by the front page of the commodity quotation, and acquiring the basic price P1 of the goods from the commodity value configuration library;
c22, confirming the type, color, process, accessories and the like of the commodity according to the parameters corresponding to the front-end page of the commodity quoted price, matching the commodity price configuration table, obtaining the partial price P2, and calculating the preliminary total price P3 according to the type;
c23, obtaining the frame height H, the frame width W and the wall thickness of the standard size range and the input frame height H, the frame width W and the wall thickness T according to the type of the front page selection of the commodity quotation, wherein if any range exceeds the standard size range, the non-standard total base price P4 needs to be calculated;
c24, learning according to the type of the page selection of the front end of the commodity offer: the method comprises the following steps of inputting a reference value K of the package frame height, the package frame width and the wall thickness, and inputting package frame height H, package frame width W and wall thickness T, wherein the input size is larger than the reference value K, and non-standard price P5, P6 and P7 of the package frame height H, the package frame width W and the wall thickness T need to be calculated;
c25, matching the hardware price attribute configuration table and the hole site price configuration table according to the parameters corresponding to the front end page of the commodity quotation to obtain a hardware price P8 and a hole site price P9;
and C26, summarizing the steps C21-C25 to obtain a customized commodity price calculation formula comprising P1-P9.
Further, the step D specifically includes: step D1, inquiring the payment account change information, checking with the quotation structure provided by the front page of the commodity quotation, and confirming the collection of the money; step D2, inquiring the user information of the user information base, checking with the user login information of the commodity quotation front-end page, and confirming the order; step D3, sending a message to an order production auditor to obtain order production detail confirmation information; step D4, sending a message to the buyer to obtain confirmation information of the details of the raw materials of the order; and D5, after the confirmation of the production details and the confirmation of the raw material details are completed, sending a message to schedule production.
Compared with the prior art, the data parameters required by the door type home customized quotation are structured and standardized, all basic data related to external online sales and display of commodities are stored in the database in advance, intelligent query and calculation are carried out in the process of user customized selection, user data are obtained in real time, calculation results are fed back, the experience of the user customized commodities is improved, the subsequent processes of order audit and production management of an ERP system are very quick, and the running efficiency of the whole product customization process is greatly improved.
Drawings
FIG. 1 is a general block diagram of an on-line customized one-key quotation system for a family home according to the present invention;
FIG. 2 is a block diagram of a basic database of commodity prices for a one-key quotation system for a family home according to the present invention;
FIG. 3 is a flowchart illustrating the general steps of the method for customizing a one-touch quotation on-line for a gate home;
FIG. 4 is a detailed flowchart of step A of the method for customizing one-touch quotation on-line for a gate home;
FIG. 5 is a detailed flowchart of step B of the method for customizing one-touch quotation on-line for a gate home;
FIG. 6 is a detailed flowchart of step C of the method for customizing a one-touch quotation on-line for a gate home;
FIG. 7 is a detailed flowchart of step D of the method for customizing one-touch quotation on-line for a gate home;
FIG. 8 is a flowchart illustrating a method B3 for customizing a one-touch quotation on-line for a family member according to the present invention;
FIG. 9 is a flowchart illustrating a method C2 for customizing a one-touch quotation on-line for a family according to the present invention;
fig. 10 is a schematic diagram of the upper half of a front page of a commodity quotation in an embodiment of the system and method for online customizing one-key quotation for a family home according to the present invention.
Fig. 11 is a schematic view of a lower half of a front end page of commodity quotation according to an embodiment of the system and method for online customizing one-key quotation for a house class of doorways of the present invention.
Detailed Description
The following detailed description of embodiments of the present invention is provided in connection with the accompanying drawings and examples.
Referring to fig. 1-2, the door type home on-line customized one-key quotation system provided by the invention comprises a commodity price basic database, a commodity quotation front-end page, a one-key quotation operation module and an ERP system order processing module.
Referring to fig. 1-2, the commodity price basic database includes a commodity basic parameter library, a commodity parameter configuration library, a commodity price configuration library, and a commodity formula collection library.
Referring to fig. 1-2 and 3-7, the method for customizing one-key quotation for the house with doors provided by the invention comprises a general step A, B, C, D and specific steps A1-A5, B1-B4, C1-C4 and D1-D5; further, the specific flow of step B3 is shown in fig. 8.
Further, the specific flow of step C2 is shown in fig. 9, and includes:
c21, determining the household goods of the door type selected by the front page of the commodity quotation, and acquiring the basic price P1 of the goods from the commodity value configuration library;
c22, confirming the type, color, process, accessories and the like of the commodity according to the parameters corresponding to the front-end page of the commodity quoted price, matching the commodity price configuration table, obtaining the partial price P2, and calculating the preliminary total price P3 according to the type;
if the commodity type is single door, primary and secondary single door and double door, P3 = (P1 + P2) × S1, and at this time, S1 is different fixed coefficients; if the commodity type is a hidden door or a single-sliding door, P3 = (P1 + P2) + S2, and S2 is a different fixed value; if the commodity type is a double-sliding door, P3 = (P1 + P2) × S3 + S4, wherein S3 is a fixed coefficient, and S4 is a different fixed value; if the commodity type is single-moving glass door, P3 = (P1 + P2) + S5 + S6 × S7, wherein S5 is a fixed value, S6 is a fixed value, and S7 is a different coefficient; if the commodity type is double-moving glass door, three-moving glass door and four-moving glass door, P3 = (P1 + P2) × S8 + S9 + S10 × S11, at this time, S8 is a fixed coefficient, S9 is a fixed numerical value, S10 is a fixed numerical value, and S11 is different coefficients;
c23, according to the type of the commodity quotation front page selection, learning the standard size range, package frame height H, package frame width W, wall thickness and input package frame height H, package frame width W and wall thickness T, wherein any range exceeds the standard size range, then the non-standard total base price P4 is required to be calculated: p4 = { P3 }. S12, wherein S12 is a fixed coefficient;
c24, learning according to the type of the page selection of the front end of the commodity offer: the method comprises the following steps of inputting a reference value K of the package frame height, the package frame width and the wall thickness, and inputting package frame height H, package frame width W and wall thickness T, wherein the input size is larger than the reference value K, and non-standard price P5, P6 and P7 of the package frame height H, the package frame width W and the wall thickness T need to be calculated;
pack height P5 = (H-pack height K)/10 non-standard unit price n1 door leaf number
Frame width P6 = (W-frame width K)/10 × (non-standard unit price n 2)
Wall thickness P7 = (H × 2+ W)/1000 = (T-wall thickness K)/10 = non-labeled unit value n3
C25, matching the hardware price attribute configuration table and the hole site price configuration table according to the parameters corresponding to the front end page of the commodity quotation to obtain a hardware price P8 and a hole site price P9;
c26 summarizing steps C21-C25 to obtain custom commodity price calculation formulas including P1-P9 in each case, such as:
if the type is single door, primary-secondary single door and double door, the total price of the door type household goods totalplace = [ (P1 + P2) × S1 ] × S12 + P5 + P6 + P7 + P8+ P9;
if the type is invisible door or single-moving door, the total price of door household goods totalplace = [ (P1 + P2) + S2 ] + S12 + P5 + P6 + P7 + P8+ P9;
if the type is a double-moving door, the total price TotalPrice = [ (P1 + P2) × S3 + S4 ] × S12 + P5 + P6 + P7 + P8+ P9 of the door type household commodity;
if the type is a single-moving glass door, the total price of door household commodities is TotalPrice = [ (P1 + P2) + S5 + S6 × S7 ] + S12 + P5 + P6 + P7 + P8+ P9
If the type is double-moving glass door, three-moving glass door and four-moving glass door, the total price of door household goods totalplace = [ (P1 + P2) × S8 + S9 + S10 × S11 ] × S12 + P5 + P6 + P7 + P8+ P9.
The following examples are intended to illustrate the invention but are not intended to limit the scope of the invention.
Referring to fig. 1-2, 3-9 and 10-11, a method for customizing a one-key price quoted on line for a customized door product of a non-paint door, specifically a blue-tone FM-S605 single-door glass door, comprises the following steps:
a1, establishing a commodity basic parameter library, including types of size, color, process, line sleeving, hardware, hole site and the like and parameters under the types; step A2, establishing a commodity parameter configuration library, and setting the numerical attributes of each parameter, including whether the parameter is presented under the condition that the classification, the name and the type accord with, the numerical range and the reference value; step A3, establishing a commodity price configuration library, and setting price attributes of each parameter, including standard price and standard exceeding price under the condition that the classification, the commodity name and the type accord with; step A4, establishing a commodity formula set library, and setting the formula attributes of each parameter, including whether to participate in the operation and the position in the formula under the condition that the classification, the commodity name and the type accord with; step a5, adjusting the data and maintaining the database in case of external condition changes. And step A is completed, namely a commodity price basic database is established and maintained, and all price basic parameters required by door type household quotation are stored in advance and standardized. Specifically, the merchandise parameter database contains all parameters and attributes thereof related to the customization of the paint-free door 'blue FM-S605 single-opening glass door'.
Step B1, sequentially acquiring selection information of a user for the commodity classification of 'no-paint door', the product name of 'single-opening glass door' and the type of 'blue tone FM-S605' from a front page of the commodity quoted price to combine into a commodity detail of 'blue tone FM-S605 single-opening glass door'; step B2, generating a customized commodity unique ID '7627' according to the commodity details, and establishing a commodity page configuration parameter linkage multidimensional model; step B3, carrying out multidimensional query on the commodity price basic database to realize the initialization of commodity page configuration parameters, and determining parameters to be presented, including size parameters of 'frame height', 'frame width', 'wall thickness', and standard numerical range thereof, color parameters and selectable values thereof, process parameters of 'standard process' and reference values thereof, 'glass type' and reference values thereof, 'door line configuration' and reference values thereof, 'opening mode' and selectable values thereof, casing line parameters of 'door casing type' and selectable values thereof, hardware parameters of 'lock', 'hinge', 'door stopper' and selectable values thereof, and hole position parameters of 'door handle hole', 'hinge hole' and selectable values thereof; and step B4, displaying the parameter information corresponding to the customized commodity on the front page of the commodity quotation, and acquiring the parameter data set or selected by the user.
Step C1, obtaining the basic price under each parameter from the commodity price basic database, and displaying the standard price '2342.00 yuan' before the commodity does not refer to the customization demand on the webpage at the front end of commodity quotation; step C2, according to the user quotation instruction, obtaining input values of each parameter of the customized commodity, performing matching recombination operation, and determining the price calculation formula of the door product as (unit price, frame height, frame width, wall thickness, door leaf number 1, door type coefficient 1+ (ultra wide unit price, ultra high unit price, ultra thick unit price) + door pocket added price + hardware added price + hole site added price) and overproof coefficient 1.2); step C3, according to a price calculation formula corresponding to the customized commodity and a corresponding parameter input value, if the data input by a user is, selecting a color of 'rice thick', selecting a door pocket type of 'single wrapping sleeve', selecting 1 set of WMA041G lock, 2 sets of H-shaped top head WMC03KD hinge, 1 WM302BG door stopper, 1 handle hole without a hinge hole, 2200mm of the height of a wrapping frame, 880mm of the width of the wrapping frame and 550mm of the thickness of a wall, and automatically calculating the accurate price of the customized commodity to obtain 3698.72 yuan; and step C4, feeding back the accurate price to the user on the page of the front end of the commodity quotation in real time, providing a wooden door list for the user to inquire, clicking to purchase and pay by the user, and acquiring an order placing instruction of the user by the system.
Step D1, inquiring the payment account change information, checking with the quotation structure provided by the front page of the commodity quotation, and confirming the collection of the money; step D2, inquiring the user information of the user information base, checking with the user login information of the commodity quotation front-end page, and confirming the order; step D3, sending a message to an order production auditor to obtain order production detail confirmation information; step D4, sending a message to the buyer to obtain confirmation information of the details of the raw materials of the order; and D5, after the confirmation of the production details and the confirmation of the raw material details are completed, sending a message to schedule production.
And at this moment, the on-line customized one-key quotation process of the door household product without the paint door 'blue FM-S605 single-door glass door' is completed.
The on-line customized one-key quotation system and method for the house with the door provided by the invention have the following advantages: the data parameters required by door type home customization quotation are structured and standardized, all basic data related to external online sales and display of commodities are stored in a database in advance, intelligent query and calculation are carried out in the process of user customization selection, user data are obtained in real time, calculation results are fed back, the experience of user customization commodities is improved, the subsequent processes of order audit and production management of an ERP system are enabled to be very quick, and the running efficiency of the whole product customization process is greatly improved.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that are within the spirit and principle of the present invention are intended to be included therein.
Claims (9)
1. The utility model provides a door type house customization one-key quotation system on line which characterized in that includes: the commodity price basic database is used for storing standardized commodity basic parameters and numerical values, prices and formula attribute information thereof; the commodity quotation front-end page is used for acquiring the commodity demand data customized by the user and presenting a price calculation result; the one-key quotation operation module is used for inquiring the commodity price basic database data and carrying out autonomous price operation; the ERP system order processing module is used for receiving the quotation result of the commodity quotation front-end page and processing the household order business information and the production information of the department;
the door type home online customization one-key quotation system is characterized in that price basic parameters required by door type home commodity quotation supplied to a user are stored in a commodity price basic database in advance and standardized, after a commodity quotation front-end page obtains the requirement of the user for customizing a door type home order, multidimensional linkage parameter matching is automatically completed through a one-key quotation operation module, the price is calculated, and the accurate price is fed back to the user in real time on the commodity quotation front-end page at one time.
2. The door type home online customized one-touch quotation system of claim 1, wherein the commodity price base database comprises: the commodity basic parameter library is used for storing door family class parameters including size, color, process, line sleeving, hardware and hole site; the commodity parameter configuration library is used for storing numerical attributes of various parameters of the door type home, including whether the door type home is presented under the conditions of classification, name and type, numerical range and reference value; the commodity price configuration library is used for storing various parameter price attributes of the door type home, including standard price and standard exceeding price under the condition that the classification, the name and the type accord with the standard price; and the commodity formula set library is used for storing door type household formula attributes, including whether to participate in operation and the position in the formula under the condition that the classification, the name and the type accord with the conditions.
3. A door type home online customization one-key quotation method is characterized by comprising the following steps: step A, establishing and maintaining a commodity price basic database, and realizing that all price basic parameters required by door type home offer are stored in advance and standardized; b, acquiring user customized commodity information from a front-end page of the commodity quotation, triggering multi-dimensional query with a commodity price basic database, and realizing linkage display of page parameters; step C, acquiring a user quotation instruction from a front page of the commodity quotation, triggering a one-key quotation operation module to calculate the price in real time, and feeding back the accurate price to the user in real time at one time; and D, throwing a user order placing instruction and customized commodity quotation information to the ERP system order processing module, and transferring order business information and production arrangement information.
4. The method for customizing one-key quotation for a house of a gate type according to claim 3, wherein the step A specifically comprises the following steps: step A1, establishing a commodity basic parameter library, which comprises the parameters of size, color, process, line sleeving, hardware, hole site type and the like; step A2, establishing a commodity parameter configuration library, and setting the numerical attributes of each parameter, including whether the parameter is presented under the condition that the classification, the name and the type accord with, the numerical range and the reference value; step A3, establishing a commodity price configuration library, and setting price attributes of each parameter, including standard price and standard exceeding price under the condition that the classification, the name and the type accord with; step A4, establishing a commodity formula set library, and setting the formula attributes of each parameter, including whether to participate in the operation and the position in the formula under the condition that the classification, the name and the type accord with the conditions; step A5, adjusting and maintaining the database according to the supply and demand changes of the door type household goods, and keeping all price basic parameters required by the quotation stored in advance and standardized.
5. The method for customizing one-key quotation for a house of a door as claimed in claim 3, wherein the step B comprises: step B1, obtaining user classification, commodity name and type selection information in sequence from the front page of the commodity quotation, and combining the information into commodity details; step B2, generating a customized commodity unique ID according to the commodity details, and establishing a commodity page configuration parameter linkage multidimensional model; step B3, carrying out multidimensional query on the commodity price basic database to realize the initialization of commodity page configuration parameters; and step B4, displaying the corresponding parameter information of the customized commodity on the front page of the mall, and acquiring the parameter data set or selected by the user.
6. The method for customizing one-touch quotation for a house of a door as claimed in claim 5, wherein the step B3 specifically comprises:
b31, establishing a commodity page configuration parameter table corresponding to the unique ID of the customized commodity, carrying out normalization and differentiation by the processing center of the operation module according to classification, commodity name and type longitudinal (namely vertical distribution acquisition) through a data multi-matrix queue and a BOX structure, obtaining a primary N linkage result from a commodity parameter configuration library, and associating a corresponding secondary N linkage result transversely (namely horizontal distribution acquisition) according to the primary N results to obtain selectable parameters of the customized commodity, including color, process, hardware and accessories; n is an integer greater than or equal to 1;
b32, establishing a commodity price configuration table corresponding to the unique ID of the customized commodity, wherein the commodity price configuration table comprises two categories of a paint-free door local price configuration table and a paint baking door local price configuration table, an operation module is integrated and distinguished according to classification, commodity names and types through a data multi-matrix queue and a BOX structure to obtain N basic price results of the first class, the N basic price results are linked, when the results are matched with the basic price results, the ID relevance is generated, and the package frame height, the package frame width and the wall thickness input range and the reference value of a relevance formula are input;
b33, establishing a hardware and hole site price configuration table corresponding to the unique ID of the customized commodity, and obtaining M independent unit prices by the operation module through a multi-matrix queue, so that integration of the database and a commodity front-end quotation page is completed, and online dynamic display of customized commodity custom parameters is realized; and M is an integer greater than or equal to 1.
7. The method for customizing one-key quotation for a house of a door as claimed in claim 3, wherein the step C specifically comprises: step C1, acquiring the basic price under each parameter from the commodity price basic database, and displaying the standard price before the commodity does not refer to the customization demand on the webpage at the front end of the commodity quotation; step C2, according to the quotation instruction of the user, obtaining the input value of each parameter of the customized commodity, carrying out matching recombination operation, and generating a price calculation formula corresponding to the unique ID of the customized commodity; step C3, automatically calculating the accurate price of the customized commodity according to the price calculation formula corresponding to the customized commodity and the corresponding parameter input value; and step C4, feeding back the accurate price to the user on the front page of the commodity quotation in real time to obtain the order placing instruction of the user.
8. The method for customizing one-touch quotation for a house of a door as claimed in claim 7, wherein the step C2 specifically comprises:
c21, determining the household goods of the door type selected by the front page of the commodity quotation, and acquiring the basic price P1 of the goods from the commodity value configuration library;
c22, confirming the type, color, process and accessories of the commodity according to the parameters corresponding to the front page of the commodity quoted price, matching the commodity price configuration table, obtaining the partial price P2, and calculating the preliminary total price P3 according to the type;
c23, obtaining the frame height H, the frame width W and the wall thickness of the standard size range and the input frame height H, the frame width W and the wall thickness T according to the type of the front page selection of the commodity quotation, wherein if any range exceeds the standard size range, the non-standard total base price P4 needs to be calculated;
c24, learning according to the type of the page selection of the front end of the commodity offer: the method comprises the following steps of inputting a reference value K of the package frame height, the package frame width and the wall thickness, and inputting package frame height H, package frame width W and wall thickness T, wherein the input size is larger than the reference value K, and non-standard price P5, P6 and P7 of the package frame height H, the package frame width W and the wall thickness T need to be calculated;
c25, matching the hardware price attribute configuration table and the hole site price configuration table according to the parameters corresponding to the front end page of the commodity quotation to obtain a hardware price P8 and a hole site price P9;
and C26, summarizing the steps C21-C25 to obtain a customized commodity price calculation formula comprising P1-P9.
9. The method for customizing one-touch quotation for a house of a door as claimed in claim 3, further comprising the following steps: step D1, inquiring the payment account change information, checking with the quotation structure provided by the front page of the commodity quotation, and confirming the collection of the money; step D2, inquiring the user information of the user information base, checking with the user login information of the commodity quotation front-end page, and confirming the order; step D3, sending a message to an order production auditor to obtain order production detail confirmation information; step D4, sending a message to the buyer to obtain confirmation information of the details of the raw materials of the order; and D5, after the confirmation of the production details and the confirmation of the raw material details are completed, sending a message to schedule production.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111086809.7A CN113538116B (en) | 2021-09-16 | 2021-09-16 | Door type household on-line customized one-key quotation system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111086809.7A CN113538116B (en) | 2021-09-16 | 2021-09-16 | Door type household on-line customized one-key quotation system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113538116A true CN113538116A (en) | 2021-10-22 |
| CN113538116B CN113538116B (en) | 2022-03-22 |
Family
ID=78123249
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111086809.7A Active CN113538116B (en) | 2021-09-16 | 2021-09-16 | Door type household on-line customized one-key quotation system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113538116B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114723514A (en) * | 2022-03-08 | 2022-07-08 | 贝壳找房网(北京)信息技术有限公司 | Home decoration customized product management method, device and storage medium |
| CN115619490A (en) * | 2022-12-14 | 2023-01-17 | 索菲亚家居股份有限公司 | Drawing-based home automatic quotation method and system and storage medium |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701247A (en) * | 2016-03-03 | 2016-06-22 | 黄川东 | Construction method for engineering-product parameterization application system |
| CN106485578A (en) * | 2016-10-27 | 2017-03-08 | 南京用友通信息技术有限公司 | Smart home quick modularity quotation system and method |
| CN107767209A (en) * | 2017-09-21 | 2018-03-06 | 武汉蜕变人工智能科技有限公司 | A kind of automatic price quoting method and system |
| CN109064246A (en) * | 2018-06-22 | 2018-12-21 | 广东美久舍住宅产业有限公司 | Standardization is had furniture made to order with order generation method, device, storage medium and terminal |
| CN109389464A (en) * | 2018-09-21 | 2019-02-26 | 浙江升华云峰新材股份有限公司 | The management method and its system of carpentery workshop personalized customization household order |
| CN111161023A (en) * | 2019-12-27 | 2020-05-15 | 北大方正集团有限公司 | Order quotation method, system, terminal and computer readable storage medium |
| CN112801729A (en) * | 2020-12-25 | 2021-05-14 | 佛山欧神诺云商科技有限公司 | Whole-house quotation generation method, equipment and storage medium of home decoration system |
| CN113159858A (en) * | 2021-05-06 | 2021-07-23 | 山东白令三维科技有限公司 | 3D printing quotation system, method and device and storage medium |
| CN113256377A (en) * | 2021-05-21 | 2021-08-13 | 蜜蜂快装科技(深圳)有限公司 | Intelligent learning system for indoor design method |
| CN113298562A (en) * | 2021-05-21 | 2021-08-24 | 索菲亚家居股份有限公司 | Drawing-based home automatic quotation method and system and storage medium |
-
2021
- 2021-09-16 CN CN202111086809.7A patent/CN113538116B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701247A (en) * | 2016-03-03 | 2016-06-22 | 黄川东 | Construction method for engineering-product parameterization application system |
| CN106485578A (en) * | 2016-10-27 | 2017-03-08 | 南京用友通信息技术有限公司 | Smart home quick modularity quotation system and method |
| CN107767209A (en) * | 2017-09-21 | 2018-03-06 | 武汉蜕变人工智能科技有限公司 | A kind of automatic price quoting method and system |
| CN109064246A (en) * | 2018-06-22 | 2018-12-21 | 广东美久舍住宅产业有限公司 | Standardization is had furniture made to order with order generation method, device, storage medium and terminal |
| CN109389464A (en) * | 2018-09-21 | 2019-02-26 | 浙江升华云峰新材股份有限公司 | The management method and its system of carpentery workshop personalized customization household order |
| CN111161023A (en) * | 2019-12-27 | 2020-05-15 | 北大方正集团有限公司 | Order quotation method, system, terminal and computer readable storage medium |
| CN112801729A (en) * | 2020-12-25 | 2021-05-14 | 佛山欧神诺云商科技有限公司 | Whole-house quotation generation method, equipment and storage medium of home decoration system |
| CN113159858A (en) * | 2021-05-06 | 2021-07-23 | 山东白令三维科技有限公司 | 3D printing quotation system, method and device and storage medium |
| CN113256377A (en) * | 2021-05-21 | 2021-08-13 | 蜜蜂快装科技(深圳)有限公司 | Intelligent learning system for indoor design method |
| CN113298562A (en) * | 2021-05-21 | 2021-08-24 | 索菲亚家居股份有限公司 | Drawing-based home automatic quotation method and system and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114723514A (en) * | 2022-03-08 | 2022-07-08 | 贝壳找房网(北京)信息技术有限公司 | Home decoration customized product management method, device and storage medium |
| CN115619490A (en) * | 2022-12-14 | 2023-01-17 | 索菲亚家居股份有限公司 | Drawing-based home automatic quotation method and system and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113538116B (en) | 2022-03-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113538116B (en) | Door type household on-line customized one-key quotation system and method | |
| CN108710749B (en) | Intelligent curtain information management system | |
| US7228283B1 (en) | Aesthetic profile collection | |
| US6873967B1 (en) | Electronic shopping assistant and method of use | |
| KR101476613B1 (en) | System for ubiquitous smart shopping | |
| Berger et al. | Border prices and retail prices | |
| KR101371326B1 (en) | System for ubiquitous smart shopping | |
| US20170018019A1 (en) | System and method for list shopping over a computer network | |
| CN112819568B (en) | Supplier ordering method based on intelligent bidding platform | |
| CN108492163A (en) | A kind of retail method based on data integration processing | |
| JP2003016308A (en) | Article assessing method, article retrieving method, selling method with article assessing function, and article assessment system | |
| CN113689179A (en) | Informationized internet platform for improving operation efficiency of home industry | |
| WO2016192557A1 (en) | Chain inquiry and quotation system and method of network or electronic business | |
| CN111161020A (en) | Method and shopping platform capable of checking commodity selling area of manufacturer | |
| US20030046217A1 (en) | Procurement negotiation method | |
| JP2003337900A (en) | METHOD AND SYSTEM FOR SELLING PRODUCT Web-LINKED WITH THREE-DIMENSIONAL FLOOR PLAN OF HOUSE | |
| KR20220105976A (en) | Record media with programs for implementing product commissioning and creation services | |
| Aurelian et al. | STANDARD COST METHOD IN CONFECTIONERY PRODUCTION. | |
| KR20220105978A (en) | Method of providing market service based on product request device | |
| CN112085544A (en) | AR offline display and sale system | |
| Wang et al. | Pricing for perishable goods in advance selling strategy | |
| Abrori et al. | Determinants of Consumer Purchase Decisions with Price and Personal Factors as Control Variables | |
| Zhou | Business Model Analysis and Evaluation of Hotpot Catering Industry——Taking Haidilao and Xiabu Group as examples | |
| KR20220105986A (en) | Program for operation of market service providing device | |
| KR20220105975A (en) | Recording Medium |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Zhu Wenquan Inventor after: Xin Fumin Inventor after: Xu Chenglong Inventor after: Liu Hai Inventor before: Xin Fumin Inventor before: Xu Chenglong Inventor before: Zhu Wenquan Inventor before: Liu Hai |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |