Upon importing, you have the option to allow duplicates or not. Choosing YES for that setting should bypass your duplicate detection rules. So no need to unpublish / re-publish them manually.
As long as the Account GUID is unique, you should not get the duplicate message anymore.
Rule of thumb for me is:
when you're sure you're not importing NEW records, set allow duplicates to YES. You've ran an export in which you defined your filters, so you should be good.when you're importing NEW records and updating some existing, considder leaving it to NO, as you don't want to import a duplicate record.For this reason I rarely ever update and insert (upsert) records in the same load.
Good luck! Happy to hear that your current update worked!
If you've found this thread useful, dive deeper into User Group community content by role