Firstly, create the import file.
The import file should contain the following fields in order, with no header row:
- Item Name (For initial import, the item name must be present. For later updates, it is not required as the vendor code is used to identify each item.)
- Vendor Code (If your vendor uses a name for this item that is different from the name you use, note the following. You can enter up to 60 characters as the vendor’s name for this item.)
- Purchase Price
- Price Schedule (optional)
- Currency (This field is present only if you use the Multiple Currencies feature.)
Import Process
- Go to Lists > Relationships > Vendor.
- Click Edit next to the vendor record.
- Click the Financial subtab.
- Click the Items subtab.
- Click Import Price List.
- The Import Vendor Price List popup window opens.
- Click Browse and go to the vendor price list file.
- Click Save.