Skip to main content

Product Impact Calculator: Bulk Upload - Material Workbook

  • Updated

Table of Contents

This workbook is only for textiles with a maximum of 4 base materials.

 

Bulk Upload - Material Workbook Fields

Field name Description
Material Name (Required)
  • Name of material or material blend.
  • Does not need to be unique
Material Code
  • Field to capture any kind of ID or Code to help brands reconcile PIC data with their internal systems.
Material Supplier
  • No FEM linking
  • Optional field that is intended to help identify a material. These are Vendors who are not involved in the making of the actual material. They’re just the point of contact for the brand when they buy textiles.
  • Example: Vendor ABC in China sold me 50 Cotton/50 Poly blend, and Vendor DEF in Vietnam sold me 50 Cotton/50 Poly blend
Material Country
  • Country Select list
Base Material 1
  • Material Select list
Composition % 1
  • Range between 1-100%
  • All Comp % combined must add up to exactly 100
Base Material 2
  • Material Select list
Composition % 2
  • Range between 1-100%
  • All Comp % combined must add up to exactly 100
Base Material 3
  • Material Select list
Composition % 3
  • Range between 1-100%
  • All Comp % combined must add up to exactly 100
Base Material 4
  • Material Select list
Composition % 4
  • Range between 1-100%
  • All Comp % combined must add up to exactly 100
T2 Facility
  • Populated with list of T2 and T3 accounts that have shared a 2023 or 2024 FEM with the brand
  • Supplier Name or Worldly ID
  • If No Match, map to Keep value as is
T2 Country
  • Country Select list
T3 Facility
  • Supplier Name or Worldly ID
  • If No Match, map to Keep value as is
T3 Country
  • Country Select list
Overwrite
  • Set to YES when uploading a file that contains revisions to existing materials.
  • Contents of MatLib can be exported by selecting one or more materials and clicking Download in the table action bar.
Worldly Material ID
  • For Bulk Revise, system generated ID
The below fields are automatically pre-populated with the T2 and T3 values, but can be overwritten if the brand has more detailed information. P002-P006 refer to lifecycle stages.
P002 Facility
  • Supplier Name or Worldly ID
  • Pre-populated with T3 Facility value
  • Yarn Formation stage (i.e. Spinners)
P002 Country
  • Country Select list
  • Pre-populated with T3 Country value
P003 Facility
  • Supplier Name or Worldly ID.
  • Pre-populated with T2 Facility value
  • Textile Formation stage
P003 Country
  • Country Select list
  • Pre-populated with T2 Country value
P004 Facility
  • Supplier Name or Worldly ID
  • Pre-populated with T2 Facility value
  • Preparation stage
P004 Country
  • Country Select list
  • Pre-populated with T2 Country value
P005 Facility
  • Supplier Name or Worldly ID
  • Pre-populated with T2 Facility value
  • Coloration stage
P005 Country
  • Country Select list
  • Pre-populated with T2 Country value
P006 Facility
  • Supplier Name or Worldly ID.
  • Pre-populated with T2 Facility value
  • Finishing stage (e.g. Applying heat transfers, or adding a weatherproofing coating)
P006 Country
  • Country Select list
  • Pre-populated with T2 Country value

 

4.png

 

Example

  1. Begin by selecting Import from the Material Library page. Data can only be inputted via Bulk Upload, you can download the Bulk Upload - Material template at the bottom of this article.
    5.png
  2. In the Bulk Upload screen, you can either drag and drop or upload a file. You can also manually enter in data.
    6.gif
  3. You can upload the following file formats: CSV, Excel, or JSON. We recommend CSV as a best practice.
  4. On the next screen, confirm the field mapping is correct.
    • For example, confirm the Incoming Fields from your file match the Destination Fields suggested in the platform.
    • If a field is missing or incorrect, select the dropdown arrow to select the desired field.
    • Preview the data for the category on the right side of the window. Hovering over different rows updates the preview window.
    • Select Continue.
  5. Next, confirm the value mapping is correct.9.gif
    • For example, confirm the Incoming Values from your file match the Destination Values suggested in the platform.
    • If a value is missing or incorrect, select the dropdown arrow to select the desired value.
    • The right side of the window contains the data preview for the category.
    • Select Continue.
  6. If there are any validation errors, click on the Invalid button to correct the errors.
    10.gif
    • Any validation errors are highlighted in red.
    • Hover over the red cell to understand what the error is.
    • Click on the red cell to resolve the validation error.
  7. Click Submit Data to finish uploading.
    11.png

 

Workbook Template