I’ve done some research on this topic and have seen similar questions being asked on this forum multiple times but with no plausible solution.
Take the example of selling PENs. The store received pens in cases. Each case has 100 boxes and each box has 12 pens. Customer can buy pens in pieces, boxes or cases. The store wants to give more discount for box buy or case buy.
The ideal solution is to have the flexibility in the shopping cart system to be able to specify the unit of measure. For example, 1 box = 12 pieces. 1 case = 1200 pieces. Regardless of the unit, all the purchase should be pointed to the same simple item, which is the PEN.
I don’t see the possibility to do so in Magento community version. So I may have to create two or three simple items, one for piece buy, one for box buy and one for case buy. This creates a big headache in inventory control. Also, when downloading orders to accounting software such as Quickbooks, this also cause extra work because Quickbooks has the ability to set different Unit of Measure for the same product.
I’m wondering what is the best way to handle Unit of Measure in Magento. Your inputs are highly appreciated.