Automation완료
SmartStore Sync
Windows desktop app that auto-syncs inventory between two Naver SmartStore shops
A standalone Windows desktop app that fully automates the daily inventory reconciliation that dual-store SmartStore operators used to do by hand. Load the warehouse inventory Excel, and the app pulls live SKU data from the SmartStore API, computes deltas, and pushes only the items that need to change.
Tech Stack
PythonPyQt6Naver Commerce API
Description
Overview
A standalone Windows desktop app that fully automates the daily inventory reconciliation that dual-store SmartStore operators used to do by hand. Load the warehouse inventory Excel, and the app pulls live SKU data from the SmartStore API, computes deltas, and pushes only the items that need to change.
Workflow
- Collect — parse warehouse Excel and pull full SKU lists via Naver Commerce API
- Compare — diff at SKU and option granularity
- Conflict detection — flag both-sides-changed items for manual decision
- Preview — confirm proposed changes before applying
- Sync — bulk update with real-time progress
- New SKUs — export new items to Excel
Core features
- Auto-parse warehouse Excel
- Bypass API pagination limits for full SKU sweep
- Conflict detection with selective resolution
- Single-EXE installerless distribution
- Auto token refresh for long-running batch jobs
Stack
Python · PyQt6 · Naver Commerce API
Key Features
Load and auto-parse warehouse inventory Excel files
Live SmartStore API integration — fetches 6,000+ SKUs
Visualize Store A vs Store B inventory differences
Conflict detection with manual per-item resolution dialog
Preview changes before applying
Gallery
