Bulk update contacts

Bulk update contacts

Overview

You can update existing contact information in bulk by:

  1. Exporting your contacts into a spreadsheet.

  2. Editing the contact information in the spreadsheet.

  3. Uploading the spreadsheet data into Cin7 Omni.

  4. Mapping the spreadsheet columns to Cin7 Omni fields.

  5. Updating the contacts.

You can only update existing contacts (customer, supplier, branch, or internal). Import to create new contacts in bulk.

Export contacts and edit spreadsheet

Export your contacts from Cin7 Omni into a .csv file. You can then update this spreadsheet with the information you want to change in Cin7 Omni.

You can't update cash customers or cash suppliers.

Upload spreadsheet data into Cin7 Omni

  1. In the left hand navigation, select CRM.

  2. Select Actions and select Bulk Update Contacts (New).

  3. You can then update your contacts by selecting either:

    1. Import from file upload

      Cin7 Omni will update the contacts with the data from your spreadsheet.

      1. Select Choose file and then select your .csv spreadsheet.

      2. Select Next.

  4. Or Copy and paste file from clipboard

    ​​​​You can copy and paste the data from a spreadsheet. Cin7 Omni will then update with the information you have pasted.

    1. Copy your spreadsheet data and paste it into the field.

    2. Select Next.

Map fields and update contacts

  1. Cin7 Omni will suggest fields that match your spreadsheet columns.

  2. If the Cin7 Field is blank, or mapped to the wrong field, click on the Cin7 Field dropdown and choose the field you want to update.

  3. Select Next.

  4. Select Update Contacts.

  5. After your import is completed, you can click Back to CRM.

Was this article helpful?

Have more questions? Submit a request