We're Here to Help

Purchase Order Spreadsheet Order Entry (.CSV)

One way to add purchase orders to your Shipwire account to be shipped is to upload a spreadsheet in .CSV, .XLS or .TSV format containing the purchase 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. Confirm that your data follows our field schema to pass validation.

  6. 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 ----------------,,,,,,,,,,,,,,,,,,
;[order_no],[order_date],[name],[address_1],[address_2],[address_3],[city],[state],[zip],[country],[email],[phone],[shipping_method],[is_commercial],[sku],[quantity],[company_name],[hold],[hold_reason]
;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*, external_id, order_date, ship_to_name*, ship_to_address_1*, ship_to_address_2, ship_to_address_3, ship_to_city*, ship_to_state*, ship_to_ZIP*, ship_to_country*, ship_to_email, ship_to_phone*, ship_to_is_commercial, ship_to_company_name, force_ship_to_address, force_duplicate, bill_to_address_1, bill_to_address_2, bill_to_address_3, bill_to_city, bill_to_state, bill_to_ZIP, bill_to_country, bill_to_email, bill_to_phone, bill_to_company_name, sku*, retailer_sku, upc, retailer_line_no, quantity*, shipping_method, packing_list_message_1, shipping_window_type, shipping_window_min_date, shipping_window_max_date, delivery_window_type, delivery_window_min_date, delivery_window_max_date, header_level_extended_attribute_name, header_level_extended_attribute_value, header_level_extended_attribute_type, line_level_extended_attribute_name, line_level_extended_attribute_value, line_level_extended_attribute_type (those marked with an asterisk are required)",,,,,,,,,,,,,,,,,,
; Each first line of an wholesale order should have data in all of the required fields,,,,,,,,,,,,,,,,,,
; Each additional line of an wholesale order (for wholesale 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,,,,,,,,,,,,,,,,,,
; The external ID is an optional 32 character identifier you can use to create your own unique identifier to reference a wholesale order,,,,,,,,,,,,,,,,,,
; Each unique product (SKU) should be called out only once per order (i.e. there should not be 2 rows for a single order 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 'ship_to_is_commercial' to 1 on wholesale orders that are known to be commercial (0 or blank will be assumed to be residential),,,,,,,,,,,,,,,,,,
; 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 ship_to_company_name and bill_to_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,,,,,,,,,,,,,,,,,,
; You can set force_ship_to_address to 1 if you do not want Shipwire to validate the address,,,,,,,,,,,,,,,,,,
; You can set force_duplicate to 1 if you want Shipwire to allow duplicates,,,,,,,,,,,,,,,,,,
; Use packing_list_message_1 to customize the gift message on your packing list on an order by order basis,,,,,,,,,,,,,,,,,,
; Use shipping_window_type, shipping_window_min_date, and shipping_window_max_date to customize the window during which the wholesale order can be shipped. Available values for shipping_window_type are ON, AFTER, BEFORE, and BETWEEN. If BETWEEN is used, use both shipping_window_min_date and shipping_window_max_date to specify the window. For AFTER and ON, use shipping_window_min_date to specify the date. For BEFORE, use shipping_window_max_date to specify the date. Date format is MM/DD/YY,,,,,,,,,,,,,,,,,,
; Use delivery_window_type, delivery_window_min_date, and delivery_window_max_date to customize the window during which the wholesale order needs to be delivered. Available values for delivery_window_type are ON, AFTER, BEFORE, and BETWEEN. If BETWEEN is used, use both delivery_window_min_date and delivery_window_max_date to specify the window. For AFTER and ON, use delivery_window_min_date to specify the date. For BEFORE, use delivery_window_max_date to specify the date. Date format is MM/DD/YY,,,,,,,,,,,,,,,,,,
; Header level extended attributes and line level extended attibutes are optional fields you can use to pass custom information. (for >1 extended attributes increase the counter by 1. ie. header_level_extended_attribute_name_2, header_level_extended_attribute_value_2, ...)Please contact Ingram Micro Commerce team before using these fields,,,,,,,,,,,,,,,,,,
; Header level extended attribute type and line level extended attribute type options include: integer, string,,,,,,,,,,,,,,,,,,
; Add your wholesale order details below, and upload when done,,,,,,,,,,,,,,,,,,
;,,,,,,,,,,,,,,,,,,
; -------------------- WHOLESALE ORDERS  --------------------,,,,,,,,,,,,,,,,,,
[order_no],[external_id],[order_date],[ship_to_name],[ship_to_address_1],[ship_to_address_2],[ship_to_address_3],[ship_to_city],[ship_to_state],[ship_to_ZIP],[ship_to_country],[ship_to_email],[ship_to_phone],[ship_to_is_commercial],[ship_to_company_name],[force_ship_to_address],[force_duplicate],[bill_to_name],[bill_to_address_1],[bill_to_address_2],[bill_to_address_3],[bill_to_city],[bill_to_state],[bill_to_ZIP],[bill_to_country],[bill_to_email],[bill_to_phone],[bill_to_company_name],[sku],[retailer_sku],[upc],[retailer_line_no],[quantity],[shipping_method],[packing_list_message_1],[shipping_window_type],[shipping_window_min_date],[shipping_window_max_date],[delivery_window_type],[delivery_window_min_date],[delivery_window_max_date],[header_level_extended_attribute_name_1],[header_level_extended_attribute_value_1],[header_level_extended_attribute_type_1],[line_level_extended_attribute_name_1],[line_level_extended_attribute_value_1],[line_level_extended_attribute_type_1],

Samples

You can download the sample files here:
XLS Sample

CSV Sample

TSV Sample
 

Spreadsheet Validation

In order to pass spreadsheet upload validation, please ensure that your data entry follows our field schema found within the spreadsheet. This promotes stronger data integrity for our Platform and enables us to better serve your company.
 

Spreadsheet Details

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

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

[external_id] – The external purchase order ID for what is being shipped. This ID needs to be unique.

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

[ship_to_name] – Receiver’s name.

[ship_to_address_1], [ship_to_address_2], [ship_to_address_3] – Address fields for shipping address. If only one line is needed for the address, then the others can be left blank.

[ship_to_city] – Destination city.

[ship_to_state] – Destination state.

[ship_to_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

[ship_to_country] – Destination country.

[ship_to_email] – Receiver’s e-mail.

[ship_to_phone] – Receiver’s phone number.

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

[ship_to_company_name] – Receiver’s company name.

[force_ship_to_address] – Forces address to be used on the order. Input 1 in this field to force the address to be used on the order.

[force_duplicate] – Forces duplicate orders. Input 1 in this field to allow duplicate orders. Otherwise, a 0 means do not allow duplicate orders.

[bill_to_name] – Payer’s name.

[bill_to_address_1], [bill_to_address_2], [bill_to_address_3] – Address fields for billing address. If only one line is needed for the address, then the others can be left blank.

[bill_to_city] – Billed city.

[bill_to_state] – Billed state.

[bill_to_ZIP] – Billed 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

[bill_to_country] – Billed country.

[bill_to_email] – Payer’s e-mail.

[bill_to_phone] – Payer’s phone number.

[bill_to_company_name] – Payer’s company name.

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

[retailer_sku] – The retailer SKU of the product being shipped.

[upc] – Universal Product Code (UPC) is a 12-digit bar code used extensively for retail packaging.

[retailer_line_no] – Retailer’s line number

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

[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.

[packing_list_message_1] – Use packing_list_message_1 to customize the gift message on your packing list on an order.

[shipping_window_type],[shipping_window_min_date],[shipping_window_max_date] – Use shipping_window_type, shipping_window_min_date, and shipping_window_max_date to customize the window during which the purchase order can be shipped.

[delivery_window_type], [delivery_window_min_date], [delivery_window_max_date] – Use delivery_window_type, delivery_window_min_date, and delivery_window_max_date to customize the window during which the purchase order needs to be delivered.

[header_level_extended_attribute_name_1], [header_level_extended_attribute_value_1], [header_level_extended_attribute_type_1] – Header level extended attributes are optional fields you can use to pass custom information. Please contact Ingram Micro Commerce team before using these fields.

[line_level_extended_attribute_name_1], [line_level_extended_attribute_value_1], [line_level_extended_attribute_type_1] – Line level extended attributes are optional fields you can use to pass custom information. Please contact Ingram Micro Commerce team before using these fields.

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?