[2025-12-25 23:23:52] Starting Google Merchant Center upload process
[2025-12-25 23:23:52] Processing limit: 1 products
[2025-12-25 23:23:52] Autoloader found at: /var/www/html/vendor/autoload.php
[2025-12-25 23:23:52] Service account authentication configured successfully using file
[2025-12-25 23:23:52] Shopping Content service initialized successfully
[2025-12-25 23:23:52] Using Merchant ID: 5554354645
[2025-12-25 23:23:52] Found 1 products to process
[2025-12-25 23:23:52] Enhanced title with author: Hitler's Field Marshals and Their Battles by Grafton
[2025-12-25 23:23:52] Extended description: Hitler's Field Marshals and Their Battles: No description available. Condition: Used – Very Good - UsedVeryGood. ISBN: 9780586205532. Available from AZ Books, trusted seller of quality books. We offer fast shipping and excellent customer service.
[2025-12-25 23:23:52] Setting link: https://www.azbooks.co.uk/products/hitler-s-field-marshals-and-their-battles
[2025-12-25 23:23:52] Image URL source: Amazon image: https://m.media-amazon.com/images/I/91XhfMkQKRL.jpg
✅ Using Amazon Image: https://m.media-amazon.com/images/I/91XhfMkQKRL.jpg
[2025-12-25 23:23:52] Setting image link: https://m.media-amazon.com/images/I/91XhfMkQKRL.jpg
[2025-12-25 23:23:52] Product sales rank value: 2486
[2025-12-25 23:23:52] Processing sales rank: 2486
[2025-12-25 23:23:52] Method 1: Setting customLabel0 directly: low_rank
[2025-12-25 23:23:52] Method 2: Set customLabel0 via reflection: low_rank
[2025-12-25 23:23:52] Method 3: Added custom_label_0 as custom attribute: low_rank
[2025-12-25 23:23:52] Setting availability: in_stock
[2025-12-25 23:23:52] Setting shipping options: Standard (£3.99) and Expedited (£5.99)
[2025-12-25 23:23:52] Setting condition: used (from original: Used – Very Good)
[2025-12-25 23:23:52] Setting brand: Grafton
[2025-12-25 23:23:52] Setting valid GTIN: 9780586205532
[2025-12-25 23:23:52] 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": "Grafton", "canonicalLink": null, "channel": "online", "color": null, "condition": "used", "contentLanguage": "en", "customLabel0": "low_rank", "customLabel1": null, "customLabel2": null, "customLabel3": null, "customLabel4": null, "description": "Hitler's Field Marshals and Their Battles: No description available. Condition: Used \u2013 Very Good - UsedVeryGood. ISBN: 9780586205532. 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": "9780586205532", "id": null, "identifierExists": null, "imageLink": "https:\/\/m.media-amazon.com\/images\/I\/91XhfMkQKRL.jpg", "includedDestinations": null, "isBundle": null, "itemGroupId": null, "kind": null, "lifestyleImageLinks": null, "link": "https:\/\/www.azbooks.co.uk\/products\/hitler-s-field-marshals-and-their-battles", "linkTemplate": null, "material": null, "maxEnergyEfficiencyClass": null, "maxHandlingTime": null, "minEnergyEfficiencyClass": null, "minHandlingTime": null, "mobileLink": null, "mobileLinkTemplate": null, "mpn": null, "multipack": null, "offerId": "U1-S-I-uvg_RSNXLZDECK", "pattern": null, "pause": null, "pickupMethod": null, "pickupSla": null, "productHighlights": [ "Condition: Used \u2013 Very Good - UsedVeryGood", "ISBN: 9780586205532", "Author\/Publisher: Grafton", "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": "Hitler's Field Marshals and Their Battles by Grafton", "transitTimeLabel": null, "virtualModelLink": null, "price": { "currency": "GBP", "value": "3.80" }, "customAttributes": [ { "name": "condition", "value": "Used \u2013 Very Good - UsedVeryGood" }, { "name": "custom_label_0", "value": "low_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: 6398

Product Title: Hitler's Field Marshals and Their Battles

Amazon Product ID: 118964

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

Original Title: Hitler's Field Marshals and Their Battles

Enhanced Title: Hitler's Field Marshals and Their Battles by Grafton (Added author)

Original Condition: Used – Very Good - UsedVeryGood

Google Condition: used (mapped from "Used – Very Good" - special case)

Description Length: 248 characters (Good length)

Description: Hitler's Field Marshals and Their Battles: No description available. Condition: Used – Very Good -...

Custom Label: low_rank (Based on sales rank: 2486)

Image URL: https://m.media-amazon.com/images/I/91XhfMkQKRL.jpg

Image Source: Amazon Images

[2025-12-25 23:23:53] Product (Offer ID: U1-S-I-uvg_RSNXLZDECK) uploaded successfully
[2025-12-25 23:23:53] customLabel0 is NOT in the response
[2025-12-25 23:23:53] imageLink is NOT in the response
[2025-12-25 23:23:53] Attempting to get product from Google with ID: online:en:GB:U1-S-I-uvg_RSNXLZDECK
[2025-12-25 23:23:54] Retrieved product from Google: {"additionalImageLinks":null,"additionalSizeType":null,"adsGrouping":null,"adsLabels":null,"adsRedirect":null,"adult":null,"ageGroup":null,"availability":"in stock","availabilityDate":null,"brand":"Grafton","canonicalLink":null,"channel":"online","color":null,"condition":"used","contentLanguage":"en","customLabel0":"low_rank","customLabel1":null,"customLabel2":null,"customLabel3":null,"customLabel4":null,"description":"Hitler's Field Marshals and Their Battles: No description available. Condition: Used \u2013 Very Good - UsedVeryGood. ISBN: 9780586205532. 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":"9780586205532","id":"online:en:GB:U1-S-I-uvg_RSNXLZDECK","identifierExists":null,"imageLink":"https:\/\/m.media-amazon.com\/images\/I\/91XhfMkQKRL.jpg","includedDestinations":null,"isBundle":null,"itemGroupId":null,"kind":"content#product","lifestyleImageLinks":null,"link":"https:\/\/www.azbooks.co.uk\/products\/hitler-s-field-marshals-and-their-battles","linkTemplate":null,"material":null,"maxEnergyEfficiencyClass":null,"maxHandlingTime":null,"minEnergyEfficiencyClass":null,"minHandlingTime":null,"mobileLink":null,"mobileLinkTemplate":null,"mpn":null,"multipack":null,"offerId":"U1-S-I-uvg_RSNXLZDECK","pattern":null,"pause":null,"pickupMethod":null,"pickupSla":null,"productHighlights":["Condition: Used \u2013 Very Good - UsedVeryGood","ISBN: 9780586205532","Author\/Publisher: Grafton","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":"Hitler's Field Marshals and Their Battles by Grafton","transitTimeLabel":null,"virtualModelLink":null,"price":{"currency":"GBP","value":"3.80"},"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}}
[2025-12-25 23:23:54] customLabel0 is in the retrieved product: low_rank
[2025-12-25 23:23:54] imageLink is in the retrieved product: https://m.media-amazon.com/images/I/91XhfMkQKRL.jpg
[2025-12-25 23:23:54] Attempting to update product with ID: online:en:GB:U1-S-I-uvg_RSNXLZDECK
[2025-12-25 23:23:55] 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-I-uvg_RSNXLZDECK","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-I-uvg_RSNXLZDECK","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-12-25 23:23:55] customLabel0 is NOT in the updated product
[2025-12-25 23:23:55] imageLink is NOT in the updated product
[2025-12-25 23:23:55] Upload details saved to database (ID: 1154)
[2025-12-25 23:23:55] Updated shopify_product_imports record (ID: 6398) with added_google_merch = 1

Google API Response for Product: Hitler's Field Marshals and Their Battles

Offer ID: U1-S-I-uvg_RSNXLZDECK

Upload ID: 1154

Image:

Image source: Amazon Images

Custom Label (Sales Rank): low_rank

Sales Rank: 2486

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-I-uvg_RSNXLZDECK",
    "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-I-uvg_RSNXLZDECK",
    "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-12-25 23:23:55] Upload complete
[2025-12-25 23:23:55] Total products processed: 1
[2025-12-25 23:23:55] Successfully uploaded: 1
[2025-12-25 23:23:55] 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
1154 6398 10666018799880 U1-S-I-uvg_RSNXLZDECK success 
{
    "id": "online:en:GB:U1-S-I-uvg_RSNXLZDECK",
    "offerId": "U1-S-I-uvg_RSNXLZDECK",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:23:55
1153 6397 10666018603272 U1-S-I-new_ZRSSRQUUTY success 
{
    "id": "online:en:GB:U1-S-I-new_ZRSSRQUUTY",
    "offerId": "U1-S-I-new_ZRSSRQUUTY",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:23:04
1152 6397 10666018603272 U1-S-I-new_ZRSSRQUUTY success 
{
    "id": "online:en:GB:U1-S-I-new_ZRSSRQUUTY",
    "offerId": "U1-S-I-new_ZRSSRQUUTY",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:23:03
1151 6395 10666018570504 U1-S-I-new_NASOLVEEGX success 
{
    "id": "online:en:GB:U1-S-I-new_NASOLVEEGX",
    "offerId": "U1-S-I-new_NASOLVEEGX",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:23:02
1150 6395 10666018570504 U1-S-I-new_NASOLVEEGX success 
{
    "id": "online:en:GB:U1-S-I-new_NASOLVEEGX",
    "offerId": "U1-S-I-new_NASOLVEEGX",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:23:02
1149 6392 10666018504968 U1-S-I-uln_XPYSGOSYUS success 
{
    "id": "online:en:GB:U1-S-I-uln_XPYSGOSYUS",
    "offerId": "U1-S-I-uln_XPYSGOSYUS",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:22:06
1148 6392 10666018504968 U1-S-I-uln_XPYSGOSYUS success 
{
    "id": "online:en:GB:U1-S-I-uln_XPYSGOSYUS",
    "offerId": "U1-S-I-uln_XPYSGOSYUS",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:22:05
1147 6392 10666018504968 U1-S-I-uln_XPYSGOSYUS success 
{
    "id": "online:en:GB:U1-S-I-uln_XPYSGOSYUS",
    "offerId": "U1-S-I-uln_XPYSGOSYUS",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:22:05
1146 6391 10666018406664 U1-S-I-au_UBHTDXKWWX success 
{
    "id": "online:en:GB:U1-S-I-au_UBHTDXKWWX",
    "offerId": "U1-S-I-au_UBHTDXKWWX",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:22:04
1145 6391 10666018406664 U1-S-I-au_UBHTDXKWWX success 
{
    "id": "online:en:GB:U1-S-I-au_UBHTDXKWWX",
    "offerId": "U1-S-I-au_UBHTDXKWWX",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:22:03
1144 6390 10666018341128 U1-S-I-uvg_CKTTVTZRDC success 
{
    "id": "online:en:GB:U1-S-I-uvg_CKTTVTZRDC",
    "offerId": "U1-S-I-uvg_CKTTVTZRDC",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:21:08
1143 6390 10666018341128 U1-S-I-uvg_CKTTVTZRDC success 
{
    "id": "online:en:GB:U1-S-I-uvg_CKTTVTZRDC",
    "offerId": "U1-S-I-uvg_CKTTVTZRDC",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:21:07
1142 6390 10666018341128 U1-S-I-uvg_CKTTVTZRDC success 
{
    "id": "online:en:GB:U1-S-I-uvg_CKTTVTZRDC",
    "offerId": "U1-S-I-uvg_CKTTVTZRDC",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:21:07
1141 6389 10666018308360 U1-S-I-uln_EDMRPLGOGC success 
{
    "id": "online:en:GB:U1-S-I-uln_EDMRPLGOGC",
    "offerId": "U1-S-I-uln_EDMRPLGOGC",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:21:06
1140 6389 10666018308360 U1-S-I-uln_EDMRPLGOGC success 
{
    "id": "online:en:GB:U1-S-I-uln_EDMRPLGOGC",
    "offerId": "U1-S-I-uln_EDMRPLGOGC",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:21:05
1139 6389 10666018308360 U1-S-I-uln_EDMRPLGOGC success 
{
    "id": "online:en:GB:U1-S-I-uln_EDMRPLGOGC",
    "offerId": "U1-S-I-uln_EDMRPLGOGC",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:21:04
1138 6389 10666018308360 U1-S-I-uln_EDMRPLGOGC success 
{
    "id": "online:en:GB:U1-S-I-uln_EDMRPLGOGC",
    "offerId": "U1-S-I-uln_EDMRPLGOGC",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:21:03
1137 6389 10666018308360 U1-S-I-uln_EDMRPLGOGC success 
{
    "id": "online:en:GB:U1-S-I-uln_EDMRPLGOGC",
    "offerId": "U1-S-I-uln_EDMRPLGOGC",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:21:02
1136 6388 10666018242824 U1-S-I-new_CNSDIRWOCU success 
{
    "id": "online:en:GB:U1-S-I-new_CNSDIRWOCU",
    "offerId": "U1-S-I-new_CNSDIRWOCU",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:20:05
1135 6388 10666018242824 U1-S-I-new_CNSDIRWOCU success 
{
    "id": "online:en:GB:U1-S-I-new_CNSDIRWOCU",
    "offerId": "U1-S-I-new_CNSDIRWOCU",
    "targetCountry": "GB",
    "contentLanguage": "en"
}
 2025-12-25 23:20:04

Products available for upload: 1

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.