We currently have products variations of the same product (each with a different price), but only one item handle the stock of all of them.
As an example, we have a chair product that can be painted in red, blue and green, or not painted at all. (Note: we currently have 11 color options, but show only those 4 just to simplify the issue, we also have more that 100 type of chairs with this issue).
As I have mentioned, each chair color has a different price, based on the type of chair.
Using Inventory Matrix Items for this kind of products seems to be the right solution, but an extra constraint is the way the stock of those items are handled.
In our business, when the customer buys, for example, a blue chair, we take one of the not painted chair, paint it and deliver to the customer. If we handled (as initially thought) this chair product as an Inventory Matrix Item, the stock of the not painted will not be decreased and the stock of a blue chair will be modified leading to a situation that is not how the business work. We can say that have no stock of colored chairs (just some particular returns that are really rarely).
QUESTION 1: The first question I have is if there is a built-in inventory product type (Matrix item, kit, item group) that handle this kind of logic. We tried with item groups (having a single non-painted chair and a color service item as the group), but those group items where not shown in the SCA Webstore.
QUESTION 2: I think that any kind of customization should be done. In this way, which is the best cost/benefit equation to solve it?
OPTION 2.1: Use Inventory Matrix Items and MAKE an inventory adjustment everytime a Sales Order is entered into the system with a color option selected.
OPTION 2.2: Use a Single Inventory Item for the Non-painted option, and build a customization so that different colors with different prices can be shown in the WebStore.
QUESTION 3: Is there any other solution that we are not considering?