Skip to content
English
Submit a request
  • There are no suggestions because the search field is empty.

Product Impact Calculator: Bulk Upload Workbook

Table of Contents

This workbook is for products with 6 or fewer materials or components.

 

Bulk Upload Workbook Fields

Field Name
Description

Product Name (Required)

(name)

The name of your product. A new product will be created even if a product with the same name already exists
 

String

Product Category (Required)

(category)

269 predefined categories like "T-Shirts", "Sneakers", "Jeans", "Hoodies", etc.

Covers apparel, footwear, furniture, home textiles, kitchen/dining, sports/outdoor
 

Picklist

Enter Materials by Weight

(ismaterialweight)

Set to TRUE when entering materials by weight instead of composition percentage

When TRUE: Use Material Weight fields, composition percentages not required

When FALSE: Use Composition fields (must total 100%)

 

Boolean

Material 1
Material 2
Material 3
Material 4
Material 5
Material 6

(material1-6)

Supports both PIC materials (e.g., "MatTX0001" for Cotton) and custom materials

Array field - can select multiple materials per set
 

Picklist with 100+ options

Composition 1
Composition 2 
Composition 3
Composition 4 
Composition 5
Composition 6

(composition1-6)

Must be number between 1-100

All composition fields must total 100%

Used when "Enter Materials by Weight" is FALSE
 

String

Material Unit of Measure 1
Material Unit of Measure 2
Material Unit of Measure 3
Material Unit of Measure 4
Material Unit of Measure 5
Material Unit of Measure 6

(material1-6)

Must be number between 1-100

All composition fields must total 100%

Used when "Enter Materials by Weight" is FALSE

 

String

Material Weight 1
Material Weight 2
Material Weight 3
Material Weight 4
Material Weight 5
Material Weight 6

(materialWeight1-6)

Options: kilograms, grams, milligram, pound, ounce

Required when Weight field is populated

 

Picklist

Net Use 1
Net Use 2
Net Use 3
Net Use 4
Net Use 5
Net Use 6

(netUse1-6)

Number between 1-100

Default value is 75%

 

String

Component 1
Component 2
Component 3
Component 4

(component1-4)

30+ options like "Comp1001" (Button/Snap Button, Aluminum 12mm)

Supports custom components

 

Picklist

Component Units 1
Component Units 2
Component Units 3
Component Units 4

(componentUnit1-4)

Must be 1 or more units per product

Required when Component field is populated

 

Number

Packaging 1
Packaging 2
Packaging 3
Packaging 4

(packaging1-4)

30+ options like "Pack1001" (Box, Shipping Medium)

Supports custom packaging

 

Picklist

Units 1
Units 2
Units 3
Units 4

(packagingUnit1-4)

Must be 1 or more units per product

Required when Packaging field is populated

 

Number

Size

(size)

Options vary by product type:

  • Apparel/Footwear: Adult, Childrens/Youth, One Size
  • Sleeping Bags: Short, Regular, Long
  • Backpacks: <35L, 35-60L, >60L
  • Tents: 1-2 Person, 3-5 Person, 6-8 Person

 

Picklist (custom)

Final Assembly Worldly Id

(finalAssemblyWorldlyId)

When provided, leave Final Assembly column blank

 

Picklist (custom)

Final Assembly

(finalAssembly)

Facility name must match account name on platform

 

Picklist (custom)

Purchase Order Quantity

(amountPurchase)

Must be 1 or more

 

Number

Purchase Order Date

(purchaseOrderDate)

Format: YYYY-MM-DD

 

String

Purchase Order Number

(purchaseOrderNumber)

String

Multi-Pack

(multiPacksQuantity)

Enter the quantity purchased

Weight

(weight)

Must be number greater than 0

Required when Material field is populated

Used when "Enter Materials by Weight" is TRUE

 

String

Unit of Measure

(unitOfMeasure)

Options: kilograms, grams, milligram, pound, ounce

Required when Weight field is populated

 

Picklist

Tags

(tags)

Enter multiple tags as a comma separated list

Identifier Type

(identifierType)

Required when Identifier ID is populated

Options: GTIN, SKU, UPC, OTHER
 

Picklist

Identifier ID

(identifier)

String

Final Assembly Location

(frenchLabelCountry)

Country for Manufacturing stage

Options: Region - Western Europe, Region - Eastern Europe, Region - Asia, Region - Africa, Region - Middle East, Region - Latin America, Region - North America, Region - Oceania, Myanmar, Bangladesh, China, France, India, Cambodia, Morocco, Pakistan, Tunisia, Turkey, Vietnam
 

Picklist

Textile Formation Location

(frenchLabelFabricCountry)

Country for Weaving/Knitting stage

Options: Region - Western Europe, Region - Eastern Europe, Region - Asia, Region - Africa, Region - Middle East, Region - Latin America, Region - North America, Region - Oceania, Myanmar, Bangladesh, China, France, India, Cambodia, Morocco, Pakistan, Tunisia, Turkey, Vietnam

 

Picklist

Preparation, Dyeing, Finishing Location

(frenchLabelDyeingCountry)

Country for Dyeing stage

Options: Region - Western Europe, Region - Eastern Europe, Region - Asia, Region - Africa, Region - Middle East, Region - Latin America, Region - North America, Region - Oceania, Myanmar, Bangladesh, China, France, India, Cambodia, Morocco, Pakistan, Tunisia, Turkey, Vietnam

 

Picklist

 

Example

Next, let's walk through an example of uploading a workbook.

  1. Select Import.

    Expand to show screenshot
    40381966947355.png

  2. Select the Bulk Upload workbook, or whichever workbook corresponds with the column headers in your file.

    Expand to show screenshot
    40381966951067.png

  3. Drag and drop your file onto the screen. You can upload the following file formats: CSV, Excel, or JSON. We recommend CSV as a best practice.

    Expand to show screenshot
    40381982927131.gif
  4. Review the field mapping on the next two windows before clicking Continue.
    • 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. 

      Expand to show screenshot
      40381982927899.png
  5. On the next page, review the Bulk Upload table for any errors. Check the Missing Info and Revising section below for a detailed example of resolving errors.
     

  6. After the table has been reviewed and all errors have been resolved, click Submit data. 

    Expand to show screenshot
    40381966956059.png

  7. You'll know if you were successful when you see the Success pop up.

    Expand to show screenshot
    40220273707035.png

 

Missing Info and Revising

Select the Missing Info checkbox in the upper right-hand corner to target just the products that are missing information. In this case, all four products are missing purchase orders.

40381966956571.png

By using the bulk upload, you can make tens of thousands of edits to your Product Library with a single file upload.

  1. Check Missing Info box if you haven’t done so already.
     

  2. Click the first checkbox in the Product Library, and navigate to Select all on this page. Steps 1 and 2 will check all the items that are missing information, which can come in handy if you’re dealing with hundreds of thousands of products.

    Expand to show screenshot
    40381966957467.png

  3. From the black navigation bar, select Download. This downloads a csv file that mirrors the selected rows in the Product Library. 

    Expand to show screenshot
    40381982935067.png

  4. Make any edits in the CSV file, in this case, adding the purchase order dates to the purchase order column. Make sure to save as a CSV file.

    Expand to show screenshot
    40464028559643.png

  5. Back on the platform, select Import. 

    Expand to show screenshot
    40765486935835.png

  6. Select the Bulk Upload - BOM workbook, or whichever workbook corresponds with the column headers in your file.

    Expand to show screenshot
    40381966951067.png

  7. Drag and drop your file onto the screen.

    Expand to show screenshot
    40381982927131.gif

  8. Review the field mapping and value mapping on the next two windows before clicking Continue.

    Expand to show screenshot
    40381982927899.png
  9. On the next page, review the Bulk Upload table for any errors.

    • The following example is for a company uploading a workbook with four products.

      Expand to show screenshot
      40381966961179.png

    • The screenshot below has errors several errors that need to be resolved.

      Expand to show screenshot
      40381966962971.png

    • To resolve the errors, hover over the red shaded cells.

      Expand to show screenshot
      40381982942875.gif

    • The red cell under the Material 1 column is blank. Select Wool from the drop-down menu.

      Expand to show screenshot
      40381966970395.png

    • The red cells under Composition 1 column should be 100. Since these products are made with only one material (Material 2 and Composition 2 columns are not filled out), the composition must equal 100%. Enter 100 into the cells with 75. 

      Expand to show screenshot
      40381966973211.png

  10. After the table has been reviewed and all errors have been resolved, click Submit data. 

    Expand to show screenshot
    40381982950555.png

  11. You’ll know if you were successful when you see the Success pop up.

    Expand to show screenshot
    40220273707035.png

 

Workbook Template

Download the Bulk Upload Workbook Template below.