# NZ Database Cleanup Summary
**Date:** 2026-02-12 22:40 CST
**Rows Verified:** 86-114 (29 contact rows, 10 companies)

---

## ❌ DELETE THESE ROWS (6 rows, 2 companies)

### Alpine Packhouse (Rows 86-88)
- **Website:** clydeorchards.co.nz
- **Issue:** Wrong produce type - they grow STONEFRUIT (cherries, peaches, nectarines), NOT kiwifruit/apples
- **Reason:** Out of scope - no CA storage for stonefruit
- **Action:** DELETE rows 86-88

### Chevalier Wholesale (Rows 94-96)
- **Website:** chevalierproduce.co.nz
- **Issue:** Distributor/wholesaler, NOT a cold storage facility
- **Reason:** Distribution center for restaurants/foodservice, not 10+ CA room facility
- **Action:** DELETE rows 94-96

---

## ⬆️ UPGRADED (4 companies, 12 rows)

### EastPack Ltd (Rows 97-99)
- **Old Score:** 90 → **New Score:** 100 (XXLarge)
- **Why:** NZ's largest kiwifruit post-harvest provider, 6 packing sites, robotic coolstore
- **CA Storage:** YES (confirmed)

### First Fresh NZ (Rows 100-102)
- **Old Score:** 70 → **New Score:** 80 (Large)
- **Why:** NZ's largest citrus supplier to domestic market, leading exporter
- **CA Storage:** Likely

### Freshmax NZ (Rows 103-105)
- **Old Score:** 80 → **New Score:** 85 (XLarge)
- **Why:** Purpose-built cold storage, 365-day operation, major retailer supplier
- **CA Storage:** YES (confirmed)

### Seeka Limited (Rows 112-114)
- **Old Score:** 75 → **New Score:** 80 (Large)
- **Why:** Major packhouse/coolstore facilities for kiwifruit + avocado
- **CA Storage:** Likely

---

## ✅ VERIFIED & KEPT (3 companies, 8 rows)

### Balle Bros (Rows 89-91) - Score: 75
- Leading NZ integrated agricultural business
- Potatoes/Onions/Vegetables with export network

### Bayley Produce (Rows 92-93) - Score: 65
- 300+ hectares, Hawke's Bay
- Apples/Summerfruit/Vegetables
- ⚠️ **TODO:** Verify 10+ rooms (may need further verification)

### LeaderBrand (Rows 106-108) - Score: 60-75
- One of NZ's most progressive horticultural businesses
- Mixed operations: Salad greens (no CA) + Potatoes/Onions (CA likely)

---

## ⚠️ NEEDS VERIFICATION (1 company, 3 rows)

### Primor Produce (Rows 109-111) - Score: 65
- **Concern:** May be marketer/distributor only, not grower/packer
- Has storage facility at Bowden Rd, Mt Wellington
- **Action:** Verify if they own/operate 10+ CA rooms or just distribute

---

## Files Created

1. **Verification Report:** `nz-86-114-verification.md` (detailed findings)
2. **Cleaned CSV Export:** `nz-cleaned-2026-02-12.csv` (full NZ sheet with updates)
3. **This Summary:** `NZ-CLEANUP-SUMMARY.md`

---

## Next Actions

1. ✅ **Done:** Updated Google Sheet with corrections (produce, CA storage, scores, notes)
2. **TODO:** Delete rows 86-88 (Alpine Packhouse) from Google Sheet
3. **TODO:** Delete rows 94-96 (Chevalier Wholesale) from Google Sheet
4. **TODO:** Verify Bayley Produce room count
5. **TODO:** Verify Primor Produce grower/packer status

---

## Final Count After Deletions

- **Before:** 10 companies, 29 contact rows
- **After removals:** 8 companies, 23 contact rows
- **Confirmed high-value:** EastPack (100), Freshmax (85), First Fresh (80), Seeka (80)
- **Pending verification:** Bayley Produce, Primor Produce

---

## Database Impact

**Total NZ facilities before cleanup:** 93 companies
**Removals:** 2 companies (Alpine Packhouse, Chevalier Wholesale)
**Total NZ facilities after cleanup:** 91 companies
**Contact rows updated:** 29 rows (produce, CA storage, scores, notes)
**Score upgrades:** 12 contact rows across 4 companies