--- title: "Offshore Delivery Model Case Study | Smart Data" url: https://www.smartdata.net/case-studies/custom-order-integration-for-cuddle-clones description: "Smart Data automated Cuddle Clones' order tracking with AWS Lambda and Google Sheets, removing manual processes and speeding up fulfillment at lower cost." source: "Smart Data (smartdata.net). Markdown copy of the page; the HTML page is canonical." --- # Faster order turnaround through workflow automation Smart Data automated order tracking for Cuddle Clones: order data from its WooCommerce store now reaches each vendor's Google Sheet through AWS Lambda, replacing manual copying. An offshore team delivered it on time and under budget. Built on Azure AWS .NET Core Industry Retail Engagement Integration Cuddle Clones is an eCommerce company that creates custom plush replicas of pets for customers worldwide. With over 50,000 units sold and orders shipped to more than 80 countries, their fulfillment process is both creative and operationally complex. To manage orders, their team was manually copying order data into various spreadsheets that were shared with vendors. This process was slow, error-prone and unsustainable as volume scaled. Cuddle Clones partnered with Smart Data to automate the transfer of order data from their eCommerce platform into vendor-specific Google Sheets, reducing manual effort while improving speed and reliability. ## The challenge ### Cuddle Clones faced several operational hurdles - Order details were being managed manually in spreadsheets for different product lines. - Vendor coordination depended on accurate, timely updates, which increased the risk of errors and delays. - The internal team lacked technical documentation and had limited resources to build a scalable solution. - The timeline was aggressive, requiring new team members to get up to speed quickly. This complex environment required a fast, coordinated solution that could be delivered entirely by an offshore development team. ## The solution Smart Data proposed an offshore delivery model, assembling a team in India to lead the design, development and deployment of the automation solution. The team worked closely with the client through daily check-ins and rapid iteration cycles. ### Key implementation highlights - Used AWS Lambda to run scheduled, serverless processes that pulled data from the client’s MySQL database (WooCommerce). - Integrated with the Google Sheets API via .NET Core to dynamically populate spreadsheets by product category. - Configured AWS CloudWatch for job scheduling and log monitoring. - Employed Azure DevOps for source control and deployment workflows. - Delivered strong post-deployment support directly from the offshore team. Development and testing happened in parallel across multiple sheets, followed by integration into a unified Lambda function. Despite working without formal documentation, the team adapted quickly, collaborating with the client to validate evolving requirements. ## The results The solution was delivered on time, under budget and with functionality that fully met the client’s needs. Faster turnaround by eliminating manual spreadsheet updates Improved vendor communication with real-time data feeds Smoother deployment thanks to daily client communication Strong post-launch support from the offshore team On-time delivery despite strict project timelines The success of this project confirmed the effectiveness of Smart Data’s offshore delivery model for complex, time-sensitive development work. Client Retail and distribution Platform and technology - .NET Core - Azure - AWS - MySQL - Azure DevOps ## Working on something similar? Tell us what you are building and what it has to connect to. Here is what happens after you reach out. ### A short call about the work What runs today, what needs to change and the date you are working toward. ### An engineer looks at what’s running Scope comes from your systems as they are, before anything is priced. ### You get a written proposal Covering scope, team, approach and price. [info@smartdata.net](mailto:info@smartdata.net) [(937) 886-9166](tel:+19378869166)