is it possible to mass delete addresses?
# suitescriptm
mg2017
08/05/2020, 11:13 AMis it possible to mass delete addresses?
g
Grant
08/05/2020, 3:17 PMHave you tried a CSV import with Overwrite Sublists checked?
Grant
08/05/2020, 3:18 PMI would test this on a sandbox or one record first before trying it on your whole account.
m
mg2017
08/05/2020, 4:13 PMyeah, i decided to go via this option. it somewhat works when there are 2 addresses only. i asked in the csv import channel
mg2017
08/05/2020, 4:14 PMwhen updating customer address i encounter an issue where there is more than 2 addresses. Ex: customer x has 2 addresses: add1, add2. I up an update using the override sublist as i want to remove add2. so my import only contains add1. after the import add2 is removed. this is perfect, however, if i have add1, add2, add3 and i wish to remove add3, i only have add1 & add2 in my import file. however, in this instance, add1 & add2 are removed instead of add3. why is this happening?
mg2017
08/05/2020, 4:14 PMthat's what i said
m
michoel
08/05/2020, 11:28 PMI had a similar issue and ending up running it as two imports. Import 1 with the first address and overwrite sublists checked, and import 2 with any additional addresses and overwrite sublists unchecked
d
David B
08/06/2020, 4:03 AMHey, can't you just use one line per customer and just have extra columns for address 2,3,4…
Using "Customer - Address 1 : …", "Customer - Address 2 : …"
Can all go in the same import
David B
08/06/2020, 4:05 AMIdeally use the correct column names to have the mapping happen automatically, but otherwise use this plus sign to add more than one address per row
m
michoel
08/06/2020, 4:38 AMThat might work, I only tried with separate rows for each address and from memory when I did overwrite sublists the second row would overwrite the first
m
mg2017
08/06/2020, 2:07 PMThanks. I didn't realise that + existed.
15 Views