A worked bundle inventory exception: the gift set that changed in one system, step by step

Short answer

The records that explain a bundle inventory exception are the ones that let someone recompute the variance from the bundle definitions that were live at the time, then follow who traced it, who approved the correction and whether the next count held. In the Illustrative case below, a gift set changed on the store but not in the ERP, a cycle count found 300 extra cleansers, and eight dated records turn an unexplained write-up into a complete, checkable decision.

Visual briefFull-size diagram
A case timeline from the February 24 merchandising decision that splits on March 1 into a store path deducting one cleanser per gift set and an ERP path deducting two, rejoining at the March 31 count that found 300 extra units, then the approved correction and the April 30 count that matched.
Illustrative case for a fictional personal-care brand. Each step is shown with the record that captured it.

This worked case belongs to the bundle inventory reconciliation guide. It walks through one hard case in order, names the person and the record at each step, and ends with how a commerce ERP integrator can spot the same pattern at a client without opening any records.

The setup: one cleanser, four ways to sell it

Illustrative. A fictional 210-person personal-care brand sells a 50 ml travel cleanser on its own and inside three bundles: a starter kit with one cleanser, a travel trio with one, and a gift set. The store runs on a commerce platform; stock and costs sit in an ERP.

Neither system holds stock on the bundle itself. Shopify's documentation says bundle inventory is determined by the inventory of each component, with the lowest-stocked one setting how many bundles can be sold. NetSuite tracks kit inventory on the individual component members, and the kit record cannot show an available quantity. So the only thing connecting a gift set order to the cleansers it used is the bundle definition that was live when it shipped. That is why this case is hard: one component, four selling paths, and two systems that each keep their own recipe.

Step by step: what went wrong and who decided what

On February 24, merchandising decided to cut the gift set from two cleansers to one from March 1 to hit a new price point. The ecommerce manager updated the bundle on the store. Nobody updated the kit definition in the ERP.

March sales, and the cleansers each system deducted:

March sales pathUnits soldCleansers per unit, storeStore depletionCleansers per unit, ERP kitERP depletion
Cleanser on its own90019001900
Starter kit40014001400
Travel trio25012501250
Gift set30013002600
Total1,850Not applicable1,850Not applicable2,150

The March 31 cycle count found 300 more cleansers on the shelf than the ERP expected. That equals the gift set difference exactly: the ERP deducted 600 against 300 actually shipped.

The decisions that followed, each with its owner and record:

StepDateDecision or eventWhoRecord it left
1Feb 24Gift set cut to one cleanser from March 1Merchandising leadPlanning ticket
2Mar 1Store bundle saved as version 2Ecommerce managerBundle definition with effective date
3Mar 1 to 31Two systems deduct different quantitiesNo one; automaticOrder lines and component movements
4Mar 31Count shows plus 300 against the ERPWarehouse managerCount sheet by location
5Apr 1Gap traced to the gift set kit, arithmetic attachedInventory analystInvestigation note
6Apr 2Plus 300 correction approved, reason "Correction"Inventory directorERP stock adjustment with approver
7Apr 2ERP kit updated, March 1 effective date notedERP administratorKit change log
8Apr 30April count matches within toleranceWarehouse managerCount records

Why this sequence is useful evidence

Take away steps 1, 2 and 5 and the case becomes a 300-unit write-up with no reason. Keep them and it shows a full loop: a problem, the reasoning that found its cause, an authorized action and a checked result. That loop is what makes documented exceptions interesting for AI training and evaluation, as exception handling data for AI agents explains, and it mirrors the approval pattern in procurement approvals and exception workflows.

Three details carry most of the value:

  • Two versions of one definition, both dated. Without version 1 and its end date, nobody can recompute what the ERP should have deducted.
  • A correction with a named approver and a reason. An adjustment posted with no reason looks like shrinkage reversed.
  • A later count. Step 8 is the evidence that the diagnosis was right, not just plausible.

Reason codes can also age out of easy view. Shopify's per-product adjustment history shows the last 180 days, with older adjustments in a separate report that can be filtered by SKU, location, staff, app and reason. Whether the company still has step 6 in readable form depends on which view it relies on.

How to recognize similar cases at a client

You do not need to see a single order to know whether a client has cases like this. Ask the inventory director, and listen for these signs:

AskA promising answerA weak answer
Does any component sell alone and in several bundles?"Yes, our hero products are in most kits""Each bundle has its own SKUs"
Where are bundle definitions kept, and are old versions saved?"In both systems, with change logs""We overwrite them"
When counts and the ERP disagree, who investigates?"An analyst writes a note, the director approves""We just adjust to the count"
Do corrections carry reason codes?"Yes, and a memo""Sometimes"
Is a bundle change, app switch or pricing rollout planned?A named dateNone known

A client with mostly promising answers likely holds complete cases. The records across systems map shows how each step is joined, and the who-can-say-yes tree shows whom to introduce. Partners keep discovery at metadata level: which records, how many years, which systems, who owns them.

For SourceX, an introduced company needs 50+ full-time employees at peak (contractors excluded), a documented operating history, rights to license and an authorized contact. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 70% of the data is in English. Whether buyers want this record set, the rights result and any offer stay unknown until SourceX reviews it. Related records are on inventory and fulfillment and the ecommerce industry page.

Next step

Refer a company. No cap on rewards. Default reward on a company's first qualifying transaction: the greater of $50,000 plus 5% and 15% of Actual Supplier Payout, with no cap; further qualifying transactions first agreed within 12 months of the first Closing pay 15%. Eligibility and payment conditions apply, including the USD 100,000 Minimum Transaction, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If a client's inventory director can describe cases like the gift set, with dated definitions, approved corrections and later counts, register as a partner, check the company against who qualifies and read the program terms before you introduce the decision-maker.

  1. Step 1Share your linkSend your personal link to a company you know.
  2. Step 2Company appliesThe company applies itself at /apply.
  3. Step 3Company signs and is paidThe company signs, delivers its data and is paid by SourceX under its agreement.
  4. Step 4You get your rewardthe greater of $50,000 plus 5% and 15% of the actual supplier payout, with no cap. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details.

Common questions

Is every positive count variance an exception worth describing?

No. Small differences inside normal tolerance happen in every warehouse. A case is worth describing when the variance had a documented cause, an approved correction and a later count that confirmed the fix.

What if the company only kept the current bundle definition?

Then the variance can still be seen, but it can no longer be explained from the records alone. Note that gap in the introduction rather than guessing; it is exactly what SourceX's review would want to know.

Sources

  1. help.shopify.com/en/manual/products/bundles/shopify-bundles
  2. docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/sectio…
  3. help.shopify.com/en/manual/products/inventory/adjusting-inven…
  4. refer.sourcex.si/terms

Free resources

Know a company with valuable proprietary data?

Become a referral partner, get your link and introduce the company’s CEO (in an owner-run company, usually the owner). Referral partners can join from most countries. We can't work with partners in countries or regions under U.S. sanctions or on U.S. restricted-party lists. The companies you introduce should be based in the U.S., Canada and the EU, or in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia with at least 70% of their data in English.

Refer a company →

I own a business

Explore licensing your company's data directly to SourceX for AI training and evaluation. Start a short assessment; no uploads needed.

Start an assessment