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 (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 (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 (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 (materialWeight1-6) |
Options: kilograms, grams, milligram, pound, ounce Required when Weight field is populated
Picklist |
|
Net Use 1 (netUse1-6) |
Number between 1-100 Default value is 75%
String |
|
Component 1 (component1-4) |
30+ options like "Comp1001" (Button/Snap Button, Aluminum 12mm) Supports custom components
Picklist |
|
Component Units 1 (componentUnit1-4) |
Must be 1 or more units per product Required when Component field is populated
Number |
|
Packaging 1 (packaging1-4) |
30+ options like "Pack1001" (Box, Shipping Medium) Supports custom packaging
Picklist |
|
Units 1 (packagingUnit1-4) |
Must be 1 or more units per product Required when Packaging field is populated
Number |
|
Size (size) |
Options vary by product type:
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.
-
Select Import.
Expand to show screenshot
-
Select the Bulk Upload workbook, or whichever workbook corresponds with the column headers in your file.
Expand to show screenshot
-
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
- 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
- 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.
-
After the table has been reviewed and all errors have been resolved, click Submit data.
Expand to show screenshot
-
You'll know if you were successful when you see the Success pop up.
Expand to show screenshot
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.
By using the bulk upload, you can make tens of thousands of edits to your Product Library with a single file upload.
- Check Missing Info box if you haven’t done so already.
-
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
-
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
-
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
-
Back on the platform, select Import.
Expand to show screenshot
-
Select the Bulk Upload - BOM workbook, or whichever workbook corresponds with the column headers in your file.
Expand to show screenshot
-
Drag and drop your file onto the screen.
Expand to show screenshot
-
Review the field mapping and value mapping on the next two windows before clicking Continue.
Expand to show screenshot
- 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
-
The screenshot below has errors several errors that need to be resolved.
Expand to show screenshot
-
To resolve the errors, hover over the red shaded cells.
Expand to show screenshot
-
The red cell under the Material 1 column is blank. Select Wool from the drop-down menu.
Expand to show screenshot
-
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
-
-
After the table has been reviewed and all errors have been resolved, click Submit data.
Expand to show screenshot
-
You’ll know if you were successful when you see the Success pop up.
Expand to show screenshot
Workbook Template
Download the Bulk Upload Workbook Template below.