If you've been using UPS Worldship® to ship your orders, you may have already built a customer address book that you'd like to use in ShipStation. Although ShipStation cannot pull the address book from UPS directly, you can export the data from UPS Worldship® and use the data to create a CSV file to import customer records into ShipStation.
This multi-step process requires you to:
Create an export map in UPS Worldship®.
Export a file using the export map created in UPS Worldship®.
Use the information in the file to build a CSV file formatted to import into ShipStation.
Import the ShipStation-formatted CSV into ShipStation.
See below for step-by-step instructions:
First, you need to create an export map in UPS Worldship® that generates a CSV file.
Open the UPS Worldship® application.
Under Import/Export Data, select Create / Edit Map... to open the Create or edit an import or export map window.
In the New Map section, select Export to ODBC Database.
Select the Export CSV checkbox.
Choose a Map Type of Address Book.
Name the map, then click Create. The Edit Export to CSV Map window will appear.
Click Add All Columns.
Click Define CSV File Name. A Save As window will appear.
Enter a file name, then click Save to save the export map file.
Click OK. You'll be taken back to the Create or edit an import or export map window.
The map you created should be listed under Existing Maps. Click Close to go back to the main view of UPS Worldship®.
Now that you have an export map created to generate a CSV file, you can export the data.
Under Import/Export Data, select Batch Export... to open the Batch export data window.
Select the export map you created in the previous steps.
Choose a date range for the export.
Click Next. An Import/Export Preview window will appear.
Verify the export details and click Next to begin the export.
Once the export is complete, click Save to save the file to your computer.
If you're unable to perform the above steps in UPS Worldship®, you can contact UPS Worldship® support for additional assistance with their application.
Next, you'll modify the exported file in a spreadsheet application since ShipStation requires a specific format for the Customer Import process.
Download the CustomerImportSample.csv file.
Open both the CustomerImportSample.csv and the UPS Worldship® export files using the spreadsheet application of your choosing.
Use Copy/Paste to move the information from the UPS Worldship® export file into the relevant columns on CustomerImportSample.csv.
Do not change the column headers in CustomerImportSample.csv!
When the address information has been transferred into the CustomerImportSample.csv file, Save the file. (Or use Save As... to save the file with a new name.)
Be sure to retain the CSV format.
The final step is to import the new CSV file into ShipStation.
Log in to ShipStation.
Go to the Customers tab.
Click Import. An Import Customers window will appear.
Click Select a File.
Select the modified version of the CustomerImportSample.csv file and click Open.
Choose one of the options under Select Options.
Click Start Import to import the file.
See our page on Importing Customers for a more detailed walk-through of the above process.
ShipStation will begin to import the file and will alert you once the import completes. Then, you'll be able to see the addresses in the Customers tab in ShipStation.
Once the customer records have been created, you'll be able to use the saved customer information to quickly create manual orders and labels.