How to import
- Open the import screenSelect "Import" in the staff list or the staff list overview.
- Select the CSV fileChoose the CSV file you created.
- Check the validation previewFor the first 50 rows, each row shows OK or error, and whether it will be created or updated.
- Run the importSelect "Import {n} rows" to start. When it finishes, you see how many rows were created and updated, plus any error rows.
Error rows are skipped
Rows with errors are not imported, and their row numbers and reasons are shown. Fix them and import again.
File requirements
- The character encoding must be UTF-8
- Up to 1,000 rows
- Separate multiple values in one column with semicolons (;)
- Rows whose "handle" value matches an existing item are updated, and rows with an empty "handle" are created as new
Staff CSV columns
| Column | Required | Details |
|---|---|---|
| handle | Optional | The key for updates. If empty, a new staff member is created. |
| name | Required | Staff name. Rows with an empty name are skipped. |
| store | Optional | Location name. |
| height / weight | Optional | Height (cm) and weight (kg) as numbers. |
| tags | Optional | Separated by semicolons. Example: Shibuya;New arrivals |
| profile | Optional | Self-introduction. |
| published | Optional | Publish status. Any value other than false is treated as published. |
| avatar_url | Optional (import only) | Image URL for the staff photo. The image is imported into Shopify Files. |
The staff import screen has an "Automatically add location names that aren't registered yet" checkbox, and it is on by default. If you turn it off, rows with a location name not in Locations are skipped with "Location is not registered".
Staff list CSV columns
| Column | Required | Details |
|---|---|---|
| handle | Optional | The key for updates (the list ID). If empty, a new list is created. |
| title | Required | List name. |
| type | Required | manual or auto (automated). |
| rule_mode | auto only | all (match all conditions) or any (match any condition). |
| rule_conditions | auto only | Condition tags separated by semicolons. Add "!" at the start of a tag to make it an "is not equal to" condition. |
| rule_tags | auto only | A column kept for compatibility with the older format. Enter tags separated by semicolons (example: Tokyo;Manager), and staff with any of these tags are included in the automated list. If empty, all staff are included. Setting conditions with rule_mode and rule_conditions is now the main method. |
| staff_handles | manual only | Handles of the staff in the list, separated by semicolons. The order you write them in is the display order. |
When importing staff lists, rows that were updated because their handle matched are still counted as "new" on the results screen.
How do I export?
Select "Export" on either list screen to download all current items as a CSV file. Edit it and import it again to update in bulk.