updating sort order on campaign member status

quick note re updating sort order on campaign member status

you cant do this via the UI, you have to do a data load

and sort order is unique, you cant set a member status to have a sort order of 2 if another one already is 2.

so lets say you have 10 member statuses, with sort order 1-10.

if you want to update them, query via workbench

select id,label,sortOrder from campaignMemberStatus where campaignId = ‘insert ID of your campaign here’

then to update the sort order, you need to set the new ones starting with 20, so you have 20-30

then the update will work

else you will get an error