I have a situation where we have 3 different flavors of soft drinks that can be sold as a single unit, a 6 pack, or a case (4-6 packs.) To add to that a case can be a mixture of the 3 different flavors(2-6 packs of one flavor 2 of another, 2 of 1 and 1 each of the other 2 flavors, etc. etc.) Prices for the single unit, 6 pack, and case all are different on a per unit(individual bottle) price.
The inventory is ordered from the vendor in 6 packs only. For each flavor the single unit and the six pack have their own upc code. Cases do not have their own upc code(there is a case upc but it is universal and doesn't differentiate what flavor it is for.) For this reason I am considering eliminating the upc code for the case from our system.
For the 6 pack to case I was thinking of setting it up as a mix and match discount when a total of 4 6packs are purchased. This would allow for the price difference as well as keeping the inventory counts for each correct. This is the best solution that I can see for this part of the problem.
The part I cannot figure out(and I'm probably over analyzing it) is keeping up with the bottles vs 6 packs. Any ideas? I've looked at assembly, kitting, parent/child, and lot matrix.
*This post is locked for comments
Create a case, a 6 and a 1
Parent 6 to the 1
Assemble the case from any 6 or single
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156