Bundles Explained:

How to Receive Cases and Sell Singles

If you order in bulk and sell individually (e.g. 6-packs or cases of 30), it usually works best to add your case to Shopventory as the non-bundle Product you’re tracking, and create a bundle to sell individual units.

Let's take a 6-pack as an example.

  1. Create a Product. I'll put the brand name "Premium Beverage" as my Product name, and the unit "6-pack” as my variant name.
  2. Add the cost and price of the full case. 
  3. If you sell full cases to your customers, you can skip to step 5.
  4. If you don't sell by the case, make the Product inactive and Save. Now go to the Products & Variants tab and create a brand new product for the single.
  5. Now add a variant for the bottle, and label it clearly with "Single" in the variant name.
  6. Set your bottle price in the Price field. Then use the gear wheel to convert the product to a Bundle. (See screenshot below)
  7. Select "Premium Beverage (6-pack)" as the component Product. A bottle is equal to ⅙ of the case, so enter 0.166 as the Qty.

Now, when you receive a case into inventory, either directly or from a purchase order, you'll see that the quantity in stock for your single bottle goes up proportionately.

NOTE: You can still sell the full case, pricing is not dependent, so you can set whatever price you'd like for each variant.


How to Receive Singles and Sell Cases

Instead of making your case a Product, it's also possible to make your case a Bundle comprised of multiple Products. The main reason to take this approach is to avoid rounding the Quantity for your single Products.

Since not all fractions can be conveyed using a finite decimal, defining a bundle as 0.167 of a Product will lead to some variations in the final result (e.g., the quantity may be rounded to 212 when you really have 213 in stock). Defining a bundle as a whole-number multiple of a Product, however, will always lead to an exact result.

The tradeoff of this set-up is that if you purchase the Product in bulk, your unit cost (what you pay for a single bottle) must be recorded in whole cents. If this value has to be rounded, you will see variations in the calculated cost of the case/bundle as well.

In this instance, simply reverse the roles above:

  • The Single will be the regular product
  • The 6-pack will be the Bundle
  • Instead of .166 6-packs = 1 Single Bundle,
    you will say 6 Singles = 1 6-pack Bundle
  • This means you will order and receive the Singles


Related Articles:

Did this answer your question?