MP Insurance Value Module

Module Summary

MP Casco Value Management System is a comprehensive data management solution that enables casco value lists published in Turkey to be transferred to WordPress-based websites securely, quickly, traceably, and scalably. The system is not only an Excel upload tool; it combines data validation, versioned dataset management, uninterrupted publishing, REST-based querying, reporting, comparison, maintenance, and health checks in a single modular ecosystem.

The solution processes XLSX data in controlled chunks with PhpSpreadsheet 5.2, stores it versioned in custom WordPress tables, and does not change the active publication before the new data set is validated. This ensures that even if an error occurs during an update, the live casco query used by visitors is not interrupted.

Core product promise

“The active data is not changed before the new XLSX is completely read and validated.” This approach transforms data updates from a risky file replacement process into an enterprise publishing workflow.

Capability	System Approach	Value Provided
Secure Data Import	XLSX signature, header, period, row, and value validation	Prevents faulty files from affecting the live system
Versioned Dataset	Active, ready, archived, and failed states	Provides uninterrupted publishing and fast rollback
Fast Frontend	REST API, indexed queries, and cache	Produces instant results without printing all JSON to the page
Enterprise Reporting	CSV, XLSX, and PDF export	Makes operation, audit, and management reports easier
System Health	Automatic maintenance, logs, and control score	Increases long-term sustainability

A New Standard in Digital Casco Value Management

Casco value lists include a large number of vehicles, model years, and price cells. Loading this data only as a JSON file into a web page may seem easy at first, but as the data grows, it creates serious problems in terms of PHP memory, page weight, browser performance, update security, and maintenance cost.

MP Casco Value Management System turns this process into a traceable data pipeline from the data source to the end-user query. The XLSX file is accepted into the system, the content is validated, the new dataset is created in isolation, counters are compared with real database records, and only a successful result is published as “active.”

Transition from a file-centered approach to a data platform: Instead of depending on a single JSON file, a queryable, indexable, and versionable table infrastructure is used.
Transition from manual risks to controlled operations: Each upload, validation, publishing, reporting, and maintenance process is a separate management step.
Transition from heavy page load to on-demand data: Only the necessary year, brand, model, and value information is retrieved according to the visitor’s selection.
Transition from uncertain updates to reversible publishing: Previous datasets are kept in the archive and can be reactivated when needed.

Core Problems Solved by the Product

Capability	System Approach	Value Provided
Loading all data as JSON	Reading tens of thousands of vehicle records on every page load	Retrieves only the required data with REST and SQL
Risk of deleting the table before update	Live data may be lost if the import is interrupted	The new dataset is uploaded separately; if successful, it is activated
Excel header errors	Year keys may be read empty or incorrectly	The header structure and year columns are strictly validated
Unnecessary storage of zero values	Hundreds of thousands of meaningless cells increase data volume	Only real values greater than zero are stored
Loss of history	Change analysis with the previous period cannot be performed	Offers dataset comparison and archiving
Lack of operational visibility	It is unclear who did what, when, and which action was performed	Keeps operation history and technical context logs

Real data scale

The system significantly reduces database volume by not storing zero-value cells.

Value Proposition of the MP Casco Value System

Uninterrupted service: The active casco query continues to work while new data is being prepared.
High data integrity: File, worksheet, period, header, code, year, and price rules are automatically checked.
Easy management: Upload, publish, archive, compare, report, and maintain from a single admin panel.
Fast visitor experience: The frontend retrieves only the information selected by the user via REST, not the entire dataset.
Enterprise traceability: Operation history, data hash information, uploading user, and publishing dates are recorded.
Expandable modular structure: Admin, setup, theme, and template layers integrate independently into the existing loader architecture.

Modular Technical Architecture

MP Casco Modular and Secure Architecture

The system uses a service-based architecture that separates responsibilities from each other. Database schema, installer, repository, dataset manager, XLSX validator, import service, REST controller, cache, analytics, report exporter, maintenance, and health check are separate classes.

Versioned Dataset Management and Uninterrupted Publishing

Each XLSX file is treated as an independent dataset. The dataset is created in processing status; it is validated during the validating phase; when ready, it is moved to ready status and made active with admin approval. The previous active dataset is automatically moved to archived status.

processing: The file has been accepted and import has started.
validating: Data counters and validation rules are being checked.
ready: The dataset has been validated but has not yet been published live.
active: The live data version used in frontend queries.
archived: The previous period; stored for comparison and rollback.
failed: Import or validation failed; it does not affect the live system.

Admin Panel and Operations Center

MP Casco Value works as an independent main menu in the WordPress admin panel. It removes technical operations from developer dependency and turns them into clear management screens.

Capability	System Approach	Value Provided
Overview	Active period, vehicle, value, brand, year range, and average	Allows the manager to see the system at a glance
XLSX / Dataset	File upload, progress, publishing, archive, and deletion	Centralizes monthly data operations
Casco Records	Dataset, year, brand, code, and text filters	Makes individual record control easier
Dataset Comparison	New, removed, changed, and identical records	Makes changes between periods visible
Reports	CSV, XLSX, and PDF generation	Provides shareable and auditable outputs
Operation History	Operation, user, status, and technical context	Provides enterprise traceability
Maintenance / Health	Cleanup preview, health score, and critical checks	Increases the long-term reliability of the system

CSV, XLSX, and PDF Reporting

The system exports record lists and dataset comparisons in three formats suitable for different usage purposes.

Capability	System Approach	Value Provided
CSV	UTF-8 BOM, Turkish Excel-compatible separator, streaming output	Low memory consumption in very large datasets
XLSX	Filter, summary, table, numeric format, and two-page comparison	Editable report for management and detailed analysis
PDF	Landscape A4, summary cards, detail table, and page number	Fixed output for presentation, archive, and corporate sharing

For readability and memory safety in PDF outputs, the first 1,500 detail rows are shown; if more results are available, a clear warning appears on the report. CSV or XLSX is preferred for all details.

Preserving filters: The dataset, year, brand, search, and change type selected on the admin screen are transferred to the report.
Security: Every report passes nonce and permission checks.
Formula injection protection: CSV text fields are made secure against Excel formula risks.
Temporary file cleanup: Temporary files generated during XLSX and PDF production are removed at the end of the process.

Use Cases and Target Audiences

Insurance agencies and consulting websites

Suitable for structures that want to offer visitors current casco value queries, manage monthly list updates securely, and report periodic changes.

Automotive and used vehicle platforms

Provides a centralized data service for platforms that want to integrate vehicle code, model year, and casco value data into pricing, content, or consulting screens.

Enterprise WordPress projects

Offers a strong starting point for developers and agencies that want to combine enterprise needs such as custom tables, REST API, capability, cron, reports, and health checks in a single module.

Internal operations teams

Provides an admin panel that can perform Excel upload, publishing, rollback, record search, comparison, and report generation without requiring technical knowledge.

Showora Product Showcase HTML Şablon

Go to Product