How should I fill in the CSV template in Supply Chain Mapper?
You should fill in the CSV template by providing information about the components that make up your product. You should fill in one line per component that makes up your product, entering information on the specific component and the supplier organisation that provides this component.
The information you enter in the CSV template is used to build the supply chain for your product and invite your suppliers to complete their own Supply Chain Mapper. All sensitive information regarding your suppliers (organisation names, contact information) is hidden from your buyer unless explicitly stated otherwise.
To fill in the CSV template:
- Sign in to your NQC account.
- On your Dashboard, open the Supply Chain Mapper.
- Click the 'Download template' button and open the file that downloads.
- For each component that makes up your product, you should fill in one line of the CSV template.
- In the 'Supplier Name' column, enter the registered organisation name of the relevant supplier.
- In the 'Supplier Country Code' column, enter the relevant ISO 3 country code of the location your supplier provides you their component from.
- In the 'Supplier Location Address' column, enter the location your supplier provides you their component from - this can be as a text string address format (Organisation, Street, Town, City, Post/ZIP Code, Country), latitude-longitude (XX.XXXXX, -YY.YYYYY), or Google Place ID format.
- In the 'Supplier Email Address' column, enter the email address of a relevant point of contact within your supplier's organisation who will receive the request to complete their own Supply Chain Mapper - you must always communicate with this supplier contact to inform them that you will be inviting them to complete a Supply Chain Mapper.
- In the 'Product Part Name' column, enter the part name of the component that your supplier provides - your supplier should know exactly what component you are referring to from this information so include the relevant part ID in this column too if needed.
- In the 'Product Part ID' column, enter the part ID of the component that your supplier provides.
- In the 'Supplier Telephone' column, enter the telephone number of the invited supplier contact if known - leave blank if not known.
- Leave all other columns blank and download the file in the .csv format.
- Within your Supply Chain Mapper, click 'Upload Suppliers' and upload the completed CSV template.