How to plan my data properties in OpenBOM Bill of Materials and Catalogs

Oleg Shilovitsky
Oleg Shilovitsky
17 July, 2019 | 2 min for reading
How to plan my data properties in OpenBOM Bill of Materials and Catalogs

Even OpenBOM looks and smells like a spreadsheet, inside OpenBOM manages data using multiple databases. The concept of a spreadsheet is applied to OpenBOM user experience. To manage data, you need to define “properties” in OpenBOM. You can think about them as a database field. OpenBOM is flexible allows you to define, change and delete these properties at any time. So, from the beginning.

OpenBOM Bill of Materials and Catalogs are fundamental data structures managed by OpenBOM. One of the questions I’ve often got in support is related to where to create a property – in BOM or in a Catalog. 

In today’s blog and video, I’d like to explain how to decide about where to create a property – in BOM or Catalog. Check the picture below. This is the data model of BOM and Catalogs. 

As you can see catalog properties are describing data that must remain the same for all instances of the part/assembly (Eg. Unit Cost, Description, etc.). At the same time, variable properties are defined in BOMs. 

The following picture can give you a very simplified idea of how it can be done. 

In the following video, I can give you some idea how to make these planning mostly efficient and how to project your concepts into OpenBOM reference-instance model by defined catalog and BOM properties.

Conclusion

Catalog and BOM model in OpenBOM is really simple but allows you to create a very sophisticated data model. Reference-instance model can be used for any type of BOMs, quantity-based, instance BOMs, engineering, production, planning, etc. You can keep data assigned to reference and instances, while BOM supports parent-child relationships. Together BOM and catalogs are a solid foundation of OpenBOM. 

Register to OpenBOM FREE user subscription and experience OpenBOM model tomorrow.

Best, Oleg

PS. Let’s get to know each other better. If you live in the Greater Boston area, I invite you for a coffee together (coffee is on me). If not nearby, let’s have a virtual coffee session — I will figure out how to send you a real coffee.

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website

Related Posts

Also on OpenBOM

4 6
3 September, 2025

We live in a digital world and data has become the most valuable business asset. Whether you are designing a...

29 August, 2025

Digital BOM is a foundation of all OpenBOM to ERP integrations. From the very early days of PLM, the connection...

28 August, 2025

In 2025, the push for better design-to-manufacturing integration is stronger than ever. But for many companies, this still gets reduced...

27 August, 2025

For decades, PDM meant file vaults, check-in/check-out, and revision control. But today’s products span mechanical, electronic, and software domains, with...

26 August, 2025

This article is part of OpenBOM BOM Excel MCP building in public. For the next few weeks, we are going...

22 August, 2025

In yesterday’s article – Understanding OpenBOM’s Multi-Tenant Data Model and System Configuration, I shared some insights about OpenBOM’s multi-tenant data...

21 August, 2025

In today’s manufacturing and engineering world, the term multi-tenant triggers both questions and confusion. Product Lifecycle Management (PLM) has historically...

20 August, 2025

Since the very beginning of OpenBOM, our mission has been to help engineers, manufacturers, and teams organize product information and...

19 August, 2025

There is a need for a rich and structured context.  Artificial intelligence has quickly become the buzzword in every boardroom,...

To the top