auto-save: 2026-06-22T11:05:33 (1 files) — KOROSEAL_COST_AUDIT_REPORT.md

cd8f0a5e246f19d58b5f35b1613eb67bdb36960e · 2026-06-22 11:05:35 -0700 · Steve Abrams
Files touched

A KOROSEAL_COST_AUDIT_REPORT.md
Diff

commit cd8f0a5e246f19d58b5f35b1613eb67bdb36960e
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Mon Jun 22 11:05:35 2026 -0700

    auto-save: 2026-06-22T11:05:33 (1 files) — KOROSEAL_COST_AUDIT_REPORT.md
---
 KOROSEAL_COST_AUDIT_REPORT.md | 98 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 98 insertions(+)

diff --git a/KOROSEAL_COST_AUDIT_REPORT.md b/KOROSEAL_COST_AUDIT_REPORT.md
new file mode 100644
index 0000000..e65f6e8
--- /dev/null
+++ b/KOROSEAL_COST_AUDIT_REPORT.md
@@ -0,0 +1,98 @@
+# 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.
← 1b96fb4 auto-save: 2026-06-22T09:35:00 (3 files) — .phase2-state.jso · back to Dw Five Field Step0 · auto-save: 2026-06-23T00:18:39 (1 files) — out/bulk-fivefiel 0e6b826 →