public function display_product_overview_page() {
    $api_client = DyronicsConnect_API_Client::get_instance();
    $online_products = $api_client->get_online_products();

    if (!$online_products || !isset($online_products['offers'])) {
        echo '<div class="wrap">';
        echo '<h1>Productoverzicht</h1>';
        echo '<p>Geen producten gevonden die online staan bij Bol.com.</p>';
        echo '</div>';
        return;
    }

    error_log('Online producten: ' . print_r($online_products, true)); // Voeg deze regel toe voor extra logging

    $online_eans = array_map(function($offer) {
        return $offer['ean'];
    }, $online_products['offers']);

    // Voeg paginering toe
    $page = isset($_GET['paged']) ? intval($_GET['paged']) : 1;
    $products_per_page = 10;
    $offset = ($page - 1) * $products_per_page;

    // Voeg filteropties toe
    $filter_status = isset($_GET['filter_status']) ? sanitize_text_field($_GET['filter_status']) : '';

    // Haal WooCommerce producten op
    $args = array(
        'post_type' => 'product',
        'posts_per_page' => $products_per_page,
        'paged' => $page,
        'meta_query' => array(
            array(
                'key' => '_sku',
                'value' => $online_eans,
                'compare' => 'IN'
            )
        ),
    );

    if ($filter_status) {
        $args['meta_query'][] = array(
            'key' => '_stock_status',
            'value' => $filter_status,
            'compare' => '='
        );
    }

    $query = new WP_Query($args);

    echo '<div class="wrap">';
    echo '<h1>Productoverzicht</h1>';

    echo '<form method="get">';
    echo '<input type="hidden" name="page" value="dyronicsconnect_productoverview" />';
    echo '<select name="filter_status">';
    echo '<option value="">Alle</option>';
    echo '<option value="instock"' . selected($filter_status, 'instock', false) . '>Te Koop</option>';
    echo '<option value="outofstock"' . selected($filter_status, 'outofstock', false) . '>Niet te koop</option>';
    echo '</select>';
    echo '<input type="submit" value="Filter" class="button" />';
    echo '</form>';

    if ($query->have_posts()) {
        echo '<h2>Producten</h2>';
        echo '<table class="wp-list-table widefat fixed striped">';
        echo '<thead><tr><th>Product</th><th>Prijs</th><th>Verkoopprijs Bol.com</th><th>Levertijd</th><th>Voorraad</th><th>EAN</th><th>Koopblok</th></tr></thead>';
        echo '<tbody>';

        while ($query->have_posts()) {
            $query->the_post();
            $product = wc_get_product(get_the_ID());
            $ean = $product->get_sku();
            $offer_id = $product->get_meta('bol_offer_id');
            $bol_price = '';

            if ($offer_id) {
                $offer_data = $api_client->get_offer_price($offer_id);
                if (isset($offer_data['pricing']['bundlePrices'][0]['unitPrice'])) {
                    $bol_price = $offer_data['pricing']['bundlePrices'][0]['unitPrice'];
                }
            }

            $has_buy_box = $product->get_meta('has_buy_box');

            echo '<tr>';
            echo '<td>' . esc_html($product->get_name()) . '</td>';
            echo '<td>' . esc_html($product->get_price()) . '</td>';
            echo '<td>' . esc_html($bol_price) . '</td>';
            echo '<td>' . esc_html($product->get_meta('delivery_time')) . '</td>';
            echo '<td>' . esc_html($product->get_stock_quantity()) . '</td>';
            echo '<td>' . esc_html($ean) . '</td>';
            echo '<td>';
            if ($has_buy_box === 'yes') {
                echo '<span style="color: green;">&#9632;</span>';
            } else {
                echo '<span style="color: orange;">&#9632;</span>';
            }
            echo '</td>';
            echo '</tr>';
        }

        echo '</tbody>';
        echo '</table>';

        // Paginering
        $total_products = $query->found_posts;
        $total_pages = $query->max_num_pages;

        echo '<div class="tablenav">';
        if ($total_pages > 1) {
            $page_links = paginate_links(array(
                'base' => add_query_arg('paged', '%#%'),
                'format' => '',
                'prev_text' => __('&laquo;'),
                'next_text' => __('&raquo;'),
                'total' => $total_pages,
                'current' => $page
            ));
            echo '<div class="tablenav-pages">' . $page_links . '</div>';
        }
        echo '</div>';
    } else {
        echo '<p>Geen producten gevonden die online staan bij Bol.com.</p>';
    }

    wp_reset_postdata();

    echo '</div>';
}