MENU

How Passenger went from scattered spreadsheets to an operational platform that runs the whole business

Joe Simms joined Passenger Clothing as Head of Technology in early 2023 with a precise idea of what needed building. He'd spent the better part of two decades thinking about how product brands should manage their operational data. What he found when he arrived made the scale of the challenge obvious.

Passenger are an outdoor and lifestyle apparel brand that had grown to around £30m in revenue by 2023. 400+ active styles, DTC and B2B, selling across the UK and into international markets, with warehouses on both sides of the Atlantic and wholesale accounts growing into the US. The operational complexity was real and getting more complex by the season. The infrastructure for managing it wasn't keeping up.

Product data lived in Shopify. Costing and buying data lived in Google Sheets. Inventory and fulfilment ran through Brightpearl. Product design and development lived in Backbone, their PLM. Nothing talked to anything else.

What Joe found when he looked closer was messier than even that. "There are so many spreadsheets I don't even know about still," he said. "People are copying and pasting everything between spreadsheets." The seasonal range plan, the document that organised every season's buying, had become the business's centre of gravity. Teams lived in it because they'd always lived in it. It held buying data, cost data, supplier information, and product details: all pulled by hand from the systems that were supposed to hold them.

This is what we call the Dark Stack: not a single broken system, but a pattern. Tools accumulated to solve specific problems at specific moments, each one siloed, each one depending on a person to copy, translate, and reconcile data across all the others. When a factory changed a specification across the product range, that meant propagating the change manually across Shopify, Brightpearl, and whichever version of the spreadsheet was current. When the buying team needed a range view for a new season, they built it in Google Sheets - pulling data out of Airtable to do it.

By mid-2024, even after more than a year of building in Airtable, the pull of the familiar was winning. "When I go to that Google sheet, Olly, everyone's looking at it every day," Joe said. "No one's looking at Airtable. It's really frustrating." New people joined the team, didn't get trained on Airtable, and defaulted to spreadsheets. The data started fracturing again.

Joe had been thinking about this class of problem for a long time. "I've probably spent 20 years thinking about this on and off," he said. "The biggest mistake people make is if they procure or implement software, they just think it's a one off shot. It's not a living and breathing thing. Anything that's operationalised within a business needs constant adaptation and development to evolve."

"There are so many spreadsheets I don't even know about still. People are copying and pasting everything between spreadsheets."

Joe Simms, COO, Passenger Clothing

Joe wasn't looking for a one-off implementation. He'd watched brands buy enterprise software they couldn't adapt, and build in-house systems that couldn't keep up. What drew him to Nolo was the specific combination: deep Airtable build capability and retail operational knowledge baked in.

"People are coming to you for your expertise in Airtable, your expertise in retail, the fact you've done it all before," he said. He wanted a partner who understood not just how to build in the tool, but what the underlying data model should actually look like for a brand at Passenger's stage.

Nolo worked with Passenger through Discovery, Design, and iterative sprint cycles, starting with the fundamental question of where product data should live and how it should be structured before any integration was built.

Product Master

The first build was a central product catalog in Airtable: every active style, every variant, every supplier, connected directly to Shopify. Data from Backbone, Passenger's PLM, pulled in automatically so the product record in Airtable always reflected what was in the design system. On the front end of Passenger's website, the colour swatches and product badges (Recycled, Organic, etc.) that customers see are managed from Airtable: the colours are Shopify Metaobjects, controlled from a Shopify Colours table rather than edited manually in Shopify. Product descriptions are generated by AI in the workflow. Product images pull through from Google Drive with correct SKU tagging via integration. The result is a single place to understand what the product range looks like: one record per style that connects upstream to Backbone and downstream to every customer-facing channel.

Buying & Costings

The second project moved supply negotiation and margin analysis into Airtable, built on top of the same product data. Supplier negotiations happen against the product record. Size curves apply at the buy level. Purchase orders are generated from the buy plan and sent directly to Brightpearl, removing the hand-off between buying team, finance, and warehouse that previously lived across email and spreadsheets.

Pricebooks

Third, centralised pricing: retail prices, wholesale prices, and RRP change requests for Passenger's full range across 10+ markets and currencies. Markdown automation built in: the team can create a markdown event, schedule it for a specific day and time, publish price changes across whichever channels and markets they choose, and revert when the sale ends. No manual coordination between Shopify and Brightpearl separately.

The three builds gave Passenger something they hadn't had: a reliable, connected product data foundation. What happened next is as much a Passenger story as it is a Nolo one.

With the core data layer in place, Passenger's own team started extending the platform. Jack Hancocks, Operations, built Shoots, a full photography planning system in Airtable that replaced the Google Sheet the team had been running for years. Shoot planning, checklist management, stock intake, creator and model management, image tagging for Dash (their digital asset management tool): all built in Airtable, connected to the same Product Master records. Jack also built out Passenger's wholesale app, synchronising products and pricing from Airtable to Elastic, the outdoor industry wholesale platform, for their B2B catalog management.

The range planning base came next, moving the seasonal buying process that had been the stubborn Google Sheet into Airtable. Product briefs, range entries, critical path, continuity tracking: the team now plans and reviews a full season from the same system that holds their product records, costings, and supplier data. The "everything document" in Google Sheets has been retired.

The sustainability layer Passenger has built on top of their product data shows what the foundation makes possible. Certifications, supplier assessments, and ESG reporting all live in Airtable, connected to the supplier and product records that came from the original Product Master build. They've integrated Fairly Made, linking product traceability data through to the product detail pages on their website, so customers can see the supply chain story for individual products. The latest innovation is operationalising AI, starting with automatic translations of product descriptions for international sales channels. None of that was in scope when Nolo started. It became possible because the data was structured and in one place.

Joe's read on where things stand: "It's all in one place. It's not spread across the business. Problems come up, of course, but they are easier to solve when it's all consolidated."

Brightpearl is still in the stack at Passenger, but its position has changed. Airtable now acts as the authoritative layer: product data, cost data, and pricing all flow from Airtable into Brightpearl, rather than Brightpearl maintaining its own version of the truth.

The US distribution centre launched as planned. The European DC is now live too. REI, the major US outdoor retailer, has come on as a wholesale account, which meant extending the barcode system to handle both EAN and UPC formats. The operational data infrastructure that runs the business keeps expanding because the foundation it was built on can take the weight.

Joe called it early. "I think Airtable can be a powerhouse across the whole organisation," he said. "I think we're only scratching the surface, really."

What changed at Passenger?

01
Nolo built the product data foundation: Product Master, Buying & Costings, and Pricebooks. Three connected systems that gave Passenger a single source of truth across product, suppliers, and pricing for the first time.
02
With the data foundation in place, Passenger's own team built on top of it: photography planning (Shoots), wholesale catalog management, range planning, ESG reporting, and sustainability traceability.
03
From "so many spreadsheets I don't even know about" to an operational platform that runs the whole business: product, buying, pricing, wholesale, shoots, range planning, sustainability, and internal ops - all in Airtable.