The Case-Pack Ladder: Wholesale Assortment Bundles
How a pet supply wholesaler can price assortment cases with product-type slots, a set ladder that upgrades every case, and a discount stacked on wholesale prices, with the checks that keep it profitable.
To price a wholesale assortment case (12 of each of four product types), use a Product Bundle with product-type slots, repeated per case. A set ladder upgrades every case once a step is reached, so price each step by its added gross profit. Stack the case discount on per-item wholesale prices, and know that the bundle floor is a margin, the wholesale floor a markup.
At a glance
- Challenge
- Retailers order twelve each of four treat types. A combined quantity tier would reward any 48 units regardless of mix, and the brand wants to reward complete cases without giving away the margin.
- Approach
- One Product Bundle with four product-type slots of 12 units, repeated per case with a 10/15/20% ladder priced step by step, stacked on per-item wholesale prices for the Wholesale segment only.
- Discount Prime campaign types used
- Product BundleWholesale / B2B Pricing
Scenario-based case study: the merchant is fictional and modeled on patterns across Discount Prime stores. Prices, costs and outcome figures are illustrative assumptions for teaching, not measured results from a real store.
Short Answer
When wholesale buyers order "twelve of each kind" rather than a quantity of one product, a Product Bundle with one slot per product type (12 units each) can define the assortment case and reward every complete case. A set ladder can raise the reward for larger orders, and "Stack on product discounts" adds the case discount on top of the buyer's wholesale price.
Three details decide whether this works as intended:
- The ladder upgrades every case. Once an order reaches the 20% step, all cases in that order get 20%, not only the newest one. The last step can add very little gross profit.
- Stacking depends on how the wholesale campaign counts quantity. In the current checkout logic, units used to complete a case are left out of wholesale pricing that is evaluated on "All items together". Use "Each item independently" for the standing wholesale price, and test it.
- Two margin floors, two definitions. Wholesale / B2B Pricing uses a markup on cost; Product Bundle uses a margin on price.
Ridgeback Pet Supply is a fictional wholesaler used to illustrate the decision. All numbers are illustrative assumptions, not results.
Fits / Does Not Fit
| Fits when | Does not fit when |
|---|---|
| Buyers order a fixed mix across product types | Buyers order large quantities of a single product (a quantity tier is simpler) |
| You want each additional complete case to earn a reward | Any combination of 48 units should qualify, regardless of mix |
| Wholesale buyers log in and are identified by a customer segment | You rely on Shopify B2B companies and catalogs to identify buyers (Discount Prime does not read company or location data) |
The Scenario and the Data You Need
Ridgeback Pet Supply, a fictional Shopify wholesaler, sells dog treats and chews to independent pet stores. Retailers ask for one case covering the range: 12 jerky, 12 dental chews, 12 training treats and 12 long-lasting chews. Logged-in wholesale buyers already see a standing wholesale price.
Illustrative assumptions (replace with your own):
| Input | Value |
|---|---|
| Units per case | 48 (12 per type) |
| Average wholesale price per unit | $6.00 |
| Average product cost per unit | $3.60 (40% gross margin at wholesale) |
| One slow-moving chew | Wholesale $5.50, cost $3.90 |
Data you need: product cost for every variant in Shopify (Cost per item), the current distribution of units per type in wholesale orders, and how many buyers already order several full assortments.
The Options Compared
| Option | Requires the mix | Rewards each case | Notes |
|---|---|---|---|
| Wholesale / B2B Pricing alone | ✕No | ✕No | Standing price, no reason to order a second case; zero extra discount cost |
| Tiered Quantity Discount, all items together (48+ units = X%) | No, any 48 units qualify | Per tier, not per case | Simple and available on lower plans; fine if the mix does not matter |
| Product Bundle with four product-type slots | Yes, 12 of each type | Yes, with "Repeat for every complete set" | Set ladder and segment eligibility need Ultimate |
If any 48 units should earn the reward, a combined quantity tier is simpler. The bundle is the right tool only when the assortment itself is the thing you are pricing.
Choosing the Ladder, With the Math
Scenario ladder: 10% for one case, 15% from case 2, 20% from case 4, all stacked on the wholesale price. Gross profit = revenue minus product cost (shipping, fees and returns excluded).
| Complete cases | Rate on every case | Revenue | Gross profit | Gross margin | Added gross profit vs one case fewer |
|---|---|---|---|---|---|
| 0 (wholesale only, 48 units) | none | $288.00 | $115.20 | 40.0% | n/a |
| 1 | 10% | $259.20 | $86.40 | 33.3% | n/a |
| 2 | 15% | $489.60 | $144.00 | 29.4% | +$57.60 |
| 3 | 15% | $734.40 | $216.00 | 29.4% | +$72.00 |
| 4 | 20% | $921.60 | $230.40 | 25.0% | +$14.40 |
The fourth case adds $187.20 of revenue but only $14.40 of gross profit, because cases 1 to 3 also move from 15% to 20%. Add your fulfillment cost per case and that step may lose money. Two adjustments to consider: a smaller last step (for example 17%), or a cap on the number of sets that receive the discount.
Also compare with the no-campaign baseline: a buyer who already orders one full assortment at wholesale earns $115.20 of gross profit today, and $86.40 with the 10% case discount. The ladder pays only if it brings extra cases.
To adapt: replace price and cost with your own averages per case, and compute the "added gross profit" column for each step before you set the ladder.
Stacking on Wholesale, and the Two Floors
Stacking. With "Stack on product discounts", the case discount is calculated from the price after the line's existing product discount, so a buyer sees both. In the current checkout logic:
- A wholesale price set to "Each item independently" is applied first, and the case discount stacks on it as intended.
- With "All items together", units used to complete a case are excluded from that wholesale calculation, and the case discount is calculated from the regular price. Those units can end up dearer than the buyer's normal wholesale price.
For a standing wholesale price, use "Each item independently" with a low minimum, and confirm the result in a test order.
Profit floors. The bundle's floor is a margin on the final price: floor = cost ÷ (1 − 22%). For the slow-moving chew, that is $3.90 ÷ 0.78 = $5.00. Stacked 20% off its $5.50 wholesale price would give $4.40, below the floor. With "Reduce the discount for that set", that line's case saving is cut to $0.50 per unit, so it sells at $5.00; other lines keep their full saving. With the other option, the whole case discount is removed whenever any line would breach the floor.
Wholesale / B2B Pricing has its own floor, defined as a markup on cost (cost + X%). A 22% markup and a 22% margin are different numbers: on a $3.90 cost they give $4.76 and $5.00.
Missing cost. With "Do not discount that item", a product with no Cost per item is taken out of the bundle. Its units in the cart do not count toward the case, even though they match the product type. Enter costs before launch.
Settings Used in This Scenario
| Setting | Value |
|---|---|
| Campaign type | Product Bundle |
| Template | Assortment case |
| Slots 1 to 4 | A product type each (Jerky, Dental, Training, Long-lasting) · Required quantity 12 |
| Reward type | Percentage off the set: 10% |
| Apply | Repeat for every complete set |
| Set ladder | Reward grows with sets: from set 2, 15%; from set 4, 20% |
| Combine with other discounts | Stack on product discounts |
| Profit protection | On, minimum margin 22%; Reduce the discount for that set |
| If a variant has no cost | Do not discount that item (after entering all costs) |
| Eligibility | Customer segments: Wholesale |
| Where to show it | Cart progress |
| Wholesale / B2B Pricing (existing campaign) | Applies to: Each item independently |
Plan note: Product Bundle starts on Premium; product-type slots and repeat start on Prime; the set ladder and segment eligibility need Ultimate. Restricted eligibility requires the buyer to be logged in at checkout.
What the Buyer Sees
The cart progress card counts complete cases with the same fill rule as checkout and shows how many units are still missing, for example "4 more to complete Assortment case". Customers outside the Wholesale segment do not see the bundle widget and do not get the discount.
| Cart (logged-in wholesale buyer) | Result |
|---|---|
| 12 jerky, 12 dental, 8 training, 12 long-lasting | Wholesale prices only; progress card shows 4 more |
| 12 of each type | 10% off the case, stacked on wholesale |
| 24 of each type | 15% off both cases |
| 48 of each type | 20% off all four cases, reduced on the low-margin chew |
| 13 of each type | One case discounted; the extra 4 units at wholesale price |
| Same cart, retail shopper or logged out | No case discount |
Limits and Pre-Launch Tests
- A slot counts units of its type. Twelve units of one jerky fill the jerky slot; variety within a type cannot be required.
- The ladder counts cases within one order; it does not accumulate across orders.
- Bundles cannot be delivered as a discount code.
- New segment members are synced to the storefront by a background job, so a buyer just added to the segment may not qualify immediately.
| Test input | Expected result |
|---|---|
| One type short by 4 units | No case discount, progress card shows 4 more |
| Exactly 12 of each type | 10% stacked on wholesale prices |
| 48 of each type | 20% on every case; the low-margin chew stops at its floor |
| Same cart with wholesale set to "All items together" (test store) | Check whether case units lose their wholesale price before choosing this mode |
| Retail account, same cart | No case discount |
| Product without cost in one slot | Its units do not count toward the case |
Measurement
- Primary metric: complete cases per wholesale order.
- Guardrail: gross profit per wholesale order, and the number of lines where the floor reduced the saving.
- Baseline: the same buyers' orders before launch; compare like-for-like seasons, since pet retail restocking is seasonal.
- Confounders: new account onboarding, retailer promotions, and price list changes.
- Decide: if orders cluster at exactly four cases and gross profit per order falls, soften the last step. If few buyers ever reach a second case, the ladder adds complexity without effect. Treat before/after comparisons as directional unless you hold out a group of accounts.
Frequently asked questions
How do I offer wholesale case pricing for mixed assortments on Shopify?
If any mix of units should qualify, a combined quantity tier is simpler. If the mix matters, define the case as a bundle: in Discount Prime, a Product Bundle with one slot per product type (for example Product type: Jerky, Required quantity 12) completes when 12 of each type are in the cart, any product within the type. With Repeat for every complete set, each additional case earns the reward.
Is a tiered quantity discount enough for assortment cases?
It can be. A tiered quantity discount set to count all items together rewards any 48 units across the campaign's products, which is enough when the mix does not matter. It cannot require 12 of each type. Use a bundle with product-type slots only when the assortment itself is what you are pricing.
Can a bundle discount stack on top of wholesale prices?
Yes, with Stack on product discounts, but check how the wholesale price is evaluated. In Discount Prime's current checkout logic, a wholesale price set to Each item independently is applied first and the case discount stacks on it. With All items together, units used to complete a case are left out of that wholesale calculation and the case discount starts from the regular price. Test a cart before launch.
How does a bundle set ladder affect wholesale margin?
The highest step reached applies to every case in the order. With 10%, 15% from case 2 and 20% from case 4, a four-case order gets 20% on all four cases. In the illustrative example, the fourth case adds $187.20 of revenue but only $14.40 of gross profit. Compute the added gross profit for each step before setting the ladder. The ladder counts cases within one order only.
What is the difference between the wholesale floor and the bundle floor?
Discount Prime's Wholesale / B2B Pricing floor is a markup on cost (cost plus X%), while the Product Bundle floor is a margin on price (cost divided by 1 minus X%). On a $3.90 cost, 22% gives $4.76 as a markup and $5.00 as a margin. Both read cost only from Shopify's Cost per item.
Can I hide a bundle discount from retail customers?
Yes. Set eligibility to a customer segment such as Wholesale; the bundle widget and the discount then apply only to logged-in customers in that segment. In Discount Prime, segment eligibility and the set ladder need the Ultimate plan. Eligibility uses customer segments, tags or lists, not Shopify B2B companies.
Go deeper
Features used
From the blog
Run this architecture in your store
Every campaign type in this case study is included in Discount Prime, with profit analytics to verify the margin impact.
More case studies
Fashion & Apparel
The Suit That Sold the Shirt: A Complete-the-Look Product Bundle
ReadHome & Living
Any Three Candles: A Mix-and-Match Bundle With a Set Ladder
ReadHobby & Specialty
One Price for the Whole Kit: A Fixed-Price Bundle Without a Kit SKU
Read