1 product which can be split in half or quarters inventory tracking

Topic summary

Inventory management for a single material sold as Full, Half, and Quarter acrylic sheets. OP wants “Auto Build” behavior: selling a Half should deduct 0.5 of a Full sheet; selling a Quarter deducts 0.25. Example: with 100 Full sheets in stock, a Half sale should show 99.5 remaining.

In MYOB this is handled via Auto Build (fractional bill-of-materials/assembly). OP can’t find an equivalent in Shopify and notes typical bundling apps don’t fit this fractional use case.

A reply says Shopify would require a custom app: maintain a master stock quantity, on each successful order recalculate remaining stock, and update related product quantities for halves/quarters.

No off‑the‑shelf solution was identified. Status: unresolved; suggested path is custom development.

Summarized with AI on January 25. AI used: gpt-5.

Hi,

I’m looking for a inventory tracker which has “Auto Build” but I haven’t been able to find one yet.

I have:
Product 1: a Full Size Sheet of Acrylic
Product 2: A Half Size sheet of Acrylic (so will only be using 0.50% of material)
Product 3: a Quarter Size sheet of Acrylic (so will only be using 0.25% of the full size material)

I need an App that will Auto Sum Tracking.

Example:
I have 100 Full Size sheets of acrylic in stock.
Someone buy a 1 x Half Sheet of Acrylic, so now i have 99.5 Sheets in Stock.

i can do this on myob easy using “Auto Build” and selecting the “Full Size sheets @ 0.50% for the list of what it takes to build” but I don’t know how to do it on shopify

I know there are many budling apps, but usually they are not build for this kind of purpose.

Hi @nicko2

Yes, you would require a custom app which will store the actual quantity somewhere and on every successful order it will recalculate the main quantity and update related product quantities.

We can create this custom APP for you.