Case Study
Here's the Case-Study of some of our works we'd like you to see...
Case Study
Online Bookstore Portal
Revamped an online bookstore’s website database and backend to improve search performance, remove errors, and allow for expansion into new countries.
Technology Stack
SQL Server Integration Services
Azure SQL Database
SQL Server 2017
C#
winrar
The Challenge
One day, I connected with one Singapore-based client and he was looking for a Full-stack Engineer who can turn his idea into reality. He came up with the idea of making a website for his bookstore. The client was trying to upgrade their system, but lacked a scalable website. They only operated in one country at that time. When they delved into the next market, the way the website was built generated a lot of errors.
Now, the challenge was to represent more than 15 million brand new books at discounted prices, Quick delivery of 4-7 working days, Conveniently search and purchase books from your home or office, Secure online payment by credit/debit cards, PayPal, and local bank transfer.
The Solution
We redeveloped their database and back-end in a way that would eliminate the errors they were having. We used ASP.NET web forms and a SQL server. The client provided us with the frontend HTML code, and then we integrated it with the .NET files. The design was provided by the client, and we integrated it with the back-end. The client was working with the multiple payment gateways in different countries, and we have taken care of those integrations.
Features:
- Search any book.
- Customer Management.
- Online Payment.
- Order History.
- Cart Facility.
Their main metric was search engine performance. They had about 20 million books, depending on how different vendors list them.
MagnusMinds Team was victorious in achieving the best performance in terms of speed: on average, a search is about 1.5 seconds, whereas it used to be 3–4 seconds.