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 chosen 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.
So make sure when you are uploading the spreadsheet is closed.
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 contains the order number, and is numbered column 01 in the imported file format box titled Order#. 
If the format is correct you will select Format Is Correct (F1).
This will generate a report that will give you information regarding the import. It will give details about each order and whether or not it was successfully uploaded If an order was not uploaded it or it will not be shippable 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 i.e. already exists). If an order is omitted you will see why when you close the report.
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 double 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.
If you have orders with out errors the resulting report will look more like the one below.
The orders will populate in the Orders from File screen with the message Ok to Ship. Your next step would be to select Ship Imported Orders. On this screen you can see that you can also send an order confirmation email. The confirmation email is set up in Email Templates.
The Shipping Information screen will pop up, and you will need to enter a Shipment date and a location (for which the wine shipped). The shipment date will most likely be the day that you are doing the upload, but please note that this effects inventory so you will want to make sure that you are shipping these orders in the correct inventory period (in the correct month). The location code is also important because it will tell the system where the inventory will be released, if it is not the default location determined by the TTX code on the order. You can see and edit these locations in the Central Table.
Once you entered the necessary information you can select accept. If you have any questions with this process please contact the help desk at helpdesk@amsoftware.com