Colossal TV

ColossalTV is a media and entertainment website combining editorial content and digital commerce through a hybrid WordPress and OpenCart architecture.

The platform supports content publishing, brand storytelling, and merchandise sales, while maintaining performance, scalability, and SEO best practices.

• Integrating content and commerce across two platforms
• Maintaining performance on media-heavy pages
• Ensuring consistent SEO across CMS and store sections

• E-commerce Platform Selection: Selected standard catalog data structures over custom database schemas to leverage proven order and shopping cart state designs. The trade-off was managing catalog data synchronization complexities, which was preferred over building custom transaction logic.
• Database Catalog Indexing: Used relational database-level indexing for simple catalog lookups. Accepted the trade-off of higher memory usage on database nodes to avoid the operational complexity of integrating an external search engine.

• WordPress-based content publishing and editorial workflows
• OpenCart integration for merchandise and digital products
• SEO-optimized media and product pages
• Performance tuning for image- and video-heavy content

• Deadlock Mitigation: Discovered that database queries during concurrent updates must execute in sequential order using transaction blocks to prevent locking issues.
• Schema Drift Control: Established strict migrations scripts checks to verify database schema consistency across staging and production environments.