Case Study

Multi-Platform Order Management Automation

About Project

(Gradio + Google Sheets)
Platforms Automated
Etsy
Amazon
eBay
Shopify
TikTok
Automations Implemented
Auto-loading order data from Google Sheets
File handling automation for each platform:
Auto-open PSD files
Auto-move PSD/PNG files to correct folders:
New_Orders → Waiting_for_Approval
Waiting_for_Approval → Completed
Shared Print_Ready movement
Auto-version validation logic
Automatic refresh every 5 minutes
Hidden refresh button system
Notes saving/loading automation (JSON-based cache)
Prevention warnings when version not selected
Multi-tab UI with identical logic per platform
Fully automated folder structure creation & actions