Skip to content

Import Stock Wholesaler File

IMPORT STOCK WHOLESALER FILE

Stock Price Update Routine

Stock prices can be updated using your main supplier’s price update file for the following suppliers:

Covetrus, MWI and NVS

Support has also recently been added for the following Irish suppliers:

Bimeda, Chanelle and Interchem

C & M (Covetrus Ireland) This price file is provided in Excel and needs to be saved as a tab separated .txt file before it is run.

  1. Having already downloaded (and formatted for C & M) and saved the > file from your wholesaler onto your Server, on the Assisi Desktop, > click Settings>Stock and, on the Stock System Setup > Menu, click Import Wholesaler File.

  2. Click > the browse button and open the relevant file.

  3. Select your supplier from the drop-down list. (For Covetrus select HSAH and for MWIAH select CENT)

  4. Click Update Stock File if you wish to implement the auto price update facility. If you just wish to update the catalogue without adjusting any of your stock prices automatically, leave this box unticked.

Note: Any products with a zero markup will not be included in the price update routine. These prices will need to be maintained manually.

  1. Only click Allow Price Reductions if you wish to apply any price reductions. Otherwise leave this box unticked.

  2. Click Import File.

  3. A progress bar will be displayed and once the import is complete a prompt will be displayed. Click OK.

  4. The Last Updated field on the stock file will be updated to today’s date for all products where the cost price has been amended.

Please Note: This will update prices of products, where applicable, where:

  • the correct Supplier Name and Supplier Ref are specified on the > Stock Product Maintenance Screen and

  • the Markup % field is not set to zero.

Price Update Reports

  1. On > the Assisi Desktop, Select Reporting>Monthly > Reports>Wholesaler Catalogue Reports.

  2. Select your supplier from the drop-down list.

  3. You can print the following reports:

  4. Price Changes

  5. Additions (to the previous catalogue)

  6. Deleted (from the previous catalogue)

  7. Select your relevant report/s and, when the display is populated, click Print.