Client Success Story

How Team4eCom Helped an eCommerce Business by Automating Sales Channel Management

In this one-of-a-kind project, we built a centralized sales channel management solution- automating over 90% of the client's backend functionality- achieving 60% higher sales productivity and 30% lower overheads.

Who is the Client?

A Prominent eCommerce Player with a Strong Foothold in the Luxury and Rugged Smartphone Market

Our client is a major player in the smartphone market, specializing in luxury and rugged smartphones and related accessories. They have a strong online presence, driven primarily by their website. They also operate eCommerce stores across multiple online marketplaces, including Amazon (across eight regions), eBay, NewEgg, and OnBuy.

What was the Initial Challenge?

Their web store is designed on nopCommerce with MS SQL Server 2012 as the backend database. It has a simple, intuitive interface to ensure user-friendly shopping experiences. However, high user traffic was causing difficulties in effectively tracking and addressing technical and performance-related concerns, thus negatively impacting customer experience.

Their team already had their hands full with other critical activities. So, to address this challenge, they sought a reliable website maintenance company that could provide comprehensive support and expertise. When they reached out to our team, they were specifically looking for nopCommerce development and customization. We initially assigned a team of two developers to maintain their website.

Going Beyond the Brief: How were the Initial Requirements Scaled Up?

As the client acquired more confidence in our team, we were exposed to other critical business challenges.

Maintaining inventory, updating prices, and managing orders across all sales channels were their biggest obstacles. While they tried solving this with popular multichannel marketplace management solutions like ChannelAdvisor and SellerCloud, those ready-to-go solutions proved incompatible for various reasons. This included high cost, complexity, limited customization flexibility, inconsistent customer support, steep learning curve, potential bugs and glitches, and integration issues.

While these platforms are widely-used, the restrictions made it difficult for our client to tailor the solutions to their specific needs, further limiting their ability to expand their online presence.

So, we brainstormed an automated centralized sales channel management solution with a management console and customized POS dashboards for every online marketplace. This solution would allow the client to maintain all product inventory, manage product data, and update prices across all selling channels from a single platform via automation, thus enabling them to focus on growing their business and maximizing profitability.

Challenges that we Resolved Through Automation

Initially, we only collaborated with Team4eCom for website maintenance, but we realized soon that the team was quick, efficient, and skilled. We decided to engage them to help us address some of our larger business challenges and in hindsight, that has proven to be one of the best decisions for us!

The Client

How did we Move Forward?

The idea was to build a unified and centralized system that would facilitate effortless management of inventory, suppliers, and prices. After thoroughly analyzing the requirements and constraints of the system, we automated essential tasks in phases and released the first working model of the system within seven months. Afterward, we worked on solution customization and maintenance.

Soon after, we were supporting the client with nearly 90% task automation while also providing manual support for bulk data upload.

1

Building the Management Console

We built multiple integrated dashboards (POS) for all sales channels and suppliers and integrated them under one roof. We used nopCommerce's built-in features and tools to design the management console and created custom plugins and extensions as needed. We also used BI and analytics tools to ensure consolidated operational functionality. Additionally, we added two data specialists to the client team for appropriate listing data management and upload.

2

Distributing Server Load

After deploying the first working model, we faced issues like slow website loading due to 100% memory utilization and database deadlock. The slow website speed led to high bounce rates and thinning sales. To manage this complication, we offloaded the burden of the main server by diverting over a hundred regularly scheduled processes to a new daemon server. This helped us ensure effective resource utilization and provided the space needed to scale the solution.

3

Syncing Supplier Inventory

To sync supplier’s inventory automatically to the client’s database, we used RESTful Selling Partner API on the Amazon Web Services (AWS) Cloud, using Amazon EC2 instances for hosting and scaling our web servers and Lambda functions for event-based processing. These allowed us to access Amazon's marketplace data easily. We also used eBay RESTful APIs from the eBay developer’s program, the Newegg Marketplace API, and OnBuy API to sync supplier inventory from those marketplaces.

4

Automating Competitor Price Scraping

We built a price calculation algorithm to map supplier prices (also considering shipping charges, exchange rates, delivery charges, etc.) and determine and update an optimal price for the listings on the client’s sales channels. This competitor price scraping tool was written in Python and implemented alongside the core solution. It located the price elements on the web, extracted the value, and returned a CSV file with all the data which was then processed for optimal price calculation.

Technology Stack used for this Project

A Prominent eCommerce Player with a Strong Foothold in the Luxury and Rugged Smartphone Market

Client Side

html bootstrap jquery telerik kendo UI

Server Side

C# asp.net mvc web api mssql
AWS

API

RESTful Selling Partner API (SP-API) on the Amazon Web Services (AWS) Cloud

Hosting

Hosting

Amazon EC2 (Amazon Elastic Compute Cloud) instance

Customizations

nopCommerce

We ran customizations on the web store built on nopCommerce as per the client’s requirements.

Python

The competitor price monitoring tool was written in Python and deployed alongside the core application.

The Achievements we Acquired for the Client

The success of this project has inspired the client to sell it as a ‘software-as-a-service’ solution and capitalize on eCommerce sellers dealing with the limitations of popular multichannel management solutions like ChannelAdvisor.

Solving an Industry-Wide Pain Point

Are you tired of using generic sales channel management tools that don't fit the unique needs of your business? Of paying high fees and commissions to third-party platforms that still limit your control and flexibility over your online sales channels?

Unlike ChannelAdvisor, SellerCloud, and other tools that offer generic and expensive solutions that may not suit your business model or strategy, the automated custom sales channel management solution we built offers the following benefits:

  • Complete access and control over data
  • Integration with any sales channel of choice
  • Flexibility to customize features
  • Elimination of unnecessary costs

Take charge of your online sales channels and grow your business faster and smarter with such a custom solution for your business.

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, Team4eCom 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