Versions Compared

Key

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

...


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 chosen what shipping code you will be using you can upload your spreadsheet by selecting Select New File.

...

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 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 give you information regarding the import.  It will give details about each order and whether or not it was successful.  successfully uploaded  If an order was not uploaded it or it was will not shipped 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.

Here is the 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.

...

The orders will populate in the Orders from File screen with the message Ok to Ship.  You Your next step would be to select Ship Imported Orders.  On this screen you can see that you can also sent out a 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 l; 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 system will release the inventory inventory will be released, if it is not the default location determined by the TTX code on the order.  You can  can see and edit these location 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

...