Yes, you can do this with a file. Import a spreadsheet that lists your units with the tags or custom field values you want to add. An import adds to the units you already have and doesn't make copies of them, as long as PayHOA recognizes each row. The file only needs the unit column plus the columns you're adding. A blank cell leaves the unit as it is.
To put one tag on units you can tick in the list, you don't need a file. See Tags.
What you need in the file
Unit Number | Unit Tags | Parking Space |
Lot 12 | Phase 2 | P-14 |
Lot 14 | Phase 2; Corner Lot | P-15 |
Lot 15 | P-16 |
Unit Number identifies the unit. It must be the unit's title exactly as it is in PayHOA.
Unit Tags holds the tags to add. Separate several with a semicolon, never a comma.
A custom field column is headed with the field's name, here Parking Space. Use one column per field.
For owner tags or owner custom fields, add Owner 1 First Name and Owner 1 Last Name, exactly as PayHOA has them, and an Owner Tags column or a column per owner field. They're saved on the first owner on the row, and only when the row has the owner's name. Without the name, the mapping page still shows the owner tag as a chip, but it isn't saved.
The easiest way to get the unit titles right is to export them from Units with Export CSV.
Steps
Export your units. Click Units, then Export CSV. Keep Unit Title. Delete every other column, including Unit Tags and the balance columns. See the full export steps.
Add your columns. Head a tags column Unit Tags. Head a custom field column with the field's name.
Fill in the cells. Leave a cell blank where there's nothing to add.
Upload the file. Click Units, Add units, then the Import owners and units tab. See 1. Open the importer.
Answer Confirm your import. Unit tags are only saved when the sentence says unit and property data. A file with only a unit column, a tags column and a custom field column can be described as custom field data instead. If it is, click No, let me clarify, type This is unit data. Update the units and owners we already have. and click Continue. The window comes back with a green line, Updated using your clarification, and a new sentence. Check it says unit and property data, then click Yes, that's right and Continue. Custom field values are saved whatever it says. See 6. Confirm your import.
Check the columns. The tags column should sit under Unit Tag, and a custom field column under that field's name followed by (unit field). If a window asks what to do with a column, choose Tag or Custom Field. See 7. Columns need your input and 10. Match your columns.
Check the rows (next section), then click Start import.
Check the result. Import complete shows Tags created and Unit custom field values saved, and no New units created card. Tags created counts every tag the import put on a unit, including tags you already use, so one tag added to 40 units reads 40. Unit custom field values saved counts the rows that had a value, changed or not. See 15. Import complete.
What you'll see before you import
Every row for a unit you already have should read No changes. Tags and custom field values never turn a row into Updating.
Tags show as chips in their column: blue for a tag that will be created, green for a tag you already use.
Custom field values have no mark, even when they replace a value the unit already has.
Important: No changes doesn't mean nothing is saved. When the file only adds tags and custom field values, the line above the table reads 40 records match your existing data. No changes will be made. Don't rely on it. Start import saves every tag and value in the file.
Don't import if you see one of these. Fix the file first.
New, or a warning triangle: PayHOA didn't recognize the unit.
One blue chip holding several tags, as in the second picture: they were typed with commas.
A blue chip for a tag you already use: the spelling is different, or the tag is in the wrong column. Unit tags and owner tags are separate lists, so a unit tag typed under Owner Tags shows as new.
What gets added, and what doesn't
In your file | What happens |
A tag the unit doesn't have | Added. A tag nobody uses yet is created. Capitals don't matter: phase 2 is saved as your existing Phase 2. |
A tag the unit already has | Nothing. It isn't added twice. |
The unit's other tags | Kept. An import never removes a tag. See Manage tags. |
A custom field value for a unit that has none | Saved. |
A custom field value for a unit that already has one | Replaced, with no mark on the mapping page. Leave the cell blank to keep the old value. |
A custom field that doesn't exist yet | Created by the import when you choose Create new custom field above the column. Afterwards, check who can see it. See 9. Add custom field. |
A blank cell | Left as it is. An import can't empty a field. |
Units that aren't in the file | Untouched. |
Notes | No column. See Tags, notes and custom fields. |
Watch out for
Warning: There is no undo. Take a tag off the wrong units under Settings, Tags, Manage Tagged. A value that was replaced has to be typed again.
Important: A comma doesn't separate tags. Corner Lot, Pool Access becomes one new tag with that whole name. Use a semicolon.
Important: Don't reuse the Unit Tags column from the Units export. It separates tags with commas, and its automatic tags, such as Missing Email Address, would become real tags.
Common questions
Can I add a tag to many units at once from a spreadsheet? Yes. Import a file with a unit number column and a Unit Tags column, read as unit and property data on Confirm your import. Each tag is added to the unit on its row. Tags the units already have are kept. You don't need addresses or owners in the file.
Will importing remove the tags a unit already has? No. An import only adds tags. Tags that aren't in your file stay on the unit. To remove a tag, use Settings, then Tags.
The unit already has a value in that custom field. Will it be overwritten? Yes, if the cell in your file has a value. The new value replaces the old one, and the mapping page doesn't mark it. Leave the cell blank to keep the value the unit has.
It says no changes will be made. Did something go wrong? No. Rows that only add tags or custom field values read No changes, and the line above the table can say No changes will be made. Click Start import anyway. They're saved.

