How to prepare a product CSV with variants and images so the import doesn't half-fail

The import finishes, the screen says it worked, and then the catalog tells a different story: variable products with no variations attached, a few product names with ä in them, and images that resolv