Landing & Auth Flow
1. Order Arrives via Shopify
Webhook fires instantly on orders/create — SKU, variant, and sale price pulled automatically from your store.
2. AI Matching Engine Runs
Searches eBay, Walmart, and distributor feeds using UPC, SKU, and GPT-4o title similarity scoring.
3. Margin Calculated Instantly
Landed cost (item + shipping + tax) vs Shopify price — profit and margin displayed with one-click approve or reject.
Dashboard Flow
142
Orders Received
↑ +8%
$12,840
Potential Savings Found
↑ +14%
28.4%
Avg Gross Margin
↑ +2.1pts
6
Pending Approval
↓ -3 from yesterday
Daily Avg Margin % — Last 7 Days
2:14
PM
Order #5082 — Nike Air Force 1 (Sz 11)
Matched on eBay · $64.99 landed · 31.6% margin · APPROVED
1:47
PM
Order #5081 — Sony WH-1000XM5
Matched on Walmart · $248.00 landed · 19.4% margin · REVIEW
Match Rate
138 / 142 orders matched
Auto-Approved
118 met margin rules
Rejection Rate
12 below min margin
Orders by Source — This Week
9:00
AM
Daily Batch Summary — Completed
142 orders · 4 unmatched · avg 27.8% margin · $128K total savings
Orders & Sourcing Flow
2:34
PM
#5084 · Adidas Ultraboost 22 Running (Sz 10)
SKU: ADI-UB22-10 · Sale: $190.00 · Best source: $118.40 · Margin: 37.7% · AUTO-APPROVE
2:21
PM
#5083 · Apple AirPods Pro 2nd Gen
SKU: APP-AIRP-2G · Sale: $249.00 · Best source: $198.00 · Margin: 20.5% · REVIEW
2:14
PM
#5082 · Nike Air Force 1 Low (Sz 11)
SKU: NKE-AF1-11 · Sale: $94.99 · Best source: $64.99 · Margin: 31.6% · APPROVED
2:09
PM
#5079 · Dyson Airwrap Complete Styler
SKU: DYS-AWR-CPL · Sale: $475.00 · Best source: $418.00 · Margin: 12.0% · REJECTED
1:44
PM
#5080 · Generic Wireless Earbuds Premium
SKU: UNK-ERB-BLK · No UPC/SKU match · AI title: 44% confidence · UNMATCHED
138
Matched Today
↑ +97.2% rate
eBay
#1
Nike Air Force 1 Sz 11 White — top_rated_kicks
$52.99 item + $6.00 ship + $0.00 tax = $58.99 landed · Match: UPC 194502093543 · 99.1%
Dist.A
#2
Nike AF1 CW2288-111 Size 11 — Distributor A
$61.00 item + $3.99 ship + $0.00 tax = $64.99 landed · Match: SKU exact · 100%
WMT
#3
Nike Air Force 1 Low Mens Size 11 — Walmart
$64.99 item + $0.00 ship + $5.85 tax = $70.84 landed · Match: UPC · 98.3%
eBay
Best Source
↑ Save $6.00 vs Dist. A
Product Matching Flow
UPC Match Rate
23 of 24 UPC orders
SKU Match Rate
52 of 59 SKU orders
AI Title Match
41 of 55 title matches
Match Rate by Method
97.1%
UPC Exact Match
↑ Most reliable
74.5%
AI Title Match
↑ +5.8% this week
4
Unmatched Orders
↓ Need manual review
GPT
4o
'Nike Air Force 1 Low Mens 11' → CW2288-111
Confidence: 91.2% · UPC cross-verified · Approved for sourcing
GPT
4o
'Wireless Earbuds Premium Bass' → No match
Too generic · 3 candidates below 50% confidence · Escalated to manual review
Margin Calculator Flow
Gross Margin
$30.00 profit on $94.99 sale
Min Margin Rule
22pts above 15% threshold
Cost Stack Breakdown
$30.00
Net Profit
↑ 31.6% margin
Avg Margin % by Source
Daily Avg Margin — Last 7 Days
27.8%
30-Day Avg Margin
↑ +3.4pts
$128,450
Total Savings (30d)
↑ +$18K vs prior month
Orders Above Min Margin
110 of 142 orders qualified
Approval Workflow Flow
2:34
PM
#5084 · Adidas Ultraboost 22 — 37.7% margin
eBay Top Rated · $118.40 landed · $71.60 profit · AUTO-APPROVE eligible
2:21
PM
#5083 · Apple AirPods Pro 2nd Gen — 20.5%
Walmart · $198.00 landed · $51.00 profit · Near threshold — manual review
2:09
PM
#5079 · Dyson Airwrap Complete — 12.0%
eBay · $418.00 landed · $57.00 profit · BELOW 15% min — recommend reject
1:55
PM
#5077 · Lego Technic Bugatti 42151 — 28.3%
Dist. B · $271.00 landed · $108.00 profit · AUTO-APPROVE eligible
6
Awaiting Decision
↑ 4 auto-eligible
Margin
Min threshold: 15% · PASS
WMT
1P
Walmart.com — In Stock · Ships in 1 Business Day
UPC Match: 194252989983 · Confidence: 99.1% · Free shipping · No seller risk
Rules & Settings Flow
Minimum Margin Threshold
Auto-reject any order sourced below this gross margin %
Auto-Approve Threshold
Automatically approve orders at or above this margin %
Manual Review Range
Route to approval queue for orders within this band
Max Landed Cost Cap
Never source orders above this landed cost (all sources)
eBay Browse & Finding API
Connected · OAuth 2.0 · 87% daily quota used · 1,300 calls remaining
Walmart Open API v2
Connected · Products + Pricing + Inventory · Real-time
Distributor A — CSV Feed (SFTP)
Last synced: Today 6:00 AM · 48,204 SKUs · Delta mode
Distributor B — REST API
Connected · 22,100 SKUs · Real-time pricing + stock levels
Shopify orders/create Webhook
store.myshopify.com/admin/api · Verified HMAC · Last event: 2 min ago
6:00
AM
Daily Sync Completed — All Distributors
Dist A: 48,204 products · Dist B: 22,100 products · 0 errors
Audit Log Flow
2:34
PM
APPROVED · #5084 · Adidas Ultraboost 22 Sz 10
User: admin@store.com · eBay · $118.40 landed · 37.7% margin · $71.60 profit
2:21
PM
APPROVED · #5083 · Apple AirPods Pro 2nd Gen
User: admin@store.com · Walmart · $198.00 landed · 20.5% margin
2:09
PM
REJECTED · #5079 · Dyson Airwrap Complete
User: admin@store.com · Below min margin · 12.0% < 15% threshold
1:55
PM
AUTO-APPROVED · #5077 · Lego Technic Bugatti
System rule (>25%) · Dist. B · $271.00 landed · 28.3% margin
1:44
PM
NO MATCH · #5080 · Dyson V15 Detect Vacuum
System · 0 results across all 4 sources · Escalated to admin queue
100%
Decision Coverage
↑ All orders logged
Decisions per Hour — Today
2:30
PM
Shopify Webhook · Order #5084 received
Processing: 1.2s · UPC match · eBay source selected · Margin 37.7%
2:15
PM
eBay API · Rate Limit Warning (87% quota used)
1,300 calls remaining today · Auto-throttle engaged · Fallback to Dist. A
9:02
AM
Walmart API · Connection Restored
15-min outage resolved · 3 queued orders reprocessed · No data loss
1.4s
Avg Processing Time
↑ -0.3s this week
0
Errors Today
↑ All systems nominal
V1 Deliverables
Complete overview of confirmed features, deliverable items, and technical architecture for SourceIQ.