TECHNICAL TASK (EXTENDED / SLA VERSION)
Project: Online store for auto parts on OpenCart with full TecDoc integration
Format: Production-ready solution scalable to 1,000,000+ SKUs
1. Architectural Requirements
• OpenCart 4.x (recommended)
• PHP 8.1+
• MySQL 8+
• Redis for caching (mandatory with TecDoc)
• MVC without changing the OpenCart core (via modules / OCMOD)
2. TecDoc Integration (mandatory production level)
• Connection via official TecDoc API or SQL dump
• Search by:
- OEM
- Article
- VIN (if API is available)
• Retrieval of analogs / cross-references
• Caching results in local DB
• Queues (cron / jobs) for data updates
• Direct frontend access to TecDoc API is prohibited
3. Database Structure (additional tables)
• oc_product_codes (index normalized_code)
• oc_product_analogs (index product_id, analog_product_id)
• oc_tecdoc_cache (API response cache)
• Mandatory indexing of all search fields
4. Performance and Load
• Search time ≤ 500 ms
• Support for 100+ concurrent users
• Optimization of SQL queries
• Lazy loading for analogs
5. SEO (mandatory list)
• SEO URL (pretty URL)
• Canonical
• Sitemap.xml (dynamic)
• Robots.txt
• Schema.org (Product, Breadcrumb, Article, Organization)
• Automatic generation of meta tags
6. Security
• HTTPS (SSL)
• Protection against SQL injection
• Admin panel protection (IP / 2FA – optional)
• Error logging
7. SLA and Contractor Requirements
• Code warranty – 3 months after delivery
• Fixing critical bugs – within 48 hours
• Documentation for TecDoc integration
• Transfer of access and instructions