Agricultural Seed Company Website
Custom WordPress theme for a seed company with interactive SVG maps, crop yield analytics powered by PostgreSQL, and a multi-taxonomy product catalogue covering regional agricultural data.
About this project
Project Overview
A fully custom WordPress theme built for an agricultural seed company. The site combines a rich product catalogue with a data-driven yield tracking system that lets farmers explore crop performance across regions and years through interactive SVG maps and dynamic data tables.
Key Features
- Crop yield analytics with historical data filtering by region, year, and category from an external PostgreSQL database
- Interactive SVG maps with clickable regions and coordinate-based geographic lookups
- 6 custom post types — products, technologies, catalogues, videos, promos, and blog posts
- Multi-level product taxonomy with groups, kinds, subkinds, and promo tags
- AJAX-powered dynamic data loading for yield tables and map markers without page reloads
- Automatic highlighting of maximum yields per region and year
- 10+ custom page templates including homepage, yields explorer, and regional contacts
- Gutenberg editor integration with custom block styles
- Scroll animations with AOS library and responsive Bootstrap 5 layout
- Advanced Custom Fields with JSON sync for version-controlled field groups
Architecture
WordPress theme built on a Bootstrap 5 starter with SCSS compiled via Node-sass. The yield system connects to an external PostgreSQL database through PDO, running geospatial queries for region lookups and hierarchical data aggregation. Frontend interactivity handled through jQuery AJAX endpoints registered as WordPress actions.