Help · Sales
Bring a warehouse customer over with the switching kit
The switching kit brings a warehouse customer's records into ContactRoll from the files its old systems export: its clients (the shippers it stores for), their contacts, its buildings, each client's rate card, each client's contract and service levels, its open claims and its recent invoices. It is under Settings, Warehouses, Switching kit.
A file can be one of ContactRoll's own templates (CSV or Excel), an export from HubSpot or Salesforce, or the customer's own billing spreadsheet. ContactRoll reads the file in your browser. It doesn't connect to HubSpot, Salesforce or any other system.
Do the files in this order
Each kind of file finds the records the ones before it brought in:
- Clients (shippers): a company a row.
- Contacts: a person a row, with the name of their client.
- Buildings: a building a row, with its pallet positions, square feet, dock doors and temperature.
- Rate cards: a charge a row, with its client, charge code, unit and rate.
- Contracts and service levels: a row a client and building, with the pallets and square feet it reserves and its targets.
- Open claims: a claim a row, with its client and claim number.
- Recent invoices: an invoice a row from the old billing system.
Start from a template, or from the file you have
Choose what the file holds and where it came from. To start from ContactRoll's columns, choose Download the template (CSV) or Download the template (Excel). Each template has two invented example rows: delete them before you import.
If you already have a file, such as a HubSpot export of companies or a billing spreadsheet of rates, use it as it is.
Say once which column holds what
Choose the file. ContactRoll guesses which column holds each field from the column names. HubSpot's and Salesforce's usual column names are guessed for you, and so are ContactRoll's template columns. Check each choice, say how the file writes a day (2026-11-03, 11/03/2026 or 03/11/2026), then choose Save the mapping.
The mapping is kept for that kind of file from that source. The next HubSpot export of companies is read the same way, without choosing again.
A billing spreadsheet's own words are understood: a category such as Inbound, Storage or Fulfillment, and a unit such as per pallet, PLT, CTN, EA, cu ft or hr. If a rate has no category, ContactRoll reads it from the charge's code and name.
Preview, then import
Choose Preview to see what the import would do, row by row: new, already here, or already here with blanks filled in. A preview changes nothing.
Choose Import to keep it. Each row that isn't taken is listed by its line in the file, or its row in the sheet, with the reason. Fix those rows and import the file again. The rows already taken are matched, not made twice.
What happens to a record that is already here
ContactRoll never makes a second copy of a record it can match:
- A client is matched by its id from the old system, then by its website, then by its name.
- A contact is matched by their id from the old system, then by their email address.
- A building is matched by its name.
- A rate card is matched when the client already has one with exactly the same charges and rates.
- A contract is matched when the client already has the same space in that building.
- A claim is matched by its claim number, and an invoice by its invoice number.
A matched record only has its blank fields filled in. Anything it already has stays as it is. If a file says something different from what is already here, for example another rate for a service level, that row isn't taken. Change it on the client instead.
Rate cards arrive as drafts
Each client's rates become one draft rate card. Check it against the customer's contract, then activate it on the client's page from the day the contract began.
Open claims and recent invoices
Each open claim becomes an open case about the client's contact, with its claim. The case says the claim came from the old system and when it was opened there.
Recent invoices are kept beside the client, under Invoices from before ContactRoll, with what is still owed. They are a record of the past. ContactRoll doesn't send them, charge them or give them its own numbers.
Undo a whole import
Every import is listed under Imports on the same page. For 7 days you can undo one:
- Clients, contacts and cases it made go to Trash, where they can be put back.
- Buildings, draft rate cards, contracts, service levels and invoices it made are deleted.
- Fields it filled in are blank again.
A record that was changed or used since the import is kept, and the undo lists it with the reason. For example, a client with a rate card that was activated, or a contact with a case of their own. Undo the later imports first, such as contacts before clients.
Who can use it
Anyone who may import records can open the switching kit. Each kind of file also needs the permission to make that kind of record: clients and contracts need permission to add companies, contacts need permission to add contacts, buildings need permission to change the organization's settings, rate cards and invoices need permission to make invoices, and claims need permission to work cases. The Owner and Administrators have all of these.
Didn’t find what you needed? Ask us on the help center: the form is at the foot of its page, and the people who build ContactRoll answer.