Hi, I work for a custom manufacturing company that handles many item variants. One example is that we buy standard sheets of aluminum (4ft x 10ft, 4ft x 12ft, …, different thicknesses, different colors). We cut these sheets into smaller pieces, then sell the smaller pieces and have a lot of leftover pieces of aluminum we put back in inventory to be used in the future. These leftover pieces can be weird dimensions like 2.43ft x 7.23ft. We also need to track the batch number as the paint colors are different between different purchases.
As you can see, we could have possibly 100s of variants of a certain item. We think of items as being the color of the raw material (item = Red Aluminum Sheet), and the variants are the dimensional properties (length, width, thickness). We have a developer team so are able to programmatically create/delete variants.
Here’s the workflow I am thinking:
- We manually create item templates for the standard purchasing sheet dimensions (roughly 5-30 variants for each item template).
- Our manufacturing software knows the dimensions of the leftover pieces of aluminum sheets when we cut them. We use the REST APIs to create these new variants (Red Aluminum 2.43ft x 7.23ft) when this happens. We enter these pieces into inventory.
- Once one of these strange dimensional variants leaves inventory (we scrap or consume), we erase these variants from the item template to keep the list manageable.
Does this workflow make sense? Can anyone see any issues with it?