Product Items with component Subitems - auto-calculate quantity of subitems per product

Platform discussions Special workflows & use cases
,
1

Hi community,

I am developing a rental product inventory on Monday.com, where each product consists of a master product (item) and all its component parts (subitems). A default quantity of component parts is always required to create a master product, which is currently indicated in a number column ‘parts per master’.

The example would be;

MASTER ITEM 3m x 3m Pop Up Gazebo
COMPONENT SUBITEM 3m x 3m Gazebo Roof (x1 parts per master item)
COMPONENT SUBITEM 3m x 3m Gazebo Walls (x4 parts per master item)
COMPONENT SUBITEM 3m x 3m Gazebo Frame (x1 parts per master item)

I am getting stuck when trying to create the order system for the products and have 2 main issues:

  1. If I create an order for several rental items on a separate board to the inventory (‘Order’ Board), I cannot generate the order as the main item, the products as the subitems and then the component parts as further subitems, as I believe I am limited to a single set of subitems. Would it be necessary to create the master items and component items as subitems that could somehow be marked as linked? If so, what would the automation be that would see a product inventory item and add its component part subitems to the order at the same time?
  1. Assuming there’s a solution to the above, what is the additional automation necessary to calculate the correct qty of component parts per quantity of master items. E.g. If I add 2 gazebos, then how to ensure the order includes 2 Roofs, 8 walls, 2 frames…?

Thanks!