OpenTrolley - Online Bookstore
ASP.NET
SQL ServerSSISSSRS
Azure SQL
Power BIAbout OpenTrolley
Using Microsoft ASP.NET, MagnusMinds developed the OpenTrolley Bookstore Website — a leading online bookstore in Singapore, Indonesia, and Malaysia. OpenTrolley offers more than 10 million imported US and UK titles at great prices, with a catalog expanded over 15 million titles across 4,000 categories.
MagnusMinds built and continues to maintain the OpenTrolley platform — one of Southeast Asia's leading online bookstores. From the full-text search engine handling 15 million titles to the Power BI dashboards giving management real-time business visibility, every component is built for scale and reliability across multiple markets.
Our Approach
Challenge & Solution
The Challenge
OpenTrolley needed a scalable platform capable of handling full-text search across 15 million book titles while expanding operations into multiple Southeast Asian markets simultaneously. The platform required efficient data movement from multiple Azure-hosted SQL server systems into Power BI dashboards and SSRS reports, and ongoing table and index maintenance to sustain search performance at scale.
Our Solution
MagnusMinds developed the OpenTrolley platform on ASP.NET with SQL Server full-text search powering the 15M+ title catalog. Datasets from various systems of record on Azure-hosted SQL Server were moved and implemented into Power BI dashboards and SSRS reports for business analytics. Regular rebuilding of tables and indexes ensures sustained search performance. The platform includes customer management, online payment processing, order history, and a full cart facility.
What We Built
Key Features
Full-text SQL Server search across 15M+ titles
Power BI dashboards for business analytics
SSRS reports for operational reporting
Online payment processing
Customer management and order history
Cart facility with multi-country support
Impact
Results & Outcomes
15M+ book titles across 4,000 categories
Power BI dashboards and SSRS reports for analytics
Full-text search delivering fast results across millions of titles
Serving customers across Singapore, Indonesia, and Malaysia
Stack
Technologies Used
ASP.NET
SQL ServerSSISSSRS
Azure SQL
Power BI
jQuery
JavaScriptClient
OpenTrolley
Industry
Education / eCommerce
Technologies
ASP.NET, SQL Server, SSIS…
Have a Similar Project?
Let's discuss your requirements and build something extraordinary together.