ChannelAdvisor & Shopify Data Import System
Built data import workflows to standardize ecommerce order data from ChannelAdvisor and Shopify for reporting, profitability analysis, and dashboard generation.
- Python
- ChannelAdvisor API
- Shopify GraphQL
- Supabase
- PostgreSQL
- Next.js
- TypeScript
- pandas
Overview
I built import workflows to bring ecommerce order data from ChannelAdvisor and Shopify into a centralized reporting database. The goal was to standardize order data across channels so it could be used for dashboards, profitability reporting, and operational analysis.
Problem
Order data from different ecommerce platforms often comes in different formats. Channel names, order IDs, dates, discounts, quantities, and fulfillment details need to be cleaned and standardized before they can be used reliably.
Manual imports created extra work and increased the risk of inconsistent reporting.
Solution
I created workflows to process order data from multiple ecommerce sources and insert it into a PostgreSQL/Supabase database.
The system included:
- ChannelAdvisor order retrieval
- Shopify order import logic
- CSV parsing and validation
- Date formatting and timezone handling
- Discount allocation
- Distribution center tagging
- Order ID standardization
- Duplicate prevention
- Database inserts for reporting
- Integration with scorecard dashboards
Impact
This project helped centralize multi-channel ecommerce data and made reporting more consistent. It reduced manual cleanup work and made the data easier to use in automated dashboards and profitability analysis.
What I Learned
This project strengthened my experience with ETL workflows and real-world ecommerce data. It also showed how important standardization is when building reporting systems across multiple platforms.