# Instructions to Update Google Sheet with NZ Research Data ## 📋 Summary **17 companies researched** → **9 fully qualified** with websites + contact info **Files created:** 1. `nz_companies_update.csv` - Ready to import to Google Sheets 2. `NZ-17-COMPANIES-RESEARCH.md` - Detailed findings 3. `NZ-RESEARCH-SUMMARY.md` - Executive summary 4. `update_nz_sheet.py` - Python script with data structure --- ## 🎯 QUICK UPDATE (Recommended) ### Method 1: CSV Import 1. **Open Google Sheet** - Sheet ID: `1uVd-xZFF4TEQGqtvw9z6W8fffeaifPCoLsek83GmEoQ` - Tab: "New Zealand" - Account: jonny@jonnyshannon.com 2. **Import CSV** - File → Import → Upload - Select `nz_companies_update.csv` - Choose "Append to current sheet" or "Replace data starting at selected cell" - Import location: Row after current data 3. **Verify columns match:** - Company Name - Website - Country (all "NZ") - State/Region - Primary Fruit - CA Storage Confirmed - Qualified - Employee Count - Revenue - Notes - Contact Name - Contact Title - Contact Email - Contact Phone - Source --- ## 📊 DATA SUMMARY ### ✅ COMPANIES WITH WEBSITES (9) - Qualified = Yes | Company | Website | Region | Fruit | Key Contact | |---------|---------|--------|-------|-------------| | Freshco - Wake's Packhouse | freshco.co.nz | Hawke's Bay | Apples, Cherries | Glenn Pool (CEO) | | Kea Apple Packhouse | integrow.co.nz | Hawke's Bay | Apples | Richard Burns | | Port Pack & Cool Storage | portpack.co.nz | Bay of Plenty | Cold storage | - | | Green Planet Limited | greenplanetapples.wixsite.com | Hawke's Bay | Apples | - | | Kelston Orchard Packhouse | kelstonpack.com | Hawke's Bay | Apples, Summerfruit | Tony Harington | | T&G Global (Jazz Apple) | tandg.global | Hawke's Bay | Apples | - | | Moffett Orchards | lovebite.co.nz | Hawke's Bay | Apples | Jonathan Moffett | | Panmure Orchards | panmureorchards.co.nz | Central Otago | Cherries, Nectarines | Jeremy | | Coxco Farming Ltd | coxco.co.nz | Gisborne | **Squash** (not fruit!) | - | ### ⚠️ COMPANIES TO REMOVE/FLAG (5) 1. **NZ Cold Storage Association** - NOT a facility (industry association) 2. **Earnscleugh Orchards** - NOT a facility (geographic region with multiple orchards) 3. **Prime Produce** - Cannot verify (no results found) 4. **Dennys Orchard** - Cannot verify (only restaurant chain found) 5. **Kathy Forrest Orchard** - Sold/status unknown ### 📍 VERIFIED BUT NO WEBSITE (3) 1. **Maleme Coldstorage** - Tauranga, property for sale 2025 2. **Golden Oak Orchard** - Hastings, small local orchard 3. **Motueka Cold Storage Ltd** - Acquired by Lineage Logistics 2022 --- ## 🔍 DETAILED CONTACT INFO ### High-Priority Prospects (for PHT sales) **1. T&G Global (Jazz Apple)** - Website: tandg.global - Location: 22 Whakatu Road, Whakatu, Hawke's Bay - Scale: 125M kg capacity, largest in Southern Hemisphere - CA Storage: YES (likely) - Notes: State-of-art automated facility 2023 - **WHY PRIORITY:** Massive scale, premium brands (Jazz, Envy), technology-focused **2. Freshco - Wake's Packhouse** - Website: freshco.co.nz - CEO: Glenn Pool - CFO: Simoli Patel - Phone: +64 6 878 8520 - Email: enquiries@freshco.co.nz - Location: 76 Rangitane Road, Hastings / 1061 Riverslea Rd (packhouse) - **WHY PRIORITY:** Major operator, multiple facilities, exec contacts identified **3. Kelston Orchard Packhouse** - Website: kelstonpack.com - Owner: Tony Harington - Phone: +64 6 879 4301 - Email: info@kelstonpack.com - Location: 49 Ormond Road, Twyford, Hastings - Notes: New facility 2022, 10 orchards, export-focused - **WHY PRIORITY:** Recently invested in new tech, quality-focused, owner accessible **4. Kea Apple Packhouse** - Website: integrow.co.nz - Contact: Richard Burns - Phone: +64 6 824 3333 - Email: [email protected] - Location: 2 Joll Road, Havelock North - Capacity: 450K cartons - Notes: Brand new Feb 2022, partnership with Integrow - **WHY PRIORITY:** New facility, open to innovation, growing **5. Moffett Orchards** - Website: lovebite.co.nz - Director: Jonathan Wallace Moffett - Phone: +64 6 879 7985 - Email: joe@moffetts.co.nz - Location: 1723 Korokipo Road, Napier - Brand: Lovebite (premium positioning) - **WHY PRIORITY:** Large family operation, premium brand = quality focus --- ## 📝 RECOMMENDED ACTIONS ### Immediate (for sheet accuracy) 1. ✅ Import the 9 qualified companies with full data 2. ❌ Remove or flag the 5 problematic entries 3. ⚠️ Add notes to 3 verified-but-limited entries 4. 🔄 Mark Motueka as "Acquired by Lineage 2022" 5. 📝 Note Coxco is vegetables (squash), not fruit ### For PHT Sales Team 1. **Target Top 5** listed above (T&G, Freshco, Kelston, Kea, Moffett) 2. **Regional focus:** Hawke's Bay has 7 of 9 qualified facilities 3. **Timing opportunity:** Kelston & Kea both invested in new facilities 2022 4. **Sustainability angle:** T&G automated, Kelston technology focus 5. **Decision-makers identified:** Glenn Pool (Freshco), Tony Harington (Kelston), Richard Burns (Kea) ### Further Research Needed - [ ] Verify CA Storage status for all qualified facilities - [ ] Employee count & revenue for major operators - [ ] Specific cool room counts (follow H1 Packhouse methodology) - [ ] Replace removed companies with new NZ facilities from: - NZ Cold Storage Association member directory - Finda.co.nz cold storage listings - MPI export facility registry --- ## 💾 FILES LOCATION All files in: `/Users/max/.openclaw/workspace/postharvest/` ``` nz_companies_update.csv ← Import this to Google Sheets NZ-17-COMPANIES-RESEARCH.md ← Detailed research notes NZ-RESEARCH-SUMMARY.md ← Executive summary UPDATE-INSTRUCTIONS.md ← This file update_nz_sheet.py ← Python data structure ``` --- ## 🔧 ALTERNATIVE: Manual Entry If CSV import doesn't work, copy data row by row from CSV or use this condensed format: **COPY-PASTE READY FORMAT (Tab-separated):** ``` Company Name Website Country Region Fruit CA Storage Qualified Notes Contact Phone Email Freshco - Wake's Packhouse freshco.co.nz NZ Hawke's Bay Apples, Cherries Yes Major NZ produce company, 76 Rangitane Rd Glenn Pool (CEO) +64 6 878 8520 enquiries@freshco.co.nz Kea Apple Packhouse integrow.co.nz NZ Hawke's Bay Apples Yes New packhouse Feb 2022, 450K cartons, 2 Joll Rd Richard Burns +64 6 824 3333 [email protected] Port Pack & Cool Storage portpack.co.nz NZ Bay of Plenty Cold storage Yes 12 Mark Rd, Mount Maunganui, MPI #4938 Green Planet Limited greenplanetapples.wixsite.com NZ Hawke's Bay Apples Yes 10 Hales Rd, Meeanee, Napier +64 6 833 7004 Kelston Orchard Packhouse kelstonpack.com NZ Hawke's Bay Apples, Summerfruit Yes 49 Ormond Rd, new facility 2022, 10 orchards Tony Harington +64 6 879 4301 info@kelstonpack.com T&G Global (Jazz Apple) tandg.global NZ Hawke's Bay Apples (Jazz, Envy) Yes Yes 22 Whakatu Rd, 125M kg capacity, largest in SH Moffett Orchards lovebite.co.nz NZ Hawke's Bay Apples Yes 1723 Korokipo Rd, Lovebite brand Jonathan Moffett +64 6 879 7985 joe@moffetts.co.nz Panmure Orchards panmureorchards.co.nz NZ Central Otago Cherries, Nectarines Yes 214 Strode Rd, Alexandra, family 1952 Jeremy +64 21 999 307 admin@panmureorchards.co.nz Coxco Farming Ltd coxco.co.nz NZ Gisborne SQUASH (not fruit) Yes 700 hectares, squash for Japan/Korea +64 6 867 4449 ``` --- ## ✅ COMPLETION CHECKLIST - [x] Research all 17 companies - [x] Find websites and contact info - [x] Identify parent companies and relationships - [x] Document facility sizes where available - [x] Create CSV for import - [x] Create detailed research notes - [x] Create executive summary - [ ] **→ UPDATE GOOGLE SHEET** (manual step required) - [ ] Mark problematic entries for review/removal - [ ] Add to PHT CRM/outreach list --- **Research completed:** 2026-02-11 **Ready for sheet update:** YES **Next action:** Import CSV or paste data into Google Sheet