A Product Information Management system four teams could finally agree on.
The before
Product information lived in a Google Doc. Anyone could edit it. It wasn’t connected to the ERP, didn’t have an owner, didn’t have a definition of “complete.” It was the source of truth in name only. People kept asking the supply chain team for product details and nobody could tell them when or how those details would arrive. The work was getting done, but there was no system, no owner, no process holding it together.
What I did
Built an ERP-integrated PIM in Airtable. Field-level ownership so every column had a person responsible for it. Validation rules so the data couldn’t go in wrong. Locked, external-facing views for the teams that consume the data without editing it. A clear, written definition of what “complete” means at each stage of the product lifecycle. Then I trained the four teams who touch it, and documented the SOPs that keep it running once I’m gone.
What changed
The crashing Excel log retired. Three redundant spreadsheets retired. Data completeness moved from 40% to 98%. Product data became something leadership tracks weekly instead of panics about quarterly. The supply chain team stopped getting the same five Slack questions every Monday.
What it gave them: four teams who finally agree on what’s true.