← Case Studies / Project story
SKYSOFT CONNECTIONS · Dynamics 365
Reducing Shopify Product Update Processing from 17,000 Hours to Under 10 Hours
Sky Soft automated CSV intake, file transfer, scheduled processing, pricing calculations, and Shopify API updates. Missing-product logging provided a way to identify records requiring follow-up.
PROJECT SPOTLIGHTDynamics 365Microsoft expertise. Practical delivery.
01 / PROJECT HIGHLIGHT
Automated CSV & File Processing
02 / PROJECT HIGHLIGHT
Automated Pricing Calculations
03 / PROJECT HIGHLIGHT
Bulk Shopify API Updates
04 / PROJECT HIGHLIGHT
Missing-Product Error Logging
01 / PROJECT DETAIL
Reducing Shopify Product Update Processing from 17,000 Hours to Under 10 Hours
Sky Soft automated CSV intake, file transfer, scheduled processing, pricing calculations, and Shopify API updates. Missing-product logging provided a way to identify records requiring follow-up.
02 / Client & Business Context
The distributor managed a large Shopify catalog and received pricing and inventory updates via CSVs. They needed a repeatable workflow to process files, calculate prices, update Shopify, and flag unmatched products.
Client: Confidential US Distributor
Industry: Distribution / E-commerce
Solution Category: Shopify Integration & Process Automation
Project: Product Pricing and Quantity Update Automation
Proof Point: CSV processing, pricing calculations, Shopify updates, and missing-product logging were automated.
The Business Problem
The existing update process required substantial manual work across file handling, pricing calculations, and Shopify updates.
Key challenges included:
Processing incoming CSV pricing and quantity files
Transferring files into the processing environment
Performing manual pricing calculations
Applying updates across a large Shopify catalogue
Managing slow product-update cycles
Identifying missing products during processing
Recording exceptions for follow-up
The challenge was to connect these activities into an automated process with visibility into records that needed attention.
Business Impact of Existing Process
Manual processing created a bottleneck between receiving updated product information and applying it in Shopify.
The source describes slow updates, calculation effort, and additional handling when products could not be found. These activities limited the practicality of maintaining the catalogue through manual processes.
03 / THE SOLUTION
The Sky Soft Connections Solution
Sky Soft built a Shopify automation that ingested scheduled CSVs, applied pricing rules, updated price/inventory via API, and logged missing products.
Key Solution Areas
Incoming CSV Detection :Automatically detected incoming emails and CSV update files.
File Transfer : Transferred files to the designated processing environment.
Scheduled Processing : Used Windows Task Scheduler for automated processing.
Pricing Calculations : Automated pricing calculations before product updates.
Shopify API Updates : Applied bulk pricing and quantity updates through the Shopify API.
Missing-Product Logging : Logged unmatched products for easy exception tracking.
The integration follows a straightforward system-to-system flow:
04 / PROJECT DETAIL
Technology & Integration Architecture
The solution connected incoming update files with automated processing and Shopify:
Incoming Email & CSV → C-Panel / Scheduled Processing → Pricing Logic → Shopify API Updates → Missing-Product Log
This represents the high-level workflow described in the project source. Detailed component responsibilities should be confirmed before publishing a technical architecture diagram.
How the Solution Works
- CSV files arrive through incoming emails.
- Automation detects and transfers the files.
- Scheduled processing applies pricing calculations.
- Shopify API updates product prices and quantities.
- Missing products are logged for review.
05 / THE SOLUTION
Implementation Highlights
1. Automated File Intake
Incoming CSV detection and file transfer were connected to the wider update workflow.
2. Scheduled Execution
Scheduled processing reduced the need to initiate each processing activity manually.
3. Pricing Logic Automation
Pricing calculations were incorporated into the automated process.
4. Shopify Update Integration
API-based updates connected the processed CSV information with the Shopify product catalogue.
5. Exception Visibility
Missing-product logging provided a record of items requiring further investigation.
06 / PROJECT DETAIL
Results & Current Outcomes
- Incoming CSV detection and file transfer were automated.
- Scheduled product-update processing was implemented.
- Manual pricing calculations were automated.
- Shopify pricing and quantity update steps were automated.
- Missing-product logging was implemented.
07 / PROJECT DETAIL
Related SkySoft Capabilities
This solution demonstrates capabilities across:
Dynamics 365 Customization
Shopify API Integration
Power Automate Cloud and Desktop
CSV Processing Automation
Product Pricing Automation
E-commerce System Integration
Business Process Automation
08 / PROJECT DETAIL
Are Manual Product Updates Slowing Your Operations?
Maintaining product pricing and quantities can become difficult when file handling, calculations, and updates depend on repeated manual work.
SkySoft can assess your existing process and build connected automation for product updates, system integration, and exception handling.
KEEP EXPLORING
More problems. More possibilities.
Business Central
Power Apps Custom Connector Integration with Business Central
Secure Power Apps integration with Business Central · Direct customer access within the app
Dynamics 365
Recovering CRM Ownership Architecture Without Rebuilding the Existing Solution
Restored ownership of the existing CRM · Preserved the current CRM architecture
Dynamics 365
Reviving a Charity’s Dynamics 365 Membership and Attendance System
Restored Membership Card Functionality · Revived Reliable Barcode Scanning
YOUR NEXT CHAPTER
Let’s build your next success story.
Bring us the bottleneck. We’ll help you plan the right Microsoft solution.