Buyer Data is the information pertaining to the individual points of contact at the companies to which you sell. The Buyer Data template works hand-in-hand with the Company Data template.
Use the Buyer Data template to link buyers to their respective companies, control which of your sales reps are assigned to each buyer, and store contact information for your buyers.
Note: If you are in the Onboarding process, uploading the Buyer Data template is the last step. When this file is uploaded (with your approval) you'll be officially launching your portal!
Download
If you're in the Onboarding process, work with your NuORDER rep and download a blank template.
If you're not in the Onboarding process, admins can download the Buyer Data template by going to Settings > Brand Admin > Data > Buyer Data.
Select a file link in the Download section. If you choose to download a CSV file, follow the steps outlined in How to best access a CSV file in Excel.
Edit
Use the Buyer Data blank template when creating new users and use the NuORDER download to edit buyer data. When populating the spreadsheet, consider the below field descriptions, requirements, best practices, and key concepts.
Field descriptions
Expand for the Buyer Data blank template field descriptions.
| Field | Example | Description |
|---|---|---|
| Company | Retailer Store | This required field is the name of the retailer. Enter the exact name as it appears in other areas of your portal. |
| Company Code | ABC123 | This field is the code of the retailer in your ERP. It's required for bulk uploads and if you integrate your company data. |
| Name | Chris Buyer | This required field is the name of the buyer. Don't enter special characters. After the buyer is created, only that buyer user can edit their name. |
| buyer@retailer.com | This required field is the email used by the buyer to log into NuORDER. Don't enter an email used by a brand user (admin, sales rep, etc.). After the buyer is created, only that buyer user can edit their email. | |
| Sales Rep 1 | salesrep@brand.com | This required field is the email of the sales rep assigned to the buyer. |
| Sales Rep 2 | salesrep2@brand.com | This optional field is the email of the second sales rep assigned to the buyer. To assign more, add columns for Sales Rep 3, etc. |
| Phone | 2125551234 | This optional field is the buyer's phone number. |
| Fax | 2125554567 | This optional field is the buyer's fax number. |
Expand for the Buyer Data download field descriptions.
| Field | Example | Description |
|---|---|---|
| company id | 12345678ab901cdefggh234i | This system generated, unique identifier is required for updating a buyer. |
| company | Retailer Store | This is the name of the retailer. |
| company code | ABC123 | This is the code of the retailer in your ERP. |
| buyer name | Chris Buyer | This is the name of the buyer. After the buyer is created, only that buyer user can edit their name. |
| buyer email | buyer@retailer.com | This is the email used by the buyer to log into NuORDER. After the buyer is created, only that buyer user can edit their email. |
| terms signed | v3 - 2023/01/01 | This is the version number and date of when the buyer agreed to your portal's terms and conditions (if your brand enabled usage terms and conditions). |
| Title | Purchasing Manager | This is the buyer's title. |
| Phone - Office | 2125551234 | This is the buyer's phone number. |
| Phone - Cell | 2125554567 | This is the buyer's cell number. |
| sales rep 1 | salesrep@brand.com | This is the email of the sales rep assigned to the buyer. |
| sales rep 2 | salesrep2@brand.com | This is the email of the second sales rep assigned to the buyer. Additional numbered sales rep columns display if more reps are assigned. |
Requirements
- Accepted file types: XLSX, XLS, CSV, or TXT (tab delimited only).
- Customer Codes are required to upload buyers in bulk.
- Remove any blank or divider rows.
- Clear all borders, shading and special formatting.
- Remove multiple worksheets from your Excel file.
Best practices
- Fill out all required fields to completion.
- Information in the Customer Code field must match your Company Data exactly, including casing, spelling, and spacing.
- Verify that all email addresses are valid prior to adding them to the template.
Key concepts
- Buyers are assigned to their respective company based on the Customer Code field.
- The email listed for each buyer serves as their NuORDER login credentials and your main means of communication with that buyer through the system.
- Emails entered in the Sales Rep Email fields must be Brand Users (your internal sales reps, sales managers, and admin).
- When uploading your file, the buyers in your spreadsheet receive emails, inviting them to log into NuORDER. This is why uploading Buyer Data is the last step in the Onboarding process.
Upload
If you're in the Onboarding process, work with your NuORDER rep before uploading Buyer Data.
If you're not in the Onboarding process, admins can upload the Buyer Data template by returning to Settings > Brand Admin > Data > Buyer Data.
Click and drag your saved file to upload it.
When the data upload is complete, you'll receive a Success message. Examine the confirmation carefully to make sure all of your files were uploaded correctly.
You can confirm that your Buyer Data is live by navigating to the Contacts section of NuORDER.
Additional resources
Want to learn more? Check out Buyer data FAQ.