KR102617602B1 - Apparatus and method for providing service of management for product purchase and sales - Google Patents

Abstract

The present invention relates to an apparatus and method for providing product purchasing and sales management services.
An electronic device according to an embodiment of the present invention includes a memory and a processor connected to the memory, wherein the processor receives product purchase information about the purchase of the first product from an administrator terminal, and Create a product management DB based on product purchase information, receive product sales information about sales of the first product from the manager terminal, update the product management DB based on the product sales information, and When receiving a first statement creation request regarding the creation of a sales transaction statement for the first product, the sales transaction statement for the first product is generated based on the product management DB, and the sales transaction statement is It can be transmitted to the manager terminal.

Description

Apparatus and method for providing product purchase and sales management services {APPARATUS AND METHOD FOR PROVIDING SERVICE OF MANAGEMENT FOR PRODUCT PURCHASE AND SALES}

The present invention relates to an apparatus and method for providing product purchasing and sales management services.

Unless otherwise indicated herein, the material described in this section is not prior art to the claims of this application, and is not admitted to be prior art by inclusion in this section.

There are many programs that manage the wholesale and retail of products. At this time, the main purpose of users is to check which company they purchased the product from, at how much, and how much profit they made by selling it to which company and at how much.

The existing program was able to check the profit margin based on the purchase price and sales price when checking the sales statement for a specific company, but it was difficult to confirm through which company the purchase was made.

Accordingly, the present invention seeks to propose a technology that can solve the above problems.

Korean Patent No. 10-2534925 (2023.05.17.)

One embodiment of the present invention provides an apparatus and method for providing product purchasing and sales management services.

The technical problems to be achieved in the present invention are not limited to the technical problems mentioned above, and other technical problems not mentioned will be clearly understood by those skilled in the art from the description below. You will be able to.

In order to achieve the above-described object, an electronic device according to an embodiment of the present invention includes a memory and a processor connected to the memory, the processor Receive product purchase information, create a product management DB based on the product purchase information, receive product sales information on sales of the first product from the manager terminal, and manage the product based on the product sales information. When updating the DB and receiving a first statement creation request regarding the creation of a sales transaction statement for the first product from the administrator terminal, the sales transaction statement for the first product is generated based on the product management DB. It is possible to generate and transmit the sales transaction statement to the manager terminal.

At this time, the product purchase information includes information about the first transaction including the purchaser, item name, specification, quantity, purchase price, and purchase price for the first product, and the product sales information includes the first transaction. 1 It contains information about the second transaction, including the sales partner, item name, standard, quantity, sales price, and sales price for the product, and the processor determines the item name for the first product based on the product purchase information. , the product management DB can be created by organizing the preset item code, specification, quantity, purchase price, purchase price, and purchase date to correspond to the item name by purchasing customer.

At this time, when receiving the first statement creation request for the second transaction, the processor determines the item name for the first product based on the product sales information and the product management DB for the second transaction. , when generating the sales transaction statement including information on item code, specifications, quantity, sales price, sales price, value-added tax, and sales date, and receiving memo information about the second transaction from the manager terminal, When creating a sales transaction statement, the sales transaction statement can be generated including the memo information.

At this time, when receiving a request to view the sales transaction statement from the manager terminal, the processor sends the sales transaction statement and the product purchase information for the first product corresponding to the second transaction to the manager terminal. can be sent to.

At this time, if the inventory amount for the first product is less than a preset critical inventory amount based on the product management DB, the processor derives a recommendation level for each first purchasing customer selling the first product, and determines the recommendation level. A second purchasing customer exceeding the preset critical recommendation level may be derived, and information on the second purchasing customer and information on the recommended order quantity derived based on the product management DB may be transmitted to the manager terminal.

At this time, the recommendation degree is derived by the equation below,

RS refers to the recommendation level, a refers to the number of transactions conducted with the first purchasing customer during the preset period, and a' refers to the average number of transactions conducted with all first purchasing customers during the period, , b means the first average purchase price in one transaction of the first product purchased from the first purchasing customer during the above period, and b' refers to the first average purchase price purchased from all first purchasing customers during the above period. refers to the second average purchase price per transaction of the product, c refers to the first average purchase quantity per transaction of the first product purchased from the first purchasing partner during the above period, and c' may mean the second average purchase quantity in one transaction of the first product purchased from all first purchasing partners during the above period.

At this time, the processor divides one year into a plurality of preset seasons, and based on the first season to which the time of generating the recommended order quantity belongs, extracts the first preset number of previous seasons as the second season, and , extracting the first average sales quantity for each season of the first product based on the past sales history of the second season, extracting the season after the second number preset based on the first season as the third season, and , compared to the existing sales customers for the first product, derive the number of new sales customers who newly sold the first product in the third season, the current inventory amount for the first product, and the first average sales The recommended order quantity can be derived based on the quantity, the number of existing sales customers, and the number of new sales customers.

At this time, the recommended order quantity is derived by the equation below,

ROQ refers to the recommended order quantity, d refers to the first average sales quantity, e refers to the inventory amount, k refers to the number of existing sales customers, and k' refers to the number of new sales customers. It can mean.

In this way, according to an embodiment of the present invention, an apparatus and method for providing product purchase and sales management services can be provided.

The effects that can be obtained from the present invention are not limited to the effects mentioned above, and other effects not mentioned can be clearly understood by those skilled in the art from the description below. will be.

The above-described and other aspects, features and benefits of certain preferred embodiments of the present invention will become more apparent from the following description taken in conjunction with the accompanying drawings.
1 is a conceptual diagram of a device for providing product purchase and sales management services according to an embodiment of the present invention.
Figure 2 is a block diagram of an electronic device according to an embodiment of the present invention.
Figure 3 is a diagram showing the creation of a sales transaction statement according to an embodiment of the present invention.
Figure 4 is a diagram showing the display of product purchase information according to an embodiment of the present invention.
Figure 5 is a diagram showing the derivation of a second purchasing customer and recommended order quantity according to an embodiment of the present invention.
Figure 6 is an exemplary diagram explaining the first season, second season, and third season according to an embodiment of the present invention.
Figure 7 is a flowchart of a method for providing product purchase and sales management services according to an embodiment of the present invention.
It should be noted that throughout the drawings, like reference numerals are used to illustrate identical or similar elements, features and structures.

Hereinafter, embodiments of the present invention will be described in detail with reference to the attached drawings.

In describing the embodiments, descriptions of technical content that is well known in the technical field to which the present invention belongs and that are not directly related to the present invention will be omitted. This is to convey the gist of the present invention more clearly without obscuring it by omitting unnecessary explanation.

For the same reason, some components are exaggerated, omitted, or schematically shown in the accompanying drawings. Additionally, the size of each component does not entirely reflect its actual size. In each drawing, identical or corresponding components are assigned the same reference numbers.

The advantages and features of the present invention and methods for achieving them will become clear by referring to the embodiments described in detail below along with the accompanying drawings. However, the present invention is not limited to the embodiments disclosed below and may be implemented in various different forms. The present embodiments are merely provided to ensure that the disclosure of the present invention is complete and to provide common knowledge in the technical field to which the present invention pertains. It is provided to fully inform those who have the scope of the invention, and the present invention is only defined by the scope of the claims. Like reference numerals refer to like elements throughout the specification.

At this time, it will be understood that each block of the processing flow diagrams and combinations of the flow diagram diagrams can be performed by computer program instructions. These computer program instructions can be mounted on a processor of a general-purpose computer, special-purpose computer, or other programmable data processing equipment, so that the instructions performed through the processor of the computer or other programmable data processing equipment are described in the flow chart block(s). It creates the means to perform functions. These computer program instructions may also be stored in computer-usable or computer-readable memory that can be directed to a computer or other programmable data processing equipment to implement a function in a particular manner, so that the computer-usable or computer-readable memory It is also possible to produce manufactured items containing instruction means that perform the functions described in the flowchart block(s). Computer program instructions can also be mounted on a computer or other programmable data processing equipment, so that a series of operational steps are performed on the computer or other programmable data processing equipment to create a process that is executed by the computer, thereby generating a process that is executed by the computer or other programmable data processing equipment. Instructions that perform processing equipment may also provide steps for executing the functions described in the flow diagram block(s).

Additionally, each block may represent a module, segment, or portion of code that includes one or more executable instructions for executing specified logical function(s). Additionally, it should be noted that in some alternative execution examples it is possible for the functions mentioned in the blocks to occur out of order. For example, it is possible for two blocks shown in succession to be performed substantially at the same time, or it is possible for the blocks to be performed in reverse order depending on the corresponding function.

At this time, the term '~unit' used in this embodiment refers to software or hardware components such as FPGA (field-programmable gate array) or ASIC (Application Specific Integrated Circuit), and '~unit' refers to what role perform them. However, '~part' is not limited to software or hardware. The '~ part' may be configured to reside in an addressable storage medium and may be configured to reproduce on one or more processors. Therefore, as an example, '~ part' refers to components such as software components, object-oriented software components, class components, and task components, processes, functions, properties, and procedures. , subroutines, segments of program code, drivers, firmware, microcode, circuitry, data, databases, data structures, tables, arrays, and variables. The functions provided within the components and 'parts' may be combined into a smaller number of components and 'parts' or may be further separated into additional components and 'parts'. Additionally, components and 'parts' may be implemented to regenerate one or more CPUs within a device or a secure multimedia card.

In describing the embodiments of the present invention in detail, the main focus will be on the example of a specific system, but the main point claimed in this specification is that the scope disclosed in this specification is applicable to other communication systems and services with similar technical background. It can be applied within a range that does not deviate significantly, and this can be done at the discretion of a person with skilled technical knowledge in the relevant technical field.

1 is a conceptual diagram of a device for providing product purchase and sales management services according to an embodiment of the present invention.

Referring to FIG. 1, the device for providing product purchase and sales management services according to an embodiment of the present invention can create and manage a product management DB based on product purchase information and product sales information received from the manager terminal 200. there is.

Meanwhile, the device for providing product purchasing and sales management services may be referred to as 'electronic device 100' in the present invention.

At this time, the administrator terminal 200 is a communication capable desktop computer, laptop computer, laptop, smart phone, tablet PC, or mobile phone. , smart watch, smart glass, e-book reader, PMP (portable multimedia player), portable game console, navigation device, digital camera, DMB (digital multimedia broadcasting) player. , may include a digital audio recorder, a digital audio player, a digital video recorder, a digital video player, a PDA (Personal Digital Assistant), etc.

Figure 2 is a block diagram of an electronic device 100 according to an embodiment of the present invention.

The electronic device 100 according to one embodiment includes a processor 110 and a memory 120. The processor 110 may perform at least one method described above. The memory 120 may store information related to the above-described method or store a program implementing the above-described method. Memory 120 may be volatile memory or non-volatile memory. The memory 120 may be called a 'database', a 'storage unit', etc.

The processor 110 can execute programs and control the electronic device 100. The code of the program executed by the processor 110 may be stored in the memory 120. The device 100 is connected to an external device (eg, a personal computer or a network) through an input/output device (not shown) and can exchange data.

At this time, the processor 110 may receive product purchase information about the purchase of the first product from the manager terminal 200.

At this time, the product purchase information may include information about the first transaction, including the purchaser, item name, specification, quantity, purchase unit price, and purchase price for the first product.

Additionally, the processor 110 may create a product management DB based on the product purchase information. In more detail, the processor 110, based on the product purchase information, determines the item name for the first product, the item code preset to correspond to the item name, specification, quantity, purchase unit price, purchase price, and purchase date. The above product management DB can be created by organizing by purchasing customer.

Through this, managers can efficiently manage detailed information about the products they have purchased.

Additionally, the processor 110 may receive product sales information regarding sales of the first product from the manager terminal 200.

At this time, the product sales information refers to information on how much and in what quantity the first product was sold to which sales customer. In more detail, the product sales information refers to information about the first product. It may contain information about the second transaction, including the sales partner, item name, specifications, quantity, sales price, and sales price.

Additionally, the processor 110 may update the product management DB based on the product sales information. Through this, you can manage the details of purchases and sales, and manage the inventory amount for each product in real time.

In addition, when the processor 110 receives a first statement creation request regarding the creation of a sales transaction statement for the first product from the manager terminal 200, the processor 110 creates the first product based on the product management DB. It is possible to generate the sales transaction statement for and transmit the sales transaction statement to the manager terminal 200.

Figure 3 is a diagram showing the creation of a sales transaction statement according to an embodiment of the present invention.

Referring to FIG. 3, when receiving the first statement creation request for the second transaction, the processor 110, based on the product sales information and the product management DB for the second transaction, The sales transaction statement can be created including information on the item name, item code, specifications, quantity, sales price, sales price, value-added tax, and sales date for the first product.

At this time, the manager may note special details about the transaction. In addition, the memo must be included in the sales transaction statement so that the manager can immediately recognize any unusual details when checking the transaction later.

To this end, when receiving memo information about the second transaction from the manager terminal 200, the processor 110 generates the sales transaction statement including the memo information. can be created.

Figure 4 is a diagram showing the display of product purchase information according to an embodiment of the present invention.

Referring to Figure 4, the manager may check the profit margin for a specific customer or specific item. At this time, when selling a specific product to a specific customer, the net profit margin can be checked based on the purchase price and sales price.

However, in this case, it is important from the manager's perspective to check which vendor the product was purchased from.

To this end, when receiving a request to view the sales transaction statement from the manager terminal 200, the processor 110 processes the product purchase for the first product corresponding to the sales transaction statement and the second transaction. Information can be transmitted to the manager terminal 200 together.

Figure 5 is a diagram showing the derivation of a second purchasing customer and recommended order quantity according to an embodiment of the present invention.

While managing inventory in real time, if inventory falls below a certain level, it is necessary to replenish inventory for future sales. At this time, there may be multiple purchasers for the product, and it is necessary to compare which of each purchaser is preferable to purchase from. Additionally, it is necessary to determine how much additional quantity should be ordered.

To this end, the processor 110 derives a recommendation level for each first purchasing customer selling the first product when the inventory amount for the first product is less than a preset critical inventory amount based on the product management DB, The manager terminal 200 derives a second purchasing customer whose recommendation level exceeds a preset critical recommendation level, and sends information about the second purchasing customer and information about the recommended order amount derived based on the product management DB to the manager terminal 200. can be sent to.

At this time, the critical inventory amount may be set as the average of the sales volume of the first product sold through one transaction.

Additionally, the critical recommendation level may be set as the average of the recommendation levels for all first purchasing customers.

In more detail, the recommendation level can be derived by Equation 1 below.

[Equation 1]

At this time, RS refers to the recommendation level, a refers to the number of transactions conducted with the first purchasing customer during the preset period, and a' refers to the average number of transactions conducted with all first purchasing customers during the period. means, b means the first average purchase price in one transaction of the first product purchased from the first purchasing customer during the above period, and b' refers to the first average purchase price purchased from all first purchasing customers during the above period. refers to the second average purchase price per transaction of the first product, c refers to the first average purchase quantity per transaction of the first product purchased from the first purchasing partner during the period, and , c' may mean the second average purchase quantity in one transaction of the first product purchased from all first purchasing partners during the above period.

At this time, the period may be arbitrarily set by the operator of the present invention, for example, 6 months or 1 year.

Through this, it is possible to derive an objective recommendation that takes into account the transaction credit with the first purchasing customer and the profit margin from product sales.

Figure 6 is an exemplary diagram explaining the first season, second season, and third season according to an embodiment of the present invention.

At this time, it is desirable to order the recommended order quantity appropriately. To this end, an embodiment of the present invention considers the expected sales volume of how much sales will be made in the future and determines the recommended order quantity by considering how much more sales are likely to be made in the future by reflecting the trend of increasing new sales customers for the product. It can be derived.

Looking in more detail with reference to FIG. 6, the processor 110 may divide one year into a plurality of preset seasons.

At this time, referring to FIG. 6, seasons can be divided by month.

Additionally, the processor 110 may extract a preset first number of previous seasons as a second season, based on the first season in which the recommended order quantity is generated.

This is to predict future sales volume, and the first number may be arbitrarily set by the operator of the present invention or may be derived based on the average delivery period of the first product. For example, if the season is set at an interval of 1 month and the average delivery period of the first product is 3 months, the first number may be set to 3.

Additionally, the processor 110 may extract the first average sales quantity for each season of the first product based on the past sales history of the second season.

Additionally, the processor 110 may extract a preset second number of subsequent seasons based on the first season as the third season.

This is to check how much the number of new sales customers for the first product has recently increased and to check the possibility of future sales volume increase.

At this time, the second number can be arbitrarily set by the operator of the present invention. It may be set to be the same as the first number, or may be set shorter depending on the characteristics of the first product. For example, if the first product is a product related to a season, it may be set briefly to check before the season passes.

In addition, the processor 110 derives the number of new sales customers who newly sold the first product in the third season, compared to existing sales customers for the first product, and calculates the number of new sales customers for the first product. The recommended order quantity can be derived based on the current inventory amount, the first average sales quantity, the number of existing sales customers, and the number of new sales customers.

In more detail, the recommended order quantity can be derived by Equation 2 below.

[Equation 2]

At this time, ROQ means the recommended order quantity, d means the first average sales quantity, e means the inventory quantity, k means the number of existing sales customers, and k' means the new sales quantity. It can refer to the number of business partners.

Through this, a recommended order quantity that can maintain an appropriate inventory level can be derived.

Figure 7 is a flowchart of a method for providing product purchase and sales management services according to an embodiment of the present invention.

Referring to FIG. 7, the method of providing product purchase and sales management services according to an embodiment of the present invention may receive product purchase information about the purchase of the first product from the manager terminal 200 (S101).

Additionally, the method for providing product purchase and sales management services according to an embodiment of the present invention can create a product management DB based on the product purchase information (S103).

In addition, the method of providing product purchase and sales management services according to an embodiment of the present invention can receive product sales information about sales of the first product from the manager terminal 200 (S105).

Additionally, the method for providing product purchase and sales management services according to an embodiment of the present invention can update the product management DB based on the product sales information (S107).

In addition, when receiving a first statement creation request regarding the creation of a sales transaction statement for the first product from the manager terminal 200, the sales transaction statement for the first product is generated based on the product management DB. Can be created (S109).

Additionally, the method for providing product purchase and sales management services according to an embodiment of the present invention can transmit the sales transaction statement to the manager terminal 200 (S111).

Additionally, the method for providing product purchase and sales management services according to an embodiment of the present invention may be configured in the same way as the device for providing product purchase and sales management services disclosed in FIGS. 1 to 6.

The embodiments described above may be implemented with hardware components, software components, and/or a combination of hardware components and software components. For example, the devices, methods, and components described in the embodiments may include, for example, a processor, a controller, an arithmetic logic unit (ALU), a digital signal processor, a microcomputer, and a field programmable gate (FPGA). It may be implemented using one or more general-purpose or special-purpose computers, such as an array, programmable logic unit (PLU), microprocessor, or any other device capable of executing and responding to instructions. A processing device may execute an operating system (OS) and one or more software applications that run on the operating system. Additionally, a processing device may access, store, manipulate, process, and generate data in response to the execution of software. For ease of understanding, a single processing device may be described as being used; however, those skilled in the art will understand that a processing device includes multiple processing elements and/or multiple types of processing elements. It can be seen that it may include. For example, a processing device may include a plurality of processors or one processor and one controller. Additionally, other processing configurations, such as parallel processors, are possible.

The method according to the embodiment may be implemented in the form of program instructions that can be executed through various computer means and recorded on a computer-readable medium. The computer-readable medium may include program instructions, data files, data structures, etc., singly or in combination. Program instructions recorded on the medium may be specially designed and configured for the embodiment or may be known and available to those skilled in the art of computer software. Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks, and magnetic tapes, optical media such as CD-ROMs and DVDs, and magnetic media such as floptical disks. -Includes optical media (magneto-optical media) and hardware devices specifically configured to store and execute program instructions, such as ROM, RAM, flash memory, etc. Examples of program instructions include machine language code, such as that produced by a compiler, as well as high-level language code that can be executed by a computer using an interpreter, etc. The hardware devices described above may be configured to operate as one or more software modules to perform the operations of the embodiments, and vice versa.

Software may include a computer program, code, instructions, or a combination of one or more of these, which may configure a processing unit to operate as desired, or may be processed independently or collectively. You can command the device. Software and/or data may be used on any type of machine, component, physical device, virtual equipment, computer storage medium or device to be interpreted by or to provide instructions or data to a processing device. , or may be permanently or temporarily embodied in a transmitted signal wave. Software may be distributed over networked computer systems and stored or executed in a distributed manner. Software and data may be stored on one or more computer-readable recording media.

Although the embodiments have been described with limited drawings as described above, those skilled in the art can apply various technical modifications and variations based on the above. For example, the described techniques are performed in a different order than the described method, and/or components of the described system, structure, device, circuit, etc. are combined or combined in a different form than the described method, or other components are used. Alternatively, appropriate results may be achieved even if substituted or substituted by an equivalent.

Therefore, other implementations, other embodiments, and equivalents of the claims also fall within the scope of the following claims.

Claims (5)

In electronic devices,
memory; and
A processor connected to the memory; Including,
The processor:
Receive product purchase information about the purchase of the first product from the manager terminal,
Create a product management DB based on the product purchase information,
Receiving product sales information on sales of the first product from the manager terminal,
Update the product management DB based on the product sales information,
When receiving a first statement creation request regarding the creation of a sales transaction statement for the first product from the manager terminal,
Generating the sales transaction statement for the first product based on the product management DB,
Send the sales transaction statement to the manager terminal,
The above product purchase information is,
Contains information about the first transaction, including the purchaser, item name, specification, quantity, purchase price, and purchase price for the first product,
The product sales information is,
Contains information about the second transaction, including the sales partner, item name, specifications, quantity, sales price, and sales price for the first product,
The processor,
Based on the product purchase information, the product management DB is created by organizing the item name for the first product, the item code preset to correspond to the item name, specifications, quantity, purchase unit price, purchase price, and purchase date by purchasing customer. However,
The processor,
When receiving the first statement creation request for the second transaction, based on the product sales information and the product management DB for the second transaction,
Generate the sales transaction statement including information on the item name, item code, specifications, quantity, sales price, sales price, value-added tax, and sales date for the first product,
When receiving memo information about the second transaction from the manager terminal, when generating the sales transaction statement, generate the sales transaction statement including the memo information,
The processor,
When receiving a request to view the sales transaction statement from the manager terminal,
The sales transaction statement and the product purchase information for the first product corresponding to the second transaction are transmitted to the manager terminal together,
The processor,
If the inventory amount for the first product is less than the preset critical inventory amount based on the product management DB,
Deriving a recommendation level for each first purchasing business that sells the first product,
By deriving a second purchasing customer whose recommendation level exceeds the preset critical recommendation level,
Transmitting information about the second purchasing customer and information about the recommended order quantity derived based on the product management DB to the manager terminal,
The above recommendation is,
It is derived from the equation below,

RS refers to the recommendation level, a refers to the number of transactions conducted with the first purchasing customer during the preset period, and a' refers to the average number of transactions conducted with all first purchasing customers during the period, , b means the first average purchase price in one transaction of the first product purchased from the first purchasing customer during the above period, and b' refers to the first average purchase price purchased from all first purchasing customers during the above period. refers to the second average purchase price per transaction of the product, c refers to the first average purchase quantity per transaction of the first product purchased from the first purchasing partner during the above period, and c' means the second average purchase quantity in one transaction of the first product purchased from all first purchasing partners during the above period,
The processor,
One year is divided into a plurality of preset seasons, and based on the first season to which the time of generating the recommended order quantity belongs, the previous season of the first preset number is extracted as the second season, and the past of the second season is extracted. Based on the sales history, the first average sales quantity for each season of the first product is extracted, the season after the second number preset based on the first season is extracted as the third season, and the season for the first product is extracted. By comparing with existing sales customers, the number of new sales customers who newly sold the first product in the third season is derived, the current inventory amount for the first product, the first average sales quantity, and the number of new sales customers who newly sold the first product in the third season are derived. Deriving the recommended order quantity based on the number of new sales customers,
The recommended order quantity is:
It is derived from the equation below,

ROQ refers to the recommended order quantity, d refers to the first average sales quantity, e refers to the inventory amount, k refers to the number of existing sales customers, and k' refers to the number of new sales customers. means,
The above period is,
Set to 6 months or 1 year,
The season is,
It is set to 1 month,
The first number is,
An electronic device, characterized in that it is set as the average delivery period of the first product divided by the season. delete delete delete delete

Images