• Supplier data automatically in order, at the source
  • Joint 1st place in the Emerce100
  • Demo with your own product data
ConnectingTheDots: PIM platform
Joris Polhaar, Sales Consultant at ConnectingTheDots

By Joris Polhaar, Sales Consultant

Replacing Excel with a PIM system.

Anyone who has managed product data in Excel knows the feeling: the first few files are manageable, but as your assortment grows, suppliers send new formats, and your online stores require more attributes, chaos ensues. Files get lost, formulas break, and errors creep in that become immediately visible to your customers.

For many mid-sized companies, this is the point where Excel no longer suffices. The solution? Product Information Management.

Excel gets stuck as you grow.

Excel feels familiar. Almost everyone knows how to use it, and in the early stages, it seems ideal: you list all product information in tables and create exports for your online stores or marketplaces.

However, over time, problems begin to pile up:

  • Version control: Different departments work with their own files. Which one is the authoritative source of truth?
  • Error-prone: A single incorrect cell or formula leads to wrong prices or missing images.
  • Not scalable: Every marketplace or sales channel requires its own format. This results in endless copying and pasting.
  • Performance: Files become so large that they open slowly or crash entirely.

This costs more than just time; it costs revenue. Customers expect complete, accurate product information. A single mistake can lead to frustration, missed orders, or unnecessary returns.

The alternative: a PIM system as the central source.

A Product Information Management system is designed to manage product data centrally and enrich it in a structured way. Instead of scattered Excel files, you work within a single central environment where all information converges: specifications, descriptions, prices, images, and classifications.

The strength of PIM lies in:

  • Consistency: Product data is identical everywhere, from your online store to marketplaces.
  • Validation: The system prevents incorrect values from being entered.
  • Scalability: You can easily add new products and suppliers.
  • Speed: New items go live faster because the data is complete from the start.

Schedule a demo and discover how PIM can accelerate your processes.

Case study: Champion Trophy Products

A good example from practice is Champion Trophy Products. The company is one of the largest suppliers of trophies and sports awards, serving wholesalers and distributors in more than 40 countries.

Champion Trophy Products works with the ConnectingTheDots PIM system, combined with import and onboarding. Supplier data is imported automatically and comes together in one central source for all product information.

What this delivers:

  • Less manual work: supplier data is imported automatically.
  • One central source: all product information lives in one place.
  • Faster publishing: product information flows from that source to the webshop and other channels.

Step by step: moving from Excel to PIM.

Migrating to a PIM system requires preparation. This five-step plan makes the transition more manageable.

1. Data cleansing

Start by cleaning up your current data. Remove duplicates, standardise colours, sizes, and currencies, and fill in any missing values.

2. Data modelling

Determine which attributes are essential for your products. For clothing, it might be size and material; for catering equipment, it could be voltage and capacity. Explore our structure for more insight.

3. Data mapping

Link your Excel columns to the fields in the PIM system. For example:

  • Excel: "Product Name" -> PIM: "Title"
  • Excel: "Description" -> PIM: "Long description"
  • Excel: "Colour" -> PIM: "Attribute: Colour"

4. Execute a test import

Import a small dataset and check for accuracy. Correct where necessary before importing the full dataset.

5. Scaling up

Once the test is successful, scale up to all products, suppliers, and channels.

Tip: Always work with CSV files instead of XLSX, split product groups (such as clothing, appliances, and accessories), and use URLs for images and documents.

The role of Import & Onboarding

Many companies hesitate to make the switch because suppliers provide data in so many different formats. Import and onboarding from ConnectingTheDots removes this obstacle.

This component automatically converts data into the correct format, validates the content, and loads the information directly into the PIM system. Whether a supplier uses Excel, CSV, or XML, import and onboarding ensures clean, complete product data is ready for publication.

The benefits of a PIM system for mid-market companies

A PIM system delivers much more than just clean product data. It creates structure and collaboration across the entire organisation:

  • Collaboration: Marketing, procurement, and e-commerce all work in the same system. No more scattered spreadsheets, just one source of truth.
  • Traceability: Every change is traceable. You can see who adjusted what, when, and why. This provides control and confidence.
  • Roles and permissions: Not everyone needs access to everything. Use automate to manage exactly who can edit what.
  • Efficiency: New products reach the market faster because data is complete and instantly available.
  • Better customer experience: Customers see consistent and comprehensive product information, leading to higher conversion and fewer returns.

Download our free guide: The hidden costs of Excel for product data.

How does PIM improve e-commerce performance?

A PIM system improves performance by delivering consistent, complete, and high-quality product information to all channels. This results in better SEO, higher conversion rates, and fewer returns due to accurate product descriptions.

Frequently asked questions about PIM systems