Skims Watchtower: A NetSuite-Native Retail Data Platform Built to Handle 100,000+ Entries Across Every Channel
Skims needed to monitor and analyze retail metrics across multiple sales channels without drowning in spreadsheets. Magentic AI built Watchtower, a NetSuite-integrated platform that structures, filters, and surfaces critical data at the exact speed their business actually operates.
Project Team
At Skims' scale, retail data is not just large. It is complex. Quantities, retail prices, buy costs, and seasonal performance figures span hundreds of SKUs across multiple channels, all living inside NetSuite in formats that were difficult to query, compare, or act on quickly.
The core problems the team faced:
- Managing datasets exceeding 100,000 entries with no efficient way to filter, segment, or surface the right information quickly.
- No centralised view of multi-channel retail performance, making comparisons across channels slow and inconsistent.
- Reporting was manual and time-consuming, pulling attention away from the decisions the data was meant to inform.
- The existing NetSuite interface did not provide the retail-specific views the merchandising and buying teams actually needed.
We built Watchtower as a purpose-built layer on top of NetSuite, designed around how Skims' retail and buying teams actually work.
- Multi-layer data structuring organises retail records within NetSuite for clean, logical access across channels, seasons, and product categories.
- Advanced filtering and global search let users pinpoint specific SKUs, price points, or cost data instantly across the full dataset.
- A consolidated retail dashboard surfaces quantities, retail prices, and buy costs in a single view, with real-time data pulled directly from NetSuite records.
- Seasonal performance tracking through a dedicated Total Buy Per Season table gives buying teams a clear picture of seasonal commitment and performance.
- Seamless data export generates reports directly from filtered views, eliminating manual compilation entirely.
- Dark and light mode UI built for teams spending long hours in the platform.
React JsWe built Watchtower directly into Skims' existing NetSuite environment, meaning no data migration and no disruption to existing workflows. The layered data structure was configured around Skims' actual product taxonomy and channel setup, and the dashboard was designed with direct input from the buying and merchandising teams who use it daily.
Key outcomes:
- Retail teams can now locate and analyse specific data points across 100,000+ entries in seconds, not hours.
- Manual reporting time dropped significantly as export and filtering tools replaced the previous process of building reports by hand.
- Multi-channel comparison, previously a multi-step process, is now available in a single consolidated view.
- User adoption was strong from day one due to the intuitive interface built around familiar retail workflows.
100,000+
NetSuite records accessible, filterable, and exportable through a single retail-specific dashboard
50%
reduction in time spent locating specific data points
25%
reduction in reporting time through automated export
40%
improvement in data location efficiency
Related Case Studies
Guvrn Built the Platform That Matches Independent Directors with Board Seats. We Built Everything That Makes It Work.
Finding the right independent director for a board seat is a consequential, friction-filled process. Lex Guvrn built a platform to fix this. Magentic AI powered it, building the automations, the AI matching layer, and a seamless onboarding experience that makes the system work effortlessly.
How Bexco Manages Digital Advertising Across Every Airport Site in South Korea From a Single Platform
Bexco manages a vast digital signage network across South Korean airports, but manual content management was impossible. Magentic AI built a centralized platform connecting every endpoint, automating formatting, and empowering advertisers to self-serve campaigns from upload to display.
One Listing, 90,000 Realtors, 200+ Platforms. MLS Apartments Built That Engine with Magentic AI.
MLS Apartments needed more than a listing tool. They needed an automated distribution machine, a smart data aggregator, and an analytics platform, all built around the way real estate professionals actually work. Magentic AI built the automations, the integrations, and the intelligence layer.