thread Re: NEW: how to correct a bad import of customer data in Archived Discussions (Read Only)

NEW: how to correct a bad import of customer data

Dawgs64 — Fri, 25 Jan 2019 12:59:13 GMT

I'm trying to import my customer list from a CSV file and I keep getting an error "Wrong Number of Fields". I've downloaded the template and copy/pasted my email list info one at a time and still get an error. Then I tried exporting a list of what I currently have entered, changed the fields to match...still get the same error. Any suggestions?

Re: NEW: how to correct a bad import of customer data

1hbomb — Sun, 12 Jan 2020 23:47:30 GMT

I am also getting an error when I import my customer list "wrong number of fields".

Only first 15 imported of several hundred customers imported.

I am on a mac, tried Chrome and firefox browsers. Deleted cache on both browsers then restarted browsers. Using the .csv template provided by square.

I also reordered the list from the 15th entry to see if there was something specific.

Re: NEW: how to correct a bad import of customer data

JustinC — Tue, 14 Jan 2020 21:13:06 GMT

Hey there @Dawgs64 & @1hbomb - sorry you're having trouble importing your customers. Have you looked at these most common importing errors yet? You'll find some troubleshooting tips that might help.

Re: NEW: how to correct a bad import of customer data

1hbomb — Tue, 14 Jan 2020 21:48:18 GMT

Thanks for that JusinC. I did double check all of that. None address the error I was getting. It took two square customer service folks to get in imported correctly.

The second was a customer directory specific one.

From what I understand, the second person copy and pasted my list into goggle sheets and resaved it as a .csv doc then imported it.

Re: NEW: how to correct a bad import of customer data

JustinC — Tue, 14 Jan 2020 23:09:11 GMT

Ah, Sweet! 🙌 I'm glad Support was able to help. Spreadsheets are super finicky and a pain to import in my opinion lol. Thanks for sharing the fix with us.

@Dawgs64, hopefully @1hbomb's post helped with next steps!

Re: NEW: how to correct a bad import of customer data

RoniM — Sat, 25 Feb 2023 20:59:55 GMT

Thanks for this 1hbomb. I was facing the same issue and tried this workaround and it worked.

@JustinC this should be marked as the correct answer. I was looking at another thread 'Import customer names and email' which didn't show this answer. Thank you.