This update allows you the opportunity to do a mass update of information relating to a ship carton tracking. You have to have the CSV file formatted in a way that Fishbowl knows what to do with the data. This is easiest to do with a spreadsheet program.
The CSV file may have more or less columns in it than the ones listed below. All extra fields will be ignored. Only required fields need to be included.
All fields will be one of two types:
|Ship Number||Text||The ship number.
(Only whole numbers)
| The carton number.
(If not specified the first carton of the shipment will be updated)
||The carton tracking number.|
||The freight cost for the carton.|
||The declared value of the carton for shipping insurance.|
||The weight for the carton in the default weight unit of measure.|
||The length dimension for the carton.|
||The width dimension for the carton.|
||The height dimension for the carton.|
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: