Importing Data

Barkpass allows you to import existing customer data into your organization so your users don't have to create accounts and pets from scratch.

Visit your Organization Settings Imports page to get started.

Upload a CSV or Excel file to perform an import. 

Available Columns

Note: some columns are required.

  • email (required)
  • name (required)
  • address_1
  • address_2
  • city
  • state (must be abbreviation, e.g. IA for Iowa)
  • zip
  • phone
  • secondary_name
  • secondary_email
  • secondary_phone
  • pet_name (required, if providing pet data)
  • pet_type (required, if providing pet data)
  • pet_breed_1
  • pet_breed_2
  • pet_color
  • pet_sex
  • pet_weight
  • pet_birthday (formatted YYYY-MM-DD)
  • pass_name
  • pass_expires_at (formatted YYYY-MM-DD) (required, if providing tag_number)
  • tag_number
  • tag_prefix
  • transaction_amount
  • custom_pet_* (see Importing Custom Fields)
  • custom_user_* (see Importing Custom Fields)


Importing Users

  • Existing users are matched based on email.
  • New users are created with a random password, and users can log in using the Reset Password functionality.

Importing Pets

  • Existing pets are matched based on pet_name.
  • pet_name, pet_type, and pet_breed_1 are required fields if you are adding or updating a pet

Importing Passes

  • To import a pass, provide a pass_expires_at column
  • Optionally provide a pass_name. This is useful if you are importing multiple passes which have the same "expires_at" value.
  • If no pass exists with the valid_until date matching that column, a new one will be created for you.
  • You can update the auto-generated name after running the import.

Importing Tags

  • To import a tag for a pet, you can add a tag_number column
  • You can import more than one tag (e.g. for a different pass). To do so, repeat the row in your data source with the required information for the user and pet.

Importing Custom Fields

  • To import custom fields for a pet or user, prefix the name of the custom field with pet_custom_ (for pets) or user_custom_ (for users)
  • The name of your field should be lowercase with underscores _ separating words
  • For example, if your custom field is named Microchip ID, its full pet custom field column would be pet_custom_microchip_id.
  • If the field does not yet exist for your organization, it will be created. You can always change the name later.

Importing Transactions

  • To import transactions, include a transaction_amount number
  • Transactions are assigned the "Other" category and do not include any additional payment information
  • When importing importing multiple pets to the same pass and application, you can include a transaction_amount for each pet if the transaction was recorded individually, or just for one of the pets if the transaction was recorded in bulk (combined).

Clearing imported data

If you've made a mistake or your import has issues, you can clear all of your organization's data by visiting Organization Settings Imports and scrolling to "Clear Data."

  • This will remove ALL data from your organization, excluding any Pass information and administrators which are kept for your convenience.
  • WARNING: This action is irreversible. This removes ALL data and users, not just data you have imported.

Import Log Retention

Import logs containing row data are kept for 30 days before being deleted.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us