article
All-caps text columns kept getting promoted to stores by the importer
A store sheet had short, all-caps columns full of words, and my importer read them as store codes. The change checks a few cells under each candidate, hunts for the real header row, stops putting made-up prices into orders, and handles one cart crash. The new detection rules still have no test of their own.
Read more