The reason your product information management project stalls is that everyone still thinks in spreadsheets

| | 9 min read
pim, workflow, ecommerce

You implemented a product information management system six months ago. The team trained on it. The data was migrated. The integration went live. And somehow, products are slower to list than before. This post is about the mental model that travels from your spreadsheet into whatever system you install next, and what it costs you when it does.

What spreadsheet thinking actually looks like

Ask any ecommerce team how they manage product data before they have a dedicated system, and the answer is almost always the same. They export from their platform (Shopify, Magento, WooCommerce, wherever), make changes in a spreadsheet, and reimport. It feels efficient. With 50 products, it is efficient. With 5,000, it quietly isn't.

Here is what the model actually requires. One person exports the file. That person needs to know everything about every product in the file at the moment they open it: what is complete, what is missing, what the marketplace expects. They make the changes. They reimport. Then the file closes and the products go out of sight.

There is no workflow state. There is no record of what was changed or left incomplete. There is no distinction between a field that is required before a product can go live and a field that is optional. A spreadsheet treats every cell as equivalent. The discipline of deciding which fields matter, which are done, and which still need work lives entirely in one person's head.

Sound familiar?

And there is no quality gate at import. Whatever goes in goes live. If a product goes up with the wrong target audience, the wrong category, or a missing size range, nothing flags it. The product sits live with bad data until a customer notices and contacts support. Support logs the complaint. And then it waits, because the person who handles customer complaints is usually not the person who controls product data, and there is no internal path between them.

The broken product stays broken until someone with enough authority happens to notice it. Which could be weeks. Could be months.

Why more channels makes it faster to go wrong

A team managing one platform can patch errors manually and stay functional. The backlog is inconvenient but manageable. Now add three marketplaces and two regional websites.

One bad import does not create one problem. It creates one problem per channel. Each channel holds its own copy of the error. Fixing the product on your website does not update Amazon. Fixing Amazon does not update your Dutch storefront. Each correction is a separate manual task, and there is no guarantee all of them get done.

As channel count grows, the surface area of every error grows with it. A team that was coping on one channel starts drowning on five. Not because the volume of products changed. Because the volume of consequences per error did.

The thing nobody tells you about your new system

Here is the part competitors will not say, because it is bad for their pitch.

A product information management system is a multiplier. If you bring good structure into it (well-defined attribute sets, clear ownership of each stage, a consistent definition of what "complete" means for each product type) the system accelerates quality and listing speed at the same time. If you bring no structure into it and connect all your channels, the system pushes your existing mess to every channel simultaneously, faster than you could do it manually.

Used without structure, the system is worse than the spreadsheet.

The team we worked with took six months to a year of having this pointed out before the shift began. Not because they were slow. Because the problem is invisible from inside it. It is like hot water: nobody appreciates it until they have been without it and then found it again. The cost of not having a workflow is never a line item. It is just the permanent background of things being slower and messier than they should be.

That is the reason implementation stalls. Not data migration. Not integration complexity. Not the wrong tool. The mental model did not change. The team is still thinking in files.

What the shift actually looks like

In a spreadsheet model, work exists when someone opens a file. The moment the file closes, the work disappears. There is no record of what is done, what is pending, and what is blocked. If the person who started the import leaves for two weeks, whoever covers for them starts from scratch or accepts incomplete data.

In a workflow model, work has state. A product record shows what has been completed, what is missing, and what the next step is. Anyone can pick up from where the last person left off. The knowledge is in the system, not one person's head. An interruption does not break the work.

Monday morning looks different too. In the spreadsheet model, the day typically starts with an inbox of channel errors and complaints, a pile of new products to process, and no clear sense of what to prioritise. Context switching between firefighting and import files is how the day gets spent. Quality suffers, because good data entry requires sustained attention and the day is built around interruptions.

In the workflow model, each person opens their task queue and sees exactly what they are responsible for. Images waiting for review. Attributes flagged as incomplete. Content ready to write. Each task is assigned, each stage is owned. The work moves forward without one person needing to orchestrate the whole.

This is the function chain model applied to product data: a production chain where each role owns a stage, products move through sequentially, and work accumulates in the system rather than in someone's memory. Product triage decides where each product goes. Each stage does its work. The chain delivers to every channel.

Structure comes first. The system makes it faster.

You do not need a product information management system to introduce good structure. Structure is understanding that each stage of product preparation has an owner, that the system enforces what "complete" means, and that errors get caught before products move forward rather than after they go live.

What the system adds is speed and scale. Once the structure is right, the system handles the volume that would be impossible to manage manually. Products flow faster. Channels multiply without adding headcount. Data quality improves because the rules are enforced consistently, not dependent on who happened to open the file last.

The question is not "a central place for product data." Any shared folder is that. The question is how many products move through the chain per week with the right data on every channel. That is the number that grows when the structure is right.

Note: what follows is based on OneSila's implementation approach. Other product information management systems may work differently.

In OneSila, dashboard task cards are assigned to specific users at each stage. Attribute reviewers see incomplete attributes. Content writers see products with attributes confirmed but content not yet written. Each person works their queue without needing to know where every other product is in the chain. The system holds the state. The team holds the work.

That is the shift. And once you have had it, going back to files does not feel like an option.

Henry Ford did not build faster horses. He built a production line where every stage ran at full capacity and the output was consistent at volume. The same thinking applies here. Quality and speed go together when the structure is right. The spreadsheet was never the problem. The thinking behind it was.

Frequently Asked Questions

Ask an Expert

Struggling with product enrichment, global rollouts or platform limitations? We'll walk you through how OneSila solves these problems, and give you clear advice on scaling product data, wherever you're selling.