Exporting Ship Carton Information

Format the Data

This CSV allows you to export information relating to a ship carton.

All fields will be one of two types:

Text - A textual value. May contain any character, but if it contains a line break, comma or double quote, it must be wrapped with double quotes on both ends. If a field is wrapped, all text must be inside the double quotes. Double quotes in the text value must be doubled to import properly
Numeric - A decimal number greater than or equal to zero with up to four digits after the decimal point. The number must not have thousands' separators in it - 1234.56 is a valid number, while 1,234.56 is not.

CSV Fields Used to view Ship Carton Information

Column Name	Type	Description
ShipNumber	Text	The ship number. *Required*
CartonNumber	Numeric (Only whole numbers)	The carton number. *Required*
CartonTrackingNumber	Text	The carton tracking number.
CartonWeight	Numeric	The carton weight.
CartonWeightUom	String	The UOM for the weight of the shipment. *(Read Only)*
CartonLength	Numeric	The carton length.
CartonWidth	Numeric	The carton width.
CartonHeight	Numeric	The carton height.
CartonSizeUom	Text	The carton unit of measure. *UOM must be in either inch (IN) or centimeter (CM).*
CartonCost	Numeric	The carton cost.
CartonDeclaredValue	Numeric	The declared dollar value of the carton.
PartNumber	Text	The part number. *Required*
PartDescription	Text	The part description. *Export only, not used in the import.*
OrderLineNumber	Numeric (Only whole numbers)	The associated order line number. *Required - Must be the correct part for the line number.*
ShipItemQty	Numeric	The ship item quantity.
ShipItemUom	Text	The UOM of the ship item. *Export only, not used in the import.*
PartTracking	Text	The tracking information for the part. The name of the column is the name of the part tracking item prefixed by "Tracking-". (i.e. Tracking-Lot Number) *If the part is not tracked by a particular tracking type the field can be left empty.*

If a part tracks serial numbers, then each serial number must be on their own line immediately following its parent line above. If a part tracks more than one type of serial number then you will need a serial number header immediately following its parent line. This header contains the names of the tracking items separated by commas. Then each serial number set must be on their own line following the header.

Creating a CSV file

In order to import your data, you must first export it to a CSV text file. All major spreadsheet programs can export data in this format. If you do not know how to export your data to a CSV file, please refer to the documentation of your spreadsheet program.

When exporting to CSV format, make sure to verify the following:

The data is formatted properly (see the first section)
The file must contain column names in the first row, using the column names in the table above.
Each part to be imported is on its own line
Commas are used to separate fields
Text values are surrounded by double quotes