How to Upload Orders to Shippo via CSV

CSV upload lets you import a large number of orders into Shippo to create shipping labels. It's especially useful if you use an ecommerce store Shippo doesn't directly support. This guide covers common upload errors and walks through uploading a CSV step by step.

Common errors

If you've run into upload errors before, or a file you just uploaded didn't go through, there's usually an easy fix. A few reminders to get you back on track:

• Correctly formatted fields are essential. Missing or incorrect fields are the most common reason an upload fails. See below for the full list of required, recommended, and optional fields.
• Before you upload, make sure all 8 required fields are filled in with the correct format.
• Check your header row for trailing spaces, like "Orders " instead of "Orders." Trailing spaces will stop the file from uploading.

Upload orders via CSV

To upload your orders via CSV:

• Create your CSV file in Google Sheets or Excel. See below for the required, recommended, and optional fields.
• Click Upload CSV at the top right of the Orders page.
• Drag your CSV file in, or click Select File to choose it.
• Match each CSV column to the right Shippo category, then click Upload.

Your orders will then appear on the Orders page.

• After you upload, you'll get a summary email showing how many orders succeeded and how many didn't, along with any error messages.
• If there are errors, edit your CSV and re-upload just the orders that failed.
• You can save your field mappings as a template so future uploads go faster.

Need a single order with multiple line items? Duplicate the row and update just the item-specific information. See this sample with one order containing two items.

Required, recommended, and optional fields

Your CSV needs to use the required fields listed below for your file to upload correctly.

Required fields:

• Recipient name
• Street line 1
• Postal/ZIP code: For the few countries without postal codes, like Hong Kong and Ireland, import a placeholder code, such as 00000.
• City
• State: U.S. domestic shipments require a two-letter state code (see state abbreviations). Some other countries also require state information; see this list for details.
• Country: Use the 2-character country code (see ISO 3166-1 alpha-2 codes).
• Recipient email: If you don't have the customer's email, use your own. Entering "N/A" causes an error.
• Phone number: Only required for international shipments via FedEx, UPS, or USPS Priority Mail Express. If you don't know the customer's number, use your own.

Recommended fields:

• Order number: Helps you identify each order, and can display on packing slips and shipping labels (45-character limit).
• Total order weight and weight unit: Pre-fills the package weight and allows bulk label creation with differing weights. The value must be a number, and the unit must be "oz," "g," "lb," or "kg."
• Order date: Use the format YYYY-MM-DD. For example, December 1, 2019 would be entered as 2019-12-01.
• Package length, width, height, and dimension unit: Pre-fills the package dimensions. Values must be numbers greater than zero, and the unit must be "in," "cm," or "mm." These fields are optional, but if you use them, all four are required together.

Optional fields:

• Company name
• Street line 2
• Street number: Only required for DHL Germany shipments, which need the house or apartment number separated from the street name. Otherwise, it can be part of Street line 1.
• Total order price and order currency: Price must be a number; currency must be the 3-character code, such as USD.
• Item title
• Item quantity
• SKU number
• Price per item and item price currency: Same format as order price and currency.
• Weight per item and weight unit: Can be used instead of, or alongside, total order weight. If both are included, the weight fields pre-fill. The same format rules apply as total order weight.