Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Industry guides

When a product bundle sells, which inventory should decrease?

Connect the bundle SKU to its components, allocate discounts consistently, and reconcile fulfillment so bundle sales do not leave inventory and margins overstated.

By Institution2 minute readPublished View sources
In this guide

Document what the bundle contains

A bundle's selling SKU may not be the same as the stockkeeping units held in the warehouse. Maintain a component list with quantities and an effective date. If customers can choose components, preserve the actual selection for each order rather than assuming every bundle contains the default combination.

Check how the store, fulfillment system, and accounting connector represent the sale. One may show a single bundle line while another shows each component. Both can be valid, but the mappings must agree about which physical units leave inventory.

Test one fulfilled order from end to end

Follow a bundle order through payment, warehouse picking, shipment, inventory movement, and the cost entry. Confirm that each component decreases once and that the bundle itself does not also reduce the same stock a second time. Check partially fulfilled orders separately.

Suppose an illustrative bundle contains one item costing $18 and two items costing $7 each. Its component cost is $32 before any additional costs included under the company's policy. A $60 selling price does not establish a $28 final profit because shipping, packaging, payment fees, and other costs may still apply.

Keep price allocation separate from stock quantities

A bundle discount may need to be allocated across components for management reporting, returns, or the applicable accounting treatment. Choose a documented method appropriate to the purpose and apply it consistently. Do not change physical inventory quantities merely to force a desired margin on each component.

If tax treatment differs between products, involve the relevant tax professional or approved tax configuration. A convenient equal split of the bundle price may not be appropriate for every reporting or tax purpose. Keep the allocation assumptions visible.

Plan for component substitutions and returns

Record substitutions made during fulfillment and update the cost information using the actual components. A warehouse replacement can change margin even when the customer pays the same bundle price. Preserve the original and revised component records so the difference can be explained.

For a partial return, identify what came back, its condition, and the approved customer refund. Restore only the supported inventory quantity and value. At month-end, compare bundle sales, component consumption, and return movements, then investigate bundles with sales but no cost or inventory movement.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.