Logo
Close
Get In Touch

Free Consultation. Guaranteed Response within 8 Business Hours.

TechnoScore – the Digital Engineering Services Division of  SunTec India.
90%+
Task Automation
30%
Lower Overheads
Service
  • eCommerce Development
  • nopCommerce Development
Technology
  • nopCommerce
  • AWS
  • Python
The Client

A Smartphone Dealer

A prominent smartphone brand specializing in luxury and rugged smartphones and accessories. With a strong online presence, they operate across multiple eCommerce platforms, including Amazon (across eight regions), eBay, NewEgg, and OnBuy.

The Requirement

A Custom Sales Automation Solution

The client faced challenges in managing inventory, prices, and orders across multiple sales channels. Existing multichannel management solutions (like ChannelAdvisor and SellerCloud) were either too costly, complex, or lacked the flexibility to meet their needs.

Hence, they required a centralized system to automate inventory management, update prices, and synchronize product data across all sales channels.

Project Complexities

The client’s website was built on nopCommerce with MS SQL Server 2012 as the backend, and struggled to perform under high traffic. The outdated stack was hampering user experience, especially with a growing multi-channel user base.

Additionally, they needed ongoing nopCommerce development support for customizations to address performance issues and ensure smooth operations.

Our Solution

A Centralized Sales Channel Management Solution

We designed and developed a centralized automation system to streamline the management of inventory, prices, and product data across multiple sales channels. The system was delivered in phases, with the first working model completed within a few weeks. Our approach automated nearly 90% of the client’s routine tasks, helping them manage their multi-channel eCommerce operations more efficiently.

Here’s a step-by-step overview:

01

Requirements Analysis & System Design

  • Data Gathering: Analyzed the existing nopCommerce store and workflows to see what challenges they faced with inventory management, pricing, and product data synchronization. We also collated data from their Amazon, eBay, Newegg, and OnBuy stores.
  • System Design: We created a blueprint for the centralized automation system and identified areas requiring customization.
02

Platform Architecture & Technology Selection

  • Architecture Design: Although the client was already using nopCommerce and MS SQL Server 2012, we enhanced and extended their existing stack to meet their automation needs and address scalability challenges.
    • Built custom plugins and extensions within nopCommerce to enable real-time inventory syncing and automated price updates.
    • Optimized the existing MS SQL Server 2012 back-end by indexing critical tables, fixing queries, and implementing efficient data processing techniques.
    • Offloaded scheduled tasks (such as inventory syncing and price updates) to a dedicated daemon server to prevent overloading the central server.
  • Cloud Deployment: To ensure seamless performance and handle high traffic volumes, we integrated AWS EC2 instances for hosting. We also incorporated AWS Lambda for event-based processing.
03

Development of Key Modules

Centralized Management Console

Our developers built a custom management console using nopCommerce's built-in features and custom plugins to provide a single dashboard/interface for all tasks. This interface was integrated with the unified database, having all product and channel data (Amazon RDS).

Inventory Synchronization

We integrated custom APIs from the Amazon Selling Partner API, eBay RESTful API, Newegg API, and OnBuy API to synchronize the client’s inventory in real-time.

Automated Pricing System

We developed a Python-based computerized pricing algorithm to monitor competitor prices and adjust the client’s product prices accordingly. The algorithm considered factors like shipping costs, exchange rates, and platform-specific fees.

04

Optimizing Performance & Scaling

The central server’s 100% memory utilization and database deadlocks were causing slow website speeds. To resolve this, we offloaded more than 100 scheduled processes (such as product syncing and price updates) to a dedicated daemon server.

We integrated Power BI into the management console, allowing the client to access real-time analytics on inventory levels, sales performance, and pricing trends.

05

Testing, Deployment & Continuous Improvement

  • Rigorous QA and testing (Jenkins) were conducted to ensure the system worked seamlessly across all platforms and that integration points with external APIs functioned as expected.
  • After successful testing, we deployed the solution in production. The centralized system was fully integrated with the client’s live eCommerce stores on Amazon, eBay, Newegg, and OnBuy.

As the client expanded its online presence, we continued to support it after deployment, providing ongoing maintenance and updates to the system.

Project Outcomes

Project Outcomes

Humans-in-the-Loop Approach

Online sales channel management is a sum of several activities, like data management, data updation, related web and app development, content creation, search engine optimization, marketing, and ongoing maintenance. While we started out with the intent to automate sales channel management for our client, our team ended up providing the client with end-to-end eCommerce support by utilizing our human-in-the-loop approach.

With a combination of automation and a team of eCommerce experts, we delivered high-quality support that met the unique needs of our clients for web development, solution customization, eCommerce support, and data management.

Overall, TechnoScore has been an excellent partner, and we are thrilled with the results achieved. Their team's technical expertise was apparent from the start, and they made suggestions and offered solutions that we had not considered. Despite encountering challenges, they delivered beyond the expectations. For nearly three years now, they have been an essential cog in the wheel of our business, and we look forward to continuing our association with their team for our future projects.

- CEO, Client Company

Technology Stack