Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Using iHub for Loading Bookings

...

Please see the user guide below showing how to manipulate CSV files for loading using iHub. Note that you should not use normal Excel functionality for this, you should follow the guide if you wish to use Excel at all. Please note also that only Excel 2019 onwards supports this functionality. If you don’t have access to this or later versions of Excel, it is recommended that you don’t use Excel at all for this. The reason is that it treats fields such as phone numbers as integer values and corrupts them from their original format.

View file
nameUser Guide to Manipulating CSV files in ExcelConverting an Excel for iHub Uploads - V1.2 130423.pdf

iHub URLs

Production System

...

List of ISO Country Codes

Country Codes List - ISO ALPHA-2, ISO ALPHA-3 and Numerical Country Codes

Example CSV Load Files

View file
nameExample Outbound.csv
View file
nameExample Inbound.csv

...

NB. Extra information are be added by default:

  • Transit Mode: ROAD

  • Quantity: PCS

...

Document Number
Transfer Order Reference #
Shipping Instructions
Company Name
Shipping Address 1
Shipping Address 2
Shipping City
Shipping State/Province
Shipping Zip
Shipping Country (Two-letter Country ISO CODE, NOT Country Name - see link above)
First Name
Last Name
Phone Number
Delivery Contact Email
Quantity
Item
KIT BOX 1
KIT BOX 2
KIT BOX 3
KIT BOX 4
KIT BOX 5
KIT BOX 6
KIT BOX 7
KIT BOX 8
KIT BOX 9
KIT BOX 10
KIT BOX 11
KIT BOX 12
KIT BOX 13
KIT BOX 14
KIT BOX 15
KIT BOX 16
KIT BOX 17
KIT BOX 18
KIT BOX 19
KIT BOX 20
KIT BOX 21
KIT BOX 22
KIT BOX 23
Estimated Ship Date
Customer Deliver by Date
Carrier
Internal ID
Order Type
Location
Assembly?
TransitMode
QuantityUnit

...