We're Here to Help

Spreadsheet Order Entry (.CSV)

One way to add orders to your Shipwire account to be shipped is to upload a spreadsheet in .CSV or .TSV format containing the order information.


Spreadsheet Upload

  1. Sign in to your account.

  2. Under the Orders tab, click “Upload multiple orders”.

  3. Click “Upload Orders”.

  4. Choose the file you wish to upload.

  5. Click the Upload Orders button.


Spreadsheet Format

Your product upload should have the following format:

; This is the Shipwire spreadsheet order upload template. Use it to upload one or more orders at a time.,,,,,,,,,,,,,,,,,,
; -------------------- EXAMPLE ORDERS ----------------,,,,,,,,,,,,,,,,,,
;1000,1/20/12,Marilyn Monroe,1 Hollywood Lane,,,Los Angeles,CA,91111,US,mmonroe@wind.com,323-555-1234,GD,0,diamond,1,Star Power,0,
;1000,1/20/12,Marilyn Monroe,1 Hollywood Lane,,,Los Angeles,CA,91111,US,mmonroe@wind.com,323-555-1234,GD,0,ruby,3,Star Power,0,
;1001,1/20/12,Joe Dimaggio,One East St.,,,Bronx,NY,10452,US,jdimaggio@wind.com,323-555-1234,GD,0,emerald,5,,1,Needs review
; -------------------- NOTES --------------------,,,,,,,,,,,,,,,,,,
; All rows with a leading semi-colon are ignored,,,,,,,,,,,,,,,,,,
; Shipwire accepts a file header row (where column fields are designated with square brackets - e.g. [order_no]). You can put these column names in any order, and choose to include only the fields you care about. Be sure to include all of the required fields",,,,,,,,,,,,,,,,,,
; Valid header column fields include: order_no*, order_date, name*, address_1*, address_2, address_3, city*, state*, zip*, country*, email, phone*, company_name, is_commercial, shipping_method, sku*, quantity*, hold, hold_reason (those marked with an asterisk are required)",,,,,,,,,,,,,,,,,,
; Each first line of an order should have data in all of the required fields,,,,,,,,,,,,,,,,,,
; Each additional line of an order (for orders > 1 unique product) should either repeat all of the same data included in the order header row (as in example above), or alternatively it can be entirely blank with the exception of the sku and quantity fields.",,,,,,,,,,,,,,,,,,
; Each unique product (SKU) should be called out only once per order (i.e. there should not be 2 rows with sku123 called out in it),,,,,,,,,,,,,,,,,,
; Shipwire will assume blank fields are unknown, and use default settings where applicable (e.g. email address)",,,,,,,,,,,,,,,,,,
; Shipping_method options include: 1D, 2D, and GD (for one day, two day and ground service respectively). You can further adjust specific service level mappings in your Shipwire shipping preferences.",,,,,,,,,,,,,,,,,,
; You can set 'is_commercial' to 1 on orders that are known to be commercial (0 or blank will be assumed to be residential),,,,,,,,,,,,,,,,,,
; Although preferred, you do not have to include leading zeroes (if present) on U.S. Zip Codes (e.g. 1233 will be assumed to be 01233) ",,,,,,,,,,,,,,,,,,
; Use company_name to customize the name that appears on your shipping labels, packing list, and confirmation emails on an order by order basis. You can also set this globally (for all orders) using the Shipwire Delight tools. If it is defined in the spreadsheet for a given order, we will override the global setting",,,,,,,,,,,,,,,,,,
; Adding a 1 under the hold field will manually hold any of your uploaded orders until you choose to release them. You can also append a custom reason to describe why you initiated the hold. (0 or blank will be assumed to imply no manual hold requested).,,,,,,,,,,,,,,,,,,
; Add your order details below, and upload when done.",,,,,,,,,,,,,,,,,,
; -------------------- ORDERS  --------------------,,,,,,,,,,,,,,,,,,


You can download the sample files here:
CSV Sample

TLV Sample

Spreadsheet Details

Your upload should have the following header row names and details:

[order_no] – The order number for what is being shipped.

[order_date] – Date of the order. The format should be mm/dd/yy.

[name] – Receiver’s name.

[address_1], [address_2], [address_3] – Address fields for shipping address. If only one line is needed for the address, then the others can be left blank.

[city] – Destination city.

[state] – Destination state.

[zip] – Destination zip code. In case a zip code is fewer than 5 numbers, a leading 0 can be used although it is not mandatory. For example, 1233 is recognized as 01233

[country] – Destination country.

[email] – Receiver’s e-mail.

[phone] – Receiver’s phone number.

[shipping_method] – Selected shipping methods can be 1D for one day, 2D for two day and GD for ground service. You can further adjust specific mapping in your Shipwire preferences.

[is_commercial] – If an address is known to be commercial, input 1 in this field. Otherwise, a 0 means an address is residential.

[sku] – The SKU of the product being shipped.

[quantity] – The number of products being shipped for each SKU.

The order of the columns does not matter, so one way of changing your existing file to fit this format would be to copy and paste each bolded header row name above over your existing header rows in your file, then saving and uploading.

Was this article helpful?  Yes   No

Forgot your password?