Order Shipment Notification CSV Field Description

Spreadsheet Header Description Example
Required?
customerAccountNumber Your customers account number that identifies them in your system
123 yes
purchaseOrderNumber The order's PO number
ABC123 yes
purchaseOrderShippedInFull Is this PO fully shipped? TRUE yes
salesOrderNumber Internal Sales Order Number
yes
salesOrderShippedInFull Is this Sales Order fully shipped?
TRUE yes
destinationShippedInFull Has this address received all its shipments? TRUE yes
customerPickup If this is a customer pickup FALSE yes
shipFrom_attentionTo From Address: Attention To line
shipFrom_companyName From Address: Company Name
1
shipFrom_address1 From Address: Address Line 1

yes
shipFrom_address2 From Address: Address Line 2

shipFrom_address3 From Address: Address Line 3
shipFrom_city From Address: City
Gardner yes
shipFrom_region From Address: State or Region
KS yes
shipFrom_postalCode From Address: Postal Code
66030 yes
shipFrom_country From Address: Country in ISO format
US
shipFrom_email From Address: email address

shipFrom_phone From Address: Phone
shipTo_destinationType Valid values: Commercial or Residential
Commercial
shipTo_attentionTo To Address: Attention To

shipTo_companyName To Address: Company Name

shipTo_address1 To Address: Address line 1

yes
shipTo_address2 To Address: Address line 2

shipTo_address3 To Address: Address line 3

shipTo_city To Address: City
Gardner yes
shipTo_region To Address: State or Region
KS yes
shipTo_postalCode To Address: Postal Code
66030 yes
shipTo_country To Address: Country in ISO Format
US
shipTo_email To Address: Email address
shipTo_phone To Address: Phone

package_trackingNumber The carriers tracking number 1Z52l2463643436264
package_carrier The name of the Carrier
UPS
package_shipmentDate A date timestamp in UTC specifying the valid timestamp depicting when the inventory will be available for allocation to sales orders.
2022-05-02 15:00:00.000 yes
package_shipmentMethod The Carriers specific name of the shipping method 2 Day
package_dimensionUom The unit of measure
Valid Unit of Measures are: Inches, Feet, mm, cm, Meters
Inches
package_dimensionLength Length of the Package 5
package_dimensionWidth Width of the Package 10
package_dimensionHeight Height of the
15
package_dimensionUom The unit of measure
Valid Unit of Measures are: Ounces, Pounds, Grams, KG
Pounds
package_weight Weight of the Package
23
item_purchaseOrderLineNumber PO Line Number 1
item_supplierProductId Product ID for the product in this package CUP1234
item_supplierPartId Part ID for the product in this package NAVYBLUE
item_distributorProductId Optional - If you have the distributors Product Id MYCUP
item_distributorPartId Optional - If you have the distributors Part Id BLUE
item_quantityUom Quantity Unit of Measure for this package
View unit of measure values >>
EA
item_quantityValue Quantity value contained in this package
1200