Importing an Address Book from a CSV File

Accessing the Address Book

First, navigate to the Address Book page within ShipBoss. You will see a list of existing addresses (if any).

Starting the Import

Click the IMPORT button, located in the row of buttons at the top of the address book.

Specifying Recipient Type

A pop-up will ask you to specify who the addresses are for. Select one of the following options from the dropdown menu:

• User: Imports addresses for individual user accounts.
• Company: Imports addresses for company-level contacts.
• My CSV contains the information: Use this option if your CSV file already includes a column specifying whether each contact is a "User" or "Company" contact.

Selecting Your CSV File

The "Import Address Book" dialog will appear. You have two methods for providing your CSV file:

• Drag and Drop: Drag your CSV file from your file explorer (Finder on macOS, File Explorer on Windows) and drop it directly onto the designated area within the dialog. The area is marked with the text "Drag and drop CSV file here, or click to select in folder."
• Click to Select: Click within the designated area. This will open your system's file browser. Navigate to the location of your CSV file, select it, and click "Open" (or the equivalent button in your operating system).

Previewing and Mapping Columns (Automatic Mapping)

Once your CSV file is selected, the system will automatically attempt to map the columns in your CSV file to the corresponding fields in the system's address book. This means it tries to match headers like "Name" in your CSV to the "Name" field in the system, "Email" to "Email", and so on.

You will see:

1. The file name.
2. A preview of data.

Reviewing and Adjusting Column Mappings (If Needed)

1. Click on Choose columns.
2. You'll see a screen where each column in your CSV is represented by a box. Above these boxes are the system's field names (e.g., "name*", "contact_name", "phone*", "email").
3. Scroll left to right, if necessary.
4. The system will automatically attempt to match column data.

If a mapping is incorrect:

If, for example, your CSV file used "Customer Name" instead of "contact_name," the automatic mapping might be incorrect.

Solution: Click, hold, and drag the box representing the correct column from your CSV (e.g., the box containing "Customer Name") and drop it onto the target system field (e.g., "contact_name"). This will override the automatic mapping.

Starting the Import

Once you are satisfied that all columns are correctly mapped (especially the required fields), click the blue Import button at the bottom-right of the dialog.

Import Progress and Completion

The system will process your CSV file. A progress bar will show the status of the import.

When the import is complete, you'll see a Success message.

Handling Import Errors and Invalid Addresses

Even with careful mapping, some addresses in your CSV might have errors that prevent them from being imported. This is where the Hidden Addresses feature comes in.

A message will appear on the bottom right indicating any issues.

Accessing Hidden Addresses

Click the Hidden Addresses tab, located to the right of the main "Address Book" tab.

Fixing Invalid Addresses

The "Hidden Addresses" tab will list any addresses that failed to import. Each entry will show:

• The data from your CSV file.
• A brief description of the error (e.g., "Zip code is invalid US").

For each invalid address:

1. Click the Fix Address button.
2. A "Create Address" form will open, pre-populated with the data from your CSV. The field(s) containing errors will be highlighted in red.
3. Correct the information in the highlighted fields.
4. Click Save.

Returning to the Address Book

After fixing and saving an address, click the Address Book tab to return to the main address list.

The corrected address will now be included in the main address book, marked with a green New tag.

Viewing Imported Addresses

Go back to the main Address Book page by clicking on it. Addresses that are new will have a New tag in green.

Additional Features

The Address Book provides several additional tools for managing your contacts: