Shopify-NetSuite Sales & Refund Connector
Project Overview
Built an automated daily sales and refund reporting connector for NetSuite import with bundle SKU decomposition.
The Challenge
An enterprise retailer needed daily SKU-level sales and refund reports from Shopify for NetSuite import, with an added complexity: pre-made bundle products needed decomposing into individual component SKUs for accurate per-item reporting.
The Solution
Built a Remix connector app that pulls from Shopify Orders API, integrates ShipHero API to decompose bundles, and generates merchant-facing reports with date range selectors and toggle between per-order and per-SKU views.
Results Achieved
Daily automated SKU-level sales and refund reports
ShipHero API integration for accurate bundle decomposition
Merchant-facing UI with date range and view toggles
Manual accounting reconciliation effort eliminated
CSV exports ready for direct NetSuite import
Project Details
Category
Integration
Key Result
Daily reports automated, manual accounting eliminated
Tech Stack
See More Projects
Returns & Exchange App — Wanderers Travel Co.
Built a multi-store returns processing system handling 1,000+ return requests daily across 4 regional storefronts.
View Case Study
Multi-Store Product & Order Sync Connector
Engineered a bi-directional product and order sync connector for 10,000+ products without a single rate limit error.
View Case Study
Let's Take Your Business Further
Whether you need a Shopify migration, custom storefront, or performance overhaul — let's start with a conversation.
Get in Touch