Berbek Village has 55 families with livelihoods as sandals craftsmen about 40%. The problem of the last five years is the sales of sandals craftsmen has decreased by 50% that bring the economy level decreased. Therefore, the craftsmen want to expand their market share and hope it will increase the sales of sandals. The solution offered is Online Sales Information System. The research methodology using Waterfall Model was started with survey and interview, system analysis, database design, coding using PHP programming language and MySQL database, system testing, training for sandals craftsmen, and system evaluation by filling and processing of questionnaire. Training results show that sandals craftsmen can sell their products through an online sales information system that has been created. System evaluation results have also shown that online sales information system can be well received by sandals craftsmen

Sulistiowati, Sulistiowati

Tjandrarini, A. B.

English

STIKOM Institutional Repositories (Institut Bisnis dan Informatika Stikom Surabaya)

CALL FOR PAPERInternational Conference on Information TechnologyApplications and Systems (ICITAS)“Managing Digital Developmentfor Sustainable Economy” International Conference on Information Technology Applications and Systems (ICITAS)  ICITAS 2018   I-41  Implementation of Online Sales Information System for Sandals Craftsmen In Berbek Village  A.B. Tjandrarini Associate’s Degree of Information System, Faculty of Technology and Informatics, Institut Bisnis dan Informatika Stikom Surabaya,  Surabaya, Indonesia asteria@stikom.edu Sulistiowati, Julianto Lemantara Bachelor Degree of Information System, Faculty of Technology and Informatics, Institut Bisnis dan Informatika Stikom Surabaya, Surabaya, Indonesia sulist@stikom.edu, julianto@stikom.edu   Abstract—Berbek Village has 55 families with livelihoods as sandals craftsmen about 40%. The problem of the last five years is the sales of sandals craftsmen has decreased by 50% that bring the economy level decreased. Therefore, the craftsmen want to expand their market share and hope it will increase the sales of sandals. The solution offered is Online Sales Information System. The research methodology using Waterfall Model was started with survey and interview, system analysis, database design, coding using PHP programming language and MySQL database, system testing, training for sandals craftsmen, and system evaluation by filling and processing of questionnaire. Training results show that sandals craftsmen can sell their products through an online sales information system that has been created. System evaluation results have also shown that online sales information system can be well received by sandals craftsmen. Keywords—online sales; sandals craftsmen; sales information system I. INTRODUCTION Berbek Village has 55 families with livelihoods as sandals craftsmen about 40%. Sandals that is produced in the form of rubber-based sandals with various models. The sandals are usually sold at traditional markets in Sidoarjo and Surabaya. The problem of the last five years is the sales of sandals craftsmen has decreased by 50% that bring the economy level decreased. Therefore, the craftsmen want to expand their market share and hope it will increase the sales of sandals . Based on the existing problems, the solution offered is Online Sales Information System, so that sandals craftsmen can sell the products widely through the internet. Therefore, the objective of this research is creating Online Sales Information Systems. Online sales information systems can expand market share [1]. Online sales can also contribute to the growth of the regional economy without substantial investment [2]. Online sales information system has been created using PHP programming language and MySQL database. PHP is chosen because PHP can be used on all operating systems [3]. In addition, another advantage of PHP is PHP has good connectivity with many DBMS [4]. MySQL is chosen because it is widely used to build web applications that use databases as their source and data management [5]. MySQL is an open source software that means free to use on various operating systems [6]. The model that used for developing the information system is Waterfall Model proposed by Jogiyanto [7]. Waterfall Model is widely used to develop almost all application both desktop and online. II. RESEARCH METHODS To create an online sales information system, this research used System Development Life Cycle Method with Waterfall Model as shown in Fig. 1. The stage of making an online sales information system in Berbek Village, Sidoarjo are: 1. System engineering is done through data collection by survey and interview with sandals craftsmen. 2. System analysis, especially functional requirements analysis. 3. System design, especially database design. 4. Coding or making an online sales information system. 5. Trial and train an online sales information system to sandals craftsmen. 6. System evaluation by filling and processing the questionnaire.  Sponsor by Institute of Business and Informatics Stikom Surabaya.  International Conference on Information Technology Applications and Systems (ICITAS)  ICITAS 2018   I-42   Fig. 1. Waterfall Model III. RESULTS A. The Result of Data Collection The data collection was done by survey and interview. The main thing that was gained during the survey and interviews is the sandals selling process and the sandals craftsmen problems that occur. In addition, there are also some data collected in this stage, namely: 1. Data about the type of sandals  2. Data about sandals  3. Data about SMEs, including: SME name, owner name, bank name, and contact person.  B. The Result of System Analysis Based on the analysis conducted, there are two groups of users who use the application, which is the owner of SME as sellers and general users as buyers. The functional requirements for each user are as follows: 1. Owner of SME (Seller) a. Maintenance of sandals category b. Maintenance of items or sandals  c. Order handling 2. General Users (Buyer) a. Online order with transfer payment method b. Confirmation payment of online order c. Monitoring of shipments   C. The Result of Design The design result in this research is database design. There are 17 tables used in the online sales information system. The database design can be seen in Fig. 2.    Fig.2. Design of Database  D. The Result of Development Information System D.1. Seller's pages (sme owners) To enter as a seller or owner of a SME, users can visit the website address: http://olshop.wiputra.com/administrasi. This seller’s page is used to set categories, product items, delivery charges, member, shopping instructions, payment account numbers, seller contacts, and galleries. In addition, the seller's page used to serve incoming customers orders and invoice for delivery of goods. On the add category page, the seller can add, edit, and delete product category. The view of add category page can be seen in Fig. 3.   Fig. 3. Add category page  On the add product page, the seller can add product by uploading the image and filling in the product name, category, price, weight (gram), stock, variant, and description. The display of the add product pages can be seen in Fig. 4.  International Conference on Information Technology Applications and Systems (ICITAS)  ICITAS 2018   I-43    Fig. 4. Add product page  On the delivery charges page, sellers can manually add, edit, and delete delivery data one by one. For more details, this page can be seen in Fig. 5.   Fig. 5. Delivery charges page  This confirmation page is used to view the list of customers who have already confirmed the payment. Additionally, this page used to remove the payment that deemed invalid by the seller. More details, the confirmation page can be seen in Fig. 6.   Fig. 6. Confirmation page  A new invoice page is used by the seller to see a list of recent invoice and the seller can also change the status of the invoice to be paid if the payment is considered valid after the seller sees a reference from the paid confirmation page. For more details, the new invoice page can be seen in Fig. 7.  Fig. 7. New invoice page  The payment list page is used to view the list of invoice that has been paid. In addition, the seller may also modify the status of the invoice to be unpaid if the seller makes a mistake on the approval of the payment. The seller may also change the sales status to ‘delivered’ on this page. For more details, this payment list page can be seen in Fig. 8.  Fig. 8. Payment list page  The delivered order page is used to view a list of order that have been sent. In addition, the seller may also re-alter the sales status to be undeliverable if the seller makes a mistake. For more details, this page can be seen in Fig. 9.   Fig. 9. Delivered order page  International Conference on Information Technology Applications and Systems (ICITAS)  ICITAS 2018   I-44   The delivery receipt page can be used by the seller to provide delivery receipt number to the customer whose order has just been processed to the freight forwarding service. For more details, the delivery receipt page can be seen in Fig. 10.   Fig. 10. Delivery receipt page  D.2. Buyer's Pages (Customers) In general, a website for customers allows customers to view a list of products, order products of interest, confirm payment, and check the delivery process by entering the delivery receipt number. In this system, new customers can order on the website after registration and logged in. If not logged in, then the customers can only see the list of products and add to the shopping cart. If the customers logged in, then the customers can proceed to the next stage. The page for add the product to the shopping cart can be seen in Fig. 11.   Fig. 11. The page for add the product to the shopping cart  After the selected product is entered into the shopping cart, the second stage is to fill the delivery form. On this page, customers can fill the shipping address completely and correctly. Then the customers can choose the type of expedition and give additional information if needed. For more details, this delivery data submission page can be seen in Fig. 12.   Fig. 12. Delivery data submission page  The third stage of the ordering process is the system showing order data, delivery data, total payments, and how to make payments. More details, the order invoice page can be seen in Fig. 13. The fourth stage is to transfer payments to bank accounts that have been displayed on the order invoice page and the fifth stage is to confirm payment. To confirm the payment, the consumer can select the confirmation menu and fill the form as shown in Fig. 14.   Fig. 13. The order invoice page   Fig. 14. The confirm payment form  After confirmation, the seller can see the confirmation list as shown in Fig. 6 and the seller can confirm the consumer payment on the new invoice page as shown in Fig . 7. Furthermore, the seller can provide the order delivery receipt  International Conference on Information Technology Applications and Systems (ICITAS)  ICITAS 2018   I-45  number as described earlier in Fig. 10. On the final stage, consumers can see the progress of the order delivery process as in Fig. 15. So, that's the sequence of online sales process on the website that has been made.   Fig. 15. The progress of the order delivery process  E. The Results of Testing and Training Training was followed by six sandals craftsmen. The result of this stage is the sandals craftsmen can test and operate functions of an online sales information system smoothly.  F. The Results of System Evaluation Overall, an online sales information system is considered good by sandals  craftsmen. The evaluation results of an information system that has been trained to sandals craftsmen can be seen in Table 1. T ABLE 1. T HE RESULTS OF SYSTEM EVALUATION   IV. CONCLUSION Based on previous explanations, the conclusions of this research are: 1. Sandals Craftsmen can sell the products through an online sales information system that has been created. 2. Based on the system evaluation using the questionnaire distribution and processing, an online sales information system can be well received by the sandals craftsmen in Berbek Village, Sidoarjo. ACKNOWLEDGMENT  The authors would like to thank the parties who assist in completing this research, especially to: 1. Prof. Dr. Budi Jatmiko, M.Pd. as Rector of Institute of Business and Informatics Stikom Surabaya and his staff who have provided support during this research activity. 2. Tutut Wurijanto, M.Kom, as Head of Research and Community Service. 3. Abdulloh Mas'ud, as the Chairman of RT1 RW2 Berbek Village. 4. All parties that can not be mentioned one by one, which has been helpful in this research. Finally, the authors hope that God Almighty rewards the appropriate to all parties who have helped in this research. In addition, hopefully the results of this research can be useful for all interested parties. REFERENCES [1] S. Kosasih, “Perancangan sistem e-commerce untuk memperluas pasar produk oleh-oleh khas Pontianak,” SNASTIA, ISSN: 1979-3960, 2015. [2] Himawan, A. Saefullah, dan S. Santoso, “Analisa dan perancangan sistem informasi penjualan online (e-commerce) pada CV Selaras Batik menggunakan analisis deskriptif,” Scientific Journal of Informatics, Vol 1 No 1, ISSN: 2407-7658, 2014. [3] K. Peranginangin, Aplikasi WEB dengan PHP dan MySQL. Yogyakarta: CV. Andi Offset , 2006. [4] M.R. Arief, Pemrograman web dinamis menggunakan PHP & MySQL. Yogyakarta:ANDI, 2011. [5] F. Junaedi, Panduan lengkap pemrograman PHP untuk membuat WEB dinamis. Yogyakarta: PD. Anindya, 2005. [6] M. Sulhan, Pengembangan aplikasi berbasis web dengan PHP & ASP. Yogyakarta: Gava Media, 2007. [7] H.M. Jogiyanto, Analisis dan desain sistem informasi Edisi IV. Yogyakarta: Andi Offset , 2010.   

Implementation of Online Sales Information System for Sandals Craftsmen In Berbek Village

http://repository.dinamika.ac.id/id/eprint/4145/18/BidC2a3_icitas%20paper_rev.pdf

Implementation of Online Sales Information System for Sandals Craftsmen In Berbek Village

Abstract

Similar works

Full text

Available Versions

STIKOM Institutional Repositories (Institut Bisnis dan Informatika Stikom Surabaya)