Version 7.0
Contents of this Topic: Show
The Import Tracking Data screen is the interface where SEOM fields are mapped to fields in a text file in order to import tracking information from an external shipping application or a drop-ship vendor.
To access this screen go to Main Menu > Settings > Shipping Functions > Import .csv Tracking Numbers.
CSVs should not contain quotes or commas or you will encounter errors. If your data contains commas, the file must be saved as a tab-delimited file or you will encounter errors.
Import Tracking Data screen
indicates that the tracking information being imported is related to drop-ship purchase orders created by SEOM
selecting this radio button activates and selects the Drop-Ship PO Number radio button in the Link Field section of the screen
enter the path and name of the text file from which the tracking information is imported or use the Folder button to navigate to its location and click Open
the program inserts the name of the text file into this field attempts to map fields from the text file to corresponding fields in SEOM
use this button to navigate to the location of the text file that contains the tracking information to be imported and click Open
the program inserts the name of the text file into this field attempts to map fields from the text file to corresponding fields in SEOM
At a minimum, the Order # and Tracking Number fields are required to be mapped to their corresponding fields in the text file. All other fields are optional.
If the Item Numbers field or the Drop-Ship PO Number field is mapped to a corresponding field in the text file, SEOM creates packing records for the items that have been shipped, as well as storing the tracking information for the shipment.
the serial number that the merchant has assigned to the product
SEOM does not enforce the use of unique serial numbers, it merely records the data
select the shipping carrier that delivered the packages
this field can be set to a default value by using system parameter, TrackingDefaultCarrier
the number SEOM assigned to the order
the number the shopping cart system assigned to the order (numeric field)
an alphanumeric identification number assigned to an order by some shopping cart systems (text field)
the number assigned to the drop-ship purchase order when it was created by SEOM
Export tracking information from the shipping application to a text file (tab-delimited or comma-delimited), or obtain the text file from a drop-ship vendor. Be sure to note where you save this file on your computer.
Go to Main Menu > Settings > Shipping Functions > Import .csv Tracking Numbers.
Select either the Regular Orders or Drop Ship POs radio button in the Import tracking for: section of the screen.
Manually type in the path to the file that contains the tracking data or click the Folder button to navigate to its location and click Open. The data from the text file is displayed at the bottom of the screen (up to 50 fields and 100 records or rows).
If the text file does NOT contain a header row, clear the box labeled First row contains field names.
Map the fields in the text file to the SEOM fields by making the appropriate selections in the drop-down lists.
Choose the appropriate shipping carrier from the Default Carrier drop-down list.
In the Link Field section, select the radio button that matches the most appropriate field found in the text file:
Order Number (SEOM #) - STRONGLY RECOMMENDED
Source Order Number (shopping cart order number -- numeric only)
Source Order ID (shopping cart order number -- alpha-numeric only)
Drop-Ship PO Number - this button is only active when the Import Tracking for: section is set to Drop-Ship POs
Click Test Data to have the program check for nominal data errors. A message box appears with the results. If an error is detected, you may elect to view additional information about the error.
When satisfied with the data in the text file and the settings on this screen, click Begin Import to initiate the process of importing the tracking information into SEOM.
When the process has been completed the program provides a count of the new records that were added.
If item number information is included or the drop-ship purchase order number is included, the program creates packing records for the items contained in the text file.
The new tracking information can be seen at the Shipping and Tracking tab of the Process Orders screen. Main Menu >Process My Orders > View and Process My Orders > Shipping
Created: 6/17/12
Revised: 12/2/14
Published: 04/13/16