Skip to main content

How to Manage Customers and Contacts

Learn how to bulk import companies and contacts into Parspec Contact Management using the downloadable spreadsheet template.

Written by Rachel Langehough

Contact Management is your address book in Parspec. It holds every company you work with (customers, contractors, specifiers and more) along with the people at each one. Parspec pulls from these records whenever you add customers and stakeholders to a BOM, address an order, or send documents, so keeping them clean saves time everywhere else.
​

In This Article You’ll Learn How To:

  • Manually add a company or contact

  • Import companies and contacts from a template or spreadsheet, including which columns are required

  • Assign a Sales Rep to a company or contact

  • Control which branches see a company

  • Edit a company’s details and notes

  • Edit a contact’s details

  • Link a branch to its parent company

  • Add Bill To, Ship To and Sold To addresses for orders

  • Fix common problems



Manually Add a Company or Contact

  1. Click Contacts in the left navigation to open Contact Management.
    ​

  2. Open the Companies tab or the Contacts tab.
    ​

  3. Click Create New.

  4. Fill in the details per each records requirements.
    ​

  5. Click Save. The new record appears in the list.

Tip: Adding someone who works at a company you already have? Open that company and add them from its Contacts tab. This requires Edit on both Company and Contacts.


Import Companies and Contacts From a Template / Spreadsheet

Moving from another system or CRM? Import your whole customer list at once instead of adding records one by one.

What's Required on the Import Template?

Only Company - Company Name is required. Every row needs one.

  • Contact - First Name and Contact - Last Name are needed to create a contact. If either is blank, Parspec still imports the row but creates only the company, with no contact.
    ​

  • All other columns are optional. Leave a column blank if you don’t have that information.

Columns In the Template / Spreadsheet That Only Accept Certain Values

  • Company - Business Type: Architect, Contractor, Distributor, Electrical Contractor, Engineer, General Contractor, Landscape Architect, Lighting Designer, Municipality, National Account, Owner or Sales Agency.

    Tip: Customize your Business Type list by going to Settings → Account Settings → Field Configurations → Company Business Types.

  • Company - Country: a two-letter country code (such as US or CA), or USA, CANADA or AUSTRALIA.
    ​

  • Company - State: the state or province code for the country (such as NY, ON or NSW).
    ​

  • Outside Sales Name (contact or company): the first and last name of an existing Parspec user.
    ​

  • Company - Location Access: branch location IDs, separated by commas. You’ll find a branch’s ID at the end of the URL when you edit that branch. If you leave this and Location ERP ID Access blank, the company is shared with all locations.
    ​

  • Company - Location ERP ID Access: location ERP IDs, separated by commas. You can use it with Location Access or in place of it.
    ​

How to Import Your Template / Spreadsheet

  1. In Contact Management, click Import.

  2. Click Download Contact File Template

  3. Add one row per contact. First Name, Last Name and Company are required. Each column in the template includes a description of what it accepts.
    ​

  4. In Business Type, use a value from your account's list. Capitalization doesn't matter.
    ​

  5. Save the file, click Import again, and upload it.
    ​

  6. Review the imported companies and contacts.

Warning: Rows missing a required field, or using a business type that isn't on your list, are skipped. Fix those rows and import the file again.


Helpful Tip: Assign a Sales Rep

Set Sales Rep on each customer company, or on an individual contact if a different rep owns that person.

  • When you add the company or contact to a project or BOM, its rep fills in automatically.

  • If both are set, the contact's rep takes priority over the company's.

  • Distributors see this field labeled Outside Sales.
    ​


Helpful Tip: Control Which Branches See a Company

Users only see companies that are shared with their branch. You control this from Manage Visibility in the company's side panel.

Setting

Who sees the company

All Branch Locations

Every branch, including branches you add later

Specific branches

Only the branches you select. New branches are not added automatically.

Note: If a coworker can't find a customer that you can see, their branch probably isn't selected. Add it in Manage Visibility or contact your Admin.


How to Edit a Company's Details and Notes

  1. Click the company name in the list. The company page opens with a summary at the top.
    ​

  2. To edit the Details to open the side panel to review the company's Company Info, Company Addresses, and Company Logo.

  3. Click any field and type. Changes save automatically when you click out of the field. There's no Save button.
    ​

  4. Use the Company Notes tab for internal notes about the customer.


How to Edit a Contact's Details and Notes

You can edit a contact from the Contacts list or from their company’s page.
​

From the Contacts List

  1. In Contact Management, click Contacts in the upper left.

  2. Search for the contact and click their name.
    ​

  3. Update the fields you need to change.
    ​

  4. Click Save in the upper right.

From the Company’s List

  1. From the Company Tab, open the company the contact belongs to.
    ​

  2. Click the (⋮) menu on the far right of the contact’s row and choose Edit.

  3. Update the contact’s details and save.


Relationship Tab: Link a Branch to Its Parent Company

Use the Relationships tab to connect a branch office to its parent company. This lets reports roll up to the parent. A company can have one parent and many related companies.
​

To remove a linked parent/child, choose the (⋮) menu on the far right. Choose remove.


Roles Tab: Add Addresses for Orders

Warning: This is only available if you're company has our Project Management or Sales Management module.

If your account uses order management, each company has a Roles tab. This is where you store the addresses that print on orders and invoices.

Role

How many

Used for

Bill To

One per company

The billing address on sales orders and invoices

Ship To

Many

Delivery addresses you choose when setting up an order

Sold To

Many

The customer the order is sold to, with a credit status

Add a Role To a Company

  1. Open the company and go to the Roles tab.
    ​

  2. Click Create New on the role you need. The name and address fill in from the company; change them if this address is different.
    ​

  3. Click Confirm.To edit or delete a role, use the (⋮) menu on its row.

Notes Per Your Companies Module:

  • Project Management: Every Bill To and Ship To needs the ERP ID your ERP uses for that account. Each ERP ID can be used only once per role type. A company can have a Ship To only if it (or its parent company) has a Bill To.
    ​

  • Sales Management: ERP IDs aren't used. Instead, set Credit Status on each Sold To to Valid, Credit Warning or Credit Hold. The status appears as a warning when someone awards a quote to that customer.


If Something Looks Wrong

A teammate can’t see a customer?
The company isn’t shared with their branch. Add the branch in Manage Visibility.
​

There is no Bill To associations at this Company or Parent Companies?
Create a Bill To first, or link the company to a parent that has one.
​

ERP ID already in use?
Another company or role already has that ERP ID. Search for it and fix the duplicate.
​

Some import rows didn’t load?
Check that required columns are filled in and that each business type is on your list.
​

Sales Rep didn’t fill in on a new BOM?
​Make sure the customer company has a Sales Rep set. If it’s still blank, pick the rep on the BOM.
​

You can’t create a company, or the side panel won’t let you edit?
Ask your admin.


Related Articles


❓

Need More Help? Reach us directly through the in-app chat — just click the chat icon within Parspec

or email us at Support@parspec.io

Did this answer your question?