Personalized E-Commerce Applications with Reports Feature

Safitri Juanita, Muhamad Arsyan and Wiwin Windihastuty

Universitas Budi Luhur

Keywords: E-Commerce, Report Feature, Financial Management, Product Management

Abstract: E-Commerce is growing rapidly; the increasing number sees this fact of companies switching to using E-

Commerce as a supporting tool in marketing their products or even making E-Commerce a business strategy

by completely transforming traditional business transactions into online transactions. Seeing this, companies

that use E-Commerce need financial management features that can help companies manage online sales

transactions. The purpose of this study is to design and implement a report feature that functions as the

company’s Financial Management and management product in E-Commerce Applications, case studies at

Rinjani Outdoor Shop. The methodology for this research is using the prototyping process which includes

stage initial prototype (using an HTML Programming language), user review of the prototype (build an

application using PHP programming language and database MySql), Revise or refine the prototype. The

results of this study are E-Commerce applications that are personalized with Feature Reports can help

companies, especially Rinjani outdoor shop to see reports relating to online sales so that corporate financial

management and product management can be managed faster, accurately and can be accessed anywhere.

1 INTRODUCTION

E-Commerce is currently growing very rapidly,

increasing number of companies are transforming

traditional business transactions into online

transactions by building E-Commerce applications.

However, there are still some companies that just

starting to market their products online using social

media, because according to research conducted by

(DHL, 2015) Social Media has shown to be an

effective platform for customers to discuss and voice

opinions about products and brands, as well as for

Business to communicate with customers. Social

Media is one of Social Marketing tools to familiarize

the consumer with Business, but E-Commerce

Application is an enterprise business process after the

occurrence of Business, electronic documents and

settlement go for automated processing, business data

is online inputted and formed the original documents

(Meharia, 2012).

E-Commerce Application integrates the product

marketing process as well as managing products,

financial management, and goods supplier

management. However, to achieve a successful

online business, an E-Commerce application is

needed that has additional features that can help meet

business needs, a measure of the success factors of

online businesses based on research conducted

(Otanasap et al , 2019) one of which is the precise

direction of goods and services business, this means

a strong understanding and proficiency and service to

customer behavior, as well as an optimal delivery

system and after-sales service, Have large enough

variation of goods and services for consumers to take

into their consideration, this means online customer

typically conduct research before actual purchase,

accordingly, Business with well-presented details and

significant variation of goods and services will hasten

and ease customer decision.

Besides the above factors, according to research

on E-Business models and financial management

companies based on cloud computing concluded that

The rise of E-Commerce has brought new

opportunities for the development of enterprises,

financial services will no longer be confined to a

country or a region, and will be moving towards

internationalization, precision, computerization,

network direction (Dongmei et al., 2016). With E-

Commerce application should help the whole process

of enterprise financial management become dynamic

and timely, making the whole financial information

generation and transmission efficiency significantly

increased (Li, 2017). Moreover, other research

conducted by (Sin et al., 2015) observes that the

Juanita, S., Arsyan, M. and Windihastuty, W.

Personalized E-Commerce Applications with Reports Feature.

DOI: 10.5220/0008931401770182

In Proceedings of the 1st International Conference on IT, Communication and Technology for Better Life (ICT4BL 2019), pages 177-182

ISBN: 978-989-758-429-9

177

CEOs who implement E-commerce adoption

significantly believe that E-commerce not only able

to increase sales, expand market share, cut down

costs, exploit new business prospects but also will

improve the relationship with dealers and companion

Based on the results of the above research, it can

be concluded that an E-Commerce Application

requires product management and financial

management that will help the company achieve

success in running an online business. So the problem

that will be discussed in this study paper is how to

meet the needs of financial management and product

management on standard e-commerce applications so

that it can help companies achieve success in running

an online business. The purpose of this study is to

design and implement a report feature that functions

as the company’s Financial Management and

management product in E-Commerce Applications,

case studies at Rinjani Outdoor Shop.

2 RELATED WORK

In this section, we briefly introduce related work on

two topics. First, we investigate the implementation

of E-Commerce in several case studies; then, we

study the relationship between financial management

strategies and E-Commerce and how other studies

apply this concept.

2.1 Implementation of E-Commerce

application in Several Case Studies

To see whether existing e-commerce applications

have met these needs, a review literature has been

conducted on previous research such as research

(Nahlah et al, 2018) the purpose of this study was to

implement the OOP technique with UML Modelling

in building an E-Commerce website for KSM

Tenggiri Ceria in Sinjai Regency, E-Commerce

applications built in this study only display standard

E-Commerce features and do not display report

features related to recapitulation of online sales

transactions. Other research is from (Soegoto,

Marbun, and Dicky, 2018). The purpose of the

research is to investigate the building of e-commerce

design. Additionally, the research was aimed to

investigate how e-commerce design influenced the

success of e-commerce. The result of this research

showed that the building of website design

significantly influenced e-commerce successfully.

Same as in previous research, the E-Commerce

application built in this study only displays standard

E-Commerce features and does not display report

features related to online sales transaction

recapitulation. For the best of our knowledge, we

have not found in previous research on developing e-

commerce applications with report features, so in this

research, we propose on personalizing e-commerce

applications with report features.

2.2 Enterprise Financial Management

System And E-Commerce

The overall objective of the financial strategy of E-

Commerce enterprises is to mobilize, configure and

use resources, to seek a balance of enterprise funds,

adequate flow, to build the core competitiveness of

the enterprise, and ultimately to achieve the

maximization of enterprise value (Dongmei et al.,

2016).

Figure 1: Enterprise Management Framework (Dongmei et

al., 2016)

Seen in figure 1, part of the enterprise

management framework is Reporting, the financial

reporting used to present performance and financial

data and operating performance for an accounting

period.

2.2.1 Network Financial Management

Model

The definition of network finance includes the

following aspect: Internet/Intranet Cooperative open

network formation, a comprehensive system of

collaborative business management and financial

management, financial enterprise application,

internet financial should fully support the E-

ICT4BL 2019 - International Conference on IT, Communication and Technology for Better Life

178

Commerce, financial function based on management

rather than accounting. The combination of network

technology and financial management, a new model

of financial management is the future of financial

accounting (Dongmei et al., 2016)

2.2.2 The function of the Network Financial

System

The primary function of the network financial system

is (Dongmei et al., 2016): to achieve the supply and

marketing of Business and financial management

(storage and other processing and automatic

inventory cost accounting); the effectiveness of cost

control (data will be automatically generated during

each cost); Effective control of the risk of financial

operations (through the network financial software to

achieve the integration of financial services to control

inventory information and sales information so as to

control the business risk more effectively). Based on

previous research, there is a connection between

financial management strategies and e-commerce, so

in this study, we build features that can help

companies evaluate and monitor sales transactions,

order transactions and transactions of goods sold.

3 RESEARCH METHODOLOGY

The research methodology has stages starting from

the data collection stage and the system design stage.

Below are the stages of the research and explanation

3.1. The phase of collecting data

This research requires a case study to implement E-

Commerce Applications so that at this stage data

collection is carried out at Rinjani Outdoor Shop.

Data collection methods used in this research are:

Interview; In this stage, the researcher interviewed

with Owners, employees, and customers of Rinjani

Outdoor Shop to get information from owner and

employees as a seller and customer as a buyer side

and to get data related to the current system. (b)

Literature review; The researcher collects data related

to the research topic by reading books, articles or

journals about E-Commerce to find out the theory of

E-Commerce and the latest information from research

that has been done before. (c) Observation; The

observation has been carried out located on Jl. Gen.

Sudirman No.4 Rt.02 / 015 Kranji Bekasi Barat, Jawa

Barat, Indonesia. Observations that have been made

are a collection of primary data such as observation

of processes, accounting procedures, and others. The

data is used as a reference in the preparation of system

(as-is business process) which is then compiled the

design of the proposed business process system in the

future (To-be business process). (d) Document

analysis; In this research, the document was carried

out from the location of the case study such as sales

receipts, purchase invoices to suppliers, shipping

document from the supplier. These documents are

analyzed and become a reference source in the

preparation of conceptual data models that are

implemented in design database and screen design.

3.2. Phase Planning

In phase planning, we used Prototyping development

process; the following are the stages of the

Prototyping process (Carr & Verner, 1997):

(a) Initial Prototype; In this stage, we developed a E-

Commerce application model in the form of a user

interface using an HTML programming language

with editor Sublime Text software. (b) User Review

of Prototype; the End user is asked to evaluate the

appearance of the user interface that has been made to

get the user needs that do not yet exist in the

prototype. If the form of user interfaces according to

user requirements, then objectives attained. Then we

do the stages of building an E-Commerce application

as a whole according to the results of user reviews.

This application is made using the PHP and MySQL

programming languages, using XAMPP and Sublime

Text software. However, if end-user did not feel

satisfied with the prototype that has been made, then

we do revise or refine the prototype. (c)

Revise/Refine Prototype; We rebuild the prototype

based on the user review of the prototype stage.

4 RESULT AND ANALYSIS

The following are the steps in designing personalized

e-commerce applications with report features :

4.1. Business Process

The flow of a business process for E-Commerce

Application; customer, can view the main menu, add

and update purchase order after that admin can

manage all order list in back end site. After admin

validation customer order, then the customer can add

and update payment confirmation, then admin will

validation all payment confirmation in back end site

after that admin will add or update delivery order.

Every month, admin or owner can view or print sales

Personalized E-Commerce Applications with Reports Feature

179

report, view or print report for sold item, view or print

report purchase order, view or print payment, view,

or print delivery order.

4.2. E-Commerce Application Menu

Hierarchy

In E-Commerce applications, there are two user

interfaces, namely admin and customer. In figure 2 is

a hierarchy of menus for admin pages.

Figure 2. Back-End Menu Hierarchy

4.3. User Interface Display For E-

Commerce Applications

The following is a screen display of E-Commerce

applications that have personalized report features:

4.3.1. Main Menu

Figure 3 is a screen display from the customer's main

menu as a shortcut to other pages that customers want

to visit, such as Home, Catalog, Discount, Best Seller,

and Category.

Figure 3. Main Menu E-Commerce

4.3.2. Homepage

The homepage is the front page when entering this

online store, containing superior products and

products that are being discounted. On this page,

visitors can immediately understand what is being

sold in the store. (See Figure 4).

Figure 4. Homepage E-Commerce application

4.3.3. Dashboard Admin page (Back-End)

Figure 5 is Dashboard on the main admin page that

displays specific sales data such as the number of

items sold, number of customers, number of orders,

number of successful transactions, income this

month, and sales charts per month.

Figure 5. The dashboard on Admin Page

4.4. User Interface E-Commerce

Application with Report Feature

The following are user interface outputs of the Report

feature that can assist companies in conducting

financial management and product management.

ICT4BL 2019 - International Conference on IT, Communication and Technology for Better Life

180

4.4.1. Sales Report

The following is the user interface as an admin to

view annual sales reports, each line in this report

showing monthly sales transaction data which is an

accumulation of sales turnover, sold items, amount of

capital, discount, and profit. (See Figure 6).

Figure 6. Sales Report User Interface

4.4.2. Order Report

The following is the annual order report display

which shows the order date, invoice number,

customer code and total order, shipping costs,

discounts, total after discount and order status. (See

Figure 7).

Figure 7. User Interface for Order Report

4.4.3. Sold Item Report

The following is a report of sold product that contains

details of the data of goods sold, purchase price,

selling price and the number of items sold. (See

Figure 8).

Figure 8. User Interface for Sold Item Report

5 CONCLUSIONS

The conclusion of this study is that the

Personalization of E-Commerce applications by

building a Sales Report feature is proven to help

companies especially Rinjani outdoor shop manage

financial management because companies can see the

total revenue every month quickly and accurately, the

product report features proven to help companies

manage inventory product because the company can

see quickly and accurately the number of items sold

so that the company can find out the stock and help

improve customer satisfaction, the ordering report

feature also helps companies manage inventory

product because the company can monitor the number

of items ordered and order status, so the company

knows the number of orders that have been processed

and not yet processed.

Further research is needed to find out how

important the report feature is for E-Commerce by

conducting a survey of several online shop owners.

REFERENCES

DHL. 2015. Omni-channel logistics: A DHL perspective on

implications and use cases for the logistics industry.

White Paper, DHL Trend Research.

Meharia, Priyanka. 2012. E-Commerce and Taxation: Past,

Present and Future. The IUP Journal of Accounting

Research. 11 (4), pp.25-33.

Otanasap, N.,Woralak, R., and Pornpimol B. 2019. Success

Factors of Thailand E-Commerce.In: 7th International

Conference on Creative Technology, 19-21 June 2019,

At Loft Mania Hotel, Chumpon, Thailand. pp. 154-161.

Dongmei, Z., Juan, L., & Suyan, S. 2016. Research on the

E-business Model and Enterprise Financial

Management based on Cloud Computing. International

Journal of Database Theory and Application. 9 (8),

pp.305-316.

Personalized E-Commerce Applications with Reports Feature

181

Li, Yimin. 2017. Analysis On Financial Management Of E-

Commerce Enterprise. In: 2nd International

Conference on Education, Sports, Arts and

Management Engineering (ICESAME 2017), 29-30

April 2017, Zhengzhou, China. pp. 1180-1183.

Sin, K Y., Osman, A., Salahuddin, S N., Abdullah, S., Lim,

Y J., Sim, C L. 2015. Relative Advantage and

Competitive Pressure towards Implementation of E-

commerce: Overview of Small and Medium Enterprises

(SMEs). In: 7th International Economics, 5 - 6 October

2015, Pahang, Malaysia. pp. 434–443.

Nahlah., Paramudia., Amaruddin., and Lukman. 2018. The

Implementation of OOP (Object Oriented

Programming) in Building an E-Commerce Website.

1st International Conference on Advanced

Multidisciplinary Research (ICAMR 2018), 6-7

Oktober 2018, Makassar, Indonesia. pp. 522-526.

Soegoto, E S., Marbun, MAS., and Dicky, F. 2018.

Building The Design Of E-Commerce. IOP

Conference Series Materials Science and Engineering.

407(1), pp. 1-7.

Carr, M., & Verner, J. 1997. Prototyping and software

development approaches. Department of Information

Systems, City University of Hong Kong, Hong Kong,

319-338

ICT4BL 2019 - International Conference on IT, Communication and Technology for Better Life

182