OnlineBookstore Portal Case Study

opentrolley bookstore website image magnusminds

Case Study

Here's the Case-Study of some of our works we'd like you to see...

case study about image magnusminds
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

logo ssis magnusminds
SQL Server Integration Services
logo azure magnusminds
Azure SQL Database
logo sql magnusminds
SQL Server 2017
logo c# magnusminds
logo winrar magnusminds

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.

case study challenge image magnusminds
case study solution image magnusminds

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.


  • Search any book.
  • Customer Management.
  • Online Payment.
  • Order History.
  • Cart Facility.
case study conclusion image magnusminds

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.