Product CSV Troubleshooting Tips

This reference provides troubleshooting tips to resolve common CSV import issues for the Mass Upload/Change Products feature.

Reminder: Do NOT delete or rename any columns from the Product CSV Template. Deleting columns will cause the CSV import to fail.

File Size is Too Large

If you cannot get your updated Product CSV to import into Vetspire, the most likely cause is that your file size is too large.

To resolve this issue, break up your spreadsheet into separate, smaller CSV files and import them into Vetspire one-by-one. Ensure that the header row of column titles displays at the top of each spreadsheet.

Vetspire Recommends

Remove rows for products with no changes from the Product CSV. Deleting a row does NOT delete the product in Vetspire.

“Disabled” vs. “Enabled” Columns

“Disabled” Column

When viewing a product’s details in Vetspire (More > Inventory & Services > Manage > Products), there is a field under Details > Settings labeled Is Enabled Everywhere?

• When the Is Enabled Everywhere? field is set to Yes, the product is enabled at all of your organization’s locations.

• When the Is Enabled Everywhere? field is set to No, the product is not enabled for the entire organization. You must enable the product for specific locations in the product details.

The disabled column in the Product CSV corresponds to the Is Enabled Everywhere? field in the product details in Vetspire.

• Enter FALSE in this field in the CSV to enable the product at all of your organization’s locations.

• Enter TRUE in this field in the CSV to disable the product for the entire organization.

Once you set disabled = TRUE, you can specify which locations the product is enabled for in the Enabled: [Location ID] column.

“Enabled” Column

In the Product CSV, the Enabled column title ends with a suffix of the location ID (for example, “Enabled:1234”).

• Enter TRUE to enable the product at a location.

• Enter FALSE to disable the product at a location.

Duplicate Product Names

Each product name must be unique. To check for duplicate product names in Excel:

1. Select the Name column to highlight the entire column.

2. Select Home > Conditional Formatting and hover over Highlight Cells Rules.

3. Select Duplicate Values, then select OK in the Duplicate Values window.

Any duplicate values are highlighted in pink.

Special Characters in Product Names

Entering certain special characters in the Name field will cause the import to fail. The following table describes which special characters are and are not supported.

Product Type Formatting in CSV

Product types cannot be added to Vetspire via the Mass Upload/Change Products feature. Entering a product type that is not already in Vetspire or using a different spelling of an existing product type will cause the import to fail.

• Match the capitalization of the product type as it displays in Vetspire. For example: If the type is Reference Lab Service and you enter “reference lab service” in the CSV, the import will fail.

• Entering additional spaces at the beginning or end of the product type in the CSV will cause the import to fail.

Example Product Type	Incorrect Formatting
	“Injection” – The missing “s” at the end will cause the import to fail.
	“In-House: Benchtop Laboratory Services” – Entering a colon instead of the dash will cause the import to fail.
	“Nutraceuticals and Supplements” – Entering “and” instead of the ampersand (&) will cause the import to fail.

Issues with Product Details Columns

Vetspire Recommends

Refer to the Product CSV Columns Reference for a list and description of all product details columns in the Product CSV template.

The following fields must be set to TRUE or FALSE. Entering any other value or leaving the field blank will cause the import to fail:

• Is Euthanasia

• Is Controlled Drug

• Is Neuter

• Coerce Integer Quantity

• Only Inventory

• Track Inventory

• Deleted

• All Category columns

Issues with Pricing Columns

Vetspire Recommends

Refer to the Product CSV Columns Reference for a list and description of all pricing columns in the Product CSV template.

If you are adding new products, leave the following fields blank:

• All Taxed columns

• Enabled

• Price: Type

• Price: Dispense Fee

• Price: Unit Fixed Price

• Price: Unit Markup Percent

• Price: Minimum Price

• Price: Deleted

If you are updating existing products, the following fields must be set to either TRUE or FALSE:

• All Taxed columns

• Enabled

• Price: Deleted

Best Practices

Ensure that all other users at your practice do NOT update product details or prices in Vetspire while you are downloading and importing the Product CSV, or your Product CSV changes will override the user’s changes.

Products can still be invoiced in Vetspire while you are downloading and importing the Product CSV.