Product data and PIM
Shopify and PIM: when a product information system pays off
Integration & data model · Updated
In short
A PIM pays off once product data is maintained for more than one channel, in more than one language, and by more than one person. Below that threshold, Shopify metafields, spreadsheet imports and ERP fields are enough. Above it, the missing single source costs more than any licence, because every assortment change has to be repeated in several places.
This guide explains when a product information management system becomes necessary, which simpler means carry you until then, and what a staged rollout looks like. Choosing a specific vendor and negotiating contracts are not covered.
Contents
- What does a PIM do that Shopify and the ERP do not?
- How do you recognise that you need a PIM?
- Which thresholds tip the decision?
- What carries you before a PIM, and where does it end?
- Who owns which kind of data in the end?
- What does a PIM cost beyond the licence?
- How do you roll out a PIM in stages instead of a big bang?
- Which mistakes occur most often in PIM projects?
- When you are better off without a PIM
What does a PIM do that Shopify and the ERP do not?
A PIM is the editing surface for everything that makes a product sellable: attributes, descriptive copy, media, classifications, translations and channel-specific variants of the same information. It owns neither prices nor stock nor orders. Its only purpose is that product information is created exactly once and flows from there into every channel.
The ERP treats an article as a commercial object: item number, purchase and sales price, tax rate, stock, supplier, customs code. Description fields usually exist too, but they are rarely multilingual, rarely built for media, and almost never designed for a marketing person to touch them daily.
Shopify handles a substantial part of this on its own. Metafields and metaobjects model structured additional attributes, translations run through the Markets structure, and media sit on the product anyway. The difference is not capability but role: Shopify is a channel. What is maintained there is not automatically available to a marketplace feed or a sales rep catalogue.
How do you recognise that you need a PIM?
The most reliable indicator is not the number of items but the number of places where the same information is maintained. A store with many thousands of items but one channel and one language often does fine without a PIM. A store with a few hundred items across five channels and four languages usually does not.
The signals below rarely appear on their own. Two of them are a hint, four of them are a decision. Check them honestly against the current state rather than against the roadmap, otherwise you buy a system for an assortment that does not exist yet.
Signals that a PIM starts to pay off
- The same product description lives in Shopify, in a marketplace backend and in a spreadsheet.
- More than two people maintain product data without anyone controlling approval.
- Translations are exported to an agency and pasted back in by hand.
- A new channel fails on missing mandatory attributes, not on the technical connection.
- Nobody can reliably say which items are fully maintained.
- Seasonal assortment changes regularly cost several weeks of manual work.
- Attributes differ so much per product group that one shared field schema no longer holds.
Which thresholds tip the decision?
Channel count is the hardest threshold. As long as Shopify is the only sales route, Shopify is also the most sensible source of truth for product data. With the second channel the question arises which of the two is right. With the third it can no longer be answered by discipline, only by a leading system upstream.
Languages and markets work similarly but with a delay. Two languages can be managed cleanly inside Shopify. Once markets are not only translated but stocked differently — different assortments, different mandatory declarations, different size systems — translation as a concept stops being enough. You then need variants of the same information per market.
Attribute depth and editing frequency decide the effort. An assortment with five relevant attributes per item stays manageable with metafields. An assortment with product-group-specific attribute sets, technical data sheets and mandatory feed fields for several marketplaces does not, especially when the assortment changes substantially several times a year.
What carries you before a PIM, and where does it end?
Most stores can solve their data problems without a new system, because the problem is rarely a missing tool and usually missing ownership. Before a licence is signed, it is worth an honest look at whether the existing means are genuinely exhausted or were simply never set up properly.
Shopify metafields and metaobjects carry you surprisingly far. Metaobjects allow reusable records such as materials, care instructions or size charts that attach to several products. Through the Admin API these fields can be written and read, so automated maintenance is possible without any additional system in between.
The limit of these means is almost always the same: they know no workflow and no concept of completeness. A spreadsheet does not tell you that three mandatory fields are missing for the French market. A feed tool can rename values, but it cannot create values that are maintained nowhere.
Options before a PIM and their real limit
- Metafields and metaobjects: strong on structure, weak on approval and completeness checks.
- Spreadsheet imports: fast for bulk changes, but without history and without conflict resolution for parallel edits.
- ERP description fields: the single truth for commercial data, but no editing surface for marketing and media.
- Feed tools: good at mapping and filtering existing values, unsuited as the place to create missing ones.
Who owns which kind of data in the end?
The most common cause of failed PIM projects is not technology but a decision never taken about which system is right for which field. That definition belongs before vendor selection, because it holds regardless of the product and because correcting it later requires a data migration.
As a rule of thumb: what ends up in accounting belongs in the ERP. What sells belongs in the PIM. What only takes effect in the storefront may stay in Shopify. The split below works in most D2C and B2B setups and can be adjusted field by field without breaking the underlying pattern.
| Data type | ERP | PIM | Shopify |
|---|---|---|---|
| Item numbers and master data | Leading | Consumes | Displays |
| Prices and conditions | Leading | Read only | Channel prices and promotions |
| Stock and availability | Leading | Not involved | Displays |
| Descriptions and marketing copy | Not involved | Leading | Displays |
| Translations per market | Not involved | Leading | Delivery through Markets |
| Attributes and classification | Base fields | Leading | Metafields |
| Images, video, data sheets | Not involved | Leading | Delivery |
| Campaign pages and storytelling | Not involved | Partly | Leading |
What does a PIM cost beyond the licence?
The licence is the smaller and the more predictable part. The larger effort comes before it: defining attributes, cutting product groups, cleaning existing data and deciding which of three contradictory description versions is the correct one. No external partner does that work alone, because it requires domain knowledge about the assortment.
Then there is ongoing operation. A PIM is a system with roles, approvals and interfaces that needs maintenance, updates and monitoring when something breaks. If nobody in the company owns product data, that role is created by the rollout — and without it the system deteriorates within a few months.
What deserves an honest calculation is rarely the licence but the alternative. Adding up the hours that go into duplicate maintenance, feed corrections and internal queries each season gives you a firmer number than any percentage from a vendor deck. Run that calculation with your own figures, not with someone else's.
How do you roll out a PIM in stages instead of a big bang?
A PIM project that starts with the full assortment and all channels at once ties up months before anyone sees a benefit. A staged rollout reverses that: one product group, one channel, one approval process. What works there gets extended to the rest, and what does not work only costs you a slice.
The first step is always the attribute model, not the system. Once you know which fields exist per product group, which of them are mandatory and which differ per market, half the work is done. That model can even be validated up front in Shopify metafields, before any licence is needed.
For the Shopify connection the rule is: mirror in read mode first, switch leadership later. A period in which the PIM supplies data while Shopify still allows the old editing routine exposes gaps in the mapping without the storefront showing wrong information. Only after that is manual editing in Shopify locked down.
A rollout order that can still be corrected
- Define ownership per data type and write it down, independently of any system.
- Draft the attribute model for one product group and validate it against real items.
- Clean the data for that product group, removing duplicates and legacy values first.
- Connect the PIM to Shopify in read mode and compare the results against the current state.
- Switch leadership, lock manual editing, then take on the next product group.
Which mistakes occur most often in PIM projects?
The most expensive mistake is running the PIM as an archive rather than as the leading system. If product data keeps being corrected in Shopify or a marketplace backend because that is quicker, you recreate exactly the state the project was meant to remove, only with an extra licence attached.
The second mistake is an attribute model that rebuilds the structure of the old export. Existing spreadsheets have grown over time and contain fields nobody needs any more, plus values that actually mean two different things. Adopting that unchanged cements the mess inside the new system.
The third mistake concerns channel requirements. Marketplaces and shopping feeds demand structured declarations such as unique product identifiers, condition and availability in a defined form. If those mandatory fields are modelled only after the rollout, a second pass through the entire assortment follows.
When you are better off without a PIM
A store with one channel, one language and one person maintaining data needs no PIM. In that setup Shopify is the only truth there is, and every additional system only lengthens the path between a decision and its visibility in the storefront. Metafields, clean naming conventions and an import template solve the problem completely.
An upcoming replatforming is also a reason to wait. A PIM feeding a data model that will be replaced within months gets introduced twice. It is more sensible to settle ownership per data type now and place the system decision at the point where the target model is defined.
FAQ
Frequently asked questions
Is Shopify alone enough as a product data source?
As long as Shopify is the only sales channel, yes. Metafields and metaobjects model structured attributes, translations run through the Markets structure, and the Admin API allows fields to be populated automatically. The limit is reached when a second channel needs the same data in a different shape and nobody can say any more which version is current.
From how many items does a PIM pay off?
Item count is the weakest indicator. What matters is the number of channels, the number of languages and markets, the attribute depth per product group and the number of people maintaining data. An assortment of a few hundred items across five channels needs a PIM sooner than a simply structured assortment of several thousand items in one channel.
Can the ERP take on the role of the PIM?
For commercial master data yes, for selling information rarely. ERP systems hold item number, price, tax and stock reliably, but usually offer no multilingual editing surface, no media management and no approval process for marketing copy. Where the ERP carries those fields anyway, marketing and editorial effectively work in a system that was not built for them.
What happens to prices when a PIM is added?
Prices normally stay in the ERP. A PIM reads them at most and does not own them, because price determination depends on conditions, customer groups and tax logic that live in the ERP. Promotional and channel-specific prices, by contrast, are often set in Shopify because they are time-limited and get controlled there.
How long does a PIM rollout take?
That depends almost entirely on how clean the source data is and how clear the attribute model is at the start. The technical connection to Shopify is the shorter part. Data cleaning, product group definition and agreement on which fields are mandatory drive the timeline. A staged rollout therefore delivers results earlier than a single full launch.
Do I need a PIM for marketplaces and shopping feeds?
Not necessarily, but marketplace and feed requirements are the most common trigger. They demand structured mandatory declarations such as unique product identifiers, condition and availability in a prescribed form. A feed tool can map and filter those values but cannot create them. If they are missing at the source, you need a place to maintain them.
Official documentation
Primary sources for the technical statements in this guide.
Keep reading
Related guides
One more thing
In Shopify projects we usually settle this ownership question before any vendor selection, because it determines whether a PIM is needed at all.
What we do