PAGE IS CURRENTLY UNDER CONSTRUCTION
Just as you export orders to your shipping company, you will most likely need to import tracking information for those orders that have shipped. This is an important step. It will allow you to see all the tracking information that is associated with any order. The tracking information is hyper-linked in the order so with one click you will be connected to the tracking information on various shippers web pages. When you upload tracking information the system will also mark these orders as shipped. So you are really doing two things when you upload tracking information, because you are shipping these orders in the system as well. You will import this shipping information in Order Management, so start by double clicking the menu option SLS->PS->PSORM->ORM.
Just like when you export orders to send to your shipping company you will need to enter your user name and password which is edited in Maintain Clerk Master File. You will need to also enter a room and register. Once you are in order management you will see that there is an Import Shipments button.
It is here that you will be able to import this tracking information for every different shipping company.
If you notice that your shipper codes are absent, you can add them. The shipper codes (SPR) are edited in the Central Table. It is important to note that the import does not need to be carrier specific. In other words you can have UPS and FedEx on the same spreadsheet, just as long as the carrier is defined on that spreadsheet. Users tend to use the UPS shipper code during an upload, but you can decide what works best for you. Once you have choosen what shipping code you will be using you can upload your spreadsheet by selecting Select New File.
\
You can then choose the excel spreadsheet that you are going to use.
If you have your spreadsheet open on your desktop your import will be unsuccessful. You will see this message like the one below.
Once you have selected the spreadsheet you will see the spreadsheet data in the import shipper tracking data file.
This is where you can see that your formatting is correct. Make sure that the correct column number corresponds with the data that is in that column i.e. column 1 is contains the order number, and is numbered column 01 in the imported file format box labeled titled Order#. 
If the format is correct you will select Format Is Correct (F1).
This will generate a report that will giver you information regarding the import. It will give details about each order and whether or not it was successful. If an order was not uploaded it or it was not shipped this report will show errors like the ones below.
Some errors are more descriptive; they tell you exactly why the order's tracking information was not uploaded (the order has already been uploaded, already exists). If an order is omitted you will see why when you close the report.
Here is the order that was omitted and you can see the it can't be shipped. If you want to know why most likely you will see why by doubloe clicking the order. For this particular order you will see that that there is still an amount due and that is why the system won't and shouldn't ship it.
