Retail

Centralised Inventory for Large Retail Business

Location:

The United Kingdom

Team size:

7 specialists: Sr. Backend Devs, SDETs, BA

Duration:

> 24 months

Technologies:

Golang

Airflow

Snowflake

Jenkins

Ginkgo

Terraform

AWS (Lambda)

AWS (DynamoDB)

AWS (S3)

AWS (SQS)

AWS (SNS)

Customer

Our customer is a fashion giant with a robust presence in both the traditional retail and e-commerce industries. With an 80-year history, they operate 250+ stores across the UK and Europe, managing the entire cycle from manufacturing and design to distribution through offline and online channels.

Challenge

Our customer faced challenges in optimising stock control processes for their stores and warehouses. They needed a system to provide a single view of inventory across all locations, synchronise data with third-party services, and improve reporting and data transmission to analytical systems.

Key questions to be addressed included:

How much stock is available and where is it located?
What is the stock worth at each location?
How much stock is available for sale?
How much stock has been lost?

Solution

We developed an Inventory Management System, which included:

Creating a unified view of inventory to provide accurate stock holding information for retail stores.
Synchronising users and products with third-party services and transmitting price lists to various platforms.
Implementing serverless architecture using AWS (Lambda, DynamoDB, S3) to support these functionalities.

Developing interfaces for stock-related searches and operations in System, and enhancing reporting capabilities in Snowflake.
Ensuring that backend services keep the inventory data in sync by integrating sales information, shipment updates, and adjustments from POS systems.

References

Engineering that reimagines tomorrow

Scale-ups, unicorns and modern enterprises around the globe trust our development teams to manage software from ideation to release and beyond. We enrich organisations with talent that boosts scalability, drives growth and brings disruptive ideas to life.

Result

The Inventory Management System successfully provided the customer with a comprehensive view of their inventory, allowing them to:

Accurately track stock levels and locations across all stores and warehouses.
Determine the value of their stock based on average weighted cost and invoice cost by location.
Monitor available stock and identify any stock losses.

Enable stakeholders to access detailed inventory reports and analytics through enhanced capabilities in Snowflake.
Improve overall efficiency in stock control processes, leading to better decision-making and resource allocation.

Schedule your free consultation

What to Expect:

An expert will reach out after reviewing your requirements.

If required, we’ll sign an NDA to guarantee full confidentiality.

You’ll receive a detailed project proposal with estimates, timelines, CVs, and more.

Thank you for your interest! 
We will contact you shortly.