Case Study Information
Short Description
We developed a sophisticated middleware solution to integrate the Hal Leonard Digital Asset Management (DAM) system with BigCommerce for a leading sheet music retailer. This automated system manages complex licensing restrictions, dynamic product updates, and secure digital delivery for thousands of downloadable assets.
The Challenge
Our client, My Worship Store, faced a massive operational hurdle in managing a digital catalog that required strict regional licensing compliance and real-time synchronization with a third-party DAM provider. Manually importing products, validating “sellable” territories (specifically North America), and managing expiring download links was labor-intensive and prone to error. They needed a way to automate the product lifecycle—from initial data import to secure customer delivery—while ensuring that no asset was sold outside of authorized regions.
The Solution
Pell Software engineered a robust middleware infrastructure hosted on Microsoft Azure to act as the “brain” between BigCommerce and the DAM system. We began by developing an Initial Data Import Routine that cross-referenced multiple data sources, including the Christian Song Database and the Hal Leonard DAM, to populate the BigCommerce store with thousands of digital products. To handle regional restrictions, we implemented a multi-layered validation strategy: a front-end JavaScript customization restricts account creation to the US and Canada, while a server-side routine validates the contents of every shopping basket against the DAM’s real-time “Asset Access” API before allowing checkout.
The technical architecture utilizes an asynchronous webhook handler to process orders. When an order is placed, our system validates the availability of each digital asset, opens the transaction in the DAM system, and only then captures the payment in BigCommerce. To solve the issue of expiring 30-minute download links provided by the DAM, we built a Proxy Download Redirect system. This allows customers to access their purchases indefinitely through a secure, dynamically generated “long-life” URL that authenticates their BigCommerce session before fetching a fresh download link from the DAM in real-time. Finally, we integrated a custom iFrame widget on product pages to provide live sheet music previews directly from the DAM’s server.
The Outcome
The implementation of this integration transformed My Worship Store into a fully automated digital storefront. By removing the need for manual product management and regional compliance checks, the client achieved a massive reduction in administrative overhead and human error. The automated “Authorize and Capture” workflow ensures that the client never pays transaction fees on orders that cannot be fulfilled due to licensing changes, directly protecting their bottom line. Customers now enjoy a seamless, high-tech experience—from interactive sheet music previews to reliable, “always-available” downloads—resulting in higher customer satisfaction and repeat business. The business is now perfectly positioned to scale its digital catalog without increasing its headcount.
Date
March, 2022 – August, 2022
We started work on Phase 1 of the application in March 2022 and finished in August, 2022. However, our team has been constantly improving and maintaining it ever since including the addition of new features and adjustments of existing features.
Major Features
- Dynamic Data Synchronization: A scheduled routine that updates product metadata, pricing, and visibility in BigCommerce based on the latest DAM API data.
- Long-Life Proxy Downloads: Developed a secure redirection service that allows customers to download assets from their order history without worrying about the DAM’s 30-minute link expiration.
- Asynchronous Order Processing: Uses secure webhooks and a local database to manage high-volume transaction processing and payment capture logic.
- Custom Product Preview Widget: Developed a BigCommerce widget that injects interactive sheet music viewers via iFrame, pulling directly from the DAM’s NoteFlight viewer.
- Automated Payment Handling: Configured a specialized workflow to Authorize payments at checkout and only Capture them once the digital asset transaction is successfully registered in the DAM system.
- Custom SFTP Management: Built a secure file transfer interface for the client to manage bypass lists and custom song databases via .CSV uploads.
Technologies Used & Keywords
- Programming Language(s): NET, C#, SQL, JavaScript
- Framework(s): ASP.NET Core
- Infrastructure: Microsoft Azure, Azure App Service, SQL Database, SFTP
- Third-party Systems: BigCommerce (API & Storefront), Hal Leonard DAM System, NoteFlight Interactive Viewer
Client
My Worship Store
Client Industry
Digital Media & Religious Resources
Client Description
My Worship Store is a specialized e-commerce retailer providing digital sheet music, backing tracks, and worship resources to churches and musicians worldwide, with a focus on high-quality Christian song catalogs
Client Review
“I appreciated not having to be the middle man with technical stuff that I have no clue about!”
- Teresa Ledford, Owner & Founder
