Introduction
Supplier information is an important component of your product's Digital Twin in Makersite, which can use it to suggest cost reduction opportunities and help reduce supply chain bottlenecks.
Prerequisites
You must import a BOM before you can import supplier data, as Makersite tries to match your Product Groups against the imported Companies and Sites.
Your supplier data must be available as .xslx (Excel) format. Your data must include the mandatory categories - see Template Formatting below.
Import Supplier File
For this tutorial, first download the Supplier Importer Template file from the link above.
Select Additional Makersite Tools > Importer from the pop-up window.
Select Supplier Importer from the list.
Drag and drop the file onto the Makersite page or click Upload File to open the upload dialog.
You will get an Import Successful message when your import has been completed.
Once the file has completed uploading, Makersite will then indicate which of the imported datasets have been matched, and which have not. Only unmatched entries are shown by default.
For the example file, Makersite should display the All products have been matched message.
For more information on how to map unmatched datasets, please see the How to Check Mapping Completeness article on the Makersite FAQ.
Template Formatting
Mandatory columns are marked as bold - your import will fail if the file does not have them. Please note that if your supplier data is named or structured differently, it will be managed during the implementation phase.
Column name | Description |
Company | Name of the supplier. When imported, Makersite creates a new Company data object with this name. |
Company URL | Optional URL address of the company. |
Site Name | This is the name of the supplier's physical facility. There can be multiple Sites per Company. When imported, Makersite will create a new Site data object with this name, which will then be linked to the Company data object for this row in the file. Sites can be headquarters, admin, manufacturing, distribution or any other type of physical location the Company operates. |
Site Geo | This is the physical address of the Site created above, it is added to the Site data object when imported. The formatting of the address, should be comma separated e.g.
1 street address, city, region, country Birketweg 32, Munich, Germany |
Site URL | Optional URL address for the Site. |
PG Name | This is the Product Group Name the Company & Site is related to, must refer to an existing Product Group in Makersite (see BOM Import for details) |
casNR | CAS number, applicable to chemical products. Can be used to map your |
MPN/PN/GUID | Manufacturer Part Number/Part Number/Unique ID. Possible ways to match the Product Group or SKU to the supplier data |
Normalization Factor | This can be used to set a scaling factor between the Product Group & the SKU. If for example the Product Group represents 1 egg, but the SKU for the order is based on a box of 12 eggs, the Normalisation Factor can be set to 0.08333 (1/12) to account for the difference in quantity. |
SKU Name | Name of the Stock Keeping Unit purchased at this Supplier. |
SKU min | Minimum SKU price |
SKU max | Maximum SKU price |
SKU URL | If available, you can enter the URL for the SKU here. |
Volume | This is the quantity of product that is supplied from the Site, it can be per unit i.e. 1000 of box 1, or in a measure i.e. 100kg of box 1. |