`KOROSEAL_COST_AUDIT_REPORT.md`

99 lines
# Koroseal Cost-Scrape Mission Report

**Date:** 2026-06-22  
**Status:** BLOCKED — Auth-Gated Portal

## What We Found

### SKU Count & Cost Status
- **Total Koroseal SKUs on Shopify:** 2,951 (DWK prefix)
- **With NO COST:** 2,950 ($0 or NULL)
- **With Cost:** 1 ($108.90)
- **Cost Coverage:** 0.03% (1/2951)

### Website Architecture
- **Public Site:** `https://koroseal.com/` — shows product categories and design info, NO pricing
- **Trade Portal:** `https://koroseal.com/login` — exists, requires email + password
- **Accessible Without Auth:** Product galleries, digital catalogs, collections
- **Gated Behind Auth:** Product pricing, specs, wholesale costs, CSV exports

### Browserbase Exploration
- ✅ Session created and navigated to Koroseal.com
- ✅ Located login page at `https://koroseal.com/login`
- ✅ Confirmed "Existing Customer" login form present
- ❌ No guest/public pricing data available
- ❌ CSV export not discoverable on public pages
- ❌ Product detail pages do NOT display prices (likely fetch via API after auth)

## Attempted Paths

| Method | Result | Blocker |
|--------|--------|---------|
| CSV Export | Not found | No login credentials |
| Public API | None discovered | Auth required |
| Product Pages | No pricing visible | Login wall |
| Wayback Machine (not tried) | Unlikely | Historical data outdated |
| Competitor Pricing | Not viable | Can't cross-verify Koroseal costs |

## Options for Steve

### 1. **Provide Koroseal Trade Credentials** (Fastest)
- Email + password for an existing dealer/account
- We can then:
  - Log in via Browserbase
  - Export CSV from admin portal
  - Parse & batch UPDATE shopify_products.cost_price
  - **Est. time: 30 min**
  - **Cost: ~$0.50 Browserbase**

### 2. **Contact Koroseal Directly** (Async)
- Reach out to sales@koroseal.com or account rep
- Request bulk pricing export (CSV/JSON)
- Forward the file to us for import
- **Est. time: 1-3 days (awaiting response)**
- **Cost: $0 (email only)**

### 3. **Reverse-Engineer from Known Product** (Low confidence)
- We have 1 SKU with cost ($108.90 for TAK-AA01-01, Subtle Leaf Taupe Grey)
- Infer markup ratio if we know retail
- Apply ratio across line
- **Risk:** Assumes uniform markup; likely inaccurate

### 4. **Skip Koroseal For Now** (Defer)
- Leave all 2,950 SKUs in "HELD" status (unpublished)
- Tag with "Needs-Cost"
- Return to this after other vendors are complete
- **Impact:** Koroseal unavailable on storefront until priced

### 5. **Reach Out to Your Koroseal Rep** (Recommended)
- If you have an existing relationship/account, ask them for a pricing sheet export
- Fastest path if they respond quickly

## Recommendation

**Path 1 + Path 5 in parallel:**
- You ask your Koroseal rep for a pricing export (takes 0 work from you)
- If they have it ready → we import it
- If they need time → we wait 1-3 days
- We can meanwhile work on other vendors (backlog list: Brewster, BN Walls, Art Wallcoverings, etc.)

**If you want us to proceed immediately:**
- Provide Koroseal trade credentials (email + password)
- We'll use Browserbase to log in and export today

## Database State

All 2,950 unpriced SKUs are currently `ACTIVE` on Shopify. Per DW standing rules:
- **Cannot ship unpriced** — violates 5-field rule (pricing required)
- Should either (a) hold/draft until cost available, or (b) request hold from fulfillment

**Query to check which are live:**
```sql
SELECT COUNT(*) FROM shopify_products 
WHERE vendor_prefix='DWK' AND (cost_price IS NULL OR cost_price=0) AND status='ACTIVE';
```

---

**Next Step:** Awaiting your direction on whether to obtain credentials or contact Koroseal.