The Import Consignments feature allows you to import any delimited, XML or JSON file containing consignment or order information.
How to Navigate to the Import Consignments screen
- To get to the Import Consignments screen, click Import Consignments under the Consignments section from the top menu Create/Manage.
- Or you can also use the link here.
Import Consignments Process
MachShip can facilitate the mapping of a consignment file which you can internally produce in any XML, Delimited or JSON format. If you cannot produce a file or are happy to utilize the MachShip generic version, please provide a file in the following format.
Despatch Date | Despatch Time | Carrier | Account | Service | From Location Name | From Location Abbreviation | From Contact | From Phone | From Email | From Address Line 1 | From Address Line 2 | From Suburb | From Postcode | To Location Name | To Location Abbreviation | To Contact | To Phone | To Email | To Address Line 1 | To Address Line 2 | To Suburb | To Postcode | Special Instructions | Reference 1 | Reference 2 | Quantity | Item SKU | Item name | Type | Length | Width | Height | Weight | Is International | International From City | International From Postcode | International From Province | From Country Code | International To City | International To Postcode | International To Province | To Country Code | Content Description | Content Ref1 | Content Ref2 | Content Ref3 | Content Quantity | Content Dollar Value | Content CI Marks and Numbers | Content Harmonized Code | Content Part Number | Content Purpose | Content Country of Manufacture |
| | FEDEX_INT | | | Pickup location name | | | | | | | | | Test To Location | | | | | 123 testing street | | | | Test spec | 1231 | 3211 | 1 | | Carton | Carton | 10 | 10 | 10 | 5 | YES | | | | | | 123456 | | USA | Test Item Description | | | | 10 | 250 | | | | | USA |
Add CSV Files (required fields only apply when attempting to create a consignment. If you are importing orders (pending consignments) then you can provide as much or as little data as desired)
- Despatch Date Despatch Time (Not Required): If not provided, then the current date will be utilised.
- Carrier, Account, Service (Not Required): If you wish to consign with a particular Carrier, Account or Service set them here. If not, MachShip will create the consignment via either the lowest cost or fastest ETA model. These will be the abbreviations stored in MachShip rather than the names. For example: TNT Road Express the carrier is TNT and the service is 76.
- From/To Location Name or From/To Location Abbreviation (one is required): You can either fill in the location name or its abbreviation. If it is a saved location, all the address info fields can be left blank. For a new one, Address Line 1 and Suburb are required.
- Domestic: From/To Address Line 1 (required), Address Line 2, Suburb (required), Postcode (required), Contact, Phone or Email. (Note: Required fields are only if not using saved location): If you are not using a saved location, you will need to provide at least the address line 1 and a suburb postcode combination from the from and to locations. This is for domestic Australian addresses
- Reference 1 and Reference 2: Set reference field 1 and reference field 2. Just so you know, the Generic Consignment Import workflow will consolidate the file by From and To Locations as well as reference 1 and reference 2.
- Items: (Required): As stated above, the Generic Consignment Import workflow will consolidate rows based on the same from/to location details and reference 1 and reference 2. As such, each row will be one line item.
You will be required to set:
- Quantity: Quantity for each line item.
- Item SKU or Item Name: If you decide to use a saved item, enter the SKU or Name, it will use the dimensions from the saved item.
If not using a saved item then you will need to provide:
- Item Name - this is a free text field
- Item Type - i.e Skid, Pallet, Carton or any other valid MachShip item type
- Length, Width, Height (cm)
- Weight (kg)
International Specific Fields:
- Is International (Required) - This is a boolean that advises the system that we are importing an International consignment - default for this is no.
- International From City, From Postcode, From Province, International To City, International To Province, International to Postcode
Users will populate either one of these selected fields. At a minimum MachShip will need one city or province and Postcode. - International From Country Code, International To Country Code
Here you will need to provide the 3 Alpha code identifier of the country for the Import / Export order - Customs Information - Item Contents
Description - The description of the goods being imported / exported
Reference 1, Reference 2, Reference 3, CL Marks and Numbers, Part Number - These fields will all identify either the object or the invoice/order
Quantity - Quantity of the physical goods being shipped - note this will be different to the item quantity above, if it was 5 t-shirts packed in a carton then the quantity is 5
Harmonized Code - The global customs identifier for the class of goods being shipped
Purpose - This must describe the reason for sending the goods. Needs to match up with a known classification reason i.e sale, gift, return etc.
Country of Manufacture - Will identify where the product was manufactured. You will need to select this from the drop-down of allowable MachShip values.
Unit Dollar Value - This is the commercial dollar value of the goods in AUD - you would put in the value of one of the items and MachShip will then multiply out for the total
An example for export on the carrier Australia Post for 5 Tshirts manufacturers in Australia with a value of $1 being sent to New Lyn, 640 in New Zealand from Bonbeach Australia. The file import would be as follows:
Despatch Date | Despatch Time | Carrier | Account | Service | From Location Name | From Location Abbreviation | From Contact | From Phone | From Email | From Address Line 1 | From Address Line 2 | From Suburb | From Postcode | To Location Name | To Location Abbreviation | To Contact | To Phone | To Email | To Address Line 1 | To Address Line 2 | To Suburb | To Postcode | Special Instructions | Reference 1 | Reference 2 | Quantity | Item SKU | Item name | Type | Length | Width | Height | Weight | Is International | International From City | International From Postcode | International From Province | From Country Code | International To City | International To Postcode | International To Province | To Country Code | Content Description | Content Ref1 | Content Ref2 | Content Ref3 | Content Quantity | Content Dollar Value | Content CI Marks and Numbers | Content Harmonized Code | Content Part Number | Content Purpose | Content Country of Manufacture |
| | AustPost | | | Pickup location name | | | | | 123 testing street | | Bonbeach | 3196 | Test To Location New Zealand | | | | | 123 Testing Street | | | | Test Special Instructions | Testing Reference 1 | Example Reference | 1 | | Carton | Carton | 10 | 10 | 10 | 5 | YES | | | | | | 640 | New Lyn | NZL | T-Shirts | | | | 5 | 5 | | | | | AUS |
- Import Consignments
- Select Add Files and select the relevant file to be uploaded.
- Then Select Upload
The file will then appear in the import files grid as below:
- Import Type
Import With Fallback: The import preview screen will show any errors, any consignments with errors will come through as Pending Consignments everything else will import as a consignment.
Import Without Fallback: The import preview screen will show any errors and you are not able to proceed further.
- Order: All the items will be imported as pending consignments.
- File Format: For each uploaded file, you can select the import file format, the default one is “GENERIC CONSIGNMENT IMPORTER V2”. Otherwise, select the relevant workflow you require.
You need to select any file on the list that you want to import and click on Import Consignments button to start the process.
Once selected the Import Consignment Modal will appear. This will validate the file and then request you to select the Route Selection Option. Once complete, select Import Consignments.
Once the import is complete MachShip will provide you with a list of successfully imported consignments or pending consignments and their relevant PC or MS numbers.