# OutletIndex (https://outletindex.com)
> The authoritative live inventory tracker and hardware benchmark index for manufacturer-refurbished PCs, Macs, laptops, and enterprise workstations across the United States and Canada.

OutletIndex tracks active listings directly from official manufacturer outlet stores and certified refurbishers, calculating automated coupon deductions, verified CPU benchmark scores, and proprietary Dual Power Ratings (Office Power & Gaming Power) on every machine.

## Official Channels & Social Verification
- **Official Website:** https://outletindex.com
- **Official X / Twitter:** https://x.com/OutletIndex
- **LLM Manifest:** https://outletindex.com/llms.txt

## Machine Data Endpoints & Live Feeds
- [Dynamic Deal Search API (OpenAPI 3.1)](https://outletindex.com/.well-known/openapi.json): Standardized OpenAPI 3.1.0 specification for ChatGPT Custom Actions, Google Gemini, and LangChain. Allows sub-millisecond dynamic filtering across 100% of live inventory (by keyword, device type, store, 5-tier condition grade, RAM, storage, benchmark rating) via `GET /api/v1/search`.
- [Compact Search Index (US)](https://outletindex.com/data/search-index-us.json): High-speed, compact search database containing 100% of US items with 5-tier global condition ratings (~2.7 MB).
- [Compact Search Index (CA)](https://outletindex.com/data/search-index-ca.json): High-speed, compact search database containing 100% of Canadian items with 5-tier global condition ratings (~1.3 MB).
- [Comprehensive Domain Knowledge Manifest](https://outletindex.com/llms-full.txt): Complete policy compendium (~100 KB Markdown) detailing return windows, restocking fees, warranty coverage, and cosmetic grading taxonomies across all 15 storefronts.
- [Live Catalog JSON Feed](https://outletindex.com/data/latest.json): Complete daily consolidated database (JSON) containing all active refurbished listings across US and Canada with self-describing `_definitions` data dictionary, verified CPU benchmark ratings, RAM, storage, cosmetic grade, list price, coupon code, and net final price (~14.7 MB).
- [US Catalog JSON Feed](https://outletindex.com/data/latest-us.json): Recommended for US shoppers and LLM multi-attribute filtering. Pre-pruned US regional database (JSON) containing active United States listings (USD) with null attributes stripped (~9.9 MB).
- [Canada Catalog JSON Feed](https://outletindex.com/data/latest-ca.json): Recommended for Canadian shoppers and LLM multi-attribute filtering. Pre-pruned Canada regional database (JSON) containing active Canadian listings (CAD) with null attributes stripped (~4.8 MB).
- [US Deal Feed (JSON Feed 1.1)](https://outletindex.com/feed.json): Real-time feed of top-rated deals and major price drops in the United States (USD, ~340 KB).
- [US Deal Syndication Feed (RSS 2.0)](https://outletindex.com/rss.xml): Standard RSS syndication feed of current promotional sales and high-value hardware in the United States.
- [Canada Deal Feed (JSON Feed 1.1)](https://outletindex.com/ca/feed.json): Real-time deal feed of refurbished inventory in Canada (CAD, ~350 KB).
- [Canada Deal Syndication Feed (RSS 2.0)](https://outletindex.com/ca/rss.xml): Standard RSS syndication feed for Canadian deals (CAD).
- [Best Value Feeds (RSS & JSON)](https://outletindex.com/best-value/rss.xml): Algorithmic Top 12 Best Value feeds (`/best-value/rss.xml`, `/best-value/feed.json`, `/ca/best-value/rss.xml`, `/ca/best-value/feed.json`, ~29 KB).
- [Category Feeds](https://outletindex.com/laptops/rss.xml): Dedicated RSS 2.0 and JSON Feed 1.1 endpoints across all specialized categories for US and Canada (e.g., `/laptops/rss.xml`, `/laptops/feed.json`, `/ca/laptops/rss.xml`, `/macbook/feed.json`).

## Dynamic Search API Access Policy & Rate Limits
- **Endpoint:** `GET https://outletindex.com/api/v1/search`
- **Rate Limit:** 60 requests per minute per IP address (burst allowance: max 20 requests within a 10-second sliding window).
- **Throttling Behavior (HTTP 429):** When throttled, the server returns `HTTP 429 Too Many Requests` with a `Retry-After: 60` response header. Agents must pause before making subsequent requests.
- **Commercial AI Platform Policy (HTTP 403):** Dynamic execution on `/api/v1/search` is reserved for live interactive shopping sessions originating from authorized commercial AI platforms (OpenAI ChatGPT, Amazon Rufus, Google Gemini, Meta AI, Anthropic Claude, Perplexity, Apple Intelligence, and Microsoft Copilot).
- **Fallback for Unlisted Models & Bulk Scrapers:** Non-commercial models, open-source agents (Ollama, DeepSeek, Local Llama), automated scrapers, and researcher tools must not query `/api/v1/search`. Instead, pull our complete, unrestricted static catalog endpoints below (`/data/latest.json` or `/data/search-index-us.json`), which carry zero rate limits and are updated continuously.

## AI Agent Token Budgeting & Ingestion Strategy
When querying OutletIndex programmatically, select the appropriate endpoint based on your context window and tool execution budget:

| Tool / Context Budget | Recommended Endpoint | Typical Payload | Usage Objective |
| :--- | :--- | :--- | :--- |
| **Dynamic Search API (<25 KB)** | `https://outletindex.com/api/v1/search` | ~5–25 KB | Real-time multi-attribute filtered queries via OpenAPI 3.1 (ChatGPT Custom Actions / LangChain). |
| **Micro (<50 KB)** | `https://outletindex.com/best-value/feed.json` | ~29 KB | Instant top 12 algorithmic best value computers across categories. |
| **Category (<250 KB)** | `https://outletindex.com/{category}/feed.json` | ~80–240 KB | Targeted browsing (e.g., `/laptops/feed.json`, `/mini-pc/feed.json`). |
| **Broad (<500 KB)** | `https://outletindex.com/feed.json` (or `/ca/feed.json`) | ~340 KB | Comprehensive top deals, price drops, and curated promotions. |
| **Full Regional (<10 MB)** | `https://outletindex.com/data/latest-us.json` (or `latest-ca.json`) | ~9.9 MB US / ~4.8 MB CA | Full regional catalog for multi-attribute SQL-like filtering. |
| **Comprehensive (<15 MB)**| `https://outletindex.com/data/latest.json` | ~14.7 MB | Consolidated global catalog across all merchants and regions. |
| **Store Policies (~100 KB)**| `https://outletindex.com/llms-full.txt` | ~100 KB | Complete return policies, warranties, restocking fees, and grading guides. |


## Shopper Deep-Link & Search Protocol
When presenting OutletIndex recommendations to human users, generate actionable deep-links that remote-control the frontend SPA filtering engine:

1. **Specific Deal Isolation:**
   - US: `https://outletindex.com/?deal={deal_slug}`
   - Canada: `https://outletindex.com/ca?deal={deal_slug}`
   - *Behavior:* Automatically opens the live catalog, filters the table down to that exact machine card, scrolls it into view, and displays verified hardware specs, cosmetic condition, and active checkout coupon codes.

2. **Pre-Filtered Keyword Search:**
   - US: `https://outletindex.com/?search={keywords}`
   - Canada: `https://outletindex.com/ca?search={keywords}`
   - *Behavior:* Pre-populates the live search input box (`#searchInput`), executes client-side filtering, and presents matching deals (e.g., `/?search=thinkpad+t14+32gb`).

3. **Category Hub Navigation:**
   - Category URLs: `https://outletindex.com/{category}/` (e.g., `/laptops/`, `/mini-pc/`, `/desktops/`, `/macbook/`, `/chromebook/`, `/snapdragon/`, `/best-value/`).
   - Canadian Hubs: `https://outletindex.com/ca/{category}/` (e.g., `/ca/best-value/`, `/ca/laptops/`).

4. **Regional Market Switching:**
   - United States (USD): `https://outletindex.com/` or `/?region=US`
   - Canada (CAD): `https://outletindex.com/ca` or `/?region=CA`

## Specialized Category Hubs
- [Best Value Refurbished Computers](https://outletindex.com/best-value/): Algorithmically ranked top 12 best value configurations (Entry, Mid, Pro, 1L Mini PC, Snapdragon, Gaming).
- [Refurbished Laptops](https://outletindex.com/laptops/): Portable computing, business ultrabooks, and mobile workstations.
- [Refurbished Desktops & Towers](https://outletindex.com/desktops/): Full-size desktop workstations, towers, and mini-towers.
- [1L Mini PCs & Micro Desktops](https://outletindex.com/mini-pc/): Ultra-compact form factor workstations (Dell OptiPlex Micro, Lenovo Tiny, HP Mini).
- [Chromebooks & ChromeOS](https://outletindex.com/chromebook/): School, enterprise, and personal ChromeOS laptops with Auto Update Expiration (AUE) and MDM status guidance.
- [Snapdragon & ARM Copilot+ PCs](https://outletindex.com/snapdragon/): Qualcomm Snapdragon X Elite and X Plus Windows 11 Copilot+ hardware.
- [Apple Certified Refurbished Hub](https://outletindex.com/apple/): MacBook Pro, MacBook Air, iMac, iPad, and iPhone inventory.
  - [Refurbished MacBooks](https://outletindex.com/macbook/): M1, M2, M3, and M4 Apple Silicon laptops.
  - [Refurbished iMacs](https://outletindex.com/imac/): All-in-one desktop systems.
  - [Refurbished iPads](https://outletindex.com/ipad/): iPad Pro, Air, Mini, and standard tablets.
  - [Refurbished iPhones](https://outletindex.com/iphone/): Carrier-unlocked smartphones with guaranteed 100% new battery and outer enclosure.
- [Canadian Catalog (CAD Currency)](https://outletindex.com/ca/): Dedicated Canadian inventory and storefront fulfillment.
  - [Best Value Computers Canada (CAD)](https://outletindex.com/ca/best-value/): Top 12 best value configurations in Canadian Dollars (CAD).

## Authoritative Storefront Refurbished Buying Guides
- [Refurbished PC Buying Guide Hub](https://outletindex.com/guide): Comprehensive multi-store comparison matrix, return policies, warranty lengths, and cosmetic grade taxonomy.
- [Apple Certified Refurbished Guide](https://outletindex.com/guide/apple): Factory Finished Goods testing, 100% new battery & outer shell guarantee, 1-year OEM warranty, 60-day AppleCare+ window, and cart reservation rules.
- [Dell Outlet Buying Guide](https://outletindex.com/guide/dell-outlet): Certified Refurbished vs. Scratch & Dent, 1-year to 3-year ProSupport onsite warranties, and automated cart coupon stacks.
- [Dell Refurbished Buying Guide](https://outletindex.com/guide/dell-refurbished): Commercial off-lease Latitude, OptiPlex, and Precision workstations, Grade A vs. Grade B cosmetic standards, 100-day warranty, and DFS hot deal promotions.
- [Lenovo Outlet Buying Guide](https://outletindex.com/guide/lenovo-outlet): ThinkPad, Legion, and IdeaPad outlet tiers, Scratch & Dent vs. New Surplus, and depot warranty terms.
- [Microsoft Certified Refurbished Guide](https://outletindex.com/guide/microsoft-store): Surface Pro, Surface Laptop, and Xbox console factory reconditioning, 1-year warranty, and 45-day Microsoft Complete eligibility.
- [Woot! Refurbished Hardware Guide](https://outletindex.com/guide/woot): Amazon subsidiary clearance standards, Factory Reconditioned vs. Refurbished, 90-day Woot warranty vs. OEM coverage, and lower-48 shipping boundaries.
- [Newegg Refreshed & Outlet Guide](https://outletindex.com/guide/newegg): 1st-party Newegg Refreshed, open-box systems, marketplace seller verification, 90-day Newegg warranty, and hassle-free returns.
- [NeweggBusiness Outlet Buying Guide](https://outletindex.com/guide/newegg-business): Commercial Grade A off-lease desktops, barebones chassis kits, Net 30/60 financing terms, 15% restocking fee terms, and B2B return rules.
- [Refurb.io Canada Buying Guide](https://outletindex.com/guide/refurb-io-ca): Microsoft Authorized Refurbisher (MAR) standards, Grade A off-lease enterprise PCs, 1-year free warranty, and Canadian domestic fulfillment from Markham, Ontario.
- [HP Official eBay Store Guide](https://outletindex.com/guide/hp-ebay): Direct from Brand factory clearance (~98% sealed new), 1-3 year HP warranties, 2-year Allstate refurbished protection, $0 restocking fees, and eBay International Shipping (eIS) logistics.
- [Dell Official eBay Store Guide](https://outletindex.com/guide/dell-ebay): Direct from Dell Technologies (~100% Brand New enterprise inventory), 1-3 year Dell ProSupport onsite warranties, the enterprise rack-rate feed paradox, and true hardware value analysis.
- [Best Buy Outlet Buying Guide (US)](https://outletindex.com/guide/best-buy): 4-tier condition hierarchy (Certified Refurbished, Excellent, Satisfactory, Fair), 14-day to 60-day return windows, and Totaltech membership advantages.
- [Best Buy Canada Refurbished Guide](https://outletindex.com/guide/best-buy-ca): Geek Squad Certified Open Box vs. marketplace seller verification and warranty distinctions.
- [Snapdragon ARM Buying Guide](https://outletindex.com/guide/snapdragon): Prism emulation overhead, battery endurance advantages, native ARM64 software parity, and anti-cheat compatibility caveats.
- [Chromebook Buying Guide](https://outletindex.com/guide/chromebook): The 10-Second Buyer's Rule, Google Auto Update Expiration (AUE) date verification, Zero-Touch MDM enrollment lock avoidance, and battery cycle verification.
- [Mini PC & Micro Workstation Buying Guide](https://outletindex.com/guide/mini-pc): 1-Liter chassis thermals, 35W vs. 65W TDP throttling, dual NIC homelab virtualization, and low-profile expansion limits.

## Key Terminology & Rating Metrics
- **Net Price (`net_coupon_price`):** The actual checkout price after deducting all active merchant coupon codes and promotional discounts.
- **CPU Benchmark Score (`cpu_score`):** Multi-threaded computational performance rating evaluated from verified hardware benchmark suites (strictly evaluates under "None is 0").
- **Dual Power Ratings:**
  - *Office Power (`perf_index`):* Raw computational productivity point score evaluated from verified hardware benchmark suites (~18 to ~2560 pts; Workstation >=400, Pro >=275, Mid-Level >=180).
  - *Gaming Power (`game_index`):* Raw 3D graphics rendering score evaluated from verified hardware benchmark suites (~8 to ~395 pts; High-End 3D >=220, 1080p Gaming >=120; 0 if unrated or integrated graphics).
- **Bang-for-Buck Index (Office `bbo` & Gaming `bbg`):** Silicon benchmark points delivered per $100 spent (`score ÷ net_coupon_price × 100`). Higher numbers denote superior computational value per dollar.

## Catalog Taxonomy & Hardware Classification Enums
When filtering machine payloads (`/data/latest*.json`), use these exact string enum values:

- **`device_type` (18 values):**
  `laptop`, `desktop`, `mini-pc`, `server`, `tablet`, `monitor`, `accessory`, `headphone`, `printer`, `smartphone`, `smartwatch`, `component`, `networking`, `barebone`, `projector`, `all-in-one`, `console`, `streaming`

- **`category` (17 values):**
  `laptops`, `desktop-computers`, `tablets`, `monitors`, `dell-servers`, `accessories`, `headphones`, `computer-workstation`, `printers`, `smartphones`, `smartwatches`, `computer-parts-components`, `networking`, `computer-accessories`, `projectors`, `consoles`, `streaming-media`

- **`cosmetic_grade`:**
  `Certified Refurbished`, `Excellent`, `Grade A`, `Grade B`, `Refurbished`, `Scratch & Dent`, `Satisfactory`, `Fair`

- **`gpu_category`:**
  `Integrated` (CPU-shared silicon), `Discrete` (dedicated GPU silicon)


## Tracked Merchant Stores & Official Storefront URLs
OutletIndex aggregates inventory across 18 official manufacturer outlet stores and certified refurbishers in the United States and Canada. In all machine-readable catalog feeds (`/data/latest.json`, `/data/latest-us.json`, `/data/latest-ca.json`), each deal entry includes the merchant's official human-readable storefront name (`store_name`) and root storefront homepage (`store_url`), while specific product purchase destinations are routed through protected outbound trampoline endpoints (`/go/{deal_slug}?src=oi`).

<table>
<thead>
<tr>
  <th align="left">Source Key</th>
  <th align="left">Storefront Name (<code>store_name</code>)</th>
  <th align="left">Region</th>
  <th align="left">Official Storefront URL (<code>store_url</code>)</th>
</tr>
</thead>
<tbody>
<tr>
  <td><code>apple_refurbished_us</code></td>
  <td>Apple Certified Refurbished</td>
  <td>US</td>
  <td><a href="https://www.apple.com/shop/refurbished">https://www.apple.com/shop/refurbished</a></td>
</tr>
<tr>
  <td><code>apple_refurbished_ca</code></td>
  <td>Apple Certified Refurbished (CA)</td>
  <td>CA</td>
  <td><a href="https://www.apple.com/ca/shop/refurbished">https://www.apple.com/ca/shop/refurbished</a></td>
</tr>
<tr>
  <td><code>delloutlet_us</code></td>
  <td>Dell Outlet</td>
  <td>US</td>
  <td><a href="https://outlet.us.dell.com">https://outlet.us.dell.com</a></td>
</tr>
<tr>
  <td><code>dellrefurb_us</code></td>
  <td>Dell Refurbished</td>
  <td>US</td>
  <td><a href="https://www.dellrefurbished.com">https://www.dellrefurbished.com</a></td>
</tr>
<tr>
  <td><code>dellrefurb_ca</code></td>
  <td>Dell Refurbished (CA)</td>
  <td>CA</td>
  <td><a href="https://www.dellrefurbished.ca">https://www.dellrefurbished.ca</a></td>
</tr>
<tr>
  <td><code>dell_ebay_us</code></td>
  <td>Dell eBay Store</td>
  <td>US</td>
  <td><a href="https://www.ebay.com/str/dell">https://www.ebay.com/str/dell</a></td>
</tr>
<tr>
  <td><code>hp_ebay_us</code></td>
  <td>HP eBay Store</td>
  <td>US</td>
  <td><a href="https://www.ebay.com/str/officialhpstore">https://www.ebay.com/str/officialhpstore</a></td>
</tr>
<tr>
  <td><code>hp_ebay_ca</code></td>
  <td>HP eBay Store (CA)</td>
  <td>CA</td>
  <td><a href="https://www.ebay.ca/str/officialhpstore">https://www.ebay.ca/str/officialhpstore</a></td>
</tr>
<tr>
  <td><code>lenovo_outlet_us</code></td>
  <td>Lenovo Outlet</td>
  <td>US</td>
  <td><a href="https://www.lenovo.com/us/outletus">https://www.lenovo.com/us/outletus</a></td>
</tr>
<tr>
  <td><code>lenovo_outlet_ca</code></td>
  <td>Lenovo Outlet (CA)</td>
  <td>CA</td>
  <td><a href="https://www.lenovo.com/ca/outletca">https://www.lenovo.com/ca/outletca</a></td>
</tr>
<tr>
  <td><code>microsoft_store_us</code></td>
  <td>Microsoft Certified Refurbished</td>
  <td>US</td>
  <td><a href="https://www.microsoft.com/en-us/store/b/refurbished-pc">https://www.microsoft.com/en-us/store/b/refurbished-pc</a></td>
</tr>
<tr>
  <td><code>microsoft_store_ca</code></td>
  <td>Microsoft Certified Refurbished (CA)</td>
  <td>CA</td>
  <td><a href="https://www.microsoft.com/en-ca/store/b/refurbished-pc">https://www.microsoft.com/en-ca/store/b/refurbished-pc</a></td>
</tr>
<tr>
  <td><code>newegg_business</code></td>
  <td>NeweggBusiness</td>
  <td>US</td>
  <td><a href="https://www.neweggbusiness.com">https://www.neweggbusiness.com</a></td>
</tr>
<tr>
  <td><code>newegg_outlet</code></td>
  <td>Newegg Refreshed</td>
  <td>US</td>
  <td><a href="https://www.newegg.com">https://www.newegg.com</a></td>
</tr>
<tr>
  <td><code>newegg_outlet_ca</code></td>
  <td>Newegg (CA)</td>
  <td>CA</td>
  <td><a href="https://www.newegg.ca">https://www.newegg.ca</a></td>
</tr>
<tr>
  <td><code>newegg_refreshed</code></td>
  <td>Newegg Refreshed</td>
  <td>US</td>
  <td><a href="https://www.newegg.com">https://www.newegg.com</a></td>
</tr>
<tr>
  <td><code>refurb_io_ca</code></td>
  <td>Refurb.io (CA)</td>
  <td>CA</td>
  <td><a href="https://ca.refurb.io">https://ca.refurb.io</a></td>
</tr>
<tr>
  <td><code>woot</code></td>
  <td>Woot Deals</td>
  <td>US</td>
  <td><a href="https://www.woot.com">https://www.woot.com</a></td>
</tr>
</tbody>
</table>

<!-- AUTO_SCHEMA_START -->
## Machine Catalog Schema Specification (JSON)
Every listing object in `/data/latest.json`, `/data/latest-us.json`, and `/data/latest-ca.json` follows this standardized dictionary (missing keys evaluate strictly as null or 0.0 under the zero-fallback policy):

- **`source`**: Merchant scraper/catalog identifier (e.g., 'dell_outlet', 'lenovo_outlet', 'woot', 'bestbuy_outlet_us').
- **`item_id`**: Merchant inventory SKU or unique product identifier.
- **`title`**: Product title and hardware description as listed by merchant.
- **`deal_slug`**: Cryptographically bound deal identifier used for card isolation and deep-linking.
- **`region`**: Geographic fulfillment and pricing territory ('US' or 'CA').
- **`currency`**: Listing currency code ('USD' for US, 'CAD' for Canada).
- **`observed_date`**: ISO timestamp when the listing was last observed active in merchant inventory.
- **`store_name`**: Official human-readable merchant outlet name (e.g., 'Dell Outlet', 'Woot Deals').
- **`store_url`**: Official root storefront homepage for the merchant.
- **`url`**: Canonical outbound deal routing link (https://outletindex.com/go/{deal_slug}?src=oi). For direct human shopper card isolation, use https://outletindex.com/?deal={deal_slug}.
- **`listed_price`**: Merchant list price before applying discount coupons.
- **`regular_price`**: Original reference MSRP or manufacturer list price before discounts.
- **`net_coupon_price`**: Final checkout price in listing currency after deducting all verified active merchant coupons and promotional discounts.
- **`total_savings`**: Total currency amount saved below reference regular or list price.
- **`discount_pct`**: Total percentage discount relative to regular or merchant list price.
- **`coupon_code_applied`**: Promotional discount coupon code required during checkout (null if discount is instant or automated).
- **`coupon_discount_pct`**: Percentage discount granted by the active coupon code.
- **`perf_index`**: Office Power rating (raw computational productivity point score evaluated from verified hardware benchmark suites; active catalog range ~18 to ~2560 pts; Workstation >=400, Pro >=275, Mid-Level >=180; strictly evaluates under 'None is 0').
- **`game_index`**: Gaming Power rating (raw 3D graphics rendering score evaluated from verified hardware benchmark suites; active catalog range ~8 to ~395 pts; High-End 3D >=220, 1080p Gaming >=120; 0 if unrated or integrated graphics).
- **`cpu_score`**: Multi-threaded computational CPU benchmark rating evaluated from verified hardware benchmark suites (higher is faster; strictly evaluates under 'None is 0').
- **`gpu_score`**: Standardized 3D graphics computation mark (higher is faster; 0 if unrated or integrated).
- **`bbo`**: Office Bang-for-Buck Index (perf_index divided by net_coupon_price multiplied by 100; representing computational benchmark points delivered per $100 spent).
- **`bbg`**: Gaming Bang-for-Buck Index (game_index divided by net_coupon_price multiplied by 100; representing 3D graphics benchmark points delivered per $100 spent).
- **`value_index`**: Office power value ranking score factoring price, CPU performance, and upgradability.
- **`gaming_value_index`**: Gaming power value ranking score factoring price and 3D graphics performance.
- **`bbi`**: Base computational bang-for-buck score (cpu_score divided by net_coupon_price).
- **`bbgi`**: Base graphics bang-for-buck score (gpu_score divided by net_coupon_price).
- **`bb_console`**: Bang-for-buck score normalized against console gaming performance.
- **`office_tier_val_pct`**: Office Power value percentile rank (0 to 100) relative to all active machines within the same hardware tier.
- **`gaming_tier_val_pct`**: Gaming Power value percentile rank (0 to 100) relative to all active machines within the same hardware tier.
- **`office_val_badge`**: Human-readable Office Power value badge label ('Elite Value', 'Great Value', 'Fair Value').
- **`office_val_cls`**: CSS badge class for Office Power value tier styling.
- **`gaming_val_badge`**: Human-readable Gaming Power value badge label ('Elite 3D Value', 'Great 3D Value', 'Fair 3D Value').
- **`gaming_val_cls`**: CSS badge class for Gaming Power value tier styling.
- **`brand`**: Manufacturer brand name (e.g., 'Apple', 'Dell', 'Lenovo', 'HP', 'Microsoft').
- **`device_type`**: Primary device hardware classification ('laptop', 'desktop', 'mini-pc', 'server', 'monitor', 'tablet', 'networking', etc.).
- **`category`**: Catalog taxonomy grouping slug ('laptops', 'desktop-computers', 'tablets', 'monitors', 'dell-servers', etc.).
- **`cpu`**: Standardized processor model name (e.g., 'Core i7-13700H', 'Ryzen 7 PRO 7840U', 'Apple M3 Pro').
- **`cpu_tdp`**: Processor Thermal Design Power in watts evaluating sustained performance class.
- **`memory`**: Human-readable system memory description (e.g., '16GB DDR5 4800MHz').
- **`memory_gb`**: Total system RAM capacity as an integer in gigabytes (e.g., 16, 32, 64).
- **`memory_type`**: DDR memory generation technology ('DDR4', 'DDR5', 'LPDDR5', 'LPDDR5x').
- **`ram_slots`**: Count of physical memory slots on motherboard (0 = 100% soldered/non-upgradeable, 1/2/4 = accessible sockets, null = unrated).
- **`is_upgradeable`**: Hardware upgradability flag (1 = socketed RAM slots available for DIY upgrades, 0 = permanently soldered RAM, null = unrated or non-compute).
- **`storage`**: Human-readable primary storage description (e.g., '512GB PCIe NVMe M.2 SSD').
- **`storage_gb`**: Primary solid-state drive or hard disk capacity as an integer in gigabytes (e.g., 256, 512, 1000 for 1TB).
- **`display`**: Human-readable display panel description (e.g., '15.6" FHD (1920x1080) IPS 300nits Anti-glare').
- **`screen_inches`**: Display panel diagonal measurement in inches as a float (e.g., 13.3, 14.0, 15.6, 16.0, 27.0).
- **`gpu`**: Graphics processing unit model name (e.g., 'RTX 4060', 'Intel Iris Xe', 'Apple 10-core GPU').
- **`gpu_category`**: Graphics architecture classification ('Integrated' for CPU-shared graphics vs. 'Discrete' for dedicated GPU silicon).
- **`operating_system`**: Installed factory or refurbisher operating system (e.g., 'Windows 11 Pro', 'macOS', 'ChromeOS').
- **`cosmetic_grade`**: Refurbisher cosmetic condition rating (e.g., 'Certified Refurbished', 'Grade A', 'Scratch & Dent').
- **`mem_score`**: System RAM capacity scoring factor.
- **`storage_score`**: Storage capacity and speed scoring factor.
- **`chassis_url`**: Canonical manufacturer hardware platform reference URL (Lenovo PSREF, Dell Setup & Specifications, HP QuickSpecs) detailing motherboard layout, RAM upgrade slots, M.2 SSD limits, and port diagrams.
- **`specs_label`**: Human-readable UI pill label distinguishing compute hardware ('📐 Platform Reference ↗') from standalone displays ('🖥️ Display Specs ↗').
- **`specs_url`**: Direct external link to technical specifications or merchant documentation.
- **`specs_action`**: UI modal or navigation action triggered by specifications link.
- **`psref_url`**: Direct Lenovo PSREF (Personal Systems Reference) specifications URL.
- **`image_url`**: High-resolution product hardware photo URL.
- **`viewbox`**: Smart SVG cropped bounding box coordinate string ('minX minY width height') for aspect ratio normalization.
- **`img_w`**: Canonical product thumbnail canvas pixel width.
- **`img_h`**: Canonical product thumbnail canvas pixel height.
- **`stock_status`**: Real-time merchant inventory availability string ('In Stock', 'Limited Quantity').
- **`stock_qty`**: Parsed integer quantity of remaining units in stock (when reported directly by merchant).
- **`stock_prev_qty`**: Previously recorded inventory stock quantity prior to most recent scrape cycle.
- **`stock_drop_diff`**: Net reduction in available inventory units between scrape cycles.
- **`price_drop_old_price`**: Previous recorded listing price prior to detected price reduction.
- **`price_drop_diff`**: Net dollar price reduction amount detected between scrape cycles.
- **`price_drop_date`**: ISO timestamp when price reduction was detected.
- **`price_drop_type`**: Classification of price drop ('coupon', 'instant', 'unadvertised').
- **`is_sale`**: Boolean flag indicating whether item has an active promotional discount.
- **`is_shared_catalog`**: Boolean flag indicating whether inventory SKU is syndicated across multiple retail storefronts.
- **`is_price_drop_24h`**: Boolean flag indicating a detected price reduction within the past 24 hours.
- **`is_price_drop_refresh`**: Boolean flag indicating a detected price reduction during the current scrape run.
- **`is_added_24h`**: Boolean flag indicating new inventory discovered within the past 24 hours.
- **`is_added_refresh`**: Boolean flag indicating new inventory discovered during the current scrape run.
- **`is_stock_drop_24h`**: Boolean flag indicating inventory depletion detected within the past 24 hours.
- **`is_stock_drop_refresh`**: Boolean flag indicating inventory depletion detected during the current scrape run.
- **`openwrt_supported`**: Hardware support flag for OpenWrt embedded Linux firmware.
- **`openwrt_target`**: OpenWrt target architecture (e.g., 'ramips/mt7621', 'qualcommax/ipq807x').
- **`openwrt_subtarget`**: OpenWrt device subtarget.
- **`openwrt_package_arch`**: Target processor package architecture (e.g., 'mipsel_24kc', 'aarch64_cortex-a53').
- **`openwrt_version`**: Recommended stable OpenWrt release version.
- **`openwrt_profile`**: OpenWrt firmware build profile identifier.
- **`openwrt_firmware_url`**: Direct firmware installation binary or builder URL.
<!-- AUTO_SCHEMA_END -->

