From Client:
For the past ten years, they have been conducting their business offline. Still, they want to establish an online platform where customers can purchase internet plans using cash on delivery or online payment through UPI. They have an extensive user database, including those with overdue payments, which they update monthly using Excel sheets. They require a system that will immediately send a WhatsApp message to users’ numbers containing the number of overdue payments of the old user when they renew or order a plan and the expiration date of their current plan. They currently have one portal of a Radius server where they manually renew user plans by searching for users using their phone numbers, as their radius server lacks API connectivity.
They want a website and an app where users can purchase or renew internet plans and receive payment reminders and overdue payment messages. They must also integrate metadata to identify the router installed in each customer’s house, including the router’s serial number, MAC address, router name, and refundable deposit.
They want a website and an app where users can purchase or renew internet plans and receive payment reminders and overdue payment messages. They must also integrate metadata to identify the router installed in each customer’s house, including the router’s serial number, MAC address, router name, and refundable deposit.
Here is what I did:
They already had a domain name, and I recommended a VPS server on Digital Ocean. They purchased it and provided me access, which I connected to serverkade.com to manage the VPS. After deploying the WordPress CMS, I began working on their project. The following day, I installed recommended plugins required for WP, including Google Site Kit, Rank Math, Elementor, Redirection, Woocommerce, cache plugin, and backup plugin, among others. It took me two days to finish the complete setup of the website, including theme design and required plugins according to customer needs.
To facilitate payment, I integrated PAYTM via their PayTm plugin. For overdue payment and router details, I created a Meta Box custom field in the order edit and customer order sections so both parties can view their recently outstanding fees. As their users were on Excel sheets, I imported all the users via API using Pabbly Connect instead of registering them manually one by one. For WhatsApp messages, I used an unofficial WhatsApp API called waqr.me, which is a codecanyon script I created connected to Pabbly Connect.
The most challenging aspect of the project was their Radius server, which lacked API connectivity, and they wanted me to renew the plan automatically. To solve this, I used RPA through zerowork.io. Whenever a new order is completed on Woocommerce, it triggers the bot in ZEROWORK, renewing itself automatically, and a WhatsApp message is sent to the customer informing them of the plan’s renewal.
To facilitate payment, I integrated PAYTM via their PayTm plugin. For overdue payment and router details, I created a Meta Box custom field in the order edit and customer order sections so both parties can view their recently outstanding fees. As their users were on Excel sheets, I imported all the users via API using Pabbly Connect instead of registering them manually one by one. For WhatsApp messages, I used an unofficial WhatsApp API called waqr.me, which is a codecanyon script I created connected to Pabbly Connect.
The most challenging aspect of the project was their Radius server, which lacked API connectivity, and they wanted me to renew the plan automatically. To solve this, I used RPA through zerowork.io. Whenever a new order is completed on Woocommerce, it triggers the bot in ZEROWORK, renewing itself automatically, and a WhatsApp message is sent to the customer informing them of the plan’s renewal.
For security, I use https://virusdie.com/ and https://www.malcare.com/
For API Security and penetration: I use https://beaglesecurity.
This project took me almost 20 days to complete, and it was my biggest and most challenging one yet, as the client wanted full automation.
This project took me almost 20 days to complete, and it was my biggest and most challenging one yet, as the client wanted full automation.
