Skip to content

Systems and records

Superseded SKU on order: labeling a wholesale product substitution dataset

By SourceX Editorial · Reviewed by Noah Loul ·

10 sections

Short answer

A wholesale product substitution dataset for superseded SKUs should label the line decision, not the swap: ship remaining stock, backorder the original, cancel with notice, escalate, quote alternatives, hold for approval or ship the successor with notice. Each line needs a dated item status, the replacement's interchangeability code and the customer's terms. In Digi-Key's public parts library, no record names a successor, and 62 parts changed status between January 2018 and August 2019.

System export

Superseded SKU on order

This page covers superseded SKU on order: labeling a wholesale product substitution dataset.Illustrative

Key takeaways

  • Label the order-line decision, not the swap: seven labels, tested in a fixed order that starts with stock of the item the customer named.
  • Interchangeability has a direction; store the code for each direction, who asserted it, when, and whether the successor was itself replaced.
  • The purchase order defines what conforms, so the notice or written approval sent before shipment is the record that makes a substitution defensible.
  • In 1,073 distributor part records, no field named a successor and 62 parts changed status between January 2018 and August 2019; freeze status as of each order date.
  • Outcome labels come from returns, credits, deductions and later orders; a quiet acceptance is a weak positive, not proof.

What decision does a superseded SKU force on an open order line?

It forces a choice before anything ships: fill the line with the item the customer named, wait for that item, send the maker's replacement, or stop and ask someone. A wholesale product substitution dataset earns its keep only when each example records that choice together with the facts that made it right on that date, because one superseded SKU can deserve different answers for two customers on the same afternoon.

Two words need separating. Supersession is the manufacturer's act of replacing one part number with another, usually announced in a discontinuance or change notice that names the successor. A substitute is any other item offered in place of the one ordered, whether or not its maker linked the two. The supersession link is the maker's claim about its own product line; the customer's purchase order is the contract that says what the customer agreed to receive. A model that treats the first as permission to override the second will be wrong in ways that cost returns and accounts.

Four records, each dated before the line shipped, decide the answer: the item's status and successor link as they stood on the order date, the interchangeability of the replacement in the direction needed, the customer's substitution terms, and the notice or approval sent to the customer. The sections below turn those records into seven labels, show what a distributor-curated parts library actually stores, apply the rule to eight illustrative order lines, and set out the outcome evidence, the hard negatives and the limits of what a seller's files can prove.

Seven labels for the line, tested in a fixed order

Give every line one of seven labels and test them in order, starting with stock of the item the customer named. The order carries most of the judgment: the cheapest correct answer is usually to ship what was ordered, and a model that reaches for the replacement first learns to overrule customers who never asked for a change.

The rule this article applies, step by step. If sellable stock of the ordered item covers the line, ship it as ordered. If not, and the ordered item can still be bought and will arrive by the customer's need date, backorder it. If the customer never accepts substitutes for this item, cancel the line and say so. If the replacement's fit is unknown, holds only after modification, or the chain of replacements is unresolved, send it to a technical reviewer. If there is no replacement, or it is not interchangeable in the direction needed, quote alternatives on a separate line. If the customer's terms require written approval, or the price, pack or unit of measure moves outside the agreement, hold for approval. Only when every test is clear does the successor ship, with notice before shipment.

A line that stock covers only in part is split, and each part gets its own label. The figure draws the same sequence. Each label, the evidence it needs and the error it prevents:

Seven labels for the line, tested in a fixed order
LabelApplies whenEvidence on file before shipmentWrong call it prevents
SHIP_AS_ORDEREDSellable stock of the ordered item covers the lineStock and status on the order date; no hold or recall on that stockPushing a replacement on a customer whose item is still on the shelf
BACKORDER_AS_ORDEREDThe ordered item can still be bought and arrives by the need dateUpstream availability and the customer's need dateTreating a not-for-new-designs or last-time-buy status as if the item were gone
CANCEL_LINE_WITH_NOTICEOrdered item unavailable and the customer never accepts substitutes for itThe customer's rule, such as a controlled drawing, and the cancellation noticeAny substitute on a line the customer has closed to them
ESCALATE_TECHNICALFit unknown, fit only after modification, or replacement chain unresolvedNotice text, the open question and the reviewer assignedA sales desk guessing fit from a part-number link
OFFER_ALTERNATIVE_QUOTENo replacement, or one that is not interchangeable in the needed directionA quote line for alternatives kept apart from the original lineFilling the line with a look-alike and calling it the same item
HOLD_FOR_APPROVALReplacement fits, but terms require written approval or price, pack or unit changesThe approval request, the customer's written answer and its dateShipping a change the purchase order did not authorize
SHIP_SUCCESSOR_WITH_NOTICEReplacement fits in the needed direction, substitutes allowed, no commercial changeInterchangeability code and its source, customer terms, notice sent before shipmentA silent swap the customer discovers at receiving
A decision ladder for one order line naming a superseded SKU: six yes-or-no questions in sequence, each yes exiting to a label (ship as ordered, backorder as ordered, cancel with notice, escalate to technical, quote alternatives, hold for approval), and a final no leading to ship successor with notice.
The seven line labels in the order the rule tests them. The questions are shortened forms of the rule in this section.

Interchangeability runs one way or both, and the record must say which

Store interchangeability as a code with a direction, because one-way replacement is the trap a bare link hides. The Federal Logistics Information System run by the U.S. Defense Logistics Agency puts a two-character code on its replacement transactions: TW when old and new items can stand in for each other, OW for one-way interchangeability, NI when they are not interchangeable, and OM or IM when they become interchangeable only after modification, according to DLA's FLIS SSR technical procedures (revision 1, 1 June 2024).

The one-way code carries two instructions at once. On the record for the original, the original may be used until stock is exhausted; on the record for the replacement, the new item may replace the original. Read the other way round, the same code rules out a common shortcut: a customer who orders the new number cannot be sent leftover stock of the old one. DLA describes its PUB LOG interchangeability and substitutability data as a reference for determining exactly this, and lists an order-of-use code and a jump-to code among its fields.

Commercial item masters rarely say this much. A supersession link in an ERP often records only that item A points to item B. For training or evaluation data, the link needs four more facts: the code in each direction, who asserted it (the maker's notice, the distributor's product team or a customer approval), the date it took effect, and whether B has since been replaced too. A chain from A to B to C is settled only when its last link is confirmed current; an agent that stops at B can ship a part as retired as the one ordered.

Notice and approval: what the customer agreed to receive

The purchase order, not the maker's notice, defines what conforms, so the label turns on the customer's terms and on the notice the distributor gave. Under section 2-313(1)(b) of the Uniform Commercial Code, a description of the goods that is part of the basis of the bargain creates an express warranty that the goods will match it, and the official comment observes that technical specifications can describe goods more exactly than words. A part number on a purchase order is that kind of description.

Article 2 starts from the perfect tender rule, which Cornell's Legal Information Institute summarizes as a buyer's right to reject goods that fail to conform in any respect, and section 2-508 gives sellers a route back. A seller whose tender is rejected while time for performance remains may seasonably notify the buyer and then deliver conforming goods within the contract period. A seller who had reasonable grounds to believe a nonconforming tender would be accepted, with or without a money allowance, may get a further reasonable time to substitute a conforming tender if it seasonably notifies the buyer. Both routes run through notice, so a dataset that drops the notice record has dropped the fact the law asks about.

Upstream notices have a structure as well. JEDEC's J-STD-048, which superseded JESD48, is the electronics industry's notification standard for product discontinuance, written so customers can manage the disruption and keep supply continuous. JEDEC's part model supply chain guidelines treat the last order date and last shipment date in a discontinuance notice as mandatory and ask suppliers to give a reason for discontinuance. Those two dates decide whether BACKORDER_AS_ORDERED is still open, so they belong on the line record exactly as they stood on the order date.

This is general information about commercial law and industry practice, not legal advice. Customer terms, state enactments of the UCC and rules for regulated products differ, and counsel should review any rule a dataset encodes as the correct answer.

What 1,073 distributor part records show about status and successors

A lifecycle status tells an order agent that something has changed but not what replaces the part, and the status itself moves over time. That is what a count of Digi-Key's public KiCad parts library shows. Its README says each part carries data taken from the distributor's website, part status included, and each symbol holds Digi-Key's part number, the manufacturer's part number and a status field, so the repository's history works as a small, dated stand-in for a distributor's item master.

At the last status update in the history, made on 1 August 2019, the library held 1,073 parts. 994 were plain Active and 79 carried another status: 47 Obsolete NonStock, 15 Not For New Designs, 10 Active NonStock, 4 Discontinued at Digi-Key NonStock and 3 Last Time Buy NonStock. Every symbol has the same nine named fields, and none of them names a successor or replacement part; no description uses replace, supersede, successor, obsolete or discontinue wording.

Statuses also moved, and not only forward. Between 25 January 2018, the first snapshot with status fields, and the last update, 62 parts changed status in 103 recorded changes; 27 parts changed more than once, and 9 changes returned a part to plain Active. Of the 879 parts listed as plain Active in January 2018 and still present at the end, 41, or 4.7 percent, finished with another status, 27 of them Obsolete NonStock. The two most frequent changes were Last Time Buy NonStock to Obsolete NonStock (23) and Active to Last Time Buy NonStock (20).

Digi-Key's own TechForum explains why these strings call for different actions. It describes a part discontinued by Digi-Key as one the distributor stopped carrying that may still be active at its manufacturer, a part not recommended for new designs as still in production and available, and a last-time-buy part as at end of life with limited stock that becomes obsolete once stock runs out. Inside the library, one state even carries two names: the status reads Not For New Designs while the symbol name ends in NRND.

Method: the script, dk_status.py, read every commit on the first-parent chain of master up to d4bd68f (125 commits, 115 of them with status fields). In each it parsed every part block in the family libraries under symbols/ and, after that folder was renamed on 29 January 2018, digikey-symbols/, decoding files with any byte-order mark removed and undecodable bytes replaced; every block carried a part number, and the per-part copies under src/ carry no status fields and were not read. Parts are keyed by Digi-Key part number, upper-cased so that case variants cannot split a part (none occurred); two part numbers appeared twice in two snapshots of 9 May 2018, with the same status both times, and were counted once. Statuses, with repeated spaces collapsed, are compared exactly between consecutive snapshots, a change counts only where the part appears in both, and each change is dated by the commit that first shows it. Descriptions were scanned case-insensitively, as whole words, for replac-, supersed-, successor- and discontinu- with any ending and for obsolete, NRND and EOL. The repository is flagged as unmaintained, so these statuses describe 2019, not today's catalog. What each status at the final update tells an order agent, and what it leaves out:

What 1,073 distributor part records show about status and successors
Status at final updatePartsWhat it tells the order deskWhat it does not tell
Not For New Designs15Still made and sold; new designs are discouragedThat the line needs a substitute today
Active NonStock10Active at the maker, not stocked by the distributorWhether the item arrives by the need date
Discontinued at Digi-Key NonStock4The distributor stopped carrying itThat the maker retired it
Last Time Buy NonStock3End of life; final purchases onlyWhich part replaces it, or when buying stops
Obsolete NonStock47No longer made; unorderable once stock is goneAny successor or interchangeability code

The casebook: eight order lines and the label each one earns

Each case is illustrative, and each label comes from applying the rule above, in order, by script; no case uses a label outside the seven. Cases 4 and 5 reach the same label for different reasons, which is the reason to keep a deciding-fact column: a model should be graded on the fact it cites as well as the label it picks.

Read the casebook as a test set in miniature. Cases 1 and 2 are the ones an eager agent gets wrong by substituting, case 6 is the one an agent that trusts the part-number link gets wrong by shipping, and case 8 is the one only the customer file can settle:

The casebook: eight order lines and the label each one earns
CaseOrder line factsLabelDeciding fact
1Contractor orders 12 valve cartridges; 40 of the old part in stock; two-way successor existsSHIP_AS_ORDEREDStock covers the line, so the successor never comes into play
2Sensor flagged not for new designs; maker still ships it before the need dateBACKORDER_AS_ORDEREDThe ordered item is still obtainable in time
3Obsolete filter; two-way successor at the same price and pack; customer accepts substitutes with noticeSHIP_SUCCESSOR_WITH_NOTICEFits, permitted, no commercial change; notice goes out before shipment
4Obsolete relay; one-way successor; purchase order requires written approval of substitutesHOLD_FOR_APPROVALCustomer terms require approval even though the part fits
5Obsolete fitting sold each; two-way successor sold only in packs of tenHOLD_FOR_APPROVALUnit of measure changes outside the agreement
6Obsolete motor; notice says the successor fits after a bracket changeESCALATE_TECHNICALInterchangeable only after modification
7Discontinued lamp; the notice names no replacement; customer open to optionsOFFER_ALTERNATIVE_QUOTENo interchangeable replacement exists
8Obsolete gasket on the customer's controlled drawing; customer never accepts substitutesCANCEL_LINE_WITH_NOTICEThe customer has closed the line to substitutes

Outcome labels: how a team learns whether the call was right

Grade the decision against the rule and the evidence on file, and record the outcome separately from later documents, because an outcome alone cannot tell a sound call from a lucky one. The documents already exist at most distributors: return authorizations with reason codes, credit memos, invoice deductions, complaint notes and the customer's next orders.

At a glance

Outcome labels: how a team learns whether the call was right

Silence is the weak spot. A customer who took a substitute without comment may have been content or may not have noticed, and returns happen for reasons unrelated to the swap, such as over-ordering. Count a return against a decision only when its reason code points at the item, and treat a quiet acceptance as a weak positive unless written approval or later adoption backs it up. Set the outcome window from the distributor's own return terms, and leave a line out of grading until that window has closed.

Five outcome classes, each tied to a record a buyer can audit:

  • Accepted without dispute: no return, credit, deduction or complaint on the line inside the return window, and the invoice paid as billed.
  • Returned or credited for the item: a return or credit whose reason names the wrong item, a fit problem or an unapproved substitute.
  • Disputed without return: a deduction or complaint about the line with no goods sent back.
  • Adopted: the customer's later orders use the successor's number, stronger evidence than silence.
  • Closed: the line was cancelled or backordered, with the date the customer was told.

Hard negatives that look like routine substitutions

Hard negatives are cases where the obvious move is wrong, and they have to be sampled on purpose because routine lines swamp any order log. Fix the share of each in the evaluation set and keep the deciding fact with the label:

  • A not-for-new-designs or last-time-buy status on an item that can still be bought in time: ship or backorder as ordered, do not substitute.
  • A one-way code read backwards: the customer ordered the new number and only old stock is on hand. The old part may not replace the new one, so the line waits for the ordered item or goes to a quote.
  • A successor that has itself been superseded: the notice names B and B is already obsolete, so the line escalates until the chain ends at a confirmed current item.
  • A two-way successor sold in a different pack or unit of measure: it fits in use, but the commercial change needs approval.
  • A status that reverses: in the parts library above, 9 recorded changes returned a part to plain Active, so a label rebuilt from today's status can contradict the decision made on the day.
  • A distributor-only discontinuation: the maker may still build the part, so the first question is sourcing, not substitution.
  • Old stock that may not ship, for example under a recall or quality hold: stock on hand is not the same as sellable stock.

What a distributor's records can show, and where they stop

A distributor's records can show the line, the decision, the notice and the commercial outcome; they rarely show whether the part worked in the customer's equipment. Write that boundary into the intended use, because data built from these records teaches order handling, not engineering fit.

What they can show: the ERP holds order lines, quantities, need dates and the commercial facts each label needs. Order acknowledgments and email hold the notice and approval text with dates. Return and credit records hold reason codes. The item master holds supersession links, but often only as they stand today; unless the system keeps history or someone saved dated snapshots, the link in force on the order date has to be rebuilt from the notice archive, and the parts-library count shows how far a later snapshot can drift.

What they cannot show: why a customer accepted quietly, how a replacement performed in service, or what would have happened had the line been held instead. Rights narrow the set further. Customer identities and contract pricing need de-identification or permission under the customer agreement, and makers' discontinuance notices may sit under supplier confidentiality or copyright, so a licensable packet usually carries the distributor's own dated summary of a notice rather than the notice itself. A sector label on the data proves none of these rights; each needs its own review.

Requesting superseded-order cases from SourceX

Ask for decided lines with their evidence attached, not for an order history. SourceX licenses records from the companies that created them and licenses them on to buyers in its own name; it keeps no shelf of distributor data and starts looking for sources once a buyer has described the need on its request form, which covers scope, volume, language, format, timing and licensing terms.

A useful request names the product families and trades in scope, the seven labels or your own equivalent, the evidence each line must carry (dated status and successor link, interchangeability code with its source, customer terms, notice or approval text, outcome record), the share of hard negatives, and an acceptance test, for example that every sampled line shows a notice or approval dated before shipment. Say whether the data is for training or evaluation, since evaluation sets need closed outcome windows. SourceX describes candidate sources against that request; stock, acceptance and model gains are not promised.

Frequently asked questions

What is the difference between a superseded product and a substitute?

A superseded product has been replaced by its maker with a named successor, usually through a discontinuance or change notice. A substitute is any item offered in place of the one ordered, linked by the maker or not. A successor can still be the wrong substitute for one customer if it fits only one way, needs modification or changes the pack.

Can a distributor ship the replacement for a superseded part without asking?

Sometimes. If the replacement is interchangeable in the direction needed, the customer's terms allow substitutes and nothing commercial changes, shipping with notice before shipment is defensible. If the purchase order requires written approval, or the price, pack or unit of measure changes, hold the line and ask; customer terms and state law decide specific cases.

What fields does a supersession record need in a training dataset?

At minimum the ordered and replacement part numbers, the interchangeability code in each direction, who asserted it and when, the item status on the order date, the maker's last order and last shipment dates, the customer's substitution rule, the action label, the notice or approval text and the outcome record. Without dated status, labels drift as the item master changes.

Why not use the item master's current supersession links?

Because they describe today rather than the order date. In Digi-Key's public parts library, 62 parts changed status between January 2018 and August 2019 and some returned to Active, so a current snapshot can contradict decisions made earlier. Rebuild each link as it stood from dated notices or saved snapshots.

How do you know a customer accepted a substitution?

From what happened after the line shipped: no return, credit, deduction or complaint inside the return window, payment as billed and, ideally, later orders that use the new number. Silence on its own is weak evidence, so require reason codes on returns and give written approval or adoption more weight.

Sources

  • Digi-Key's public KiCad parts library at commit d4bd68f (2 February 2022), whose git history was counted for this article: 1,073 parts at the last status update on 1 August 2019, their status strings, field names and status changes since 25 January 2018. Source
  • The library's README says each part is pre-loaded with information based on the Digi-Key website, part status included, and flags the library as unmaintained. Source
  • Digi-Key's TechForum explains its part statuses: discontinued by Digi-Key may still be active at the manufacturer, not recommended for new designs is in production and available, and last time buy moves to obsolete when stock runs out. Source
  • DLA's FLIS SSR technical procedures (revision 1, 1 June 2024) define interchangeability codes on replacement transactions: TW, OW, NI, and OM or IM for interchangeability after modification. Source
  • DLA describes PUB LOG's interchangeability and substitutability data as a reference for determining interchangeability and substitutability, with order-of-use and jump-to codes among its fields. Source
  • UCC section 2-313(1)(b): a description of the goods made part of the basis of the bargain creates an express warranty that the goods will conform to it. Source
  • UCC section 2-508: a seller may cure a rejected tender after seasonable notice, and may get further reasonable time to substitute a conforming tender when it had reasonable grounds to believe the tender would be accepted. Source
  • Cornell's Legal Information Institute summarizes the perfect tender rule: a buyer may reject goods that fail to conform to the contract in any respect. Source
  • JEDEC's J-STD-048, the notification standard for product discontinuance, superseded JESD48 and aims to help customers manage discontinuance and keep supply continuous. Source
  • JEDEC's part model supply chain guidelines treat the last order date and last shipment date in a discontinuance notice as mandatory and ask for a reason for discontinuance. Source
  • SourceX's request page: it licenses business data from companies and licenses it to buyers in its own name, datasets are sourced on request, and buyers share scope, volume, language, format, timing and licensing. Source

Tell us what data you need

Share scope, volume, format, timing and licensing needs. Datasets are sourced on request.

See if your company qualifies