SKU-Level Reporting System for Colgate
See how Colgate-Palmolive optimized SKU tracking using MySQL and SSRS to deliver fast, accurate product-level reporting.
About Colgate-Palmolive
Colgate-Palmolive, a global FMCG leader, needed better visibility into SKU-level product data across its vast inventory. Their existing systems lacked the flexibility and performance needed to filter and analyze variants quickly. The challenge wasn’t the tools—they just needed to make MySQL and SSRS work smarter together.
At a Glance
- Industry: FMCG
- Company Type: Global Consumer Goods Manufacturer
- Location: United States
- Engagement Model: Fixed, Project-Based
- Duration: 4 Months
- Tech Stack: MySQL, SSRS
The SKU-Level Blind Spot
Colgate’s operational database (MySQL) and reporting engine (SSRS) were underdelivering. The gaps included:
- No drill-down capability by SKU or product line
- Inability to filter by category, variant, or related products
- Slow report generation due to unoptimized queries
- Business teams reliant on tech support for report access
Colgate didn’t need a new system—they needed to optimize the one they already had.
Tech Stack – What We Used & Why
| Tool | Purpose & Fit |
|---|---|
| MySQL | Core product and inventory data store. We restructured queries and added indexes for performance gains. |
| SSRS | Existing reporting platform. We extended its capabilities with parameter-driven filters, drill-downs, and layered access. |
The Team
A focused four-person team tackled both backend and reporting layers to improve speed, access, and usability.
| Role | Responsibility |
|---|---|
| 1× SQL Developer | Schema normalization, query optimization |
| 1× SSRS Report Developer | Report design, filter logic, UI enhancements |
| 1× Business Analyst | Requirements gathering, use-case mapping |
| 1× Project Manager | Timeline tracking, delivery management |
The Fix
- Restructured the Data Model
- Normalized tables for SKUs, categories, and product variants
- Indexed high-volume tables for faster execution
- Refactored stored procedures used in legacy reports
- Built Smart SKU Filters in SSRS
- Enabled dynamic filtering by SKU, variant, and category
- Designed reports to auto-display related product groupings
- Added sorting and drill-down logic for deeper analysis
- Delivered Actionable Product Insights
- Allowed brand managers to instantly access SKU performance
- Removed reliance on manual data exports and flat files
- Ensured consistent reporting across inventory, supply chain, and marketing teams
The Impact
- Faster access to SKU performance reports
- Fully filterable, drill-down reporting in SSRS
- Technical teams unburdened from ad-hoc reporting requests
- Consistent data for decision-making across the board
| Metric | Before | After |
|---|---|---|
| SKU-Level Report Generation | Manual, Complex Queries | Instant via Dynamic Filters |
| Report Load Time | ~2–3 Minutes per Report | Under 30 Seconds |
| Data Clarity & Consistency | Low | High |
| Cross-Team Access | Limited to Technical Teams | Broad, Role-Based Access |
What’s Next for Colgate?
- Expanding SSRS to cover promotional and forecast tracking
- Setting alerts for underperforming or overstocked SKUs
- Integrating warehouse management data for real-time updates
Still Struggling with Complex SKU Reporting?
Whether you’re in FMCG, retail, or manufacturing—product-level visibility is everything. We help you get there faster, smarter, and without changing your entire stack.
Client Feedback
“This upgrade changed everything. What used to take hours and multiple teams now takes seconds—with every SKU and variant just a click away. We finally have visibility where it matters.”
