Skip to content
Smart Data
Services
Modern data platforms
Data strategy consultingData engineeringData governance and qualityPower BI and analytics on Fabric

Platforms we build on

Microsoft FabricDatabricksSnowflake
AI
AI-assisted modernizationAI on your dataAI developmentAI readiness workshop

Start here

AI Enablement GuideReadiness self-check
Applications
Application developmentLegacy modernizationERP and enterprise integrationAPIs and API security

ERP integration

SAP S/4HANA and ECC, NetSuite, Dynamics, Oracle, Epicor and others
How we work
Managed servicesScoped projectsStaff augmentationDirect placement

Where the work happens

Dayton, OhioSmart Data Global Center
All services
Work
National distributor620+ known vulnerabilities eliminated across the customer portalsManaged servicesNuvei: Managed services for payments-to-ERP integrationsGoogleGoogle: A custom LMS for the internal sales teamAll case studies
Industries
HealthcareFinancial servicesInsuranceManufacturing and industrialRetail and distributionAll industries
Insights
BlogEventsSD Labs(opens in a new tab)Tools, open source and talks from our engineersAI Enablement GuideData readiness assessment
Company
AboutCareersSmart Data Global CenterPartners
Talk to us about scope
info@smartdata.net(937) 886-9166

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 onAzureAWS.NET Core

Industry
Retail
Engagement
Integration
A Great Dane and a puppy lying on the grass

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.

Rows of open, empty cardboard shipping boxes

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

Industry

Retail and distribution

Platform and technology

  • .NET Core
  • Azure
  • AWS
  • MySQL
  • Azure DevOps

Related services

ERP and enterprise integrationRetail and distribution

Working on something like this?

Talk to us about scope

Related case studies

All case studies

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.

  1. A short call about the work

    What runs today, what needs to change and the date you are working toward.

  2. An engineer looks at what’s running

    Scope comes from your systems as they are, before anything is priced.

  3. You get a written proposal

    Covering scope, team, approach and price.

info@smartdata.net(937) 886-9166

Tell us what you are working on

We use your details only to reply.

Your privacy choices

Choose what this browser shares with us. The site works the same either way. Privacy policy