Good day
We have a client with a scenario very true to any retail store and need to know how to cater for this in Netsuite.
eg. A single can of coldrink costs $1. If you buy a 6-pack, you pay $5. If you buy a case (24) its $17.
The can have a barcode, but the 6-pack might have a different barcode on the pack, and the case (24) also have a different barcode, but it is all the same item, and we don't want to create 3 different SKU's.
If they scan the barcode for the can, it must bill the $1, and the inventory must reduce by 1. If they scan the 6-pack, it must bill $5 and reduce inventory with 6, and if they scan the case (24) it must bill $17 and reduce inventory with 24 units (Each).
The reason why we only want one item (SKU), is because they can at any time open a 6-pack and sell as single can and the inventory should be correct. So, if there are 2 cases (24) in stock, the system must know there are 48 cans of coldrink.
Can this be catered for in Netsuite and how do we set this up?
Thank you!