You have decided to upload the component data using bulk uploads.

Once you click + Add Component, choose Upload Files. You will be directed to the bulk uploads page. Download and fill the mandatory fields. 

Save, then upload again. 

When we are uploading the components to the system, there are several fields which needs to be filled in. Let's take a look at these together:

Before we explain all the fields, it's good to know that if it's written in Bold in the excel sheet, this means the field is mandatory to fill in.

1. Universally Unique Identifier (UUID): This is an automatically generated ID, consisting of a 36-character alphanumeric string that can be used to identify information. A standard UUID code contains 32 hex digits along with 4 “-” symbols, which makes its length equal to 36 characters. As mentioned in the templates, adding the UUID is only required for updates. It will be autogenerated by the system, if the information is added for the first time.

1. Component Identifier Type: This is the internal code your company uses to identify the components. Only letters can be used in this field. One of the most used type is "SKU" (stock-keeping unit) which are assigned by the merchant is used for internal identification of inventory and sales. Another identifier type can be: CAS (Chemical Abstracts Service). The identifier type is received from the ERP systems and can be specific to company only.

3. Component Identifier Value: This is the code your company uses to identify the components. A combination of letters and numbers is used in this field. The identifier value is received from the ERP systems and stands together with the main component identifier type. This id allows the matching on both sides when PCF is requested from the supplier. The component identifier value should be added under the matching component identifier type columns.
4. Component Name: The name of the component/material needs to be added in this field. This field allows up to 50 characters.
5. Special characters like: "( )", "&", ".", "%","<", ">", "=" and " are not accepted.
6. Material Category: When adding the components list to Mattermaps, you can also create component categories. This way you can filter based on material / component category and request the PCF for all the components in the respective category at once.
7. Unit Type: this field allows you to declare the component unit types. It needs to be selected from the dropdown option provided in the excel template. We offer piece, kg, m2, m3, kWh, km, TEU(twenty equipment unit - used in logistics), pkm (a passenger km), tkm (ton km - for unit measure of freight transport), MJ(megajoule - energy per unit time), L types.
8. Weight (in kg): Weight should be added in kilograms.
9. Supplier Company ID: This is an internal id that your company identifies the supplier with. It can be received from ERP systems.
10. Supplier Product ID: This is the ID that your supplier uses to identify this product. It can be received from sales orders. Supplier Product id is necessary to add to be able to link the suppliers with the components. If you don't have supplier product id information in your organization, you can use a combination of your supplier's name and your component's name. You can also skip this column but the component wouldn't be linked with the supplier.
11. Quote/Share: If there are multiple suppliers that supplies a specific component, the share of a supplier should be added in this field. If there is only one supplier the share should be added as 100%.
12. Location of Manufacturing: Manufacturing location of the suppliers must be added in this field. It can be added as country or city and that way it can be seen on the Component Overview page as well.
13. PCF Estimation per Unit in kg CO2(Total incl. or excl. bio): In this field PCF estimation can be added per component. It should be always added in "kg". Good to know: When your product unit is not kg, make sure the decimals of the estimation amount does not exceed 16 decimals. This field allows max 16 decimals. Total including biogenic or excluding biogenic depends on the your calculation and the standard you are using. to make sure it covers all the standards, you can add the same value to both of the fields.
14. Estimation Data Provider: This is the field to add the data provider that's used to retrieve the CO2 emission estimations.
15. Quantity: This is the declared quantity.
16. Email: The email of the person or department who created this component's secondary data should be added in this field.
17. Data Verification: In this field the data provider can be added either as secondary data or proxy data. Secondary data is that data retrieved from databases (GaBi, EcoInvent, etc) whereas proxy data is the data that is retrieved from direct measurements and from machine outputs.