We recently needed to reconfigure our products that are sold by the single, dozen, or gross so that we can accurately track their inventory.
The master product, Widgets, has attributes of "By the Piece", "By the Dozen", and "By the Gross". We track the inventory of the master product, and the current stock amount is counted "by the piece" inclusive of the total pieces in any dozen-kits or gross-kits.
We configured the product using Inventory Kit Builder. The variants each contain quantities of their own master product; 1 (piece), 12 (dozen), and 144 (gross).
When inventory is tracked, the amount deducted from the Current Inventory level is always over by 1 per number of "master product" ordered. So for example 3 @ 1-Piece deducts 6 from inventory, 3 @ dozen-kit deducts 39 from inventory, etc. It appears that this is because Miva is deducting the amount assigned to each part, and also deducting 1 for each "master kit product".
In order for inventory tracking to be correct on products where the attribute parts are actually quantities of the master product itself, it would be necessary Miva to recognize when master products and parts are the same product code and adjust accordingly.
For the time being we created a hack to get around this.. we assign one less than the amount in our case (assign 11 parts for the dozen-kit, easy enough,) but for the single-unit attributes (since you're not allowed to assign 0 of a part,) we created a fake "adjustment product" (no cost, no inventory tracking) and assign that as the only part for the per-piece variant. The hack works, but it's clumsy and comes along with other issues we had to address.. (hiding it in an availability group, it shows up on ShipStation invoices, etc.)
Would love to see either a new way to create kits that are simply bundled units of the master product itself, or a slight modification to the existing Inventory Kit Builder that would have an option to address this particular situation.
The master product, Widgets, has attributes of "By the Piece", "By the Dozen", and "By the Gross". We track the inventory of the master product, and the current stock amount is counted "by the piece" inclusive of the total pieces in any dozen-kits or gross-kits.
We configured the product using Inventory Kit Builder. The variants each contain quantities of their own master product; 1 (piece), 12 (dozen), and 144 (gross).
When inventory is tracked, the amount deducted from the Current Inventory level is always over by 1 per number of "master product" ordered. So for example 3 @ 1-Piece deducts 6 from inventory, 3 @ dozen-kit deducts 39 from inventory, etc. It appears that this is because Miva is deducting the amount assigned to each part, and also deducting 1 for each "master kit product".
In order for inventory tracking to be correct on products where the attribute parts are actually quantities of the master product itself, it would be necessary Miva to recognize when master products and parts are the same product code and adjust accordingly.
For the time being we created a hack to get around this.. we assign one less than the amount in our case (assign 11 parts for the dozen-kit, easy enough,) but for the single-unit attributes (since you're not allowed to assign 0 of a part,) we created a fake "adjustment product" (no cost, no inventory tracking) and assign that as the only part for the per-piece variant. The hack works, but it's clumsy and comes along with other issues we had to address.. (hiding it in an availability group, it shows up on ShipStation invoices, etc.)
Would love to see either a new way to create kits that are simply bundled units of the master product itself, or a slight modification to the existing Inventory Kit Builder that would have an option to address this particular situation.
Comment