Descartes ShipRush Web can read Order/Shipment data stored in an MS Excel worksheet and place the information into the Order list in Descartes ShipRush Web.
To save Tracking Numbers to MS Excel, go to SETTINGS > ACCOUNT SETTINGS > Reports > Order & Shipment. At the bottom of the page, choose to export the data back to MS Excel.
Warning: If the same spreadsheet is imported multiple times, its data is duplicated in Descartes ShipRush Web. This can cause significant issues, including the possibility of duplicate shipments.
MS Excel Requirements
Descartes ShipRush Web works with most modern types of spreadsheet files in MS Excel format, including .xls, .xlsx, and .xlsb files. All currently supported versions of MS Excel can be used.
Before a worksheet can be used with Descartes ShipRush Web, it must have the correct column names. See Column Names in the Worksheet.
To display and download a sample xls file, click here. The Download file button will be at the top of the spreadsheet.
Only the first worksheet in the workbook is imported.!
Spreadsheet File Name
The spreadsheet file can be assigned any name.
Column Names in the Worksheet
Each worksheet column must have an appropriate name in order to identify the data. A basic set of columns is required. Additional columns are optional. See the sections that follow for lists of column names.
Column names are set by simply typing the names in row 1 of the worksheet.
Tip: If you enter column names regularly, consider creating an MS Excel macro to enter the column names for you.
Required Column Names for Parcel and LTL Shipping
Contact
Company
Address1
City
State
PostalCode
Order ID Column
The addition of an OrderID column is strongly suggested.
Warning: Each entry in the OrderID column must be unique. For example, the entry could be a Customer ID or Order Number. Click here for instructions on generating unique IDs automatically in Excel. If OrderID's are not provided, Descartes ShipRush Web will generate random Order Numbers dynamically.
Generating Unique OrderID Values Automatically
If your source data lacks a unique value for each row, do the following:
In row 1 of an empty column, enter OrderID.
In row 2 of this column, enter this formula: =Row().
Select the cell from step 2, and then press CTRL+C.
Select all cells in this column to the end of the data--except for the cells in row 1 and row 2.
Press CTRL+V to paste the formula into the selected cells in this column. Each row should now have a unique row number in the OrderID column.
Optional Columns for Parcel and LTL Shipping
Address2
Country
Email
Phone
IsPaid (enter Y if true)
IsShipped (enter Y, yes, or 1 if true)
ItemSKU
ItemAccountingID
ItemID
ItemDescription
ItemQuantity
ItemPrice
ItemTotal (total dollar amount of all items for this line item)
Tags (separate multiple tags with commas; for example: Tag1, Tag 2, Tag2)
TotalAmount (the Order's total dollars)
TotalWeight
PackageLength
PackageWidth
PackageHeight
OrderDate
CustomerPO
Reference
PaymentType
ThirdPartyAccount
ThirdPartyCompany
ThirdPartyCountry
DeclaredValue
ShipMethod
ShippingPaid
Additional Columns for LTL
Note: Some of these elements only accept specific values. Click the item to see accepted values.
FreightClass
FreightDescription
FreightNMFC
FreightTotalWeight (in LBS)
FreightPieceCount
InsuranceIncludingFreightCharge (yes, y or 1 if true)
FreightInsuranceMarksAndNumbers
FreightInsuranceDescriptionOfCargo
FreightClientDiscountPercent
FreightDeclaredValueUnits
FreightTotalHandlingUnits
FreightItemHandlingUnits
Column Format/Data Type
This step is required if the Postal Codes and/or Order IDs contain any non-numeric data. Do the following for both the Postal Code and Order ID columns.
To format the column:
Select the entire column.
Right-click the selected column, and then click Format Cells.
In the Number list, click Text (see below).
Click OK.
This worksheet is ready to go: