Online Marketing of Herbal Medicines and Supplements (Case Study of Farah Shop, Banjarmasin)

The business of selling medicines and herbal supplements at Farah Shop was pioneered in mid-2017 by Farah Putriana as the official distributor for several brands such as HDI, DXN, Herbalife, etc. Products sold include cough medicine, slimming medicine, honey, etc. Farah's shop is located at Jalan Sultan Adam, Taekwondo complex Permai line III no. 7 Surgi Mufti Village, North Banjarmasin, with telephone number 081254545594. The management of recording the purchase and sale of drugs and herbal supplements uses a semi-computer system by registering on a spreadsheet application. Some business problems at Farah's shop, such as the slow preparation of profit reports from the sale of medicinal and herbal supplement products, difficulties in obtaining final inventory reports of medicinal and herbal supplements, and marketing of medicinal and herbal supplement products is still limited because prospective buyers must come in person or ask product questions to the admin using the Whatsup application, with With the rapid development of the internet at this time, the owner of Farah Shop considers it necessary to make better use of this technology by creating an online application where prospective buyers can view and choose the medicine or herbal

The management condition of recording the purchase and sale of medicines and herbal supplements still uses a semi-computer system by recording on a spreadsheet application (Shah & Fry, 2019). Some of the problems that exist in the Farah Shop business such as the slow preparation of profit reports from the sale of medicinal products and herbal supplements (Tan dkk., 2020), difficulty getting reports on the final inventory of drugs and herbal supplements (Munn dkk., 2018), marketing of medicinal products and herbal supplements is still limited because prospective buyers must come in person or make product inquiries to the admin using the Whatsup application (Evans dkk., 2021), with the current rapid development of the internet, Farah Shop owners consider it necessary to make better use of this technology by creating an online application where prospective buyers can see and choose the drugs or herbal supplements that they will buy directly.
This will increase sales from the Farah Shop business (Singh dkk., 2019). Another problem is that making reports on total sales and purchases of medicines and herbal supplements, carried out every month, is constrained by time and human resources due to the absence of an exemplary computer system (El-Sayed & Youssef, 2019). The difficulty in seeing the final stock of drugs or supplements so that orders from buyers are often not fulfilled (Ivanov, 2021). In this study, an application will be made using MySQL and PHP databases with a general description of providing online sales services (Depommier dkk., 2019), which can serve buyers who come directly to Farah's shop or those who will buy directly via the internet online.
The formulation of the problem in this study is How to make an application for selling medicines and herbal supplements at the Farah Banjarmasin shop using an online system with PHP (Hassan dkk., 2018). How to save transaction data on the sale of Medicines and Herbal Supplements at the Farah Banjarmasin Shop into the MySQL database system.
Limitations of the problem in this study Only discuss the sale of medicines and herbal supplements at the Banjarmasin Farah Shop (Magee & Greenberg, 2020), Not discussing purchases with COD (Cash On Delivery) (Hemilä & Chalker, 2019), Only serve sales transactions in cash or with a bank transfer payment system, do not serve sales by credit/installments (Jolliffe dkk., 2021), Serving online sales only by using TIKI expedition services, Checking postage by the Farah Shop sales admin is still done manually by checking postage on the Tiki.co.id service site (Tamtaji dkk., 2019), Applications will be made with the PHP programming language and MySql Database.
The objective objectives in research with the object of the Banjarmasin Farah Shop are the Recording of data on the purchase of drugs and herbal supplements Recording of drug and herbal supplement sales data (Huang dkk., 2019), either direct sales to consumers or online system using the TIKI courier service (Jiang dkk., 2019). Preparation of reports on the remaining stock of medicines and herbal supplements. Preparation of reports on the purchase and sale of drugs and herbal supplements at the Farah Banjarmasin Shop daily, weekly and monthly.
The benefits of research are Make it easier for employees/admins who work to make reports on purchases (Tam dkk., 2019), sales (Dwivedi dkk., 2021), sales profits, and final stock of drugs and supplements at the Farah Banjarmasin Shop (Raddats dkk., 2019). Applications with an online system can increase the interest of prospective buyers in the Farah Banjarmasin Shop

RESEARCH METHODOLOGY
An interview is a method of preparing the research (Zhu dkk., 2019). It is an activity to obtain data by conducting interviews with the owner of the Farah Shop named, Farah Putriana (Wong dkk., 2020). Observational observation (Geleris dkk., 2020): The activity carried out is observing the sales and purchasing activities of herbal medicines at Farah's Shop (Puntmann dkk., 2020). Documentation (Marijon dkk., 2020), Is the collection of data at the Farah Store in the form of notes or sales reports System Design is The Online Application for Sales of Medicines and Herbal Supplements at Farah Shop Banjarmasin uses PHP and MySQL (Khanna dkk., 2021), this herbal medicine sales system can be done by buying directly served by the Farah Shop admin by coming directly to the shop without having to register (Abd El-Hack dkk., 2020), the second way is to purchase online. The buyer registers by filling in the identity of the herbal medicine orderer then (Koch dkk., 2020). Buyers can order herbal medicines by selecting the name of the item and the number of drugs to be ordered (Lin dkk., 2019). The Farah Shop Admin will check the total cost of shipping to the buyer's address by manually checking the cost per kilo of delivery to that address multiplied by the order's total weight (Carvalho & Conte-Junior, 2021). The Farah Shop Admin will inform the buyer about the total shipping cost and added to the total cost of the buyer's drug order. The buyer pays via bank transfer then proof of payment is uploaded on the application. The admin will check the payment status and process the delivery of goods sent to the buyer via the expedition service.

DFD design
Functional requirements analysis Data Flow Diagram (DFD) level 0 describes the process of activities implemented in a system. It explains the requirements needed by the system so that the system can run properly according to the needs of the Data Flow Diagram (DFD) level 0 below (Wang dkk., 2020):

Figure 1. DFD design Table relations Main Menu Design
Below is the Main Menu design. In this Main Menu design, a sidebar allows the user to choose the desired menu (Attwood dkk., 2020). Sidebar on this Main Menu.

User List Design
Customers and buyers who have not registered as users in this application use this user list form to make buying and selling transactions (Burchert dkk., 2019).

Figure 3. User List Design Login Form Design
Below is the login form. At this login, the user is expected to fill in the name and password according to the register so they can enter the system, as shown below (Repaka dkk., 2019).

Figure 4. Login Form Design User Main Form
The primary user form is the initial display when the user has logged in using the username and password according to the data registered at registration.

User Order Form
The user order form is transaction data carried out by the user.

Figure 6. Main User Design User Payment Form
The payment form is information for making payments according to purchase transactions, where the admin updates the information.

Figure 7. User Payment Design Admin Main Form
The main admin form is an administrator user level to access all menus in the application.

Drug Addition Form
The admin enters the form for adding drug data as drug master data. Figure 9. Drug Addition Design

Drug Data Form
The admin enters the drug data form to be displayed and sold to users. Figure 10. Drug Data Design

Stock Purchase Form
The stock purchase form is a menu for adding stock which will be updated automatically in-stock items to simplify the process of adding stock.

Figure 11. Stock Purchase Design Order Form
An order form is a form that contains data on orders made by all customers where the admin can provide postage and notes as information to customers.

Figure 12.Design Order Admin Sales Detail Form
This form is used to display the details of what was purchased by the user, which is displayed in the admin.

CONCLUSION
This research report concludes that The application stores data on purchasing medicines and herbal supplements in the database. The application stores data on sales of drugs and herbal supplements, either selling directly to consumers or using an online system using a courier service. The application can quickly generate reports on the remaining stock of medicines and herbal supplements. The application generates reports on purchasing and selling drugs and herbal supplements at the Farah Banjarmasin Shop, which can be viewed daily, weekly and monthly.
Suggestions are given for the perfection of this application as follows. Readers in the STMIK Indonesia Banjarmasin library can further develop this research report to become a reference for other researchers who wish to raise the same theme with a broader scope. This application can be developed into an Android-based application.