Update Asset Metadata by CSV
Update asset metadata for hundreds of existing assets simultaneously from a CSV file instead of manual entry
Update Asset Metadata by CSV allows you to update multiple existing assets in HIVO simultaneously using a CSV file. Instead of opening each asset to edit it manually, you can:
Export your asset data -> edit the data in the CSV -> import it back into HIVO with Bulk Import Asset Data.
Update an asset's Name, Folder Path, Production Date, Location, Tags and Metadata fields.
⚠️ Who can use it: Client Admins who have permission to edit assets. The import and export pages are in Client Profile -> Settings -> Reporting & Data.
1. Export Asset Data to get the Internal Asset ID
The safest way to update assets is to match them by their Internal Asset ID. Do not create Asset IDs manually. Instead, export your asset data from HIVO so you have the correct IDs.
🔹 Step 1. Export Asset Data
👉 Go to Client Profile -> Settings -> Reporting & Data -> Export Data via CSV, then select the Assets tab.
Click the Select folder path field to choose the folder containing the assets you wish to export. Tick Include all results in sub-folders to include assets in its sub-folders too.
You can use filters to narrow down the assets you want to export:
Created from / Created to
Last modified from / Last modified to
Then select Export Assets. HIVO prepares the CSV in the background and sends you a notification with the download link when it's ready.

The exported CSV contains these columns: ID (the Internal Asset ID), name, location, tag, createAt, SKUs... (if you can see Products), and one column per metadata field.
🔹 Step 2. Prepare the CSV File
Open the exported CSV file.
Keep the ID column intact. This is the Internal Asset ID that HIVO uses to find each asset during the import.
Edit the columns you want to update, or add new columns for metadata fields. You can delete any columns you don't want to change.
The first row must contain the column headers. The file can be up to 50 MB.

2. Import the CSV File
👉 Go to Client Profile -> Settings -> Reporting & Data -> Import Data via CSV. The import has four steps: Upload CSV, Map Columns, Confirm and Import and Review Results.
🔹 Step 3. Upload your CSV File
Set Target to Assets. Import Mode is always Update Only for assets.
Drag and drop the CSV file into the upload area, or click Choose CSV File to browse your computer.
HIVO reads the file and moves on to the next step automatically.

🔹 Step 4. Map Columns
For each column in your CSV, choose the HIVO field it should update, or choose Ignore to skip it. Click Auto-map Columns to let HIVO match columns to fields by their headers, and Reset mappings to start again.
The fields you can map are ID, Name, Folder Path, Production Date, Location, Tags, an existing Metadata field, or New Metadata Field.
You also need to choose how HIVO finds each asset. Tick Select as matching field on one of these columns:
ID (recommended): map the
_idcolumn to ID. It's automatically used as the only matching field, and each row updates exactly one asset.Name and/or Folder Path: assets are found by their current name and/or folder. A column used for matching is only used to find assets; it isn't updated.
Click Next when the mapping is done. You can't continue until a matching field is selected.

🔹 Step 5. Confirm and Import
Check the summary before importing:
the matching fields that will be used to find the assets,
the column mappings, and
a preview of the first rows of your data.
Click Import to start updating the assets. Large files are imported in batches, so this can take a few minutes.

🔹 Step 6. Review Results
When the import finishes, HIVO shows how many rows were processed, how many assets were updated, and how many rows were skipped or failed. Common reasons a row is skipped:
Upload not found: no asset in your account has that ID.
No matching upload found: no asset matches the Name or Folder Path in that row.
No changes to make: the row has no values to update.
If some rows failed, click Download Error Records to get a CSV of those rows with the error for each one. Fix them and import that file again.
Click Start New Import to import another file.

Error Records preview

If you have any questions, don't hesitate to ask, we're always here to help!
Last updated