Why are there errors in the customer upload batch?

Either because of invalid data or duplicate records.

Invalid data includes missing information or information in an incorrect format. You can correct some information directly in the Correct Customer Data spreadsheet. If the invalid data is related to the customer profile class, payment method, reference account, or customer bank account, then you must import the correct data using a new spreadsheet upload.

To avoid duplicating existing records, ensure that each customer in the Customers worksheet has a unique combination of these values:

• Customer number

• Customer account number

• Customer site number

Ensure that each contact in the Contacts worksheet has a unique person number.