Bulk Upload - BOM Workbook Fields
Example, Missing Info and Revising
This workbook is for products requiring more than 6 materials or components.
Bulk Upload - BOM Workbook Fields
| Field Name | Description |
|
Worldly Product ID (worldlyProductId) |
A system-generated unique identifier assigned to a product If empty, then Worldly Purchase Order ID is required
String |
|
Product Name (Required) (name) |
For new products: name must be unique
String |
|
Product Category (Required) (category) |
Same 269 categories as main workbook ("T-Shirts", "Sneakers", etc.) Picklist |
|
Size (size) |
Options vary by product type:
Picklist (custom) |
|
Multi-Pack (multiPacksQuantity) |
Enter the quantity purchased
String |
|
Product Weight (weight) |
Enter the weight of the product
String |
|
Unit of Measure (unitOfMeasure) |
Enter the corresponding unit of measure if the weight field is populated
String |
|
Product ID (productId) |
String |
|
Product ID Type (productIdType) |
Type identifier - EAN, GTIN, SKU, Other Picklist |
|
Worldly Purchase Order ID (worldlyPurchaseOrderId) |
String |
|
Quantity (amountPurchase) |
Enter the quantity purchased
String |
|
Purchase Order Date (purchaseOrderDate) |
Format: YYYY-MM-DD
String |
|
Purchase Order Number (purchaseOrderNumber) |
Enter in the unique identifier for the Purchase Order
String |
|
BOM Type (Required) (bomType) |
Options: material, component, packaging, final assembly Determines what type of BOM entry this row represents Picklist |
|
BOM ID (bomID) |
String |
|
Material (material) |
Same options as main workbook Picklist |
|
Enter Materials by Weight (isMaterialWeight) |
Set to TRUE when entering materials by weight instead of composition percentage Boolean |
|
Material Unit of Measure (materialUnitOfMeasure) |
Must be number between 1-100 All composition fields must total 100% Used when "Enter Materials by Weight" is FALSE
String |
|
Material Weight (materialWeight) |
Options: kilograms, grams, milligram, pound, ounce Required when Weight field is populated
Picklist |
|
Net Use (netUse) |
String (1-100, default 75%) |
|
Composition (composition) |
String (1-100, all must total 100%) |
|
Component (component) |
Same component options as main workbook Picklist |
|
Component Units (componentUnit) |
Enter 1 or more units per product, when the "Component" field is populated
String |
|
Packaging (packaging) |
Same packaging options as main workbook Picklist |
|
Units (packagingUnit) |
Enter 1 or more units per product when the "Packaging" field is populated
String |
|
Final Assembly Name (finalAssembly) |
Facility name must match account name on platform Picklist |
|
Tags (tags) |
Enter multiple tags as a comma separated list |
| Overwrite (Required) |
True: New product or PO for existing product False: Update existing product
Boolean |
| Final Assembly Location |
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 |
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 |
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 |
Note
If you are importing new products, the Overwrite column must be populated with False.
If you are importing existing products, the Overwrite column must be populated with True and paired with either a Worldly Product ID or Worldly PO ID.
Example
Next, let's walk through an example of uploading a Bulk Upload - BOM workbook. Download the template
- Select Import.
- Select the Bulk Upload workbook, or whichever workbook corresponds with the column headers in your file.
- 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.
- 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.
- 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.
- You'll know if you were successful when you see the Success pop up.
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.
- From the black navigation bar, select Download. This downloads a csv file that mirrors the selected rows in the Product Library.
- 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.
- Back on the platform, select Import.
- Select the Bulk Upload - BOM workbook, or whichever workbook corresponds with the column headers in your file.
- Drag and drop your file onto the screen.
- Review the field mapping and value mapping on the next two windows before clicking Continue.
- 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.
-
-
-
The screenshot below has errors several errors that need to be resolved.
-
To resolve the errors, hover over the red shaded cells.
- The red cell under the Material 1 column is blank. Select Wool from the drop-down menu.
- 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.
-
- After the table has been reviewed and all errors have been resolved, click Submit data.
- You’ll know if you were successful when you see the Success pop up.
Workbook Template
Click HERE to download the Bulk Upload - BOM Workbook Template