=== AbeBooks Order Fetching Script ===
=== ABEBOOKS API RAW RESPONSE ===
HTTP Code: 200
Response Length: 6182 characters
Raw Response:
--------------------------------------------------------------------------------
<?xml version="1.0" encoding="ISO-8859-1"?>
<orderUpdateResponse version="1.1">
 <purchaseOrderList>
  <purchaseOrder id="714551405">
   <buyer id="86628611">
    <email>c-richmond@sky.com</email>
    <mailingAddress>
     <city>Morecambe</city>
     <code>LA3 1JH</code>
     <country>United Kingdom</country>
     <name>C R Richmond</name>
     <phone>01524749485</phone>
     <region />
     <street>11 Harewood Avenue</street>
     <street2 />
    </mailingAddress>
   </buyer>
   <buyerPurchaseOrder id="757604806" />
   <domain id="46">
    <name>abebooks.co.uk</name>
   </domain>
   <indirectTaxList />
   <orderDate>
    <date>
     <day>24</day>
     <month>12</month>
     <year>2025</year>
    </date>
    <time>
     <hour>12</hour>
     <minute>27</minute>
     <second>45</second>
    </time>
   </orderDate>
   <orderTotals>
    <gst currency="GBP">0.0</gst>
    <handling currency="GBP">0.0</handling>
    <shipping currency="GBP">0.0</shipping>
    <subtotal currency="GBP">3.55</subtotal>
    <tax currency="GBP">0.0</tax>
    <total currency="GBP">3.55</total>
   </orderTotals>
   <purchaseMethod>CC</purchaseMethod>
   <purchaseOrderItemList>
    <purchaseOrderItem id="788154892">
     <book id="32351834671">
      <author>Holton, David</author>
      <description>Free shipping. Dispatch on all orders before 3pm same day. SHOP &amp; WAREHOUSE OVERSTOCK - LOWEST PRICE ONLINE! This book is in New condition - never been read or used. Pages are pristine, binding is tight, and cover shows no wear. This is genuine overstock inventory that allows us to offer new books at the lowest prices available online. Perfect condition at unbeatable value. Please note: Shop spoilt or may show signs of wear from handling and storage. Cover may differ from image - contact us for cover confirmation. New Mint Condition Dispatch same day for order received before 12 noon Guaranteed packaging No quibbles returns Book Details: Publication Date: 1997-09-18 00:00:00 Language: english Weight: 1.60 pounds Seller SKU: U1-S-JH-uvg_RUXBRXYRTM</description>
      <isbn />
      <price currency="GBP">3.55</price>
      <title>Greek: A Comprehensive Grammar of the Modern Langu</title>
      <vendorKey>141789</vendorKey>
     </book>
     <orderDate>
      <date>
       <day>24</day>
       <month>12</month>
       <year>2025</year>
      </date>
      <time>
       <hour>12</hour>
       <minute>27</minute>
       <second>45</second>
      </time>
     </orderDate>
     <purchaseOrder id="714551405" />
     <sellerTotal currency="GBP">3.55</sellerTotal>
     <status code="05">Ordered</status>
    </purchaseOrderItem>
   </purchaseOrderItemList>
   <reseller id="846587">
    <name>Abebooks</name>
   </reseller>
   <seller id="89969041" />
   <shipping>
    <company />
    <extraItemShippingCost currency="GBP">0.0</extraItemShippingCost>
    <firstItemShippingCost currency="GBP">0.0</firstItemShippingCost>
    <maxDeliveryDays>3</maxDeliveryDays>
    <minDeliveryDays>2</minDeliveryDays>
    <trackingCode />
   </shipping>
   <specialInstructions />
   <status code="05">Ordered</status>
  </purchaseOrder>
  <purchaseOrder id="714594121">
   <buyer id="70516959">
    <email>kadiri@blueyonder.co.uk</email>
    <mailingAddress>
     <city>Surrey</city>
     <code>SM1 3AZ</code>
     <country>United Kingdom</country>
     <name>Hafisi Kadiri</name>
     <phone>09740522716</phone>
     <region />
     <street>37 Gassiot Way</street>
     <street2>Sutton</street2>
    </mailingAddress>
   </buyer>
   <buyerPurchaseOrder id="757636340" />
   <domain id="46">
    <name>abebooks.co.uk</name>
   </domain>
   <indirectTaxList />
   <orderDate>
    <date>
     <day>25</day>
     <month>12</month>
     <year>2025</year>
    </date>
    <time>
     <hour>10</hour>
     <minute>14</minute>
     <second>53</second>
    </time>
   </orderDate>
   <orderTotals>
    <gst currency="GBP">0.0</gst>
    <handling currency="GBP">0.0</handling>
    <shipping currency="GBP">0.0</shipping>
    <subtotal currency="GBP">7.5</subtotal>
    <tax currency="GBP">0.0</tax>
    <total currency="GBP">7.5</total>
   </orderTotals>
   <purchaseMethod>CC</purchaseMethod>
   <purchaseOrderItemList>
    <purchaseOrderItem id="788206366">
     <book id="32363398205">
      <author>Okpewho, Isidore</author>
      <description>Free shipping. Dispatch on all orders before 3pm same day. SHOP &amp; WAREHOUSE OVERSTOCK - LOWEST PRICE ONLINE! This book is in New condition - never been read or used. Pages are pristine, binding is tight, and cover shows no wear. This is genuine overstock inventory that allows us to offer new books at the lowest prices available online. Perfect condition at unbeatable value. Please note: Shop spoilt or may show signs of wear from handling and storage. Cover may differ from image - contact us for cover confirmation. Seller SKU: U1-S-0-new_BOZHFNNRAE</description>
      <isbn>9780582102767</isbn>
      <price currency="GBP">7.5</price>
      <title>Tides (Longman African Writers S.)</title>
      <vendorKey>143155</vendorKey>
     </book>
     <orderDate>
      <date>
       <day>25</day>
       <month>12</month>
       <year>2025</year>
      </date>
      <time>
       <hour>10</hour>
       <minute>14</minute>
       <second>53</second>
      </time>
     </orderDate>
     <purchaseOrder id="714594121" />
     <sellerTotal currency="GBP">7.5</sellerTotal>
     <status code="05">Ordered</status>
    </purchaseOrderItem>
   </purchaseOrderItemList>
   <reseller id="846587">
    <name>Abebooks</name>
   </reseller>
   <seller id="89969041" />
   <shipping>
    <company />
    <extraItemShippingCost currency="GBP">0.0</extraItemShippingCost>
    <firstItemShippingCost currency="GBP">0.0</firstItemShippingCost>
    <maxDeliveryDays>3</maxDeliveryDays>
    <minDeliveryDays>2</minDeliveryDays>
    <trackingCode />
   </shipping>
   <specialInstructions />
   <status code="05">Ordered</status>
  </purchaseOrder>
 </purchaseOrderList>
</orderUpdateResponse>


--------------------------------------------------------------------------------
=== END OF RAW RESPONSE ===

DEBUG: Individual Address Fields for Order 714551405:
- Name: C R Richmond
- Email: c-richmond@sky.com
- Street: '11 Harewood Avenue'
- Street2: ''
- City: 'Morecambe'
- Region: ''
- Code: 'LA3 1JH'
- Country: 'United Kingdom'
DEBUG: Combined Address: '11 Harewood Avenue , Morecambe, , LA3 1JH, United Kingdom'
--------------------------------------------------
DEBUG: Processing item - ABEPOID: 714551405, ABEPOITEMID: 788154892, Vendor Key: 141789
DEBUG: Individual Fields Being Saved:
- Phone: '01524749485'
- Address Line 1: '11 Harewood Avenue'
- Address Line 2: ''
- Address Line 3: ''
- City: 'Morecambe'
- State/Region: ''
- Postal Code: 'LA3 1JH'
- Country Code: 'United Kingdom'

DEBUG: Shipping Information:
- Shipping Cost: £0
- First Item Shipping: £0
- Extra Item Shipping: £0
- Subtotal: £3.55
- Total: £3.55
- Paid for Shipping: NO
--------------------------------------------------
DEBUG: Looking up SKU for vendor_key: '141789'
DEBUG: No SKU found, will use vendor_key as fallback
Saved order item: ABEPOID 714551405, ABEPOITEMID 788154892, SKU: 141789
DEBUG: ===== STARTING CROSS-PLATFORM STOCK SYNC =====
DEBUG: Vendor Key: 141789
DEBUG: SKU: 141789
DEBUG: Status: Ordered
DEBUG: Status Code: 05
DEBUG: Attempting immediate AbeBooks DELETE by vendorBookID: 141789
DEBUG: AbeBooks DELETE by vendorBookID result: OK
DEBUG: No valid SKU found for vendor_key: '141789', skipping stock sync
DEBUG: Individual Address Fields for Order 714594121:
- Name: Hafisi Kadiri
- Email: kadiri@blueyonder.co.uk
- Street: '37 Gassiot Way'
- Street2: 'Sutton'
- City: 'Surrey'
- Region: ''
- Code: 'SM1 3AZ'
- Country: 'United Kingdom'
DEBUG: Combined Address: '37 Gassiot Way Sutton, Surrey, , SM1 3AZ, United Kingdom'
--------------------------------------------------
DEBUG: Processing item - ABEPOID: 714594121, ABEPOITEMID: 788206366, Vendor Key: 143155
DEBUG: Individual Fields Being Saved:
- Phone: '09740522716'
- Address Line 1: '37 Gassiot Way'
- Address Line 2: 'Sutton'
- Address Line 3: ''
- City: 'Surrey'
- State/Region: ''
- Postal Code: 'SM1 3AZ'
- Country Code: 'United Kingdom'

DEBUG: Shipping Information:
- Shipping Cost: £0
- First Item Shipping: £0
- Extra Item Shipping: £0
- Subtotal: £7.5
- Total: £7.5
- Paid for Shipping: NO
--------------------------------------------------
DEBUG: Looking up SKU for vendor_key: '143155'
DEBUG: No SKU found, will use vendor_key as fallback
Saved order item: ABEPOID 714594121, ABEPOITEMID 788206366, SKU: 143155
DEBUG: ===== STARTING CROSS-PLATFORM STOCK SYNC =====
DEBUG: Vendor Key: 143155
DEBUG: SKU: 143155
DEBUG: Status: Ordered
DEBUG: Status Code: 05
DEBUG: Attempting immediate AbeBooks DELETE by vendorBookID: 143155
DEBUG: AbeBooks DELETE by vendorBookID result: OK
DEBUG: No valid SKU found for vendor_key: '143155', skipping stock sync
DEBUG: ===== PROCESSING SUMMARY =====
DEBUG: Script completed successfully
DEBUG: Check the debug output above for any issues with Amazon order deletion
Done.