Offline data import
To provide more than one shipping transaction at a time for inclusion in the ShippingScore database, this is done by a simple text file.
There are 2 types of import files:
- New shipments/transactions
- Updates to Existing shipments/transactions
If the file contains new shipments, the filename must be RS.txt and the TransactionType must = 1
If the file contains updates to previosuly submitted shipments, the filename must be CS.txt and the TransactionType must = 2.
The file is pipe delimited (|).
BETA Period
During the BETA period, this file will be emailed to us for manual processing.
Make sure to set ShipmentToValidationFlag = 1
TransactionType|TrackingNumber|ReferenceNumber|ShipmentToAddressLine1|ShipmentToAddressLine2|ShipmentToCity|ShipmentToState|ShipmentToCountry|ShipmentToZipCode|ShipmentToValidationFlag|ShipmentCost|shipmentDate|ShipmentStatusID|ShipmentCategoryID
Examples
IMPORTANT
If the file contains new shipments, the filename must be RS.txt and the TransactionType must = 1
If the file contains updates to previously submitted shipments, the filename must be CS.txt and the TransactionType must = 2.
1|9400109699937124533244||1234 Main St||Los Angeles|CA|US|90036|1|99.00|2014-12-8|1|1
TransactionTypes Types
| ID | Description |
|---|---|
| 1 | New Shipment. |
| 2 | Update to an existing shipment. Used to update ShipmentStatus. |
ShipmentStatus Types
| ID | Name | Description |
|---|---|---|
| 1 | Nothing | Used to report initial shipping transaction |
| 2 | Loss Package | The shipment was lost in transit or the recipient indicated such. |
| 3 | Damaged Package | The shipment was damaged in transit or the recipient indicated such. |
| 4 | Shortage | The shipment arrived with part of or all of the contents missing. |
| 5 | Tracking Non-Delivery | The shipment was not scanned as "Delivered". |
| 6 | Fraudulent Transaction | The merchant indicated the entire transaction to this address was fraud. |
| 7 | Chargeback | The recipient at the address filed a chargeback against the shipper. |
| 8 | Returned Package | The shipment was returned to sender. |
ShipmentCategoryID Types
| ID | Description |
|---|---|
| 1 | Appliances |
| 2 | Auto |
| 3 | Books |
| 4 | Computers |
| 5 | Laptops |
| 6 | Electronics |
| 7 | Furniture |
| 8 | Miscellaneous |
| 9 | Clothing |
| 10 | Health and Beauty |
| 11 | Jewelry and Watches |
| 12 | Sports and Fitness |
| 13 | Hardware |