[2025-08-04 21:08:55] Starting Google Merchant Center upload process<br>[2025-08-04 21:08:55] Processing limit: 1 products<br>[2025-08-04 21:08:55] Autoloader found at: /var/www/html/vendor/autoload.php<br>[2025-08-04 22:08:55] Service account authentication configured successfully using file<br>[2025-08-04 22:08:55] Shopping Content service initialized successfully<br>[2025-08-04 22:08:55] Using Merchant ID: 5554354645<br>[2025-08-04 22:08:55] Found 0 products to process<br><hr>[2025-08-04 22:08:55] Upload complete<br>[2025-08-04 22:08:55] Total products processed: 0<br>[2025-08-04 22:08:55] Successfully uploaded: 0<br>[2025-08-04 22:08:55] Errors: 0<br>        <hr>
        <h2>Google Merchant Center Upload</h2>
        <div style="margin-bottom: 15px; padding: 10px; background-color: #f8f9fa; border: 1px solid #ddd; border-radius: 5px;">
            <p><strong>Google Merchant Center Requirements:</strong> The following validations are now applied to meet Google's requirements:</p>
            
            <p><strong>1. GTIN/ISBN Handling:</strong>
                <ul>
                    <li>ISBN numbers are now properly formatted as 13-digit GTINs</li>
                    <li>ISBN-10 numbers are automatically converted to ISBN-13</li>
                    <li>Non-numeric characters are removed</li>
                    <li>Invalid ISBNs will not be sent as GTINs</li>
                </ul>
            </p>
            
            <p><strong>2. Description Enhancement:</strong>
                <ul>
                    <li>Short descriptions are automatically extended to meet Google's minimum requirements</li>
                    <li>Extended descriptions include: title, condition, ISBN, and standard store information</li>
                    <li>Ensures descriptions are at least 150 characters long</li>
                </ul>
            </p>
            
            <p><strong>3. Condition Mapping:</strong>
                <ul>
                    <li>Conditions are properly mapped to Google's accepted values: "new", "used", "refurbished"</li>
                    <li>Special handling for "The Botham Report" - forced to "new" condition</li>
                    <li>Special handling for "The Trials of Life" - forced to "used" condition</li>
                    <li>Direct match for "NewItem" - set to "new" condition</li>
                    <li>Special handling for "UsedLikeNew" and conditions containing "like new" - set to "used" condition (Google requirement)</li>
                    <li>Exact matches for "new", "used", "refurbished" are used as-is</li>
                    <li>Conditions containing "new", "sealed", "mint", "unused" are mapped to "new"</li>
                    <li>Any condition containing "refurbished", "restored", "reconditioned", etc. is mapped to "refurbished"</li>
                    <li>Special conditions like "very good", "good", "fair", "acceptable", "excellent", "collectible", "vintage", etc. are mapped to "used"</li>
                    <li>All other conditions default to "used"</li>
                </ul>
            </p>
            
            <p><strong>Image Selection:</strong> Images are selected in the following priority:
                <ol>
                    <li><strong>Amazon Images:</strong> High-quality images from amazon_product_images table (width >= 500px)</li>
                    <li><strong>Shopify Images:</strong> Images from the shopify_product_imports table</li>
                    <li><strong>Default Image:</strong> Fallback to the default book image if no other images are available</li>
                </ol>
            </p>
            
            <p><strong>Custom Label Assignment:</strong> 
                <ul>
                    <li><strong>Products with sales_rank < 500,000:</strong> Will receive <code>low_rank</code> label</li>
                    <li><strong>Products with sales_rank 500,000-1,000,000:</strong> Will receive <code>mid_rank</code> label</li>
                    <li><strong>Products with sales_rank > 1,000,000:</strong> Will receive <code>high_rank</code> label</li>
                    <li><strong>Products without sales_rank:</strong> Will receive <code>high_rank</code> label (default)</li>
                </ul>
            </p>
            
            <p><strong>Debug Information:</strong> Extra debugging is now displayed for each product, showing validation status for GTIN, condition, and description length.</p>
        </div>
        <form method="get">
            <label for="limit">Number of products to process:</label>
            <input type="number" id="limit" name="limit" value="1" min="1" max="1000">
            <div style="margin-top: 10px;">
                <label for="create_table">
                    <input type="checkbox" id="create_table" name="create_table" value="1">
                    Create tracking table if it doesn't exist
                </label>
            </div>
            <button type="submit" style="margin-top: 10px;">Start Upload</button>
        </form>
        
        <div style="margin-top: 15px;">
            <a href="add_to_google_merchant.php?action=reset_flags" style="background-color: #dc3545; color: white; padding: 8px 15px; text-decoration: none; border-radius: 4px; display: inline-block;">Reset Upload Flags</a>
            <span style="margin-left: 10px; color: #6c757d; font-size: 0.9em;">Use this to make all products available for upload again</span>
        </div>
        
        <!-- Add a section to view recent uploads -->
        <hr>
        <h2>Recent Uploads</h2>
                        <table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse; width: 100%;">
                    <thead>
                        <tr style="background-color: #f2f2f2;">
                            <th>ID</th>
                            <th>Product ID</th>
                            <th>Shopify Product ID</th>
                            <th>Offer ID</th>
                            <th>Status</th>
                            <th>Response/Error</th>
                            <th>Timestamp</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77586</td>
                                <td>89379</td>
                                <td>10451057312008</td>
                                <td>U1-S-DC-new_QOSTDQNYFM</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_QOSTDQNYFM&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_QOSTDQNYFM&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:23:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77586)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77585</td>
                                <td>89379</td>
                                <td>10451057312008</td>
                                <td>U1-S-DC-new_QOSTDQNYFM</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_QOSTDQNYFM&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_QOSTDQNYFM&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:23:03</td>
                                <td>
                                                                            <button onclick="showResponseData(77585)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77584</td>
                                <td>89378</td>
                                <td>10451056427272</td>
                                <td>U1-S-DD-new_RAGPOJTEIS</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DD-new_RAGPOJTEIS&quot;,
    &quot;offerId&quot;: &quot;U1-S-DD-new_RAGPOJTEIS&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:22:03</td>
                                <td>
                                                                            <button onclick="showResponseData(77584)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77583</td>
                                <td>89377</td>
                                <td>10451054395656</td>
                                <td>U1-S-DC-new_EJDIMCWFDE</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_EJDIMCWFDE&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_EJDIMCWFDE&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:21:05</td>
                                <td>
                                                                            <button onclick="showResponseData(77583)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77582</td>
                                <td>89377</td>
                                <td>10451054395656</td>
                                <td>U1-S-DC-new_EJDIMCWFDE</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_EJDIMCWFDE&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_EJDIMCWFDE&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:21:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77582)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77581</td>
                                <td>89376</td>
                                <td>10451053379848</td>
                                <td>U1-S-DC-new_QIKIEMNMVN</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_QIKIEMNMVN&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_QIKIEMNMVN&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:20:05</td>
                                <td>
                                                                            <button onclick="showResponseData(77581)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77580</td>
                                <td>89376</td>
                                <td>10451053379848</td>
                                <td>U1-S-DC-new_QIKIEMNMVN</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_QIKIEMNMVN&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_QIKIEMNMVN&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:20:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77580)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77579</td>
                                <td>89375</td>
                                <td>10451050889480</td>
                                <td>U1-S-DC-new_BXSROIAKWE</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_BXSROIAKWE&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_BXSROIAKWE&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:19:03</td>
                                <td>
                                                                            <button onclick="showResponseData(77579)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77578</td>
                                <td>89374</td>
                                <td>10451049677064</td>
                                <td>U1-S-DC-new_LGGNZNDDVY</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_LGGNZNDDVY&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_LGGNZNDDVY&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:18:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77578)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77577</td>
                                <td>89374</td>
                                <td>10451049677064</td>
                                <td>U1-S-DC-new_LGGNZNDDVY</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_LGGNZNDDVY&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_LGGNZNDDVY&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:18:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77577)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77576</td>
                                <td>89373</td>
                                <td>10451048235272</td>
                                <td>U1-S-DC-new_NUJFLMUWKD</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_NUJFLMUWKD&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_NUJFLMUWKD&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:17:05</td>
                                <td>
                                                                            <button onclick="showResponseData(77576)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77575</td>
                                <td>89373</td>
                                <td>10451048235272</td>
                                <td>U1-S-DC-new_NUJFLMUWKD</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_NUJFLMUWKD&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_NUJFLMUWKD&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:17:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77575)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77574</td>
                                <td>89372</td>
                                <td>10451046727944</td>
                                <td>U1-S-DD-new_JEWZUTAFZU</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DD-new_JEWZUTAFZU&quot;,
    &quot;offerId&quot;: &quot;U1-S-DD-new_JEWZUTAFZU&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:16:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77574)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77573</td>
                                <td>89371</td>
                                <td>10451044499720</td>
                                <td>U1-S-DD-new_ZFIJQQZGYV</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DD-new_ZFIJQQZGYV&quot;,
    &quot;offerId&quot;: &quot;U1-S-DD-new_ZFIJQQZGYV&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:15:05</td>
                                <td>
                                                                            <button onclick="showResponseData(77573)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77572</td>
                                <td>89371</td>
                                <td>10451044499720</td>
                                <td>U1-S-DD-new_ZFIJQQZGYV</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DD-new_ZFIJQQZGYV&quot;,
    &quot;offerId&quot;: &quot;U1-S-DD-new_ZFIJQQZGYV&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:15:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77572)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77571</td>
                                <td>89370</td>
                                <td>10451043811592</td>
                                <td>U1-S-DC-new_CXWSKAPOIG</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_CXWSKAPOIG&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_CXWSKAPOIG&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:14:03</td>
                                <td>
                                                                            <button onclick="showResponseData(77571)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77570</td>
                                <td>89369</td>
                                <td>10451040305416</td>
                                <td>U1-S-DD-new_GMJUQAWEZJ</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DD-new_GMJUQAWEZJ&quot;,
    &quot;offerId&quot;: &quot;U1-S-DD-new_GMJUQAWEZJ&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:13:03</td>
                                <td>
                                                                            <button onclick="showResponseData(77570)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77569</td>
                                <td>89368</td>
                                <td>10451037618440</td>
                                <td>U1-S-DD-new_LYSDHFEGFL</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DD-new_LYSDHFEGFL&quot;,
    &quot;offerId&quot;: &quot;U1-S-DD-new_LYSDHFEGFL&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:11:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77569)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77568</td>
                                <td>89367</td>
                                <td>10451034997000</td>
                                <td>U1-S-DC-new_FCVAUVLALG</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_FCVAUVLALG&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_FCVAUVLALG&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:10:04</td>
                                <td>
                                                                            <button onclick="showResponseData(77568)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                                    <tr style="background-color: #e6ffe6">
                                <td>77567</td>
                                <td>89366</td>
                                <td>10451033817352</td>
                                <td>U1-S-DC-new_VFUNCTLCOV</td>
                                <td>success</td>
                                <td>
                                                                            <div style="max-height: 100px; overflow: auto;"><pre style="margin: 0; font-size: 12px;">{
    &quot;id&quot;: &quot;online:en:GB:U1-S-DC-new_VFUNCTLCOV&quot;,
    &quot;offerId&quot;: &quot;U1-S-DC-new_VFUNCTLCOV&quot;,
    &quot;targetCountry&quot;: &quot;GB&quot;,
    &quot;contentLanguage&quot;: &quot;en&quot;
}</pre></div>                                                                    </td>
                                <td>2025-08-04 15:09:03</td>
                                <td>
                                                                            <button onclick="showResponseData(77567)" class="view-btn">View Full Response</button>
                                                                    </td>
                            </tr>
                                            </tbody>
                </table>
                
                <!-- Modal for displaying response data -->
                <div id="responseModal" style="display: none; position: fixed; z-index: 1000; left: 0; top: 0; width: 100%; height: 100%; overflow: auto; background-color: rgba(0,0,0,0.4);">
                    <div style="background-color: #fefefe; margin: 5% auto; padding: 20px; border: 1px solid #888; width: 90%; max-width: 1200px; max-height: 80%; overflow: auto;">
                        <span style="color: #aaa; float: right; font-size: 28px; font-weight: bold; cursor: pointer;" onclick="document.getElementById('responseModal').style.display='none'">&times;</span>
                        <h3>Google API Response Data</h3>
                        <div id="responseImageContainer" style="margin-bottom: 15px; display: none;">
                            <p><strong>Product Image:</strong></p>
                            <img id="responseImage" src="" style="max-width: 200px; max-height: 200px; border: 1px solid #ddd; padding: 5px;" />
                        </div>
                        <div id="responseData" style="white-space: pre-wrap; background-color: #f5f5f5; padding: 15px; border-radius: 5px; overflow: auto;"></div>
                    </div>
                </div>
                
                <script>
                function showResponseData(id) {
                    // Fetch the response data via AJAX
                    fetch('?action=get_response_data&id=' + id)
                        .then(response => response.json())
                        .then(data => {
                            document.getElementById('responseData').innerHTML = JSON.stringify(data, null, 2);
                            
                            // Check if there's an image link to display
                            const imageContainer = document.getElementById('responseImageContainer');
                            const imageElement = document.getElementById('responseImage');
                            
                            if (data.imageLink) {
                                imageElement.src = data.imageLink;
                                imageContainer.style.display = 'block';
                            } else {
                                imageContainer.style.display = 'none';
                            }
                            
                            document.getElementById('responseModal').style.display = 'block';
                        })
                        .catch(error => {
                            alert('Error fetching response data: ' + error);
                        });
                }
                
                function showErrorData(id) {
                    // Fetch the error data via AJAX
                    fetch('?action=get_error_data&id=' + id)
                        .then(response => response.json())
                        .then(data => {
                            let displayText = '';
                            if (data.error_message) {
                                displayText = data.error_message;
                            } else {
                                displayText = JSON.stringify(data, null, 2);
                            }
                            document.getElementById('responseData').innerHTML = displayText;
                            document.getElementById('responseModal').style.display = 'block';
                        })
                        .catch(error => {
                            alert('Error fetching error data: ' + error);
                        });
                }
                </script>
                <style>
                .view-btn {
                    background-color: #4CAF50;
                    color: white;
                    padding: 5px 10px;
                    border: none;
                    border-radius: 4px;
                    cursor: pointer;
                }
                .view-btn:hover {
                    background-color: #45a049;
                }
                .error-btn {
                    background-color: #ff0000;
                    color: white;
                    padding: 5px 10px;
                    border: none;
                    border-radius: 4px;
                    cursor: pointer;
                }
                .error-btn:hover {
                    background-color: #cc0000;
                }
                </style>
                        <p><strong>Products available for upload:</strong> 0</p>

        <p><strong>Note about Custom Labels and Images:</strong> Google Merchant Center may not immediately show custom labels and images in the API response. 
        These fields are often processed asynchronously and may take some time to appear in the feed. 
        Check the Google Merchant Center web interface to confirm if the data was properly received.</p>