You can update multiple Artist Profiles at once using a CSV file. Depending on the changes you're making, this process can be much quicker than editing artists one by one.
IMPORTANT: Handling Empty Cells Before Importing CSV Files
Before you import a CSV file into our system, we strongly recommend reviewing your CSV file closely and then:
Deleting any empty columns, and
Identifying any empty cells.
This step is essential when you already have data in the system, because you might unintentionally overwrite existing data in the system. That happens because the system interprets empty cells in the CSV as an instruction to clear any pre-existing data in the corresponding fields.
Taking this step protects the integrity of your data, ensuring the system imports only the information you intend. Time spent in preparation will enhance the accuracy and completeness of your data within our system, and save you time in the future.
1. Open Inventory.
2. While on the Artworks screen, scroll down and click Import CSV.
3. Click Download artists template.
4. Open the template.
5. Add the artist code (or firstname + lastname of the artist) in the columns and then update the rest of the information you need to edit.
6. Remove any columns that you do not want to update. Any columns you include and map during the upload process will be will be updated for the artists, including blank columns.
Make sure you only include or map the columns you wish to update.
Any columns you include and map during the upload process will be will be updated for the artists, including blank columns.
6. To upload your CSV, open the same window where you downloaded the template by going to Inventory and scrolling down to click Upload CSV.
7. Click in the Click here to select your CSV or TSV file to upload area to select your CSV file, then click Upload CSV.
8. Make sure that the columns from your CSV are correctly mapped. In the event that things haven't happened automatically:
Click Change to map the columns to another field.
Select the appropriate column.
9. Click Next Step: Process Import.
10. You will get a successful message if everything went well with the import.
