[2025-11-10 20:54:12] Starting Google Merchant Center upload process
[2025-11-10 20:54:12] Processing limit: 1 products
[2025-11-10 20:54:12] Autoloader found at: /var/www/html/vendor/autoload.php
[2025-11-10 20:54:12] Service account authentication configured successfully using file
[2025-11-10 20:54:12] Shopping Content service initialized successfully
[2025-11-10 20:54:12] Using Merchant ID: 5554354645
[2025-11-10 20:54:13] Found 1 products to process
[2025-11-10 20:54:13] Enhanced title with author: Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11) by Award Publications Ltd
[2025-11-10 20:54:13] Extended description: Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11): No description available. Condition: New - NewItem. ISBN: 9781841351407. Available from AZ Books, trusted seller of quality books. We offer fast shipping and excellent customer service.
[2025-11-10 20:54:13] Setting link: https://www.azbooks.co.uk/products/peronnel-s-magic-polish-enid-blyton-s-popular-rewards-series-11
[2025-11-10 20:54:13] Image URL source: Amazon image: https://m.media-amazon.com/images/I/919M9V-t6VL.jpg
✅ Using Amazon Image: https://m.media-amazon.com/images/I/919M9V-t6VL.jpg
[2025-11-10 20:54:13] Setting image link: https://m.media-amazon.com/images/I/919M9V-t6VL.jpg
[2025-11-10 20:54:13] Product sales rank value: 4556613
[2025-11-10 20:54:13] Processing sales rank: 4556613
[2025-11-10 20:54:13] Method 1: Setting customLabel0 directly: high_rank
[2025-11-10 20:54:13] Method 2: Set customLabel0 via reflection: high_rank
[2025-11-10 20:54:13] Method 3: Added custom_label_0 as custom attribute: high_rank
[2025-11-10 20:54:13] Setting availability: in_stock
[2025-11-10 20:54:13] Setting shipping options: Standard (£3.99) and Expedited (£5.99)
[2025-11-10 20:54:13] Setting condition: new (from original: New)
[2025-11-10 20:54:13] Setting brand: Award Publications Ltd
[2025-11-10 20:54:13] Setting valid GTIN: 9781841351407
[2025-11-10 20:54:13] Sending product data to Google: { "additionalImageLinks": null, "additionalSizeType": null, "adsGrouping": null, "adsLabels": null, "adsRedirect": null, "adult": null, "ageGroup": null, "availability": "in_stock", "availabilityDate": null, "brand": "Award Publications Ltd", "canonicalLink": null, "channel": "online", "color": null, "condition": "new", "contentLanguage": "en", "customLabel0": "high_rank", "customLabel1": null, "customLabel2": null, "customLabel3": null, "customLabel4": null, "description": "Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11): No description available. Condition: New - NewItem. ISBN: 9781841351407. Available from AZ Books, trusted seller of quality books. We offer fast shipping and excellent customer service.", "disclosureDate": null, "displayAdsId": null, "displayAdsLink": null, "displayAdsSimilarIds": null, "displayAdsTitle": null, "displayAdsValue": null, "energyEfficiencyClass": null, "excludedDestinations": null, "expirationDate": null, "externalSellerId": null, "feedLabel": null, "gender": null, "googleProductCategory": "784", "gtin": "9781841351407", "id": null, "identifierExists": null, "imageLink": "https:\/\/m.media-amazon.com\/images\/I\/919M9V-t6VL.jpg", "includedDestinations": null, "isBundle": null, "itemGroupId": null, "kind": null, "lifestyleImageLinks": null, "link": "https:\/\/www.azbooks.co.uk\/products\/peronnel-s-magic-polish-enid-blyton-s-popular-rewards-series-11", "linkTemplate": null, "material": null, "maxEnergyEfficiencyClass": null, "maxHandlingTime": null, "minEnergyEfficiencyClass": null, "minHandlingTime": null, "mobileLink": null, "mobileLinkTemplate": null, "mpn": null, "multipack": null, "offerId": "U1-S-AF-new_VLSVHTWWD", "pattern": null, "pause": null, "pickupMethod": null, "pickupSla": null, "productHighlights": [ "Condition: New - NewItem", "ISBN: 9781841351407", "Author\/Publisher: Award Publications Ltd", "Quality second-hand books shipped from the UK" ], "productTypes": [ "Books", "Literature & Fiction" ], "promotionIds": null, "salePriceEffectiveDate": null, "sellOnGoogleQuantity": null, "shippingLabel": null, "shoppingAdsExcludedCountries": null, "sizeSystem": null, "sizeType": null, "sizes": null, "source": null, "targetCountry": "GB", "taxCategory": null, "title": "Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11) by Award Publications Ltd", "transitTimeLabel": null, "virtualModelLink": null, "price": { "currency": "GBP", "value": "9.12" }, "customAttributes": [ { "name": "condition", "value": "New - NewItem" }, { "name": "custom_label_0", "value": "high_rank" } ], "shipping": [ { "country": "GB", "locationGroupName": null, "locationId": null, "maxHandlingTime": null, "maxTransitTime": null, "minHandlingTime": null, "minTransitTime": null, "postalCode": null, "region": null, "service": "Standard", "price": { "currency": "GBP", "value": "3.99" } }, { "country": "GB", "locationGroupName": null, "locationId": null, "maxHandlingTime": null, "maxTransitTime": null, "minHandlingTime": null, "minTransitTime": null, "postalCode": null, "region": null, "service": "Expedited", "price": { "currency": "GBP", "value": "5.99" } } ], "shippingWeight": { "unit": "kg", "value": 0.5 } }

Debug Information for Product ID: 51

Product Title: Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11)

Amazon Product ID: 107556

ISBN/GTIN: 9781841351407 (Valid 13-digit GTIN)

Original Title: Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11)

Enhanced Title: Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11) by Award Publications Ltd (Added author)

Original Condition: New - NewItem

Google Condition: new (exact match)

Description Length: 252 characters (Good length)

Description: Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11): No description available. Conditi...

Custom Label: high_rank (Based on sales rank: 4556613)

Image URL: https://m.media-amazon.com/images/I/919M9V-t6VL.jpg

Image Source: Amazon Images

[2025-11-10 20:54:14] Product (Offer ID: U1-S-AF-new_VLSVHTWWD) uploaded successfully
[2025-11-10 20:54:14] customLabel0 is NOT in the response
[2025-11-10 20:54:14] imageLink is NOT in the response
[2025-11-10 20:54:14] Attempting to get product from Google with ID: online:en:GB:U1-S-AF-new_VLSVHTWWD
[2025-11-10 20:54:14] Retrieved product from Google: {"additionalImageLinks":null,"additionalSizeType":null,"adsGrouping":null,"adsLabels":null,"adsRedirect":null,"adult":null,"ageGroup":null,"availability":"in stock","availabilityDate":null,"brand":"Award Publications Ltd","canonicalLink":null,"channel":"online","color":null,"condition":"new","contentLanguage":"en","customLabel0":"high_rank","customLabel1":null,"customLabel2":null,"customLabel3":null,"customLabel4":null,"description":"Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11): No description available. Condition: New - NewItem. ISBN: 9781841351407. Available from AZ Books, trusted seller of quality books. We offer fast shipping and excellent customer service.","disclosureDate":null,"displayAdsId":null,"displayAdsLink":null,"displayAdsSimilarIds":null,"displayAdsTitle":null,"displayAdsValue":null,"energyEfficiencyClass":null,"excludedDestinations":null,"expirationDate":null,"externalSellerId":null,"feedLabel":"GB","gender":null,"googleProductCategory":"784","gtin":"9781841351407","id":"online:en:GB:U1-S-AF-new_VLSVHTWWD","identifierExists":null,"imageLink":"https:\/\/m.media-amazon.com\/images\/I\/919M9V-t6VL.jpg","includedDestinations":null,"isBundle":null,"itemGroupId":null,"kind":"content#product","lifestyleImageLinks":null,"link":"https:\/\/www.azbooks.co.uk\/products\/peronnel-s-magic-polish-enid-blyton-s-popular-rewards-series-11","linkTemplate":null,"material":null,"maxEnergyEfficiencyClass":null,"maxHandlingTime":null,"minEnergyEfficiencyClass":null,"minHandlingTime":null,"mobileLink":null,"mobileLinkTemplate":null,"mpn":null,"multipack":null,"offerId":"U1-S-AF-new_VLSVHTWWD","pattern":null,"pause":null,"pickupMethod":null,"pickupSla":null,"productHighlights":["Condition: New - NewItem","ISBN: 9781841351407","Author\/Publisher: Award Publications Ltd","Quality second-hand books shipped from the UK"],"productTypes":["Books","Literature & Fiction"],"promotionIds":null,"salePriceEffectiveDate":null,"sellOnGoogleQuantity":null,"shippingLabel":null,"shoppingAdsExcludedCountries":null,"sizeSystem":null,"sizeType":null,"sizes":null,"source":"api","targetCountry":"GB","taxCategory":null,"title":"Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11) by Award Publications Ltd","transitTimeLabel":null,"virtualModelLink":null,"price":{"currency":"GBP","value":"9.12"},"shipping":[{"country":"GB","locationGroupName":null,"locationId":null,"maxHandlingTime":null,"maxTransitTime":null,"minHandlingTime":null,"minTransitTime":null,"postalCode":null,"region":null,"service":"Standard","price":{"currency":"GBP","value":"3.99"}},{"country":"GB","locationGroupName":null,"locationId":null,"maxHandlingTime":null,"maxTransitTime":null,"minHandlingTime":null,"minTransitTime":null,"postalCode":null,"region":null,"service":"Expedited","price":{"currency":"GBP","value":"5.99"}}],"shippingWeight":{"unit":"kg","value":0.5},"customAttributes":[{"name":"update type","value":"merge"}]}
[2025-11-10 20:54:14] customLabel0 is in the retrieved product: high_rank
[2025-11-10 20:54:14] imageLink is in the retrieved product: https://m.media-amazon.com/images/I/919M9V-t6VL.jpg
[2025-11-10 20:54:14] Attempting to update product with ID: online:en:GB:U1-S-AF-new_VLSVHTWWD
[2025-11-10 20:54:15] Updated product: {"additionalImageLinks":null,"additionalSizeType":null,"adsGrouping":null,"adsLabels":null,"adsRedirect":null,"adult":null,"ageGroup":null,"availability":null,"availabilityDate":null,"brand":null,"canonicalLink":null,"channel":"online","color":null,"condition":null,"contentLanguage":"en","customLabel0":null,"customLabel1":null,"customLabel2":null,"customLabel3":null,"customLabel4":null,"description":null,"disclosureDate":null,"displayAdsId":null,"displayAdsLink":null,"displayAdsSimilarIds":null,"displayAdsTitle":null,"displayAdsValue":null,"energyEfficiencyClass":null,"excludedDestinations":null,"expirationDate":null,"externalSellerId":null,"feedLabel":"GB","gender":null,"googleProductCategory":null,"gtin":null,"id":"online:en:GB:U1-S-AF-new_VLSVHTWWD","identifierExists":null,"imageLink":null,"includedDestinations":null,"isBundle":null,"itemGroupId":null,"kind":"content#product","lifestyleImageLinks":null,"link":null,"linkTemplate":null,"material":null,"maxEnergyEfficiencyClass":null,"maxHandlingTime":null,"minEnergyEfficiencyClass":null,"minHandlingTime":null,"mobileLink":null,"mobileLinkTemplate":null,"mpn":null,"multipack":null,"offerId":"U1-S-AF-new_VLSVHTWWD","pattern":null,"pause":null,"pickupMethod":null,"pickupSla":null,"productHighlights":null,"productTypes":null,"promotionIds":null,"salePriceEffectiveDate":null,"sellOnGoogleQuantity":null,"shippingLabel":null,"shoppingAdsExcludedCountries":null,"sizeSystem":null,"sizeType":null,"sizes":null,"source":null,"targetCountry":"GB","taxCategory":null,"title":null,"transitTimeLabel":null,"virtualModelLink":null}
[2025-11-10 20:54:15] customLabel0 is NOT in the updated product
[2025-11-10 20:54:15] imageLink is NOT in the updated product
[2025-11-10 20:54:15] Upload details saved to database (ID: 172061)
[2025-11-10 20:54:15] Updated shopify_product_imports record (ID: 51) with added_google_merch = 1

Google API Response for Product: Peronnel's Magic Polish (Enid Blyton's Popular Rewards Series 11)

Offer ID: U1-S-AF-new_VLSVHTWWD

Upload ID: 172061

Image:

Image source: Amazon Images

Custom Label (Sales Rank): high_rank

Sales Rank: 4556613

Set as customLabel0 in the API

{
    "additionalImageLinks": null,
    "additionalSizeType": null,
    "adsGrouping": null,
    "adsLabels": null,
    "adsRedirect": null,
    "adult": null,
    "ageGroup": null,
    "availability": null,
    "availabilityDate": null,
    "brand": null,
    "canonicalLink": null,
    "channel": "online",
    "color": null,
    "condition": null,
    "contentLanguage": "en",
    "customLabel0": null,
    "customLabel1": null,
    "customLabel2": null,
    "customLabel3": null,
    "customLabel4": null,
    "description": null,
    "disclosureDate": null,
    "displayAdsId": null,
    "displayAdsLink": null,
    "displayAdsSimilarIds": null,
    "displayAdsTitle": null,
    "displayAdsValue": null,
    "energyEfficiencyClass": null,
    "excludedDestinations": null,
    "expirationDate": null,
    "externalSellerId": null,
    "feedLabel": "GB",
    "gender": null,
    "googleProductCategory": null,
    "gtin": null,
    "id": "online:en:GB:U1-S-AF-new_VLSVHTWWD",
    "identifierExists": null,
    "imageLink": null,
    "includedDestinations": null,
    "isBundle": null,
    "itemGroupId": null,
    "kind": "content#product",
    "lifestyleImageLinks": null,
    "link": null,
    "linkTemplate": null,
    "material": null,
    "maxEnergyEfficiencyClass": null,
    "maxHandlingTime": null,
    "minEnergyEfficiencyClass": null,
    "minHandlingTime": null,
    "mobileLink": null,
    "mobileLinkTemplate": null,
    "mpn": null,
    "multipack": null,
    "offerId": "U1-S-AF-new_VLSVHTWWD",
    "pattern": null,
    "pause": null,
    "pickupMethod": null,
    "pickupSla": null,
    "productHighlights": null,
    "productTypes": null,
    "promotionIds": null,
    "salePriceEffectiveDate": null,
    "sellOnGoogleQuantity": null,
    "shippingLabel": null,
    "shoppingAdsExcludedCountries": null,
    "sizeSystem": null,
    "sizeType": null,
    "sizes": null,
    "source": null,
    "targetCountry": "GB",
    "taxCategory": null,
    "title": null,
    "transitTimeLabel": null,
    "virtualModelLink": null
}
[2025-11-10 20:54:15] Upload complete
[2025-11-10 20:54:15] Total products processed: 1
[2025-11-10 20:54:15] Successfully uploaded: 1
[2025-11-10 20:54:15] Errors: 0

Google Merchant Center Upload

Google Merchant Center Requirements: The following validations are now applied to meet Google's requirements:

1. GTIN/ISBN Handling:

2. Description Enhancement:

3. Condition Mapping:

Image Selection: Images are selected in the following priority:

  1. Amazon Images: High-quality images from amazon_product_images table (width >= 500px)
  2. Shopify Images: Images from the shopify_product_imports table
  3. Default Image: Fallback to the default book image if no other images are available

Custom Label Assignment:

Debug Information: Extra debugging is now displayed for each product, showing validation status for GTIN, condition, and description length.

Reset Upload Flags Use this to make all products available for upload again

Recent Uploads

ID Product ID Shopify Product ID Offer ID Status Response/Error Timestamp Actions
172061 51 10460464677128 U1-S-AF-new_VLSVHTWWD success 
{
    "id": "online:en:GB:U1-S-AF-new_VLSVHTWWD",
    "offerId": "U1-S-AF-new_VLSVHTWWD",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-10 20:54:15
172060 53 10460465037576 uln_AMQQNPQTXB success 
{
    "id": "online:en:GB:uln_AMQQNPQTXB",
    "offerId": "uln_AMQQNPQTXB",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-09 04:58:07
172059 52 10460464906504 U1-S-AG-uln_ZRQSRNCUAT success 
{
    "id": "online:en:GB:U1-S-AG-uln_ZRQSRNCUAT",
    "offerId": "U1-S-AG-uln_ZRQSRNCUAT",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-08 19:23:58
172058 51 10460464677128 U1-S-AF-new_VLSVHTWWD success 
{
    "id": "online:en:GB:U1-S-AF-new_VLSVHTWWD",
    "offerId": "U1-S-AF-new_VLSVHTWWD",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-07 18:46:40
172057 52 10460464906504 U1-S-AG-uln_ZRQSRNCUAT success 
{
    "id": "online:en:GB:U1-S-AG-uln_ZRQSRNCUAT",
    "offerId": "U1-S-AG-uln_ZRQSRNCUAT",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-06 08:55:19
172056 51 10460464677128 U1-S-AF-new_VLSVHTWWD success 
{
    "id": "online:en:GB:U1-S-AF-new_VLSVHTWWD",
    "offerId": "U1-S-AF-new_VLSVHTWWD",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-05 04:56:10
172055 51 10460464677128 U1-S-AF-new_VLSVHTWWD success 
{
    "id": "online:en:GB:U1-S-AF-new_VLSVHTWWD",
    "offerId": "U1-S-AF-new_VLSVHTWWD",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-04 07:17:45
172054 54 10460465201416 U1-S-AK-new_IFJOSMKRLG success 
{
    "id": "online:en:GB:U1-S-AK-new_IFJOSMKRLG",
    "offerId": "U1-S-AK-new_IFJOSMKRLG",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-03 22:33:07
172053 53 10460465037576 uln_AMQQNPQTXB success 
{
    "id": "online:en:GB:uln_AMQQNPQTXB",
    "offerId": "uln_AMQQNPQTXB",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-03 19:45:41
172052 52 10460464906504 U1-S-AG-uln_ZRQSRNCUAT success 
{
    "id": "online:en:GB:U1-S-AG-uln_ZRQSRNCUAT",
    "offerId": "U1-S-AG-uln_ZRQSRNCUAT",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-03 16:24:56
172051 51 10460464677128 U1-S-AF-new_VLSVHTWWD success 
{
    "id": "online:en:GB:U1-S-AF-new_VLSVHTWWD",
    "offerId": "U1-S-AF-new_VLSVHTWWD",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-03 10:46:01
172050 51 10460464677128 U1-S-AF-new_VLSVHTWWD success 
{
    "id": "online:en:GB:U1-S-AF-new_VLSVHTWWD",
    "offerId": "U1-S-AF-new_VLSVHTWWD",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-03 05:11:12
172049 191 10460501016840 U1-S-EJ-uln_FZAZRWGERN success 
{
    "id": "online:en:GB:U1-S-EJ-uln_FZAZRWGERN",
    "offerId": "U1-S-EJ-uln_FZAZRWGERN",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-01 12:59:34
172048 190 10460500918536 U1-S-EJ-new_OIEVFUTJD success 
{
    "id": "online:en:GB:U1-S-EJ-new_OIEVFUTJD",
    "offerId": "U1-S-EJ-new_OIEVFUTJD",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-01 11:18:05
172047 190 10460500918536 U1-S-EJ-new_OIEVFUTJD success 
{
    "id": "online:en:GB:U1-S-EJ-new_OIEVFUTJD",
    "offerId": "U1-S-EJ-new_OIEVFUTJD",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-01 11:18:04
172046 189 10460500820232 U1-S-EJ-new_LRBCGWSJWO success 
{
    "id": "online:en:GB:U1-S-EJ-new_LRBCGWSJWO",
    "offerId": "U1-S-EJ-new_LRBCGWSJWO",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-01 11:18:03
172045 188 10460500721928 U1-S-EJ-new_QLQCNSNNL success 
{
    "id": "online:en:GB:U1-S-EJ-new_QLQCNSNNL",
    "offerId": "U1-S-EJ-new_QLQCNSNNL",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-01 11:18:02
172044 187 10460500623624 U1-S-EJ-au_USXFVTVDEO success 
{
    "id": "online:en:GB:U1-S-EJ-au_USXFVTVDEO",
    "offerId": "U1-S-EJ-au_USXFVTVDEO",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-01 11:18:01
172043 185 10460497969416 U1-S-EJ-uvg_ZDZUBMUKUW success 
{
    "id": "online:en:GB:U1-S-EJ-uvg_ZDZUBMUKUW",
    "offerId": "U1-S-EJ-uvg_ZDZUBMUKUW",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-01 11:18:00
172041 184 10460497805576 U1-S-EJ-au_NZNLHGTZ success 
{
    "id": "online:en:GB:U1-S-EJ-au_NZNLHGTZ",
    "offerId": "U1-S-EJ-au_NZNLHGTZ",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-11-01 11:17:59

Products available for upload: 15748

Note about Custom Labels and Images: 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.