Skip to main content

Updating Many Items in a Collection at Once

Written by Melinda Haughey

This article is about the Proxi admin app at app.proxi.co.

A collection is a table of places — each row is one item, and each column is a field you've set up. When you need to update lots of rows at once, open the collection (under Collections in the sidebar) and use either quick select actions or the spreadsheet view.

One thing to know: collections can rename their items. If yours calls them Vendors or Artists instead of Listings, the buttons below will use that word — everything works the same.

Selecting Items for a Quick Action

  1. Click Select in the toolbar and check the rows you want. Select all matching grabs everything that fits your current search (up to 500 at a time).

  2. From the bar that appears you can:

    • Edit field — set one dropdown or checkbox field to the same value across everything selected. Pick the field, choose the value (or clear it with No value), and apply. For fields that allow several values you can choose whether to add, remove, or replace, and you can create a new option on the spot.

    • Delete — remove the selected items from this collection. This can't be undone, so we'll ask you to confirm.

Editing in a Spreadsheet

Click Bulk Edit to open the collection as a spreadsheet — type in cells, paste from Excel or Google Sheets, drag to fill, and save when you're happy. The basics are covered in Using the Bulk Edit Spreadsheet; a couple of things are special to collections:

  • Photos — photo columns are tucked away by default since they can be slow to load. Check Show image columns above the table to reveal them. Click the pencil on a photo cell to add or manage photos, or paste web links to images straight into the cell and we'll add them.

  • Rich text — fields with formatted text edit as plain text in the spreadsheet for now.

  • New rows — the spreadsheet is for editing what's there. To add items, use the Add button above the table, Import a file, Add from listings, or Find places.

Importing and Exporting

The buttons at the top of the collection page cover files: Download exports the collection as a CSV, and Import brings in rows from a spreadsheet file.

Did this answer your question?