We are converting Funnl.biz into a website more like Amazon or Fiverr where users can sign up to hire service providers to perform prepackaged jobs like they would an individual item. Its also a place where local service providers can go to showcase their best work in the form of easy-to-find, pay for and book service products. For example, a homeowner may be looking to have a burned-out ceiling fan replaced. They just search for "ceiling fan replacement" add it to the cart. Pay for it, then use our custom scheduling software to assign an installation date and time. Im not sure how payment sill work it could very possibly operate on a Escrow system like Upwork. We need to prepare for all possible payment options.
It will give the cities we operate out of locals access to professional quality contract work without the complicated scheduling and price negotiating with Yelp, Google and Homeadvisor as none of them are a complete end-to-end solution. In other words they arent as involved with the process as we are.
The categories are seen below:
- Automobile Modification services. Eg - Auto Body Shop
- Cleaning & Maid Service
- Computer Repair & Building Service
- Construction Services
- Electrician Services
- Event Planning Services
- Flooring Services, floor installation etc.
- Home inspection and evaluation services.
- Home Remodelling services.
- HVAC Services.
- House & Office Interior Design services.
- Lawn Care Services
- LockSmith Services.
- Masonry Services
- Mechanic Services, Auto Repair.
- Painter Services
- Pest Control Services
- Plumbing services
- Pool Services
- Photography Services
- Pressure Washing Services.
- Building Roof repair, roofing services.
- Security System and hardware installation services (cctv cam etc)
- Window treatment services
Possibly more.
Just like amazon we would like the storefront page to be both listing by search query and also able to run structural search under different categories. So it is crucial to use an SQL database and store the listings with SQL. However with SQL comes a great difficulty to scale. If we hit 100+ users simultaneously loading the storefront page looking for results, more and more queries will be executed and as the listings increase the database size will grow thus increasing the query execution time. Which will propose to us a problem not after a short time we went live.
Therefore we must utilize a multi node solution and clever workarounds to overcome this problem.
One workaround we had previously used was to generate a .json file as a copy of the database and adjust the page template to use the .json file to load the results. This decreased the page load time from +30 seconds to just under 3 seconds. We had to use this on the previous version of funnl.biz which consisted of two sections on homepage. Top being the directory and bottom being the blog.
https://funnl.biz/
In the blog section we wanted to show multiple articles from various categories at the same time and this required multiple queries to be executed to load every article thumbnail and the hyperlink every time a user would load the Funnl.biz homepage.
We set a scheduler and ran a query to generate a copy of the database inside a json file and load the data from the json file instead. This took a lot of lift from the server’s resources resulting in a much smoother experience.
However we want to be able to get ever increasing traffic and ever increasing user count and we would like to be able to use a smart multiple node structure to utilize multiple servers and route the traffic to the least busy server to load balance our resource uses.
Therefore we would like to have the e-commerce version of funnl.biz using a CMS that can support;
- Multiple Nodes: The more we scale, we must be able to get away by adding more nodes.
- Multiple user levels: Admins, Editors, Service Providers, Customers.
- Custom Control Panels: While admins and Editors can use the default control panel presented by the CMS, we want to develop our own version of control panel when it comes to managing the store. We need the service providers to see a very user friendly and modern panel while they are customizing their services. Comparable to any large e-commerce platform like ebay or amazon.
- Custom account management panel. Just like any other ecommerce platform. In the account panel, the users must be able to see their order history, manage payment methods, change password, manage addresses etc.
- A blog that supports RSS features. Can use multiple wordpress sites as an RSS source.
- Multiple search indexes like search within the blog or search within the shop.
- Open source and well documented & easily customizable.
- Umbraco might be a good candidate.
The design document is much longer than Upwork will allow. But here a good summary. Its a relatively big project and we are rushing every day to get it done.
Hourly Range: $12.00-$25.00
Posted On: February 18, 2021 20:51 UTC Category: Ecommerce Development