Keywords
Systematization, web systems, sales management, time, agile methodologies
This article is included in the Software and Hardware Engineering gateway.
Nowadays, organisations are encountering ever-more challenging demands, and those that do not adapt risk closure. This trend is particularly notable in small and medium-sized enterprises, where deficits in technology adoption are often particularly conspicuous. Companies that succeed in streamlining their sales process are more likely to enjoy better outcomes, underlining the crucial requirement of implementing technical solutions to tackle these problems with optimal efficiency. Therefore, the aim of this investigation is to deploy a web-based system for the purpose of enhancing sales management in a company operating in the field of real estate and construction. The system was constructed utilising Extreme Programming XP methodology, consisting of four phases: planning (user stories), design (system outline), coding (system programming) and testing (testing). The introduction of a web-based system highly streamlined the company’s sales process, reducing information search times by 64% and decreasing time spent on recording sales data by 62%. The system enabled greater sales activity during the day, resulting in a 72% increase in task performance. It also aided the accounting department in streamlining revenue reporting. This demonstrates that the system is an efficient tool for enhancing the sales process, reducing yearly tasks, and minimizing recording time.
Systematization, web systems, sales management, time, agile methodologies
The rapidly increasing production of data across a variety of social domains has created an pressing need for efficient tools that can precisely analyze and manage this information in a clear and understandable manner.1,2 At present, the manual handling of these operations has become intricate and prone to errors, necessitating a technological solution for centralised and real-time data control and visualisation.3 One solution is to develop a web-based system that enhances the efficiency of the sales process to a significant degree.4
This technology for business intelligence can integrate all data and intelige records of business transactions in a unified manner.5,6 It also offers a thorough and current overview of sales behaviour.7,8 Furthermore, the implementation of a system enables customised customer follow-up, resulting in heightened levels of customer satisfaction and loyalty.9 On the contrary, the provision of real-time reports and statistics will enhance managers’ capability to evaluate sales performance and boost customer contentment.10
In this context, web-based tools or systems present an appealing option for enhancing sales management.11 The approach aims to automate business processes, centralise information, and optimise customer service, with the goal of achieving substantial growth and success for the organisation.12 Furthermore, the implementation of integrated automation has the potential to notably diminish the burden of manual labour, leading to a heightened optimisation of accessible resources and a decrease in errors.13
The adoption of a web-based system using Open Source distribution tools facilitates comprehensive information management for corporations.14,15 It can offer swift, effortless, and gratifying services to enhance organizational sales.16 Furthermore, the company implemented a web-based system which enhanced the product registration process and subsequently boosted sales figures.5
Several case studies indicate that incorporating a web-based system for sales management within a company enhances sales process efficiency and decision-making.17,18 Furthermore, there is robust, contemporary evidence concerning the particular correlation between this tool and its ability to enhance data visualisation and sales management within commercial projects.19–21
The purpose of this article is to evaluate the web-based sales management system’s effectiveness upon implementation in Titanio SAC. This will lead to the optimization of commercial processes and contribute to the company’s sustainable growth within the market. Moreover, the article aims to examine the system’s efficiency, taking into account factors such as information search times and sales process duration.
This study enhances the construction and real estate sector’s knowledge and development by presenting crucial insights into the implementation of a web-based sales management system, and its impact on construction businesses. The study’s results and conclusions, which promote efficiency, productivity, and informed decision-making, could potentially expedite and enhance company growth.
This article is divided into five sections, with the first section serving as the Introduction, where issues encountered by companies regarding sales and systematisation are presented. Section 2, known as the Method, provides a detailed account of the hardware and step-by-step procedure employed in developing the web system, using the project methodology. Section 3, named Results, involves the production of infographics to illustrate the working of the system and its interfaces. Section 4 of this study compares and analyses the findings with existing research and relevant theoretical frameworks. Subsequently, in Section 5, the author presents their conclusions on the benefits of their research and their recommendations for future studies.
In this section, we describe the methods used in the development and operation of our software,22 a programme designed to improve decision making for micro and small enterprises in the real estate sector.
A laptop equipped with an AMD Ryzen 9 5900HX processor, Radeon Graphics, Windows 11 Pro 64-bit OS (10.0, build 22621), and 16384MB of RAM was utilised. The website structure was constructed using the PHP 8 programming language whilst adhering to the MVC (Model View - Controller) design pattern and incorporating REST APIs for database communication.
Extreme Programming (XP) was employed following 4 fundamental activities, which are carried out in accordance with the guidelines or stages (Figure 1).23–25
This figure has been reproduced with permission from Ref. 26.
2.2.1 Planning phase: The system requirements were extracted by detailing all user stories according to the customer’s demands. The first requirement allows for the login and registration of users, including both administrators and salespeople. The second requirement facilitated the projects and the lots assigned to them, while the third requirement enabled the allocation of sales to the lots assigned to the said projects. The fourth requirement facilitated the assignment of payments to the sold lots, and the fifth requirement generated a report of the sold lots and the accounts receivable. It is crucial to note that in this phase, the participants were assigned certain roles showing in Figure 2.
2.2.2 Design phase: The most relevant user stories have been selected and simplified for convenience. Furthermore, CRC (Class-Responsibility-Collaboration) cards will be created to enhance the system analysis effectively. Refer to the Figure 3 for an illustration:
2.2.3 Coding phase: Technical abbreviations will be explained when first used. The website structure was developed using HTML tags, CSS for style, color, and box layout, and JavaScript for HTML object manipulation as shown in Figure 4. Additionally, the site incorporates various technologies such as Materialize CSS, which is a design framework based on Google’s Material Design, DataTables for managing data in tables, Select2 for adding search functionality in combo-boxes, and PDFMake for exporting reports. The language will remain objective and value-neutral, with a passive and impersonal tone. The text will adhere to correct grammar, spelling, and punctuation. Regular author and institution formatting will be maintained, using clear and concise language with precise technical terms. The text will avoid colloquial language and unnecessary jargon. Sentences and paragraphs will have a logical flow of information with causal connections between statements. Common academic sections will be included, with factual and unambiguous titles and hedging to maintain a balanced view. The web system operates using PHP 8 programming language, with the implementation of the MVC (Model View - Controller) design pattern. Additionally, MySQL version 10.0 is utilized as the database management system and the eschema is on Figure 5, and REST APIs are employed to transfer data between the view and controller.
2.2.4 Testing phase: The system underwent unit-level testing to identify any code faults and improve its quality, and these tests were incorporated into the development process, which can be seen in Figure 6. Following this, supervised acceptance testing was conducted with the client to grant final approval to the application.
Different features have been incorporated into this software compared to existing solutions available on the market:
• Tailored to meet the requirements of small and medium enterprises in the real estate industry, our software is precisely tailored for micro and small firms in the sector to enhance management decision-making, conforming to their workflows and specific demands.
• Customised options are available to users who can access reports to make queries on sales, outstanding targets, percentage progress of the sales project, and more.
By outlining the methodology and distinctive features, our software provides a comprehensive manual for the creation and adoption of the technology in small and micro real estate businesses, thus encouraging its ability to be replicated and emphasising its practicality.
Preface: Data Initialization Process
The system’s data initialization process is executed automatically, in accordance with the installation procedures outlined in the “Readme.md” file, which can be found in the relevant repository.27
Use case 1: Sales Report
The developed user interface has the ability to create project-specific reports on lots sold which include graphical representations of both sold and unsold lots, along with sales dates (Figure 7).
Input:
Output:
Use case 2: Dues receivable report
The interface presents a comprehensive list of lots with outstanding fees. The information displayed includes the due date, amount payable, as well as the contact details and name of the owner (Figure 8).
Input:
Output:
Use case 3: Sales register
For the sales process there is a list of sales in which the information of the sale is indicated, likewise the sellers can register the sales, where the buyer, the location, the project, lot and price are indicated; which can take about 2 minutes to complete (Figure 9).
Input:
Output:
Use case 4: Dashboard
After the application has been developed, the user logs in and the main interface displays their dashboard. The dashboard includes a graph of projects with remaining lots to be sold, sorted from highest to lowest, and another graph displaying owners and their respective accumulated balances, sorted from highest to lowest, as depicted in Figure 10.
Input:
Output:
Based on the system’s evaluation, there has been a substantial decrease of around 64% in the duration spent exploring details in the sales process. This decline showcases a distinctive effectiveness in sales proceedings, which is an exceptional advantage for real estate enterprises. Additionally, previous research has demonstrated that streamlining the information search process enables organisations to provide a responsive, uncomplicated and fulfilling service, ultimately leading to increased sales.16 It is noted that a web-based enterprise sales management system not only improves the efficiency of sales processes, but also contributes to more effective decision making.17,18
The system design has been found to be extremely efficient in streamlining the process and considerably decreasing manual operations. Consequently, transaction recording time has been reduced by 62%. These findings are consistent with previous research,3,5,6,13 which observes that the introduction of a sales system streamlines customer service. Additionally, the findings align with previous research,4,9 indicating that utilizing the system results in enhanced processing times and an augmentation of sales.
One of the noteworthy features of our system is its sales interface, which allows for precise customer tracking and simplifies the recording and analysis of customer behaviour. This approach is in line with,14,15 who affirmed that analogous systems aid in personalised tracking of consumers. What’s more, the systems automate business records19–21 and ensure efficient control of information.10
The use of a dashboard has yielded dependable outcomes and enhanced supervision of process metrics and objectives, ensuring prompt delivery and efficient handling of tasks, transactions and documentation. Additionally, this tool features graphical interfaces to interact with databases, making it a vital component of business intelligence.28,29 Furthermore, it streamlines the decision-making process by enabling companies to efficiently visualise sales, time and product data.30–32
Therefore, a web-based system proves to be a dependable approach for real estate companies that seek enhanced efficiency in their sales process. The system has shown high adherence to the established objectives by optimising the process and improving usability via the Dashboard, thereby promoting informed decision-making in the company.
The implemented system has demonstrated its effectiveness in enhancing the sales process, reducing yearly tasks, and minimizing registration times.
Consistent with previous research, these findings provide evidence of the significance of sales systems in optimising customer service and diminishing processing delays, resulting in augmented sales.
The execution of the sales interface has facilitated precise customer tracking and enhanced information administration, aligning with research emphasising the value of systems in personalised customer tracking and automation of business records.
It is advisable that future researchers employ alternative methodologies to determine whether equivalent outcomes can be achieved. Such methodologies may include Waterfall, Scrum or V Methodology.
Zenodo: luisgarciaheredia. (2023). luisgarciaheredia/database: FAST a digital sales transformation software for the real estate industry (v1.0). Zenodo. https://doi.org/10.5281/zenodo.10071938. 27
Data are available under the terms of the Creative Commons Attribution 4.0 International (CC-BY 4.0).
Source code available from: https://github.com/luisgarciaheredia/inmobiliaria.
Archived source code at time of publication: https://zenodo.org/doi/10.5281/zenodo.10071930. 22
License: Creative Commons Attribution 4.0 International (CC-BY 4.0).
We thank the Constructora e Inmobiliaria Titanio SAC for their strong support and help with this study. The authors would like to thank Alex Pacheco of the Faculty of Engineering and Architecture of Universidad Cesar Vallejo for his methodological advice on this study.
Views | Downloads | |
---|---|---|
F1000Research | - | - |
PubMed Central
Data from PMC are received and updated monthly.
|
- | - |
Is the rationale for developing the new software tool clearly explained?
Partly
Is the description of the software tool technically sound?
Partly
Are sufficient details of the code, methods and analysis (if applicable) provided to allow replication of the software development and its use by others?
Yes
Is sufficient information provided to allow interpretation of the expected output datasets and any results generated using the tool?
Yes
Are the conclusions about the tool and its performance adequately supported by the findings presented in the article?
Partly
Competing Interests: No competing interests were disclosed.
Reviewer Expertise: Marketing management and digital business
Is the rationale for developing the new software tool clearly explained?
Yes
Is the description of the software tool technically sound?
Yes
Are sufficient details of the code, methods and analysis (if applicable) provided to allow replication of the software development and its use by others?
Yes
Is sufficient information provided to allow interpretation of the expected output datasets and any results generated using the tool?
Partly
Are the conclusions about the tool and its performance adequately supported by the findings presented in the article?
Partly
Competing Interests: No competing interests were disclosed.
Reviewer Expertise: strategic human resource management, talent management, organizational transformation, leadership
Is the rationale for developing the new software tool clearly explained?
Partly
Is the description of the software tool technically sound?
Yes
Are sufficient details of the code, methods and analysis (if applicable) provided to allow replication of the software development and its use by others?
Yes
Is sufficient information provided to allow interpretation of the expected output datasets and any results generated using the tool?
Yes
Are the conclusions about the tool and its performance adequately supported by the findings presented in the article?
Partly
Competing Interests: No competing interests were disclosed.
Reviewer Expertise: Information Systems Analysis and Design, User Experience, Human and Computer Interaction, Software Engineering.
Alongside their report, reviewers assign a status to the article:
Invited Reviewers | |||
---|---|---|---|
1 | 2 | 3 | |
Version 1 15 Apr 24 |
read | read | read |
Provide sufficient details of any financial or non-financial competing interests to enable users to assess whether your comments might lead a reasonable person to question your impartiality. Consider the following examples, but note that this is not an exhaustive list:
Sign up for content alerts and receive a weekly or monthly email with all newly published articles
Already registered? Sign in
The email address should be the one you originally registered with F1000.
You registered with F1000 via Google, so we cannot reset your password.
To sign in, please click here.
If you still need help with your Google account password, please click here.
You registered with F1000 via Facebook, so we cannot reset your password.
To sign in, please click here.
If you still need help with your Facebook account password, please click here.
If your email address is registered with us, we will email you instructions to reset your password.
If you think you should have received this email but it has not arrived, please check your spam filters and/or contact for further assistance.
Comments on this article Comments (0)