Closeup of microchips

20 million technical records in days: the RS Components Product Data Library

Engineers buying from RS Components rely on datasheets, schematics, simulation models and application notes, and RS needed a better way to upload and maintain them across a range of more than half a million products. Box UK built a Product Data Library that imported 20 million records from six suppliers in a matter of days.

In short

RS Components supplies more than half a million products to around a million engineers in 32 countries, and those engineers depend on accurate technical documentation. RS needed a better way to upload and maintain it, and turned to Box UK.

  • A Product Data Library built on MongoDB, designed for speed at large volumes
  • Fewer upload steps, plus automatic tagging, renaming and indexing for RS staff
  • Integration with supplier data stores, so RS knew about new information straight away
  • A multilingual portal where engineers could search, filter and download documentation
  • 20 million records from six suppliers imported in a matter of days

Client

RS Group

Sector

Manufacturing

Customer background

RS Components, part of RS Group, supplies more than half a million products to around a million engineers in 32 countries, shipping some 44,000 parcels every day.

Its customers are electronics and automation engineers, who rely on a wide range of technical resources, including schematics, simulation models and application notes, to plan their projects and source the right parts.

For those customers, RS’s online documentation is part of the service.

The challenge

RS Components recognised that its future success depended heavily on giving engineers an unbeatable online resource. That meant technical documents covering a wide and diverse range of products and suppliers, kept current and accurate.

RS needed to update the way it uploaded and maintained those documents, so it could handle very large volumes and keep pace as suppliers changed their information.

That called for two things: a store that could cope with the volume, and a way for engineers to find what they needed in it.

Our approach

Box UK built the Product Data Library in two parts. The first was the store itself, which had to hold very large volumes of documentation and keep it up to date with as little manual work as possible. The second was the portal engineers would use to find what they needed.

For the store, the team chose MongoDB, a cross-platform, document-oriented database designed with speed as a specific concern. For the portal, Box UK took a user-centred approach, starting with a period of requirements gathering and working through multiple prototype iterations until the design was right.

What we built

The MongoDB store made documentation available when and where it was needed. To keep it current, Box UK’s UX and software consultants reduced the number of steps RS staff needed to upload resources, and added automatic tagging, renaming and indexing to cut the admin further. The system was also integrated with suppliers’ data stores, so RS Components knew about new information as soon as it was available.

On the front end, engineers got a multilingual portal where they could search, filter and download product documentation, confident that it was up to date. Behind the scenes, RS could see how engineers used the system, spotting patterns and trends to serve their needs better over time.

Screenshot of desktop view of RS PDL dashboard

The outcome

With the Product Data Library in place, RS Components imported 20 million records from six suppliers in a matter of days. Importing datasheets was much faster than with the previous solution, a significant gain in efficiency for the team, and the library let RS expand the range of technical documentation types it could publish.

RS gained highly scalable storage without compromising on performance, and engineers gained documentation they could rely on to be current as suppliers’ information changed.

Frequently asked questions

What’s the best way to store large volumes of product documentation?

Use a database designed for varied documents at scale, and automate updates from suppliers. RS Components’ library used MongoDB, with direct integration to suppliers’ data stores.

How do you keep product data accurate across many suppliers?

Connect to the suppliers’ data directly, so changes flow in automatically rather than relying on manual uploads. That’s how RS Components’ library learned about new supplier information straight away.

How fast can a large product data import be?

With the right architecture, very fast. RS imported 20 million records from six suppliers in a matter of days.

How do you reduce the admin of publishing technical documents?

Cut the number of upload steps and automate the repetitive work. RS Components’ library added automatic tagging, renaming and indexing, so staff spent less time on admin.

Why prototype a documentation portal before building it?

To get the design right for the people who’ll use it. RS Components’ portal went through requirements gathering and multiple prototype iterations before the design was settled.

What this means for your organisation

If your customers depend on technical information to choose and use your products, that information is part of what you sell. When it’s slow to publish or out of date, customers notice, and some go elsewhere.

If you’re managing large volumes of product data from many sources, send us a few lines about where it comes from and where it needs to go. We’ll tell you how we’d structure it.

Client

RS Group

Sector

Manufacturing

Talk to one of our digital experts

Tom Houdmont

Head of Business Solutions

Do you have a great idea for a project you need support with?

Tom leads Box UK’s Business Solutions team and has over 15 years experience in the web industry. Tom is passionate about creating impactful solutions that solve real problems and deliver the outcomes our clients need.

Or call us on 020 7439 1900

Have a project you’d like to discuss?

Give us a call on 020 7439 1900 or fill in the form and we will get back to you.