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.

Download Templates Here

You can download the sample files here:

 

Spreadsheet Guidelines

  • 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.
  • The following header column fields are required:
    • order_no
    • ship_to_name
    • ship_to_address_1
    • ship_to_city
    • ship_to_state
    • ship_to_ZIP
    • ship_to_country
    • ship_to_phone
    • sku
    • quantity
  • 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 repeat all of the same data included in the order header row.
  • 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 (0 or blank will be assumed that we should do address validation).
  • You can set force_duplicate to 1 if you want Shipwire to allow duplicates (0 or blank will be assumed that duplicates will not be allowed).
  • 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
    • 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
    • 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 attributes 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 note that this is a hidden field and must be activated by the Shipwire Platform customer team. Incorrectly adding this field may cause delayed order routing or cancellations.
  • Header level extended attribute type and line level extended attribute type options include: integer, string, and float.

 

How To 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 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.

Acceptable Values for Specific Fields:

  • [country]2 digit country code or full name.
  • [phone] – Phone numbers must be within 50 characters.
  • [warehouse_id] – Specify which warehouse by its ID found here. *Please note that this is a hidden field and must be activated by the Shipwire Platform customer team. Incorrectly adding this field may cause delayed order routing or cancellations.
  • [carrier_requested] – Specify which carrier to use for the order. *Please note that this is a hidden field and must be activated by the Shipwire Platform customer team. Incorrectly adding this field may cause delayed order routing or cancellations.

 

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 note that this is a hidden field and must be activated by the Shipwire Platform customer team. Incorrectly adding this field may cause delayed order routing or cancellations.

[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 note that this is a hidden field and must be activated by the Shipwire Platform customer team. Incorrectly adding this field may cause delayed order routing or cancellations.

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.

{% block invis %}{% endblock %}