A lightweight Python automation pipeline was developed around the tools already used by Lovey Prints.
Shopify served as the source for orders and customer information while Google Drive continued to act as the artists' production workspace. All the customer communication was handled via email to offer a hassle-free experience. The automation was designed to connect these systems, without replacing the team's existing working environment.
Automated Order Intake
A scheduled Python job checked Shopify for newly created orders. The workflow retrieved order identifiers, customer information, purchased items, and uploaded image URLs. Customer photos were then prepared for the appropriate production path.
Order-Based Artwork Tracking
Uploaded images were renamed using the Shopify order ID, line-item position, and display order number. This naming convention created a persistent connection between the customer order and its artwork without introducing a separate tracking database.
Service-Based Production Routing
The automation inspected each order for the image-resolution upgrade service. Standard artwork entered the normal production folder, while images requiring resolution improvement were automatically sent to a separate Google Drive queue.
Automated Customer Proof Delivery
When completed artwork appeared in the Finished Art folder, the workflow extracted the Shopify order ID from the filename. It then retrieved the matching customer information, downloaded the finished proof, and sent the image to the customer by email for approval.
Exception Handling & Monitoring
Files that could not be safely matched were moved into a dedicated Manual Sending folder rather than being processed automatically. Logging captured uploads, file movements, sent emails, skipped items, and exceptions so operational problems could be reviewed separately from normal fulfillment.
Key Deliverables
- Built automated Shopify order intake and customer-image retrieval.
- Created Google Drive routing for standard artwork and resolution improvement orders.
- Implemented order-based file naming for reliable cross-system artwork tracking.
- Automated finished-proof matching and customer email delivery.
- Added manual review routing, scheduled execution, and operational logging for exceptions.