Supplier Data Upload

These are the common fields used when uploading supplier data.  Template attached below. 

Field	Detail
SupplierNumber	Optional, unique when entered
SupplierName	This is the supplier name and must be unique
AddressLine1	Supplier Address Line 1
AddressLine2	Supplier Address Line 2
City	Supplier City
StatesName	State or province name.  Abbreviations will convert to full name on import
PostalZip	postal or zip code
CountriesName	Full Country Name
PhoneNumber	Supplier Phone Number
Email	Supplier contact email

Unique Supplier Number and Supplier Name 

To ensure that your field data is unique, you can perform conditional formatting in excel.

1. Highlight the column
   
2. Click on Conditional Formatting in the top ribbon (on Home tab)
   
3. Select Highlight Cell Rules > and then Duplicate Values...
   
4. By default this will highlight duplicates with a light red color... click OK
   
5. Any duplicate values will be highlighted... make changes and highlighting will disappear

Upload Data

To upload supplier data into your tenant, go to Data > Overview.   Then drop your formatted data file onto the suppliers card.  If you used the template then your fields should match the database fields.  Scroll to the right to confirm all fields have a check mark.  Any that have an exclamation  will not be uploaded.  You can either match these to a database field by finding it in the dropdown or leave as is. Once you have reviewed your fields click Upload Supplier.

A success or error message will appear onscreen and you will receive an email with upload results.  Large lists will take some time to upload.  Click on Suppliers card to see results of your upload.

• Related Articles

• Product Data Upload

  These are the common fields used when uploading product data. Template attached at the bottom of article. Field Detail ProductNumber unique alphanumeric - see validation below Name This is the product name and should be unique Inventory Enter 1 for ...

• Customer Data Upload

  These are the common fields used when uploading customer data. Template attached below. Field Detail CustomerNumber Customer number must be unique CustomerName Customer name must be unique AddressLine1 Customer Address Line 1 AddressLine2 Customer ...

• Add a Supplier

  A customer can be added from Data > Suppliers or from a Purchase Order. Click on the + symbol to add a new supplier. In the banner of the Supplier window, add the Supplier # and Supplier Name. In the Details Tab, add contact information.

• Master Data Grids

  Each Master Data type, Customers, Suppliers, Companies, and People, are viewed in a grid that easily sortable and searchable. At the top of each grid is a search input and the ability to add a new data entry. To search the grid, add a search term and ...

• Giving a Supplier Credit

  Giving a Supplier Credit In the left menu select “Data”. Click “Suppliers” and locate the supplier and double click to open the supplier’s details.  On the left click the “Credit” tab and then depending on the type of credit that you want to add to ...