Product Specifications
Manage detailed product specification data with rich feature tracking, flexible import options, and semantic search integration.
editor manager superadmin
Overview
The Product Specifications database stores structured product data with detailed attributes, variant tracking, and 15 boolean feature flags. It supports full-text search, VectorDB semantic search, and multi-format import/export.
Data Schema
Core Fields
| Field | Type | Required | Description |
|---|---|---|---|
brand | Text | Required | Manufacturer or brand name (e.g., "Honda", "Toyota") |
model | Text | Required | Model name (e.g., "Civic", "Corolla") |
variant | Text | Optional | Specific variant or trim level |
year | Integer | Optional | Model year |
Vehicle / Technical Fields
| Field | Type | Description |
|---|---|---|
body_type | Text | Body style (SUV, Sedan, Hatchback, MPV, etc.) |
engine_type | Text | Engine type (Petrol, Diesel, Hybrid, Electric) |
engine_cc | Text | Engine displacement (e.g., "1500cc") |
horsepower | Text | Power output (e.g., "150 HP") |
transmission | Text | Transmission type (AT, MT, CVT, DCT) |
drive_system | Text | Drive system (FWD, RWD, AWD, 4WD) |
fuel_type | Text | Fuel type |
seating_capacity | Text | Number of seats |
Boolean Feature Flags (15)
Each feature is stored as a boolean (true/false) and displayed as a badge in the table.
| Feature Flag | Description |
|---|---|
has_cooling_seat | Ventilated / cooled seats |
has_sunroof | Sunroof or panoramic roof |
has_360_camera | 360-degree surround view camera |
has_wireless_charge | Wireless phone charging pad |
has_cruise_control | Cruise control system |
has_collision_warn | Forward collision warning |
has_lane_assist | Lane departure warning / lane keep assist |
has_auto_parking | Automatic parking assist |
has_apple_carplay | Apple CarPlay support |
has_android_auto | Android Auto support |
has_keyless_entry | Keyless entry / smart key |
has_push_start | Push button start |
has_rear_camera | Rear-view backup camera |
has_electric_seat | Electrically adjustable seats |
has_heated_seat | Heated seats |
Notes
A spec_notes free-text field for any additional information that doesn't fit the structured fields.
Browse & Search
Table View
The table displays key columns: Brand/Model, Variant, Year, Body/Engine, Transmission, and Feature badges (green Yes / gray No icons for each boolean feature).
Search & Filters
- Search — Full-text search across brand, model, variant, transmission, engine_type, drive_system, body_type, and spec_notes
- Brand filter — Dropdown populated from distinct brands in the database
- Body Type filter — Dropdown populated from distinct body types
- Pagination — Navigate through large datasets
Add / Edit / Delete
Adding a Spec
- Click "+ Add" above the table.
- A modal appears with two tabs: Form and JSON.
- Use the Form tab for guided input with labeled fields, dropdowns, and checkboxes for feature flags.
- Or use the JSON tab to paste a complete JSON object directly.
- Click Save. The data is validated before saving.
Editing a Spec
Click Edit on any row. The form is pre-filled with current values. Both Form and JSON tabs are available.
Deleting a Spec
Click Delete on any row. Confirmation required. The record is permanently removed.
Import & Export
Product Specs support three import formats — the most flexible of all data types:
| Format | Extension | Notes |
|---|---|---|
| JSON | .json | Array of spec objects |
| CSV | .csv | Header row required, comma-separated |
| Excel | .xlsx, .xls | First sheet used, header row required |
Product Specs is the only data type that supports Excel import. This is useful for teams who maintain spec sheets in spreadsheets.
VectorDB Sync
Like the Pricing Database, product specs can be synced to ChromaDB for semantic search. This allows the AI to answer natural-language questions about product specifications.
- Click "Sync VectorDB" at the top of the Product Specs page.
- Each spec record is converted to a text representation and embedded.
- Specs become discoverable via semantic queries like "which cars have 360 camera and lane assist?".
Truncate
The "Truncate" button deletes ALL product spec records permanently. Export your data first if you need a backup. This cannot be undone.