Packaging Products — Custom Sales Reporting Dashboard

Client Overview

Packaging Products, led by owner Cameron, operates a successful eCommerce platform alongside their traditional B2B sales channels. While their account customers are managed through a sophisticated ERP system with detailed reporting, their website cash sales presented a significant blind spot in business intelligence.

The Challenge

All cash sales from the website were being recorded in the ERP under a single generic code. While this kept the accounting tidy, it created a major problem: there was no way to see any meaningful data about this revenue stream. Which products were selling best? Were customers making repeat purchases? Were there patterns that could inform stock decisions or marketing efforts?

Without visibility into individual transactions, Cameron and his team were flying blind on what was becoming an increasingly important part of the business. The sales reps had no way of knowing if a cash customer had quietly become a significant buyer who might benefit from a dedicated account relationship.

The Solution

Phase 1: Data Capture & Dashboard

Automate AI designed a solution that works alongside the existing ERP without disrupting established workflows. We built an automated system that scrapes the order confirmation emails generated by the website, extracts the relevant transaction data, and stores it in a dedicated database.

• Email Parsing: Automated extraction of customer details, order items, quantities, and totals from confirmation emails.
• Customer Matching: Intelligent identification of repeat customers even when email addresses vary slightly.
• Product Analysis: Detailed breakdown of which products are driving cash sales.
• Custom Dashboard: A purpose-built reporting interface providing the insights Cameron needed.

Dashboard Capabilities

Phase 2: Automated Email Campaigns (In Progress)

With a rich database of customer behaviour now in place, we're building the next layer of automation: intelligent email marketing campaigns that leverage this data to drive repeat purchases and improve customer retention.

• Re-engagement Campaigns: Automated emails to customers who haven't purchased in a defined period.
• Cross-sell Recommendations: Personalised product suggestions based on purchase history.
• Restock Reminders: Timely prompts for consumable products based on typical usage cycles.
• VIP Recognition: Special offers for customers identified as high-value through the dashboard.

Results and Impact

The immediate impact was revelation: what had been an opaque revenue stream was suddenly transparent. The dashboard revealed customers who had been making regular, substantial purchases—buyers who had flown completely under the radar because they'd never been flagged for account conversion.

The product analysis has also informed inventory decisions, highlighting items that consistently sell well through the website but weren't being given sufficient priority in stock planning.

Conclusion

This case study demonstrates how hidden data—even data that seems inaccessible within legacy systems—can be unlocked to drive business decisions. For Packaging Products, a creative approach to email parsing transformed a black hole of anonymous transactions into a goldmine of customer insights. With Phase 2 underway, the same data that revealed hidden value is now being used to actively grow it through intelligent, automated marketing.