endorsedOngoing

BigQuery Order Data Pipeline for DTC Fashion Retailer

Services Covered:

API Development • Data Integration • Web Application Development

Industry

E-commerce & Retail

9 months

Budget

10K - 49K

Start Date

1 July 2020

Team Size

1-5

Engagement Model

Nearshore

Project Capability Score (PCS)

70/100

Good

Project Capability Score (PCS) estimates how capable Vstorm is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

Netherlands

Project Summary

VSTORM built an API-based data pipeline for a direct-to-customer fashion retailer that synchronized order data from the client's e-commerce platform to BigQuery, including a historic import. The system made order and transaction data accessible to reporting tools such as Google DataStudio, enabling analyses that were previously impossible. Communication was managed primarily over Slack with bi-weekly reports and occasional calls.

Key Challenges

Export ecommerce order data continuously to BigQuery
Make the exported data accessible from reporting platforms like Google DataStudio
Ensure swift, preferably direct, synchronization and include a historic import

Project Deliverables

Order data synchronization to BigQuery
Historic data import to BigQuery
Integration with E‑commerce platform via API
Deployment of an application to run continuous synchronization

Project Solution

VSTORM implemented an API integration that continuously synchronized order data from the client's e-commerce platform into Google BigQuery. They performed a historic data import, prioritized a swift direct connection for near-real-time sync, and provided an application to run and manage the synchronization. The vendor team of three (founder, developer, senior developer) delivered the integration and supported deployment and monitoring.

Project Outcome

Enabled improved company data insights that made new analyses possible
Provided organized data accessible to reporting tools (e.g., Google DataStudio)
Established regular communication and bi-weekly progress reporting via Slack

Platforms

Cloud

Tech Stack

REST API
Google Cloud Platform (GCP)

Client Endorsement

Overall Review Rating

4.75

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“VSTORM's application enabled the client to gather important insights from organized data. They were able to execute innovative solutions to improve internal analysis. Slack was used as their main communication platform and had bi-weekly reports for their progress. Phone calls were also optional.”
Anonymous
Director
Date: 04/29/2021