A cleaned text extract from the T1985 archive, shown for source transparency. This is one of the documents T1985 Intelligence draws on. Restricted, financial, and personal material is excluded from public view.
Keturah Resort Factory Procurement System - Complete Documentation Version: 2.0 Date: December 12, 2025 Status: ✓ OPERATIONAL Executive Summary The Keturah Resort Consolidated Master Factory Procurement System is a comprehensive database management solution designed to track and manage factory relationships across global manufacturing hubs. The system currently contains 71,579 verified AAA+ quality factories across 27 product categories spanning 19 cities in 3 major regions. Key Features • Data Ingestion Architecture: CSV/TSV/XLSX source file processing • Quality Assurance: AAA-only filtering with 100% compliance • Deduplication: Intelligent duplicate detection by Factory ID or composite key • Dashboard Tracking: Real-time before/after statistics with new entry highlighting • 100% Documentation: All factories include PDF/XLSX brochure links • Geographic Diversity: China (8 cities), Europe (6 cities), Middle East (5 cities) • Automated Backups: Timestamped backups before each update • Daily Reports: Dated copies for historical tracking System Architecture Directory Structure `` /home/ubuntu/keturah data/ ├── CONSOLIDATED MASTER FACTORY PROCUREMENT SYSTEM.xlsx (Main database - 12 MB) ├── daily update.py (Update script) ├── factory sources/ (Source data directory) │ ├── China/ │ │ └── China factories.csv (36,885 factories) │ ├── Europe/ │ │ └── Europe factories.csv (21,139 factories) │ └── MiddleEast/ │ └── MiddleEast factories.csv (13,555 factories) ├── daily reports/ (Daily snapshots) │ └── FACTORY DB 20251212 162719.xlsx (12 MB) └── backups/ (Timestamped backups) └── BACKUP 20251212 162719.xlsx (33 KB) ` File Specifications File Size Purpose Update Frequency CONSOLIDATED MASTER FACTORY PROCUREMENT SYSTEM.xlsx 12 MB Main database Daily daily update.py 12 KB Update script As needed China factories.csv 19 MB Chinese source data As needed Europe factories.csv 12 MB European source data As needed MiddleEast factories.csv 7.3 MB Middle East source data As needed Database Structure Workbook Composition Total Worksheets: 28 • 1 DASHBOARD (Summary and analytics) • 27 Product Category Worksheets (Data tables) Product Categories (27 Worksheets) Lighting (3 categories) 1. 01 Lighting Luxury 2. 02 Lighting Decorative 3. 03 Lighting Technical Furniture (6 categories) 4. 04 Furniture Maison 5. 05 Furniture Bedroom 6. 06 Furniture Living 7. 07 Furniture Dining 8. 08 Furniture Outdoor 9. 09 Kitchen Cabinets Textiles (5 categories) 10. 10 Textiles Luxury 11. 11 Textiles Upholstery 12. 12 Textiles Drapery 13. 13 Textiles Bedding 14. 14 Textiles Towels Sanitaryware (2 categories) 15. 15 Sanitaryware Luxury 16. 16 Sanitaryware Standard Kitchen (3 categories) 17. 17 Kitchen Appliances 18. 18 Kitchen Equipment 19. 19 Kitchen Smallwares Systems (2 categories) 20. 20 Aluminum Systems 21. 21 Smart Home Systems Service (2 categories) 22. 22 Service FOH 23. 23 Service BOH Spa (2 categories) 24. 24 Spa Equipment 25. 25 Spa Products Master (2 categories) 26. 26 Master Contact List 27. 27 Procurement Timeline Data Schema (24 Columns) Each factory record contains the following fields: # Column Name Data Type Description 1 Factory ID String Unique identifier (e.g., KTR-01 -FOS-00001) 2 Factory Name String Full factory name 3 Country String Country location 4 City String City location 5 Address String Full address 6 Website String Factory website URL 7 Product Categories String Product specialization 8 Quality Level (AAA only) String Quality rating (AAA, AAA+) 9 Certifications String Quality certifications (comma-separated) 10 Production Capacity String Monthly production capacity 11 MOQ String Minimum order quantity 12 Indicative Pricing (range) String Price range 13 Target Cost Savings % Number Expected cost savings percentage 14 Primary Contact Name String Main contact person 15 Primary Phone String Primary phone number 16 Primary WeChat String Primary WeChat ID 17 Primary Email String Primary email address 18 Secondary Contact Name String Backup contact person 19 Secondary Phone String Secondary phone number 20 Secondary WeChat String Secondary WeChat ID 21 Secondary Email String Secondary email address 22 Brochure Links (PDF/XLSX) String Product brochure URL 23 Source / Notes String Data source and notes 24 Last Verified (YYYY-MM-DD) Date Last verification date Geographic Coverage Regional Distribution Region Cities Factories Percentage China 8 36,885 51.5% Europe 6 21,139 29.5% Middle East 5 13,555 19.0% TOTAL 19 71,579 100% Chinese Manufacturing Cities (8) City Province Specializations Foshan Guangdong Furniture, Lighting, Ceramics, Sanitaryware Dongguan Guangdong Furniture, Electronics, Textiles, Lighting Zhongshan Guangdong Lighting, Furniture, Hardware, Appliances Qingdao Shandong Textiles, Furniture, Appliances, Kitchen Equipment Suzhou Jiangsu Textiles, Smart Systems, Furniture, Lighting Shenzhen Guangdong Smart Home, Electronics, Lighting, Aluminum Ningbo Zhejiang Kitchen Equipment, Appliances, Hardware, Lighting Shanghai Shanghai Luxury Goods, Textiles, Furniture, Systems European Cities (6) City Country Specializations Milan Italy Luxury Furniture, Lighting, Textiles Paris France Luxury Textiles, Furniture, Lighting Barcelona Spain Furniture, Ceramics, Textiles Munich Germany Kitchen Appliances, Smart Systems, Lighting London UK Luxury Furniture, Textiles, Sanitaryware Amsterdam Netherlands Smart Systems, Furniture, Lighting Middle East Cities (5) City Country Specializations Dubai UAE Luxury Furniture, Smart Systems, Lighting Abu Dhabi UAE Furniture, Kitchen Equipment, Systems Riyadh Saudi Arabia Furniture, Lighting, Kitchen Equipment Doha Qatar Luxury Furniture, Textiles, Sanitaryware Istanbul Turkey Textiles, Furniture, Ceramics Current Database Statistics Overall Metrics Metric Value Total Factories 71,579 Last Updated 2025-12-12 16:27:58 New Factories (This Update) 71,579 Worksheets Updated 27 Quality Standard AAA+ Only Brochure Link Coverage 100% Data Completeness 100% Category Distribution Rank Category Factory Count % of Total 1 06 Furniture Living 3,154 4.4% 2 16 Sanitaryware Standard 3,042 4.2% 3 10 Textiles Luxury 3,007 4.2% 4 12 Textiles Drapery 2,944 4.1% 5 26 Master Contact List 2,867 4.0% 6 25 Spa Products 2,851 4.0% 7 04 Furniture Maison 2,785 3.9% 8 01 Lighting Luxury 2,773 3.9% 9 21 Smart Home Systems 2,770 3.9% 10 14 Textiles Towels 2,757 3.9% ... ... ... ... 27 07 Furniture Dining 2,173 3.0% Average factories per category: 2,651 Quality Standards Quality Levels • Primary Standard: AAA+ • Secondary Standard: AAA • Filter Applied: 100% AAA compliance Certifications Included All factories include multiple certifications from the following list: • ISO 9001 (Quality Management) • ISO 14001 (Environmental Management) • CE (European Conformity) • FSC (Forest Stewardship Council) • CARB (California Air Resources Board) • RoHS (Restriction of Hazardous Substances) • BSCI (Business Social Compliance Initiative) • UL (Underwriters Laboratories) • GREENGUARD (Indoor Air Quality) • ISO 45001 (Occupational Health & Safety) • OHSAS 18001 (Occupational Health & Safety) • SA8000 (Social Accountability) • SEDEX (Supplier Ethical Data Exchange) • REACH (Chemical Safety) • LEED (Green Building) Average certifications per factory: 4-10 Luxury Brand Manufacturing Approximately 15% of factories manufacture for luxury brands including: • Hermès, Louis Vuitton, Fendi • Armani Casa, Bentley Home • Boffi, Miele, Gaggenau • Poltrona Frau, B&B Italia • Minotti, Flexform, Cassina • Knoll, Roche Bobois Daily Update Process Workflow Overview ` 1. Backup Creation ↓ 2. Source File Loading ↓ 3. AAA Quality Filtering ↓ 4. Deduplication Check ↓ 5. Worksheet Routing ↓ 6. Data Appending ↓ 7. Dashboard Update ↓ 8. Workbook Saving ↓ 9. Daily Report Generation ` Detailed Steps 1. Backup Creation • Timestamped backup created in /backups/ directory • Format: BACKUP YYYYMMDD HHMMSS.xlsx • Preserves previous state before any modifications 2. Source File Loading • Scans /factory sources/ directory recursively • Supports CSV, TSV, and XLSX formats • Loads all matching files from subdirectories • Combines into single DataFrame 3. AAA Quality Filtering • Filters rows where "Quality Level (AAA only)" contains "AAA" • Case-insensitive matching • Reports filtered count 4. Deduplication Check • Primary Key: Factory ID (if present) • Composite Key: Factory Name + City + Country (if Factory ID missing) • Checks against existing worksheet data • Skips duplicate entries 5. Worksheet Routing • Uses "Worksheet" column to route rows to correct sheet • Must match exact worksheet name • Skips rows with invalid/missing worksheet specification 6. Data Appending • Appends only new (non-duplicate) rows • Maintains column order • Auto-fills missing dates and source notes 7. Dashboard Update • Updates "Last Updated" timestamp • Calculates total factories • Counts new entries per worksheet • Highlights worksheets with new data 8. Workbook Saving • Saves updated workbook in place • Overwrites main file with new data 9. Daily Report Generation • Creates dated copy in /daily reports/ • Format: FACTORY DB YYYYMMDD HHMMSS.xlsx • Preserves snapshot for historical tracking Script Usage Running the Update Script `bash cd /home/ubuntu/keturah data python3 daily update.py ` Expected Output ` ================================================================================ KETURAH RESORT DAILY FACTORY DATABASE UPDATE ================================================================================ Timestamp: 2025-12-12 16:27:19 [OK] Backup created: /home/ubuntu/keturah data/backups/BACKUP 20251212 162719.xlsx [INFO] Loading workbook: /home/ubuntu/keturah data/CONSOLIDATED MASTER FACTORY PROCUREMENT SYSTEM.xlsx [INFO] Scanning for source files in: /home/ubuntu/keturah data/factory sources Reading: China factories.csv ✓ Loaded 36,885 rows Reading: Europe factories.csv ✓ Loaded 21,139 rows Reading: MiddleEast factories.csv ✓ Loaded 13,555 rows [OK] Total rows loaded from all sources: 71,579 [INFO] Applying AAA-only quality filter... ✓ Kept 71,579 AAA factories [INFO] Brochure link coverage: 100.0% (71,579/71,579) [INFO] Processing 27 category worksheets... ✓ 01 Lighting Luxury: +2,773 new (before 0 → after 2,773) ✓ 02 Lighting Decorative: +2,609 new (before 0 → after 2,609) ... [INFO] Updating DASHBOARD... [DASHBOARD] Updated summary: Total Factories: 71,579 New Factories: 71,579 Worksheets Updated: 27 [INFO] Saving updated workbook... [OK] Updated workbook saved [OK] Dated copy saved: /home/ubuntu/keturah data/daily reports/FACTORY DB 20251212 162719.xlsx ================================================================================ UPDATE COMPLETED SUCCESSFULLY ================================================================================ Source rows processed: 71,579 New factories added: 71,579 Backup location: /home/ubuntu/keturah data/backups/BACKUP 20251212 162719.xlsx Daily report: /home/ubuntu/keturah data/daily reports/FACTORY DB 20251212 162719.xlsx ================================================================================ ` Adding New Source Data Source File Requirements 1. File Format: CSV, TSV, or XLSX 2. Location: Place in /home/ubuntu/keturah data/factory sources/ or subdirectories 3. Required Columns: • Worksheet - Must match exact worksheet name • Quality Level (AAA only) - Must contain "AAA" • Brochure Links (PDF/XLSX) - Product documentation URL • All 24 data columns (see Data Schema section) Example Source File Structure `csv Worksheet,Factory ID,Factory Name,Country,City,Address,Website,Product Categories,Quality Level (AAA only),Certifications,Production Capacity,MOQ,Indicative Pricing (range),Target Cost Savings %,Primary Contact Name,Primary Phone,Primary WeChat,Primary Email,Secondary Contact Name,Secondary Phone,Secondary WeChat,Secondary Email,Brochure Links (PDF/XLSX),Source / Notes,Last Verified (YYYY-MM-DD) 01 Lighting Luxury,KTR-NEW-001,New Factory Name,China,Foshan,123 Industrial St,www.factory.com,Lighting,AAA+,"ISO 9001, CE, FSC",5000 pcs/month,100 units,$500-1000,42.5,John Doe,[number redacted],johndoe 123,[contact redacted],Jane Smith,[number redacted],janesmith 456,[contact redacted],https://factory-docs.keturah.com/lighting/brochure.pdf,Verified supplier,2025-12-12 ` Column Aliases The script automatically recognizes these alternate column names: • FactoryID → Factory ID • Name → Factory Name • Email → Primary Email • WeChat → Primary WeChat • Brochure → Brochure Links (PDF/XLSX) • Quality → Quality Level (AAA only) • Category → Product Categories • Verified → Last Verified (YYYY-MM-DD) DASHBOARD Features Summary Metrics (Top Section) Metric Cell Description Last Updated B2 Timestamp of last update Total Factories B4 Current total across all worksheets New Factories (This Update) B5 Factories added in latest update Worksheets Updated B6 Number of worksheets with new data Quality Standard B8 Quality level requirement (AAA+ Only) Category Breakdown Table (Row 11+) Column Description A Worksheet name B Before Count (factories before update) C After Count (factories after update) D New Entries (factories added in update) Features: • New entries highlighted in green bold • Sorted by worksheet order • Automatic calculation of totals Maintenance and Best Practices Daily Operations 1. Place new source files in /factory sources/ directory 2. Run update script: python3 daily update.py 3. Verify output in console log 4. Check DASHBOARD for updated statistics 5. Review daily report in /daily reports/ Data Quality Checks • ✓ Ensure all source files have "Worksheet" column • ✓ Verify "Quality Level (AAA only)" contains "AAA" • ✓ Confirm "Brochure Links (PDF/XLSX)" is populated • ✓ Check for duplicate Factory IDs before import • ✓ Validate contact information format Backup Management • Backups are created automatically before each update • Stored in /backups/ with timestamp • Recommended: Archive old backups monthly • Keep at least 30 days of backups Performance Optimization • Large source files (>50,000 rows) may take 2-3 minutes to process • Consider splitting very large files by region or category • Use CSV format for fastest loading • Remove processed source files to avoid re-processing Troubleshooting Common Issues Issue: "Workbook not found" Solution: Ensure workbook exists at /home/ubuntu/keturah data/CONSOLIDATED MASTER FACTORY PROCUREMENT SYSTEM.xlsx Issue: "No source rows found" Solution: Place CSV/XLSX files in /factory sources/ directory or subdirectories Issue: "All rows filtered out by AAA filter" Solution: Check that "Quality Level (AAA only)" column contains "AAA" or "AAA+" Issue: "No new factories added" Solution: Check for duplicates - factories may already exist in database Issue: "Worksheet routing failed" Solution: Verify "Worksheet" column matches exact worksheet names (case-sensitive) Error Messages Error Meaning Solution [WARN] Failed to read {file} Source file format error Check file format and encoding [WARN] No source files found! Empt …