Welcome To (Amazon Flat File) Hell! - Part Two: The Solution

In the first post on this subject, entitled Welcome To (Amazon Flat File) Hell! - Part One: The Problem , I detailed my numerous travails encountered whilst attempting to get an Amazon flat file product upload to work. For the second post in this series it seemed naturally fair to present the solution which, after a lot of trial, error and experimentation, provided the concluding "a-ha!" moment to a week of frustration. By the close of the first post, just to recap, I had more-or-less exhausted all of my ideas on how to fix the Amazon 8058 error. Just to remind you: By now I was really up against it in terms of needing to find a solution to this problem. I was only a couple of days away from really needing the SKUs on Amazon so that I could get the first orders placed within our deadline and we weren't very far away from our target date to launch either. In addition, Amazon had recently sent me and the team an internal promotional calendar with details of their planned...