⚠ Project Status: PRE-BUILD READY — ACTIVE BLOCKERS
All reference documents current (R1–R6). All code files current. Build sequence locked.
10 open blockers — Items 11 & 12 resolved (Favorites + Community Dashboard = Phase 1). B4 formally blocked. B6 conditional on data cleaning completion.
Recommended start: resolve Phase 0 data blockers, then begin at B1.
83+
Active Project Files
6
R-Series Docs — All Current
12
Open Blockers
8
Build Phases (1 Blocked)
📌 Key Project Facts
| Site | DiscoverCuenca.com |
| Platform | WordPress + GeoDirectory + Elementor Pro |
| Hosting | Hostinger |
| Database | Airtable — 28 active tables — always source of truth |
| Automation | Make.com — 16 scenarios — sole write authority AT↔WP |
| Languages | English (primary) + Spanish via WPML |
| Forms | 9 Gravity Forms — zero WooCommerce dependency |
| Maps | OpenStreetMap + Leaflet.js — Google Maps permanently excluded |
| SEO | RankMath — Yoast permanently excluded |
| CDN | Bunny.net (static assets only) |
| Dataset | 3,676 records — DC_Bus_Listings_clean_feb_2026.csv |
| Sections | 8 content sections (Businesses, Food & Drink, Things To Do, Nightlife, Cuenca's Got Talent, Classifieds, Bulletin, Events) |
| Build approach | Option B — AI-generated code, owner-executed. No external developer. |
🛡 Build Sequence Status
B1WordPress Core SetupNot Started
B2GeoDirectory ConfigNot Started
B3CPTs & TaxonomyNot Started
B7WPML BilingualNot Started
B5Make.com ScenariosNot Started
B6Airtable ImportConditional
B4WooCommerceBlocked
B8Pre-Launch & DeployNot Started
⚠ Top 5 Priority Actions
| # | Action | Type | Unblocks |
|---|---|---|---|
| 1 | Run borough geocoding script (Google Colab) — 369 records | Owner Action | B6 import |
| 2 | Manually assign ~23 non-standard borough records | Owner Action | B6 import |
| 3 | Confirm 24 CLOSED_PERMANENTLY exclusions | Owner Decision | B6 import |
| 4 | Confirm Verified + Featured Premium subscription prices | Owner Decision | B4 (WooCommerce) |
| 5 | Create WhatsApp Channel — provide Channel ID | Owner Action | A3 social + email templates |
R-Series — Core Specification Documents
| ID | Document | Version | Status | Notes |
|---|---|---|---|---|
| R1 | DC_MasterBuildSpec_v3_8.pdf | v3.8 | Current | 19pp. Section 5.10 dual listing. 16 scenarios. Sole build authority. |
| R2 | DC_TaxonomyReference_v3_3.pdf | v3.3 | Current | 5pp. Official taxonomy authority. All CPTs, categories, boroughs. |
| R3 | DC_AirtableArchitecture_v3_4.pdf | v3.4 | Current | 15pp. 28 active tables. import_destination + linked_gd_listing_id added. |
| R4 | DC_DataGovernance_v2_3.pdf | v2.3 | Current | 5pp. Source of truth rules. QA framework. primary_industry prohibition. |
| R5 | DC_Wireframes_v6_4.pdf | v6.4 | Current | 19pp. 16 templates. T14 Zone 8 dual listing panel added. |
| R6 | DC_SiteMap_v2_2.pdf | v2.2 | Current | 5pp. All URLs and navigation structure. |
| B-Series — Build Phase Guides | ||||
| B1 | WordPress Core Setup Guide | v1.0 | Current | First build phase. Staging first. |
| B2 | DC_GeoDirectoryConfig_v1_3.pdf | v1.3 | Current | CPT setup, categories, OpenStreetMap. |
| B3 | Custom Post Types & Taxonomies Guide | v1.1 | Current | Taxonomy verification and role testing. |
| B4 | DC_WooCommerceSetup_v1_1.pdf | v1.1 | Blocked | Blocked — tier prices TBD. Do not create subscription products until confirmed. |
| B5 | DC_MakecomFlows_v1_3.pdf | v1.3 | Current | 16 scenarios. Build in sequence. Test each on staging. |
| B6 | DC_AirtableSetupGuide_v1_2.pdf | v1.2 | Conditional | Requires borough geocoding + data cleaning protocol complete. |
| B7 | WPML Bilingual Setup Guide | v1.1 | Current | Execute before B5 and B6. |
| B8 | DC_PreLaunchChecklist_v1_1.pdf | v1.1 | Current | Final gate before production deployment. |
| S-Series — Reference & Instruction Documents | ||||
| S1 | DC_GravityForms_v1_3.pdf | v1.3 | Current | 9 forms, field-by-field build instructions. |
| S2 | DC_GeoDirectoryConfig_v1_3.pdf | v1.3 | Current | GeoDirectory reference guide. |
| S3 | DC_AirtableSetupGuide_v1_2.pdf | v1.2 | Current | 28-table Airtable setup instructions. |
| S4 | DC_WPEnvironmentSetup_v1_3.pdf | v1.3 | Current | WordPress + Hostinger environment configuration. |
| S5 | DC_MakecomFlows_v1_3.pdf | v1.3 | Current | Make.com scenario reference. |
| S6 | DC_DataImportSpec_v1_4.pdf | v1.4 | Current | Dual listing workflow + Verification Check 6 added Apr 3. |
| S7 | DC_ElementorTemplates_v1_3.pdf | v1.3 | Rebuilt Apr 4 | 23pp. Full rebuild. All 16 templates with complete build instructions. |
| S8 | DC_ListingCounter_v1_1.pdf | v1.1 | Current | [dc_listing_counter] shortcode. 180s cache. Zone 2 Hero only. |
| S9 | DC_RSVPComponent_v1_1.pdf | v1.1 | Current | [dc_rsvp] shortcode. A3 WhatsApp prompt included. |
| S10 | DC_EmailContent_v1_2.pdf | v1.2 | Current | 12pp. Full body copy all 7 templates + admin notification. |
| S11 | DC_DeveloperHandoff_v1_1.pdf | v1.1 | Current | 77-file package handoff reference. |
| S12 | DC_CustomRoles_v1_1.pdf | v1.1 | Current | 3 custom roles. PHP reference. Capability matrix. |
| S13 | DC_WooCommerceSetup_v1_1.pdf | v1.1 | Blocked | Also B4. Blocked — tier prices TBD. |
| S14 | DC_StagingToProduction_v1_1.pdf | v1.1 | Current | Production migration guide. Execute after B8 checklist passes. |
| S15 | DC_ExecutiveSummary_v1_2.pdf | v1.2 | Current | Full substance restored Mar 27. |
| S16 | DC_MarketingStrategy_v1_2.pdf | v1.2 | Current | Full substance restored Mar 27. |
| S17 | DC_PreBuild_Readiness_Report_v2_Apr2026.pdf | v2 | Updated Apr 4 | Updated to MBS v3.8. 12 blockers. Data prep gate added. |
| S18 | DC_PreLaunchChecklist_v1_1.pdf | v1.1 | Current | Also B8. Final validation checklist. |
| S19 | DC_DesignCritiqueGrowth_v1_2.pdf | v1.2 | Current | Full substance restored Mar 27. |
| S20 | DC_PrimeDirective_v1_1.pdf | v1.1 | Current | 11 directives. Preamble in carry-over Section 1. |
| S21 | DC_PresentationStandards_v1_0.pdf | v1.0 | Current | 9 standards governing all visual deliverables. |
| S22 | DC_DataCleaningProtocol_v1_0.pdf | v1.0 | New Apr 4 | 7pp. 5-phase pre-import protocol. Must complete before B6. |
| S23 | DC_DataCleaningHistory_v1_0.pdf | v1.0 | New Apr 4 | 8pp. Project data work history. 10 issues. 9 protocols. |
| Addenda — Permanently Locked | ||||
| A1 | Homepage Corrections Addendum | v1.0 | Locked | 7-card Browse By Category. Analytics global. External blog links. |
| A2 | Monetization Corrections Addendum | v1.0 | Locked | $5/$10 boost products. Health Score 14 criteria. |
| A3 | Social Integration Addendum | v1.0 | Locked | WhatsApp share. Floating sidebar. Talent social fields. Email footer. |
| Supplemental — UD-Series | ||||
| U9 | DC_SessionCarryOver_Apr10_2026_v1_U9.pdf | U9 v1 | Current | CURRENT. Directive 12 added. Apr 10 session captured. Supersedes U8. |
| Code Files | ||||
| — | discovercuenca-custom.php | v1.1.0 | Current | 773 lines. CPTs, roles, shortcodes, RSVP, 13-tab admin. |
| — | dc_import.py | v1.2 | Current | Handles dual listing. Verification Check 6. Idempotent. |
| — | dc_rsvp_component.js | v1.1.0 | Current | RSVP + WhatsApp share prompt (A3). |
| New Documents — Apr 4 2026 | ||||
| — | DC_PreBuild_Readiness_Report_v2_Apr2026.pdf | v2 | New | Updated S17. MBS v3.8 references. 12 blockers. Data gate. |
| — | DC_ProjectPlan_v1_0.pdf | v1.0 | New | Lean Six Sigma DMAIC + MS Project WBS. Full project control doc. |
| — | AI_WorkingDirectives_Generic_v1_0.pdf | v1.0 | New Apr 10 | Generic AI directives extracted from Prime Directive v1.2. Applicable to all future projects. |
| — | DiscoverCuenca_ProjectHub.html | v1.0 | New | This file. HTML intranet. Host on Hostinger staging subdomain. |
Instructions Check off tasks as you complete them. Progress is saved in your browser. Update Status badges manually as phases complete.
Phase 0 — Pre-Build Blockers Resolution
B1 — WordPress Core Setup
B2 — GeoDirectory Configuration
B3 / B7 / B5 / B6 / B4 / B8 — Remaining Phases
10 Open Blockers — Items 11 & 12 resolved Apr 10 2026. As of Apr 10 2026Items 1–7 must be resolved before B4 or B6 can begin. Items 8–12 can be resolved in parallel with build phases.
🛑 Blockers — Owner Action Required
1. Verified Subscription Price ($/month)
Owner confirms price. Do not create DC-SUB-VERIFIED product until confirmed.
BLOCKS: B4 WooCommerce
2. Featured Premium Price ($/month)
Owner confirms price. Do not create DC-SUB-FEATURED until confirmed.
BLOCKS: B4 WooCommerce
3. Ecuador IVA Rate (%)
Verify current rate. 15% was provisional as of Mar 2026. Confirm before WooCommerce tax activation.
BLOCKS: B4 tax configuration
4. Borough Geocoding — 369 Records
Run the geocoding script in Google Colab (free, no install). Script exists — ready to run. Provide output CSV with borough populated for all recoverable records. See DC_DataCleaningProtocol_v1_0.pdf Phase 3 Step 1.
BLOCKS: B6 import
5. Non-Standard Borough Mapping — ~23 Records
Review filtered list. Assign closest official borough to each of ~23 records (e.g. Urdesa, Cochapamba). See DC_DataCleaningProtocol_v1_0.pdf Phase 3 Step 2.
BLOCKS: B6 import
6. CLOSED_PERMANENTLY Exclusion List
Confirm all 24 CLOSED_PERMANENTLY records are excluded from import. Alternatively confirm any that should be imported with a closed status. Default: exclude all 24.
BLOCKS: B6 import
7. talent_category for ~40 Dual-Listed Records
Each dual-listed record (import_destination = both) must have a talent_category value from the locked 6 categories: Musicians | Performers | Craftsmen | Artists | Instructors | Makers. dc_import.py v1.2 requires this field.
BLOCKS: B6 import
8. WhatsApp Channel ID
Create WhatsApp Channel. Provide Channel ID. Sets dc_whatsapp_channel WP option. Also replace DC_CHANNEL_ID in EMAIL_Footer_Standard.html before activating email templates.
BLOCKS: A3 social integration, email templates
9. dc_rsvp_webhook_url
Set WP option after Scenario 10 (RSVP) is built in Make.com and the webhook URL is known.
BLOCKS: Scenario 10 activation
10. dc_counter_secret
Generate a random string during B6. Same value must be set in WP option AND in Make.com Scenario 11 Module 3.
BLOCKS: Listing Counter security
11. Favorites / Saved Listings — RESOLVED Apr 10 2026
Decision: Phase 1. Architecture finalization unblocked.
RESOLVED
12. Community Member Dashboard — RESOLVED Apr 10 2026
Decision: Phase 1. Architecture finalization unblocked.
RESOLVED
⚠️ Risk Register — 10 Identified Risks
| Risk | Prob | Impact | Priority | Status | Mitigation |
|---|---|---|---|---|---|
| Content stripping in S-series documents | H | H | CRITICAL | Active | S7, S10, S15, S16, S19 confirmed and rebuilt. Upload each doc before executing that phase. |
| Session memory reset — project state lost | H | H | CRITICAL | Mitigated | Carry-over U7 v2 self-contained. conversation_search covers Mar 3 forward. |
| 248-record talent misclassification recurrence | L | H | HIGH | Mitigated | DC_DataCleaningProtocol_v1_0.pdf Phase 1 mandatory profiling. dc_import.py enforces multi-field validation. |
| Borough geocoding failure — 369 records | M | H | HIGH | Open | Nominatim script ready. Owner must run in Google Colab. Blocks B6. |
| Dual listing cross-link fails post-import | L | M | MEDIUM | Mitigated | Scenario A3 created. Verification Check 6 confirms cross-links. |
| WooCommerce tier prices never confirmed — revenue inactive at launch | M | M | MEDIUM | Open | Site can launch without B4. Boost products can be added post-launch. |
| Elementor Pro licence expires mid-build | L | M | LOW | Monitor | Confirm renewal date. Elementor Pro required for Theme Builder. |
| Make.com scenario errors in production | M | H | HIGH | Mitigated | All scenarios tested on staging. wordpress_sync table logs every event. |
| Google photo URLs expire — images broken post-launch | H | M | HIGH | Accepted | photo_status = google_source flagged. Owners replace via dashboard. Known limitation. |
| February 2026 session decisions not captured | M | M | MEDIUM | Partial | Carry-over captures outcomes. conversation_search covers March onward. February not recoverable. |
🔄 Project Change Log — Significant Decisions
Apr 10 2026
Items 11 & 12 resolved — Phase 1 confirmedFavorites/Saved Listings and Community Member Dashboard both confirmed Phase 1. Architecture finalization unblocked. Open blockers reduced from 12 to 10.
Apr 10 2026
Domain architecture clarified — .org internal / .com productiondiscovercuenca.org = internal/intranet domain. stagingintranet.discovercuenca.org = current WordPress staging. hub.discovercuenca.org = Project Hub (this file). discovercuenca.com = public production + future staging.discovercuenca.com when build begins.
Apr 10 2026
S15 v1.6, U3 v1.3, U9, AI_WorkingDirectives_Generic_v1_0 producedTu Página rename complete. De Aquí repositioned to Section 3. Audience table reordered (De Aquí community first). Directive 12 (Full Change Accounting) added. Generic AI directives document produced. Registry v3.11.
Apr 4 2026
HTML Project Hub, Project Plan, Readiness Report v2 producedThree new documents added. DC_ProjectPlan_v1_0.pdf (Lean Six Sigma DMAIC + WBS). DC_PreBuild_Readiness_Report_v2_Apr2026.pdf (updated to MBS v3.8). HTML intranet (this file). Registry updated to v3.9.
Apr 4 2026
DC_DataCleaningProtocol_v1_0.pdf + DC_DataCleaningHistory_v1_0.pdf producedS22 and S23 added. 5-phase pre-import gate established. Data cleaning session prompt created. Registry v3.9.
Apr 4 2026
DC_ElementorTemplates_v1_3.pdf — full rebuild (S7)v1.2 was content-stripped to 2 pages. v1.3 is 23pp with complete zone-by-zone build instructions for all 16 templates. Authority corrected to MBS v3.8 + Wireframes v6.4.
Apr 3 2026
Dual listing strategy formally resolvedConfirmed gap — present in early sessions, absent from all documents. Fully resolved: MBS v3.8 Section 5.10, Airtable Arch v3.4, Data Import Spec v1.4, dc_import.py v1.2, Wireframes v6.4 T14 Zone 8, Scenario A3.
Apr 3 2026
DC_EmailContent_v1_2.pdf rebuiltv1.1 was stripped to subject lines only. v1.2 restores full body copy for all 7 templates + admin notification. 9 standalone email files produced.
Mar 27 2026
S15, S16, S19 rebuilt — content stripping correctedExecutive Summary, Marketing Strategy, Design Critique & Growth all stripped to outlines in v1.1. Full substance restored in v1.2.
Mar 27 2026
DC_PrimeDirective_v1_1.pdf — Directive 11 addedDirective 11 established: every document version must be fully self-contained. No version splitting ever. Carry-over document updated to include preamble prompt directly (no second file needed).
Mar 26 2026
Featured boost model lockedTier-based featured model permanently revoked. Replaced with $5 flat fee / 30 days and $10 flat fee / 60 days one-time WooCommerce products. Source: Addendum A2.
Mar 2026
Map provider: Google Maps → OpenStreetMap + Leaflet.jsGoogle Maps permanently excluded from all templates. OpenStreetMap is the only permitted map provider. Maps appear on single listing detail pages only — never on archive or homepage.
Mar 2026
SEO plugin: Yoast → RankMathYoast SEO permanently excluded. RankMath is the only permitted SEO plugin. Yoast reintroduced in early sessions from conversation history — corrected and locked in all documents from MBS v3.7+.
Mar 2026
Nightlife category: "Dancing Adventures" → "Dancing"Permanently locked. "Dancing Adventures" is always wrong. Exactly 2 Nightlife categories: Dancing + Dinner Adventures. No additions ever.
Mar 2026
Browse By Category: 3-tile → 7-card 4+3 grid3-tile model permanently revoked. 7 hardcoded Elementor tiles in 4+3 grid. Source: Addendum A1. "Browse by Category" is the ONLY acceptable label.
🔒 Locked Taxonomy — Source: Taxonomy Reference v3.3Nothing may be added, removed, or renamed without explicit owner instruction and a Taxonomy Reference version update. primary_industry NEVER drives CPT or category assignment.
Businesses (gd_place)
4 Top-Level Categories
| Category | Subcategories |
|---|---|
| Retail & Shopping | Malls | Mercados | Furniture & Home Goods | Supermarket | Hardware & Specialty Stores |
| Services | Computers & Tech | Co-Working | Legal & Visas | Education & Training | Home Repair | Cleaning | Personal Care | Transportation |
| Health & Wellness | Spas | Gyms | Wellness Centers | Dance Studios | Mind Body Studios |
| Community Interests | Faith | Charities | Community Centers | Support Groups | Where to Serve | Non Profits |
Food & Drink (food_drink_listing)
6 Categories — ALWAYS "Bars" never "Bars & Pubs"
| Restaurants |
| Bakeries |
| Cafes |
| Coffee Shops |
| Bars |
| Dance Clubs |
Nightlife (nightlife_listing)
EXACTLY 2 — PERMANENTLY LOCKED — NO ADDITIONS EVER"Dancing" | "Dinner Adventures"
ALWAYS "Dancing" — NEVER "Dancing Adventures"
ALWAYS "Dancing" — NEVER "Dancing Adventures"
Cuenca's Got Talent (talent_profile)
6 Categories — Full name "Cuenca's Got Talent" always
| Musicians |
| Performers |
| Craftsmen |
| Artists |
| Instructors |
| Makers |
Classifieds (classified_ad)
5 Categories
| For Sale |
| Housing |
| In Search Of |
| Wanna Barter |
| Community Posts |
Cuenca Bulletin (bulletin_article)
4 Categories — People Spotlight = ADMIN ONLY
| Community News |
| Hidden Gems |
| People Spotlight (admin only — not in Form 5) |
| Blog |
15 Official Boroughs — URL: /neighborhoods/{slug}/ (American spelling always)
Bellavista
Canaribamba
El Batan
El Sagrario
El Vecino
Canaribamba
El Batan
El Sagrario
El Vecino
Gil Ramirez Davalos
Huayna Capac
Machangara
Monay
San Blas
Huayna Capac
Machangara
Monay
San Blas
San Sebastian
Sucre
Totoracocha
Yanuncay
Hermano Miguel
Sucre
Totoracocha
Yanuncay
Hermano Miguel
Important: Always unaccented. Canaribamba not Cañaribamba. "Parroquia" = WPML Spanish translation only. "Neighbourhood" = free-text sub-borough field, not a taxonomy term.
⚙️ WordPress Options — Complete Reference
| WP Option Key | Value / Type | Set When | Current Status |
|---|---|---|---|
| dc_featured_carousel_cap | 12 (integer) | B1 setup | Default on plugin activation |
| dc_new_additions_cap | 16 (integer) | B1 setup | Default on plugin activation |
| dc_listing_counter_data | JSON string | Auto — Scenario 11 every 3 min | Written by Make.com — do not edit manually |
| dc_rsvp_webhook_url | Make.com webhook URL | After Scenario 10 built | TBD — set after Scenario 10 URL is known |
| dc_counter_secret | Random string | During B6 | TBD — generate during B6. Same in WP + Scenario 11. |
| dc_whatsapp_channel | WhatsApp Channel ID | Owner provides | TBD — owner creates channel first |
| dc_ga4_measurement_id | G-XXXXXXXXXX | B1 setup | TBD — owner provides GA4 measurement ID |