Import Order feature in Adhoc Shipping

Import Orders: 

Here users provide data in CSV Format which contains information like 

Order number                         Unique Identifier for Shipments 

Customer Name                      Contains name of the customer 

Contact Name                         Contains name of Ship To Contact 

AddressLine1                          Contains Ship To Address line 1 

AddressLine2                          Contains Ship To Address line 2 

AddressLine3                          Contains Ship To Address line 3 

City                                         Contains Ship To City 

State                                        Contains Ship To State 

Postal Code                             Contains Ship To Postal Code 

Country Code                          Contains Ship To Country Code 

Phone Number                         Contains Ship To Phone Number 

Company                                 Contains Ship  From Company 

Ship Method                            Contains Ship method through which Shipping is done 

Pay Method                             Contains Pay Method  through which Shipping is done 

Carrier Account Number          Contains Shipping Account Number 

Reference 1                              Contains Reference 1 value which needs to be printed on the label 

Reference 2                              Contains Reference 2 value which needs to be printed on label 

Click on” Import Orders”.

The CSV File which contains all the information needs to be uploaded by clicking on Browse and then on upload.

 
Once the file is uploaded it can be as below:

If there are any errors while uploading, it can be shown as below: 

 By Clicking on Download Report in the below screenshot , you could see if there are any duplicate Orders or Errors in the data. 

Once the CSV File is imported successfully then the order number can be retrieved in non-oracle page (Adhoc Shipping ).Once the order number is retrieved it can be shown as below: 

Once the order is retrieved it can be shipped by giving the required details.

Note:     

• One thing to note is that International/Commodity data will not be included as part of the import, but Customer Information, Service, Pay Method, Account, and References will be imported through the file.
• The company name you add in this template must match the company name saved in the Ship from Location. This is a key piece of information, as it will act as the primary key to match the data.
• Ship Method in template must also be same as the one from the ship methods configured.