`ARBITRAGE_PLAN.md`

489 lines
# LUXURY HANDBAG ARBITRAGE SYSTEM
## Japan → USA/Hong Kong Price Analysis

**Goal:** Identify profitable arbitrage opportunities by comparing luxury handbag prices across Japan, USA, and Hong Kong markets.

---

## MARKET OVERVIEW

### Why Japan is a Key Arbitrage Source

1. **Tax-Free Shopping:** Foreign visitors get 8-10% consumption tax refund
2. **Weaker Yen:** JPY has depreciated significantly (2024-2025)
3. **Parallel Imports:** Gray market goods at lower prices
4. **Department Store Sales:** Mitsukoshi, Takashimaya seasonal sales
5. **Pre-owned Market:** Huge second-hand luxury market (Komehyo, Brand Off)

### Target Markets for Resale

**USA:**
- Higher retail prices (brand premium)
- Strong luxury market demand
- eBay, Fashionphile, The RealReal, Rebag

**Hong Kong:**
- Tax-free luxury shopping hub
- High demand from mainland Chinese buyers
- Regional arbitrage opportunities

---

## PRICE SOURCES

### Japan Sources

**Retail (New):**
- Louis Vuitton Japan: `https://jp.louisvuitton.com`
- Chanel Japan: `https://www.chanel.com/jp/`
- Hermès Japan: `https://www.hermes.com/jp/`
- Dior Japan: `https://www.dior.com/ja_jp`

**Pre-Owned (Used):**
- Komehyo: `https://komehyo.jp/` (Major chain, accurate pricing)
- Brand Off: `https://www.brandoff.jp/`
- Reclo: `https://reclo.jp/`
- Mercari Japan: `https://jp.mercari.com/`
- Yahoo Auctions Japan: `https://auctions.yahoo.co.jp/`

**Department Stores:**
- Mitsukoshi: `https://www.mitsukoshi.mistore.jp/`
- Takashimaya: `https://www.takashimaya.co.jp/`

### USA Sources (Already Integrated)

- eBay sold prices (API: `/api/ebay-sold`)
- Fashionphile, The RealReal, Rebag
- Marketplace API (API: `/api/marketplace/real`)

### Hong Kong Sources (To Add)

- Vestiaire Collective HK
- Carousell Hong Kong
- Price.com.hk luxury section

---

## ARBITRAGE CALCULATION FORMULA

### Cost Breakdown (Japan → USA)

```
Purchase Price (Japan JPY):        ¥350,000
- Tax Refund (8-10%):              - ¥35,000
= Net Purchase Price:              ¥315,000

Convert to USD (¥145/USD):         $2,172

Additional Costs:
+ Shipping (Japan → USA):          + $50
+ Import Duty (0-5% luxury):       + $110
+ Payment Processing (3%):         + $65
+ Inspection/Authentication:       + $50
= Total Cost Basis:                $2,447

Sell Price (USA):                  $4,200
- Selling Fees (15% avg):          - $630
= Net Revenue:                     $3,570

PROFIT:                            $1,123 (46% margin)
```

### Key Variables

1. **Exchange Rates:**
   - JPY/USD: Live rates (varies 140-155)
   - HKD/USD: Fixed peg ~7.8

2. **Costs:**
   - Shipping: $30-100 depending on size/speed
   - Duties: 0-20% (luxury goods often exempt)
   - Platform fees: 10-20% (eBay, Fashionphile, etc.)
   - Authentication: $20-100

3. **Tax Considerations:**
   - Japan tax refund: 8-10%
   - Hong Kong: 0% (duty-free)
   - USA state sales tax: Varies by state

---

## DATABASE SCHEMA

### New Table: `arbitrage_opportunities`

```sql
CREATE TABLE arbitrage_opportunities (
  id INTEGER PRIMARY KEY AUTOINCREMENT,

  -- Product Info
  brand TEXT NOT NULL,
  model TEXT NOT NULL,
  condition TEXT CHECK(condition IN ('new', 'excellent', 'good', 'fair')),

  -- Japan Source
  japan_price_jpy REAL NOT NULL,
  japan_source TEXT, -- 'komehyo', 'brand_off', 'mercari', 'retail'
  japan_url TEXT,
  japan_tax_refund_pct REAL DEFAULT 10.0,

  -- USA Comparison
  usa_price_usd REAL,
  usa_source TEXT, -- 'ebay', 'fashionphile', 'therealreal', 'rebag'
  usa_url TEXT,

  -- HK Comparison
  hk_price_hkd REAL,
  hk_source TEXT,
  hk_url TEXT,

  -- Calculations
  exchange_rate_jpy_usd REAL NOT NULL,
  total_cost_usd REAL NOT NULL, -- After all fees/shipping
  potential_profit_usd REAL,
  profit_margin_pct REAL,

  -- Metadata
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  is_active BOOLEAN DEFAULT 1,

  -- Verification
  verified BOOLEAN DEFAULT 0,
  verified_at DATETIME,

  INDEX idx_profit (profit_margin_pct DESC),
  INDEX idx_brand (brand),
  INDEX idx_created (created_at DESC)
);
```

---

## API ENDPOINTS

### 1. Calculate Arbitrage
```
POST /api/arbitrage/calculate
Body: {
  "brand": "Louis Vuitton",
  "model": "Neverfull MM",
  "japanPriceJPY": 350000,
  "usaPriceUSD": 4200,
  "condition": "excellent"
}

Response: {
  "profitable": true,
  "netProfit": 1123.50,
  "profitMargin": 46.0,
  "costBreakdown": {
    "purchaseJPY": 350000,
    "taxRefundJPY": 35000,
    "netPurchaseJPY": 315000,
    "purchaseUSD": 2172,
    "shipping": 50,
    "duties": 110,
    "fees": 65,
    "authentication": 50,
    "totalCost": 2447
  },
  "revenueBreakdown": {
    "sellPrice": 4200,
    "platformFees": 630,
    "netRevenue": 3570
  },
  "recommendation": "BUY - 46% margin"
}
```

### 2. Get Top Opportunities
```
GET /api/arbitrage/opportunities?minMargin=30&limit=20

Response: {
  "opportunities": [
    {
      "brand": "Hermès",
      "model": "Birkin 25",
      "japanPrice": "¥1,200,000",
      "usaPrice": "$18,500",
      "profit": "$4,250",
      "margin": "48%",
      "source": "Komehyo"
    }
  ]
}
```

### 3. Live Exchange Rates
```
GET /api/arbitrage/rates

Response: {
  "JPYUSD": 0.0069,
  "HKDUSD": 0.128,
  "lastUpdated": "2025-11-17T16:30:00Z"
}
```

### 4. Market Comparison
```
GET /api/arbitrage/compare?brand=Chanel&model=Classic%20Flap

Response: {
  "brand": "Chanel",
  "model": "Classic Flap Medium",
  "prices": {
    "japan": {
      "retail": "¥1,034,000 ($7,131)",
      "preowned": "¥680,000 ($4,690)",
      "source": "Komehyo"
    },
    "usa": {
      "retail": "$10,200",
      "preowned": "$8,500",
      "source": "Fashionphile"
    },
    "hongkong": {
      "retail": "HKD 64,500 ($8,270)",
      "preowned": "HKD 52,000 ($6,667)",
      "source": "Carousell"
    }
  },
  "bestArbitrage": {
    "route": "Japan → USA",
    "profit": "$2,810",
    "margin": "45%"
  }
}
```

---

## DASHBOARD FEATURES

### Arbitrage Opportunity Board

**Filters:**
- Minimum profit margin (%)
- Minimum profit amount ($)
- Brand selection
- Condition (new/used)
- Source market (Japan/HK)
- Target market (USA/HK)

**Display Columns:**
1. Image thumbnail
2. Brand + Model
3. Japan Price (¥ + $)
4. Target Market Price
5. Estimated Profit
6. Profit Margin %
7. Source link
8. "Calculate Details" button

### Arbitrage Calculator Widget

**Inputs:**
- Japan price (¥)
- USA price ($)
- Condition dropdown
- Shipping method (economy/express)
- Include authentication? (checkbox)

**Live Calculation:**
- Total cost in USD
- Expected revenue
- Net profit
- ROI %
- Break-even price

### Market Trends

**Charts:**
1. **Exchange Rate Trend:** JPY/USD last 30 days
2. **Best Arbitrage Brands:** Bar chart of avg margin by brand
3. **Opportunity Timeline:** Deals over time
4. **Geographic Heatmap:** Where profits are highest

---

## DATA SOURCES & SCRAPING

### Japan Price Scraping Strategy

**Komehyo (Primary Source - Most Reliable):**
```python
# Example: Scrape Komehyo luxury handbags
URL: https://komehyo.jp/product/search?category=luxury&brand=hermes

Data Points:
- Brand, model
- Price in JPY
- Condition grade (A, AB, B, C)
- Product images
- Inventory status
- Store location
```

**Mercari Japan API:**
```
# Mercari has unofficial APIs that can be used
Endpoint: https://api.mercari.jp/v2/entities:search
Params: keyword=エルメス バーキン (Hermès Birkin in Japanese)
```

### USA Price Data (Already Have)
- eBay Sold API: ✅ Integrated
- Marketplace scraper: ✅ Integrated

### Hong Kong Sources (To Add)
- Vestiaire Collective HK API
- Carousell scraper

---

## PROFIT OPTIMIZATION FEATURES

### 1. Fee Calculator
- Platform-specific fee structures
- Shipping cost estimator by carrier
- Import duty calculator by product category
- Tax implications (state-by-state)

### 2. Seasonality Analysis
- Best months to buy in Japan (sale seasons)
- Best months to sell in USA (holiday demand)
- Exchange rate predictions

### 3. Risk Assessment
- Authentication risk score
- Market liquidity score
- Price volatility index
- Hold time estimate

### 4. Alerts System
- Email/SMS when margin > X%
- Currency rate alerts
- New inventory alerts from Japan

---

## REAL-WORLD EXAMPLES

### Example 1: Louis Vuitton Neverfull MM
```
Japan (Komehyo):        ¥180,000 → $1,241 (after tax refund)
+ Costs:                $200 (shipping, fees, auth)
= Total Cost:           $1,441

USA (Fashionphile):     $2,100
- Selling fees (15%):   -$315
= Net Revenue:          $1,785

PROFIT: $344 (24% margin) ✅ GOOD DEAL
```

### Example 2: Hermès Birkin 30
```
Japan (Brand Off):      ¥1,500,000 → $10,345
+ Costs:                $500
= Total Cost:           $10,845

USA (eBay Sold Avg):    $18,500
- Selling fees (13%):   -$2,405
= Net Revenue:          $16,095

PROFIT: $5,250 (48% margin) 🚀 EXCELLENT DEAL
```

### Example 3: Chanel Classic Flap (Not Profitable)
```
Japan (Retail):         ¥1,034,000 → $7,131
+ Costs:                $350
= Total Cost:           $7,481

USA (Current Market):   $8,200
- Selling fees (15%):   -$1,230
= Net Revenue:          $6,970

LOSS: -$511 (-7% margin) ❌ SKIP
```

---

## IMPLEMENTATION PHASES

### Phase 1: MVP (Week 1)
- [x] Database schema
- [ ] Basic arbitrage calculator API
- [ ] Simple dashboard with manual input
- [ ] Exchange rate integration
- [ ] Cost calculator

### Phase 2: Automation (Week 2)
- [ ] Komehyo price scraper
- [ ] Automatic opportunity detection
- [ ] Email alerts for high-margin deals
- [ ] Historical tracking

### Phase 3: Advanced (Week 3)
- [ ] Hong Kong market integration
- [ ] ML price prediction
- [ ] Risk scoring
- [ ] Mobile app
- [ ] Bulk analysis tools

---

## LEGAL & COMPLIANCE

**Important Considerations:**

1. **Import Regulations:**
   - US Customs declaration required
   - Duties vary by product classification
   - Some brands prohibit resale

2. **Authentication:**
   - Always authenticate before listing
   - Use Entrupy, Authenticate First, etc.
   - Cost: $20-100 per item

3. **Tax Obligations:**
   - Report import costs accurately
   - Sales tax collection (USA state laws)
   - Income tax on profits

4. **Brand Policies:**
   - Some brands (Hermès) restrict resale
   - Warranty may not transfer
   - Gray market considerations

---

## SUCCESS METRICS

**Target KPIs:**
- Average profit margin: >30%
- Monthly deals identified: 50+
- Conversion rate: 20% (opportunities → actual purchases)
- Average profit per deal: $800+
- ROI: >40%

---

## COMPETITIVE ADVANTAGES

1. **Real-time Data:** Live pricing from multiple sources
2. **Automated Calculations:** Instant profit analysis
3. **Historical Trends:** Learn from past deals
4. **Multi-Market:** Japan + HK sources (most competitors only do USA)
5. **AI Insights:** Predict best buying/selling times

---

**Status:** Ready to implement
**Next Steps:** Build Phase 1 MVP with arbitrage calculator and basic dashboard