Custom Inventory Tracking System

Kaleidos

Kaleidos is a hidden vintage shop and creative studio where good vintage, good people, and good vibes come together. They offer a thoughtfully curated selection of clothing, homewares, and unique goods, all while fostering a vibrant community centered around timeless style and meaningful discovery.

Phase 1

Discovery

The client needed a simple, reliable way to track vintage inventory and update pricing across their growing collection. Their existing process made it difficult for the team to stay consistent, and inaccuracies could lead to pricing errors, missed items, or extra time spent reconciling totals.

The solution had to be:


– easy for the team to use
– accurate and error-resistant
– flexible enough to handle varied vintage items
– maintainable without technical overhead

Phase 2

Approach

Custom Google Sheets System

Built a streamlined inventory sheet tailored to the way Kaleidos categorizes and manages vintage items. Structured fields kept data consistent, minimized manual errors, and ensured clarity across the team.

Automated Pricing & Tracking with Apps Script

Used Google Apps Script to automate calculations, validations, and updates behind the scenes. This created a smoother workflow that reduced mistakes and made day-to-day management easier.

Team-Friendly Workflow

Designed the system to feel intuitive—even for team members unfamiliar with spreadsheets. Minimal friction, built-in logic, and clean organization helped everyone adopt the new process quickly.

Project Duration

Timeline

2 weeks

Tools & Platforms

Tech Used

Google Sheets
Google Apps Script

© 2025 Vega, LLC. All Rights Reserved.

Made by It's Vega