Price History Tracking

Overview

DealAI.lt tracks price changes over time, providing historical analysis, trend visualization, and discount detection.

Features

• Historical Data: Track every price change
• Trend Visualization: Chart.js line charts
• Discount Detection: Identify price drops
• Availability Tracking: Monitor stock status

Database Schema

Table: product_crawl_history

Stores historical snapshots of product data including price, availability, and changes.

Implementation

File: /inc/product-pricing-history.php

Get Price History:

function get_product_price_history($product_id, $days = 30) {
    $connection = get_db_connection();

    $query = "
        SELECT price, list_price, availability, crawled_at
        FROM product_crawl_history
        WHERE product_id = $1
        AND crawled_at >= NOW() - INTERVAL '$2 days'
        ORDER BY crawled_at ASC
    ";

    return pg_query_params($connection, $query, [$product_id, $days]);
}

Chart Rendering

Uses Chart.js for interactive price trend visualization.

Next Steps

• Analytics - Reporting features
• Database - Data storage