← Derek Rose
CRM Project

Derek Rose · Image Automation

Derek Rose is a UK luxury fashion brand specializing in high-end apparel and accessories. Metawork built a comprehensive Pipedrive-based CRM and order management system including automated image collection by style code, inventory import orchestration, and ongoing support with advanced features like customer lifecycle tracking and AI-powered scoring.

Duration 2 months
Tasks 7

What was built

The Image Automation project automated Derek Rose's product image collection workflow by style code. The system retrieves product identifiers from Pipedrive deals, searches Microsoft OneDrive/SharePoint for matching product images organized by style code, and stores or surfaces those images for sales and marketing use. This eliminated manual image searching and ensured that sales staff always have the correct product visuals for customer presentations.

The implementation involved integrating the Microsoft Graph API for file discovery and retrieval, building search logic to match style codes with stored image filenames, and handling edge cases like multiple images per style or missing images. The automation has been deployed but required ongoing refinement to address API rate limiting and image discovery edge cases documented in the task history.

Project stats: 7 tasks, 6 development/troubleshooting iterations, ~50h

Recently touched

  • 2025-08-05 Automated Image Collection by Style Code Done
  • 2025-07-14 Customer told that doesn't loading images Done
  • 2025-07-14 Checkign out histories, try to find out the reason Done
  • 2025-07-03 Automated Image Collection by Style Code Done
  • 2025-07-03 Many issues with Microsoft API + Task requirements issues Done

Other projects in this case study

  • Ongoing Support

    Ongoing Support covers the continuous operation and evolution of Derek Rose's Make.com automation stack from 2024 through present. The work spans three main areas: regular break recovery on the…

    Read case study
  • JotForm + AI Agent

    We ran a scoped evaluation of JotForm's built-in AI agent feature to determine whether it could replace or reduce manual data collation work inside Derek Rose's existing Pipedrive and Make.com stack.

    Read case study
  • Automatic Imports

    Automatic Imports is Derek Rose's largest and most complex project: a sophisticated multi-scenario inventory import system that processes product catalog data from upstream sources and syncs it into…

    Read case study
  • Pipedrive Onboarding

    GoogleSpreadsheet - Logins + Data Mapping

    Read case study