Skip to content
zea-favicon
Zea Knowledge Base
Zea Knowledge Base
Zea Partner Program
Release Notes
More
Zea Parts

icon picker
Importing a Bill of Materials (BOM)

Import Service Bill of Materials (SBOMs) into Zea Parts.
info
Note: Zea Parts documentation is currently a work in progress and is being actively developed. Some sections may be incomplete or subject to change. We appreciate your understanding and patience as we work to provide the most accurate and comprehensive information.

zea-favicon
Applicable to:
Zea Parts
Organization Owners and Admins

Overview

An SBOM is a list of parts specific to a manufactured product and includes information on all parts in an assembly, up to the root assembly. Multiple SBOMs are imported as a folder of spreadsheets, one for each manufactured product, and can include other data such as descriptions. If the same part appears in multiple SBOMs, it will not be duplicated across the system; instead, Zea Parts uses a single instance of the part.
Importing SBOMs provides three main benefits:
Provide an Explicit Structure:
An SBOM allows you to control the structure of the SBOM shown to customers.
Display Non-3D Items in Your SBOM:
The SBOM can specify any part to be shown in the tree, even parts without associated 3D models or parts that have 3D models but are not part of the same assembly (e.g., peripheral items included in the box with the product).
Control the Loading of 150% CAD Models:
Some manufacturers provide multiple variations of a product in a single CAD model and hide/show various options to display a specific configuration. The BOM for a specific product should specify exactly which options were included when manufacturing the product. The BOM loaded into Zea Parts can control the loading of these configurations.

⁠

Download the Template File

This file shows the basic columns that can be imported. Columns with an * are Default Fields.
export-excel
⁠
zea-sbom-template.xlsx
70.6 kB
⁠
⁠
⁠
image.png
⁠
⁠

⁠

Open the Zea Sync Desktop App

Launch the Zea Sync app on your desktop.
Log in if required, and select the Organization and Workspace where you want to set up your parts catalog.
Choose SBOMs from the options.

⁠

Select Your Folder

The SBOMs Settings dialog will open the first time you enter (if it does not open, click ⚙️ in the top right).
Click on the Select folder button.
Browse to the location of the folder containing your SBOM spreadsheets and select it.
⁠
image.png
⁠
⁠

⁠

Explore the interface

A) Toolbar

Refresh folder button: Useful if you have made changes in your local folder.
Synchronize button: Click this button to sync to the Zea Platform.
Settings button: Access the SBOMs settings.

B) File List

This is a list of all the spreadsheet files in your selected folder and if they are processed or not.

C) Preview

This is a preview of the selected spreadsheet file. Use it as a reference when mapping fields.

D) Mapping

The Mapping section is where you map Zea Parts Fields to Imported Fields in the spreadsheet.
Header Row: The row containing the header columns.
Fields: This is where you select if a field is public or not, map Imported Fields to Zea Part Fields, assign languages, and add new optional fields.
Warnings: Any warnings for missing field mapping are show below the fields.
⁠
image.png
⁠
⁠

⁠

Set Header Row

Adjust this number when the first row in your spreadsheet does not contain the column headings.
⁠
image.png
⁠
⁠

⁠

Map Default Fields

Select the corresponding Imported Field from your spreadsheet that maps to the Zea Parts Fields below:
Engineering Part Number (Required): The column in your spreadsheet the contains values that map directly to parts and assemblies in your CAD.
Service Part Number: May be provided as alternatives to the Engineering Part Number used within the CAD data. When a Service Part Numbers is used, the customer is shown that not the Engineering Part Number.
Parent Part Number: Specifies the hierarchy within the SBOM. The value in the Parent Part Number field should refer to an Engineering Part Number that has already occurred higher up in the spreadsheet. The hierarchy specified in the SBOM is show to the end user, and should somewhat follow the hierarchy of nodes in the CAD data.
Sellable: One of the most important settings to specify is if a part or assembly is sellable. Specifying that a row is sellable will enable the add to cart button to be displayed in the published catalog and users are then able to request a quote.
⁠
⁠
⁠

⁠

Configure Languages

Zea Parts supports importing data for multiple languages, and enabling end users to choose their preferred language. Languages can be configured in the Master Parts List or SBOMs Settings.
Navigate to the Languages tab in the settings.
Click the Add Languages button.
Start typing in the language name to find the language you are looking for.
Click Add.
You can import as many languages as you want, as long as there is a corresponding column in the spreadsheet.
⁠
image.png
⁠
⁠

⁠

Map Optional Fields

Optional fields can be added by clicking the New button and provide more detail about parts in the published catalog.
String fields: Used for text such as descriptions. When a string field is Public it will require a language.
Number fields: Used for numbers such as price. Number fields will automatically total when items are added to the shopping cart.
⁠
image.png
⁠
⁠

Public vs. Private Fields

When adding new fields, you can specify whether they are Public or Private.
Public: Choose Public for fields which you want to display in the published catalog, such as description and price.
Private: Choose Private for internal fields that you do not wish to be displayed in the published catalog. Private fields do not require a language.
⁠
image.png
⁠
⁠
info
Public fields are not displayed in the shopping cart by default. This is configured in the Fields tab of Zea Parts Settings.
Learn more about optional fields here.

⁠

Process Your SBOMs

Now that you have all your fields mapped, it is time to process the filed and sync you SBOMs to Zea Parts.
Click the Synchronize button
The files will process one at a time and change to a ⚙️ Processing state.
If everything is correct, the file will change to a ✅ Processed state.
If there are issues with mapping, the file will show an ❎ Error state.
If you make changes to the source spreadsheets of processed files they will display as ✅ Processed and Modified state. In this case you may re-process the SBOMs if the change was intentional.
ok
Hover on an individual file and click on the Synchronize icon to process and individual file.
⁠
⁠
⁠

⁠

View Your Parts

Go to the Zea Platform and navigate to the Workspace that you synced your parts to.
Here you can see statistics for how many parts have been successfully mapped to 3D models.
Click on Zea Parts in the Workspace Dashboard.
⁠
image.png
⁠
⁠
⁠
image.png
⁠
⁠

⁠

Fixing Parts With ‘No Models’

The article about fixing missing parts is coming soon. In the meantime, here is a quick overview:
Go to Zea Parts on the Zea Platform.
Open Zea Parts setting and click on the SERVICE PARTS MAPPING tab.
If your Service Parts Numbers are included in CAD file metadata enter the metadata field.
If your CAD filenames do not completely match the Service Part Numbers in your imported spreadsheet you can add and text Regex here.
Return to Zea Sync and reprocess your SBOMs.
Recheck your statistics on the Workspace Dashboard.

⁠

Related Articles

Map Optional Fields












Version 1

What is a BOM

While BOM is also a list of parts, it serves a different purpose. A BOM is specific to a manufactured product, while a parts list contains information on all parts within the organization. The BOM and Parts List should include rows for all levels of the assembly, up to the root assembly.
e.g. If you sell 2 diffent products, then each product will have a different BOM. However, the 2 products may be based on a shared set of parts. The parts list would contain a row for each part used in either of the 2 products.
A BOM will look very similar to a parts list, but it can provide a structure that helps customers navigate your 3d models.
⁠
image.png
⁠
⁠
In the absence of a an import BOM, Zea Parts will generate a BOM dynamically using the hierarchy defined in your 3d models. The tree it generates will closely match the tree defined in the 3d model inspector.
Importing BOMs Provide 3 main benefits.

Provide an explicit structure

Providing an SBOM alllows you to control the structure of the BOM shown to customers.

Display non-3d items in your BOM

The BOM can specify any part to be shows in the tree. Even parts that do not have any associated 3d model to represent them, or parts that do have 3d models, but those models are not part of the same assembly. e.g. peripheral items included in the box with the product.

Control the loading 150% CAD Models

Some manufacturers provide multiple variations of a product in a single CAD model, and then hide/show valrious options to display a specific configuration. The BOM for a specific product should specify exactly which options were included when manufacturing the product. The BOM loaded into Zea Parts can control the loading of

⁠
image.png
⁠
⁠

Configuring the Header Row

⁠
image.png
⁠
⁠
When setting up a spreadsheet for import, configuring the header row is the first step that must be completed before any columns can be mapped.

Understanding the Columns you can import.

Engineering Part Number

The Engineering part number is the column in your spreadsheet the contains values that map directly to parts and assemblies in your CAD.

Parent Part Number

The parent column specifies the hierarchy within the BOM. The value in the parent column should refer to a part number that has already occurred higher up in the spreadsheet.
The value provided in the Parent column should be an Engineering Part Number.
The hierarchy specified in the BOM is show to the end user, and should somewhat folow the hierarchy of nodes in the CAD data.

Service Part Number

Service Part numbers may be provided as alternatives to the engineering part number used within the CAD data. When this happens, the part being solid in service is being sold under the Service Part number and the customer is not shown the engineering part number.

Sellable

One of the most important settings to specify, is if a part or assembly is sellable. The BOM should include rows for all levels of the assembly, up to the root assembly, even non-sellable items. Specifying that a row is sellabe will enable the add to cart button to be displayed in the published catalog and users are then able to place and order/RFQ for those parts.


Overview
Download the Template File
Open the Zea Sync Desktop App
Select Your Folder
Explore the interface
Set Header Row
Map Default Fields
Configure Languages
Map Optional Fields
Process Your SBOMs
View Your Parts
Fixing Parts With ‘No Models’
Related Articles
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.