Vendor Import

Go to Admin Tools-> Imports, and click directly on Imports

Step 1 - Upload File

Type: Choose “Vendors”

File: Choose CSV file – see attached field definitions for file format. The fields where data is REQUIRED in the file are listed in the figure above, on the right side of page. Note that the fields in the CSV file are NOT required to be in any specific order.

Mode:

• Option 1. Create and Update – will update any changes from the file for existing items, will add any new items from the file to the product database.
• Option 2. Create Only – will ignore any existing products in the file.
• Option 3. Update Only – will ignore any new products in the file.

Attributes set – for user defined attributes not covered by default fields. Will be covered separately as an advanced topic.

Once all file import settings have been chosen, click NEXT (upper right hand corner)

Step 2 -  Map Fields automatically vs Create a Mapping

There are no exceptions that would require manual mapping in this file.

_{(figure above does not necessarily include all available fields, see attached field definitions)}

The file is then read, and a list of the fields in the SalesWarp database which match, or (don't match) the CSV file is displayed. If you have an "X" in any row for the "Field Found" column, then you either need to (1) rename those fields in your CSV file to match the field from list, 2) add fields that may be missing entirely, or (3) create a new mapping.

For missing fields, the field headers are required, simply add them as blank columns. Data is not required except as noted above. Note that if you need to alter the file, you will have to start the import process again.

If you have no "X" in the "Field Found" column, then you may immediately select the map fields automatically button. Additionally, note that if there are fields in the file that aren't listed they will be ignored. Note: if the headings do not match, and you do not map manually, then those columns, also, will be ignored.

Remember that the field headings are case sensitive! It will still likely be easier to rename the headings in your file, than to build a map. That way you can always use the automatic function, and not have to worry about constantly creating or reusing an existing map.

When ready to continue, click "Next" in upper right hand corner.

Step 3. Verify and Process the Import File

The system will verify the file data, and you will be alerted to any specific issues in the file that need to be corrected prior to importing. If there are no issues with the file, you may be given an option to process the file immediately, but more likely you will be required to queue the file to process later. (Process now functionality is based on the file size - If you have more than a few vendors, your file will probably not pass the size check.)

If you want to monitor the queue, press "back to list" button in top left hand corner, and then the queue button on the far right - you will be able to see if the file has begun or finished processing. Note you may need to hit the refresh button on your browser.

 

Once completed, go to the PO/Receiving tab, select Vendors, and review the vendors.