Overview
A consulting skill where e-commerce sellers self-diagnose the operational automation potential of their own store and automatically generate priorities and a roadmap.
One-line responsibility: Seller status input → automatic generation of 6 major area diagnosis + automation priority score + 3 Phase roadmap + 5 KPI targets + HITL review points.
6 Major Commerce Work Areas
| Area | Question | Key Tasks | ROI |
|---|---|---|---|
| A Product Operations | "What to sell" | Product sourcing, listing, images, detail pages, categories | 중 |
| B Pricing & Promotion | "At what price, how to sell" | Cost analysis, margin calculation, discount policy, coupons, events | 중 |
| C Orders & Settlement | "Order processing and payment collection" | Order collection, invoice issuance, cancellation/returns/exchanges, settlement, matching | 🏆 Highest ROI (30-50% reduction) |
| D Inventory & Logistics | "Where and how much inventory to hold" | Real-time inventory, safety stock, ordering, inbound/outbound, courier integration | 중 |
| E Marketing & Customers | "Acquire and retain customers" | Ad execution, performance marketing, CRM, inquiries, reviews | 중 |
| F Data & Management | "Determine whether things are going well" | KPI monitoring, P&L, performance analysis, strategic decision-making | High |
3 Automation Type Classifications
| Type | Definition | Automation Strategy | Tool Examples |
|---|---|---|---|
| ① Repetitive (Repetitive) | A person repeats the same task — data entry, copying, regular reports | RPA / Workflow | Zapier, Make, UiPath, Power Automate |
| ② Judgment-based (Judgment) | Decisions by rules/criteria — category classification, anomalous transactions, order quantity | Rule Engine + AI | Drools, AWS SageMaker, Custom Python |
| ③ Creative (Creative) | Planning, strategy, copy — event planning, detail page copy | AI Copilot | ChatGPT, Claude, GPT-4 |
4-Step Automation Design Process
[STEP 1] 업무 나열 (List Up)
- 모든 업무를 표준 포맷으로 나열
- 업무명 / 주기 / 소요시간 / 입력(Input) / 출력(Output) / 사람이 개입하는 이유
↓
[STEP 2] 유형 분류 (Categorize)
- 나열된 업무를 3가지로 분류
- ① 반복형 ② 판단형 ③ 창의형
↓
[STEP 3] 우선순위 점수 (Scoring)
- ROI 기반 점수 = (빈도 × 시간 × 오류비용) ÷ 복잡도
- 예외 발생 비율이 높은 업무는 '복잡도' 점수를 높게 설정
↓
[STEP 4] 방식 결정 (Decision)
- High: RPA / API 연동 즉시 적용
- Mid: Rule Engine + AI 검토 후 진행
- Low: AI Copilot 보조만 (완전 자동화 어려운 창의형)
Automation Readiness Checklist (HARD)
If any of the following 5 items is not met, prerequisite work is required before introducing automation:
| Check Item | Readiness Criteria | Prerequisite Work if Not Met |
|---|---|---|
| Data Structuring | Order/product/inventory DB normalization completed | ERD redesign + migration |
| API Integration Feasibility | Securing API keys for major shopping malls | Partnership negotiation or crawling alternative |
| Process Standardization | Unification of processing methods for identical tasks | SOP documentation + training |
| Permission system | Automated authentication between systems possible | SSO implementation or API token management |
| Exception handling policy | Response manual for automation failures | Fallback process design |
Pro Tip: Before automating "Excel → shopping mall registration", standardizing the Excel template is 80% more important. Unifying the different Excel formats across departments is the key to automation success.
Minimum automation set by area ("Core 6")
Rather than automating everything, firmly build just the core 6:
| Area | Core Automation |
|---|---|
| A Product operations | Bulk product registration API |
| B Price & promotion | Automatic margin rate calculator (commerce-margin-calculator integration) |
| C Order & settlement | Order integration + automatic invoice registration (first priority) |
| D Inventory & logistics | Real-time inventory synchronization |
| E Marketing & customers | Automatic ad report aggregation (moai-seller:commerce-marketplace-coupang-ads integration) |
| F Data & management | Automatic daily sales dashboard refresh (commerce-morning-brief integration) |
Insight: Rather than aiming for 100% automation, automating just these 6 items increases work efficiency by more than 3x.
HITL (Human-in-the-Loop) checkpoint design
Golden Rule
Set the goal not as complete automation (100%) but as **"80% automation rate + 10x review speed"**.
Required checkpoints (humans must judge)
- Image quality and legal wording (copyright·exaggerated advertising)
- Approval of large discount prices (abnormalities such as missing 0 won)
- High-value refund cases (e.g., 500,000 won or more)
- Seasonal product ordering (unpredictable from past data)
System guardrails (blocking error spread)
- Threshold Alert: Pause automation temporarily when "order volume surges 500% vs. previous day"
- Dual Approval: Two or more managers must approve changes to core settings (margin rate logic)
- Automatic rollback and retry: Immediately restore the previous state on API integration failure, retry 3 times
- Audit Log: Permanently preserve all automation execution records and human intervention/modification history
Automation strategy by organization size
| Stage | Monthly orders | Core strategy | Recommended tools | Goal |
|---|---|---|---|---|
| Stage 1 Early startup | <1,000건 | "Focus only on repetitive tasks, manual for judgment-based" | Zapier/Make, Google Sheets+Apps Script, free SaaS | Survival and PMF validation |
| Stage 2 Growth stage | 1,000-10,000건 | "Full automation of repetitive tasks + introduction of Rule engine" | Commerce ERP (Sabangnet, etc.), Python custom, RPA | Operational efficiency & workforce optimization |
| Stage 3 Scale-up | >10,000건 | "Full-domain automation + AI optimization/internalization" | In-house proprietary systems, MLOps, Data Warehouse + BI | Super-gap competitiveness & decision-making speed |
5 Key KPIs for Measuring Automation Effectiveness
| Metric | Target (Year 1) | Measurement Method |
|---|---|---|
| Time Savings Rate | 70%+ | Comparison of processing time before and after automation |
| Error Reduction Rate | 90%+ | Comparison of number of human errors |
| Processing Speed | 1/10 | Time required per 100 orders (e.g., 60 min → 6 min) |
| ROI | 280% | Savings relative to system build cost |
| Throughput per Person | 3.0x | Handle 3x the volume with the same staff |
3 Phase Roadmap
[Phase 1] Quick Wins (1~2개월)
목표: 반복 업무 즉시 제거 & ROI 확인
주문 수집 통합 → 송장 번호 자동 등록 → 재고 수량 실시간 동기화
도구: 기존 ERP 기능 + RPA
[Phase 2] Core Automation (3~6개월)
목표: 전체 업무량 50% 감축 달성
상품 대량 등록 API 연동 → 가격/마진 자동 계산 로직 → 정산 및 리포트 자동 생성
도구: API 개발 + Rule Engine
[Phase 3] AI Enhancement (6~12개월)
목표: 의사결정 속도 및 정확도 향상
수요 예측 기반 발주량 제안 → 고객 세그먼트 자동 분류 → 동적 가격(Dynamic Pricing) 최적화
도구: ML 모델 + A/B 테스트
Input·Output
Input Slots
| Item | Required | Example |
|---|---|---|
| Monthly Order Count | Required | 3,500건 |
| Operating Staff | Required | 2 full-time employees + 1 part-timer |
| ERP·Tools in Use | Required | Sabangnet·Cafe24·Coupang Wing |
| Estimated Ratio of Repetitive Tasks | Recommended | 45% |
| Average Daily Error Rate | Recommended | 12% (manual entry) |
| Category | Recommended | Food·Beauty·Fashion·Household Goods, etc. |
Output (Diagnostic Report)
# 자동화 도입 요약 보고
## 1. 현황 분석 (AS-IS)
- 월 주문: 3,500건 → Stage 2 성장기
- 반복형 업무 비율: 45% → 자동화 ROI 충분
- 주문 1건당 처리시간: 8분
- 수동 입력 오류율: 12%
## 2. 자동화 시나리오 (PLAN)
### Phase 1 (2개월) Quick Wins
- 송장 자동 등록 (월 120시간 절감)
- 주문 통합 자동화
### Phase 2 (6개월) Core Automation
- 상품 대량 등록 API (월 280시간 절감 누적)
- 마진 자동 계산기 (commerce-margin-calculator 연계)
## 3. 예상 효과 (TO-BE)
- 예상 1년차 ROI: 280%
- 투자금 3.2개월 내 회수
- 3명 인력 재배치 (단순→기획)
- 오류율 12% → 2% (10pp 개선)
## 4. 투자 개요
- 초기 개발비: 5,000만원
- 연간 운영비: 1,200만원
- 총 투자 (1년): 6,200만원
## 5. Next Steps
- STEP 01: 파일럿 영역 선정 → 추천: C. 주문 & 정산 영역
- STEP 02: 2주 스프린트 실행 → 송장 자동 등록 완성
- STEP 03: 효과 측정 및 확산
Trigger Keywords
Automation diagnosis, automation prioritization, ROI automation, automation roadmap, Quick Wins, Phase diagnosis, repetitive judgment-based creative, RPA adoption, AI Copilot, HITL review, automation tools by organization size, 5 key KPI automation, automation readiness
Chaining
commerce-automation-audit (현황 진단)
↓ (Phase 1 식별)
commerce-margin-calculator (마진 자동 계산)
commerce-marketplace-coupang-ads (광고 자동 최적화)
↓ (Phase 2~3 추진)
commerce-integrated-strategy (매출 전략 + 자동화 통합)
Pair Separation
| Pair Skills | Differences |
|---|---|
commerce-integrated-strategy |
Immediate execution tactics for revenue improvement (this skill: operations automation diagnosis·roadmap) |
commerce-market-research |
Market entry decision (this skill: operations infrastructure diagnosis) |
commerce-margin-calculator |
Dedicated margin calculation (this skill: full diagnosis of 6 domains) |