Hey everyone! Is there a simpler way to import dozens of addresses into a single customer instead of manually mapping each address? Thanks!

As far as I know, there is no faster way than this. If you find yourself doing this often, what I did was created and saved a CSV import that had like 20 addresses. Then each time I needed to do an import, I just removed the ones I didnt need and did a "Save As" (so I wouldn't lose the original one with 20 addresses)

Yes just use a separate address file and do a multi-file import. That functionality you're showing can be used if you have all your 20 addresses in columns, but I'd try to convert it to a file where you have each address as a separate line. You'd need the internal ID of the customer on the line to link the two files together.

Thank you both for the replies! Could you elaborate a bit more @rsm_ryan_meyer? I don't really follow, thank you!

I have them in the same tab here just for illustration, but File 1 and File 2 represent two different CSV fields. File 1 would contain all the customer fields you want to set other than Address fields. File 2 would contain all the addresses you want to import with 1 address per line. They're linked by External ID in my example although you could make up some reference column that doesn't get imported if you're using External ID for something else. When you select a multi-file import on the first screen, there's an extra step in the CSV process where it will ask you what field you want to use to link the files together. That's where you choose External ID or whatever your link is. Obviously we'd need more fields in both files to successfully complete the import, but if we saved each file like below and imported, the 4 address records in green would be added to ABC Company and the 2 in yellow would be added to DEF Company.

Wow, thank you so much for that straight forward illustration! Really, really appreciate it. Happy Friday!

This doesn't sound necessary. If you just have an excel sheet with addresses on each line with the customer field repeating, it will import each address to a separate record on the customer. You just have to make sure that the address Label field is unique.

It does work that way too, yeah. But if the 'header' (other customer) data isn't clean, you end up accidentally creating other customers and duplicate addresses are always possible and all that fun stuff. I've taken to just doing separate files a lot of the time with this type of thing just because it can be a pain to fix if you don't have everything right the first time.

I hear you. I had a lot of customers with over 1000 store addresses, so i had a big file with customer internal ID as one column and then the addresses. Some excel work to make a clean sheet, but it made the importing pretty trivial