Amazon integration not importaning random batches

I've been struggling for the last 6 months with multiple random batches not importing through the Amazon Seller integration. Support has been no help and continues to make up excuses as to why it doesn't work and have basically told me to figure it out myself. I have at least a half dozen batches and hundreds if not thousands of transactions to import. As a QBO Certified Proadvisor and user of Quickbooks products for over 25 years, I am extremely upset and disappointed but I won't go off on that tangent now. (Shout out to Marggi in support as she has been the only person on my team trying to force the issue. With year-end coming up for my clients, I just can't continue to wait for help.)

I've downloaded the XML file and done my best to convert it into usable data within Excel. I decided to reverse engineer some of the batches that actually came through to make sure I was categorizing everything consistently the integration. Unfortunately, a couple of the numbers on the sales receipt are off by minimal amounts and I can't quite figure out why.

Does anyone have a successful method they've been able to replicate in order to properly categorize the sales data in QBO?