If you use the Pricing Hub, you can update central items' purchase prices and optionally mark them as discontinued by uploading a file through Import from file. Select the Sync wholesaler items import type to do this. This import type only updates items that already exist in Vetera, and it is only available from the central clinic location when the Pricing Hub is enabled.
Updating a central item's purchase price also updates the purchase price at any clinic location that follows the central item pricing method.
Before You Start
You are working in the central clinic location.
The Pricing Hub is enabled for your organization.
You have a file from the wholesaler (for example, downloaded from the wholesaler's website) listing current items, with columns for the item's code (either Vetera's own item code or the wholesaler's item code, depending on the identification method you plan to use) and the purchase price. Supported file formats are XLSX, XLS, and XML.
Import the File
Select the File and Import Settings
In the central clinic location, go to Settings > Import & Export > Import from file.
Drop the file into the upload area, or select a previously uploaded file from the Existing file drop-down list.
From the Import type drop-down list, select Sync wholesaler items.
Under Identification method, select how to match items in your file to items in Vetera: Item code, or Wholesaler & wholesaler item code.
Select the wholesaler from the Wholesaler drop-down list.
Keep Check for discontinued items selected to mark items as discontinued when they no longer appear in the file. Clear it to only update prices.
Select Next.
Map and Run the Import
On the Mapping page, map Purchase price excl. VAT and either Item code or Wholesaler item code, depending on which identification method you selected. The matching field is automatically set as the key field. If your file's column headers exactly match these field names, Vetera maps them automatically. For more on mapping, see Import from File.
Select Next.
On the Preview and import page, review the items that will be updated and, if selected, the items that will be marked as discontinued.
Select Start import.
The selected items are updated in the central clinic location, and the changes propagate to local items across clinic locations.
What Happens During the Import
Items in the file that match an existing item, using the identification method you selected, have their purchase price updated. If the price has not changed, that item is skipped.
If Check for discontinued items is selected, items linked to the selected wholesaler that do not appear in the file are marked as discontinued and hidden from ordering search. Archived items are also checked and updated.
Note: The Sync wholesaler items import type does not add new items — it only updates and marks existing central items as discontinued. This limitation applies only to this import type. To add new central items, use a different import type in Import from file, or see Create and Manage Central Items.
Check the Import Status
Go to the Import progress page to follow the import. The Model column shows Sync wholesaler items for this import type, and the Status column shows whether the import succeeded, failed, or was reverted. If rows failed, the failed row count is shown, and you can download the errors.
Once the import finishes, select Report next to the completed import to open the post-import report, which shows an overview of the import and a list of any items marked as discontinued. You can also select Undo next to the same import to revert it — this restores the previous prices and clears any discontinued flags the import set.