All Collections
Importing Data
Import Supplier Data
Import Supplier Data

How to import raw materials, supplier details, and cost data

A
Written by Alex Inglis
Updated over a week ago

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

  1. For this tutorial, first download the Supplier Importer Template file from the link above.

  2. Select Additional Makersite Tools > Importer from the pop-up window.

  3. Select Supplier Importer from the list.

  4. Drag and drop the file onto the Makersite page or click Upload File to open the upload dialog.

  5. 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.

Did this answer your question?