Importing Multiple Fulfillment Requests Using a Spreadsheet

Creating fulfillment requests manually can be a pain when you have dozens, or hundreds of customer orders to fulfill.  In this article, we’ll cover how to upload many requests at once using a spreadsheet, along with a spreadsheet template to start out with.

Import a CSV/TSV

You can import a list of customers using a comma-delimited (CSV) or tab-delimited (TSV) file with the format described below. Files must end with an extension of .csv (for comma-delimited files) or .tsv (for tab-delimited files).

To format your file correctly, be sure you include following columns, in this order.  Every column must be present, but for columns not marked with an asterisk (*) below, they may have empty values depending on where the shipment will be delivered.

  • Customer Name*
  • Company
  • Phone Number (required for intnerational orders)
  • Email Address
  • PO number
  • Address Line 1*
  • Address Line 2
  • City*
  • State/Province
  • Postal Code*
  • Country (ISO 3166-2 Code)*
  • Future Expansion (leave column blank)
  • Future Expansion (leave column blank)
  • Future Expansion (leave column blank)
  • Future Expansion (leave column blank)
  • Customs Value (must start with $)
  • Preferred Carrier (USPS, DHL, UPS)
  • Preferred Service (i.e. 2ndDayAir)
  • Product SKU 1*
  • Unit Count 1*
  • Product SKU 2
  • Unit Count 2

For international shipments, you must provide a phone number, or the package will not be deliverable. For countries where a State or Province is typically required in the address, the State/Province column must be populated.

The first line of the file will be treated as headers, and not used.  The following is an example of a properly formatted import file:

Basic Contact Info

The first set of fields include the standard customer info: name, company, phone, address, etc. Be cautious about using international characters here, as they may be misinterpreted during label printing.  In nearly all occasions, you should use standard ASCII characters only.

Phone numbers are required by USPS and UPS for international orders.

Product Info

After the customer’s contact info, you’ll include information about the product(s) to be included in the shipment. Make sure you use the exact SKU (case-sensitive) as you have it written on the Product page.

If a customer is buying multiple products at once, don’t create new row for each product as this will create multiple shipments. Instead, you should repeat the Product SKU and Unit Count columns for each unique SKU to add to the order. (See the example above, which shows two unique products in one order.)

Setting the Customs Value for international customers is the declared the value you want to provide so you can specify the sales price to the customer instead of the default price associated with the given product(s).  Warning: your shipment will be insured for this amount, for those methods that support insurance, and if you set the value too low you may not be able to recoup the full costs of the product should the package be lost.