Importing Shipping Information
Perform the importing of Shipping data. It will handle scenarios
where the user scans a packing list number (which is really the
ShipNum) signaling that UPS (or Fedex) has arrived to pick up
boxes and they are now going out the door. The packed ship
record is then marked as shipped. It
is assumed that the correct Carrier is there to pick things up.
Formatting the Data
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 For Importing Shipping Data.
| Column Name |
Type |
Description |
| ShipNum |
Text |
The ship number that was shipped. The ship number must include the prefix for the order type: S for sales
order, P for purchase order, and T for transfer order.
Required |
| Date |
Text |
The date the shipment was shipped. If this is not provided, the date
of the import will be used.
Optional |
| Carrier |
Text |
The shipping carrier name.
Optional |
| Carrier Service |
Text |
The shipping carrier service name.
Optional |
Creating a CSV file
In order to import your data, you must first create a comma separated
values (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.
- 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.
- Commas are used to separate fields
- Text values are surrounded by double quotes