John Bettiol

Launching a marketplace on-time: A lesson in taking shortcuts using spreadsheets!

With 90 days to launch, they scrapped all internal tools. Their backend became a massive spreadsheet that wrote raw SQL directly to the production database.

Launching a marketplace on-time: A lesson in taking shortcuts using spreadsheets!
#1about 4 minutes

Facing a 90-day deadline to launch a new marketplace

The team had to build a complex B2B marketplace with a distributed team, a massive backlog, and no clear data on products or sellers.

#2about 3 minutes

De-scoping all internal tooling to meet the launch date

To meet the aggressive deadline, the team decided to build no administrative tools, relying on manual processes to manage the platform at launch.

#3about 4 minutes

Building a spreadsheet tool for seller data onboarding

A custom Excel spreadsheet was created to simplify seller data submission, handling data mapping, legal requirements, and file encoding issues for non-technical users.

#4about 2 minutes

Managing platform configuration with a complex spreadsheet

A single, massive spreadsheet was developed to manage 35 database tables for platform configuration, including categories, translations, and legal attributes.

#5about 2 minutes

Pivoting to Google Sheets after a data loss crisis

When the Microsoft 365 spreadsheet became corrupted from concurrent use, the team bypassed IT policy and switched to Google Sheets to restore their workflow.

#6about 2 minutes

The long-term consequences of taking technical shortcuts

While the spreadsheet solution enabled a successful launch, it created significant technical debt that led to inefficient processes and longer onboarding times years later.

#7about 5 minutes

Q&A on lean management, team morale, and tech debt

The speaker answers audience questions about using lean principles, maintaining team morale after data loss, and securing management buy-in to fix the initial shortcuts.

Related jobs
Jobs that call for the skills explored in this talk.

Featured Partners

Related Videos

Seven Myths, Three Reasons, One Goal46:48

Seven Myths, Three Reasons, One Goal

Stefan Priebsch

Single Server, Global Reach: Running a Worldwide Marketplace on Bare Metal in a Cloud-Dominated World50:06

Single Server, Global Reach: Running a Worldwide Marketplace on Bare Metal in a Cloud-Dominated World

Jens Happe

Business Strategies for Scaling European Tech29:57

Business Strategies for Scaling European Tech

Anastasia Zemskova, Vuyiswa V. M'Cwabeni, Gilli Cegla, Nikola Pavesic

Unveiling the Dark Side: Navigating the Pitfalls of Digital Ambitions21:39

Unveiling the Dark Side: Navigating the Pitfalls of Digital Ambitions

Johannes Hansen

Let developers develop again26:47

Let developers develop again

Kai Geißelhardt & Volker Zöpfel

ShapeShift: Reinventing Agile for a B2B SaaS Scale-Up05:11

ShapeShift: Reinventing Agile for a B2B SaaS Scale-Up

Milton Leon Rodriguez

Forget Developer Platforms, Think Developer Productivity!57:45

Forget Developer Platforms, Think Developer Productivity!

Robert Hoffmann & Christian Denich

Overcoming bottlenecks of Platform Teams19:04

Overcoming bottlenecks of Platform Teams

Candost Dagdeviren

From learning to earning

Jobs that call for the skills explored in this talk.

Senior PHP Developer

Senior PHP Developer

Online Payment Platform
Delft, Netherlands

€75-95K
Senior
PHP
MySQL
Redis
Symfony
+1