The 7 weirdest Shopify CSV export quirks (and how we handle them)

Shopify’s order CSV is the most-used export format in ecommerce. It’s also a moving target.

The 7 quirks

• "Name" is the order number. Not the customer name.
• "Shipping Province" is what the rest of the world calls "state".
• Multi-line orders repeat the order rows with blank Shipping fields on lines 2+.
• Weight column is in grams unless you’ve toggled the unit setting.
• Currency conversion fields appear and disappear based on multi-currency settings.
• "Email" is the buyer’s email; the actual ship-to email is in shipping notes if at all.
• Subscription orders use a totally different export format.

Our column aliases library knows all seven. Drop a Shopify CSV and the mapper gets it right on the first try.