Manage master product stock based on variants

[RKS_213]

I have a situation where the variants of a product are actually quantities of that product.

For example, you have a product called "Nails" and the variants are Box of 50, Box of 250, Box of 500, and Box of 1000. The way we handle inventory is account all nails and package them upon order. So in this case we have 60,000 nails in stock. When a Box of 50 is ordered, it decrements the stock by "1" which is incorrect in this case. It also decrements by only 1 when a box of 1000 is ordered.

How can I get it to recognize the inventory management system we have in place?

I have also seen this with weight, whereas you have in stock 100 lbs of Coffee and the variants are 1lb Bag, 2lb Bag, and 3lb bag. When 1lb is ordered, it decrements the stock by 1, which would be correct, but only decrements by 1 when a 3lb bag is ordered. There isn't any other way to control inventory for weighted goods like that. You can't say I have 1,000,000 Coffee beans and/or a 1lb bag of Coffe is 1000 beans. The inventory control is the weight.

Thanks.

[compunerdy]

You would have to use kits to make this work without customizing.

[RKS_213]

I don't see what you mean. I can add products in a kit as a component, but these have to be products. Are you saying that I should create different products for each box?

[compunerdy]

You can add the same product mutlipe time for the kit drop down. So you would do it like this..

Main item > bogus item called nails bundle or whatever..

Drop down asking for amount of nails.
Box of 50 - qnty 50
Box of 100 - qnty 100

These box can all be the same item and sku but with different quantities.

[RKS_213]

Hmmm. It appears to work however I STILL have to customize.

Infuriating, worthless, limited AC is maxed at 100 quantity. Everyday I say I can't be more disappointed with AC and everyday I am wrong.