Tampa Auto Gallery: Building a Real-Time Inventory Pipeline for a Custom Web Platform
Real-Time Inventory Pipeline Overview
Tampa Auto Gallery is a luxury and exotic vehicle dealership based in Tampa, Florida. They specialize in high-end vehicle sales, as well as services including wraps, maintenance, and performance modifications.
Their audience consists of buyers and enthusiasts seeking premium vehicles and customization services.
The inventory work was part of a larger Tampa Auto Gallery website rebuild, in which Unlock-IT helped transform a legacy website into a scalable automotive platform.
The Custom Web Platform Challenge
Tampa Auto Gallery had recently transitioned from a boilerplate WordPress site to a fully custom web application built with a modern stack (Next.js).
While the new platform unlocked significant flexibility and performance, it introduced a critical inventory challenge:
- Their inventory was managed externally through Dealer Center
- There was no native API integration available
- Inventory updates needed to be frequent, accurate, and automated
Without a reliable data pipeline, the new site risked displaying outdated inventory—directly impacting user trust and sales opportunities.
Strategic Approach
To solve this, the goal was to build a scalable, automated integration layer between Dealer Center and the custom web application.
Instead of relying on traditional APIs, the solution leveraged Dealer Center’s SFTP capabilities and modern cloud infrastructure.
1. Real-Time Inventory Pipeline via SFTP
- Established a dedicated SFTP server for Dealer Center to upload inventory data
- Configured the system to receive structured CSV files containing vehicle listings
This created a reliable, standardized entry point for inventory data.
2. Cloud-Based Processing Pipeline
- Built a scheduled service using Google Cloud Run to poll the SFTP server multiple times per day
- Automatically downloaded and processed new inventory files
- Parsed CSV data into structured records for downstream use
This ensured inventory updates were consistent and automated without manual intervention.
3. Automotive Inventory System Database Sync
- Transformed and stored inventory data in Firebase Firestore
- Structured the data to align with the frontend’s needs for fast querying and rendering
- Enabled near real-time updates across the application
4. Frontend Integration for the Custom Web Platform
- Connected the Firestore database directly to the Next.js frontend
- Allowed the site to dynamically reflect inventory updates with minimal latency
- Supported advanced filtering, search, and customization features
Execution Highlights
- Designed a custom API layer in the absence of a traditional third-party API
- Leveraged cloud-native infrastructure (GCP Cloud Run) for scalability and reliability
- Built a fully automated ETL pipeline (Extract → Transform → Load)
- Enabled seamless integration between legacy systems and modern web architecture
Results
The implementation delivered immediate and tangible improvements:
- Near real-time inventory updates, refreshed multiple times per day
- Elimination of manual inventory management workflows
- Improved data accuracy, reducing discrepancies between systems
- A highly flexible platform capable of supporting advanced UI features and customization
- A future-proof architecture that can scale with business growth
Key Takeaway
By engineering a custom data pipeline around existing system constraints, Tampa Auto Gallery transformed a disconnected inventory workflow into a fully automated, scalable infrastructure, unlocking the full potential of their modern web platform.