Purpose
This routine can be used to upload Product suppliers and rankings from a file created outside of the system. This is an alternative way of updating product suppliers into the system and is most useful when you are updating large volumes. Using this method a “spread-sheet” style tool can be used to create a list of products you want with supplier details as needed.
Note: This function only uploads suppliers for existing products. For additional details on creating upload files see the note HERE.
Data Input
Step 1 – Upload File
Clear or Append
Select ‘Clear’ if you want to replace the existing suppliers and ranks recorded on the products found in the file you upload. If you want to add more product suppliers onto what is already recorded in the system, then choose the ‘Append’ option. This option ONLY applies to the products listed in your file and does not clear all product suppliers recorded in the system.
Upload File
Find and select the spreadsheet file you wish to upload, by clicking ‘Browse’. This assumes you have access to the file with the product supplier details from the browser that you are currently using.
Step 2 – Verify File Details
A list of the new product suppliers and ranking details from the file are displayed so that you can review the data and confirm that the correct file has been uploaded before you continue.
Click Submit to submit all the details.
Return to the Top
Spread sheet format
The spread sheet must be in a csv format.
The first row of the spread sheet must be a heading row – it does not matter what the headings are, as long as they are meaningful to you e.g. you could have ‘Product’, ‘Product Code’ or ‘SKU’.
The columns required are:
| Column | Name | Additional Details |
| A | Product Code | Mandatory. Must be a valid product on the Product Master. |
| B | Supplier Code | Mandatory. This is the supplier code to upload. The supplier may not be duplicated on any given product. |
| C | Rank | Optional. The rank must be numeric. Suppliers with a rank of 1 are chosen as the supplier to use when creating replenishment purchase orders. |
Updating
Once you click submit, the rows on the spread sheet are validated.
If no invalid data is detected, the list of suppliers is updated on the products ready for use.