Course contents
Practitioner · Course 3: Digital Colour and Material Libraries · Lesson 5 of 5

Building a complete digital colour and material library tracker

Level: PractitionerTime: 45 minutesOrder used: A (the T-shirt)Tool: Digital colour and material library tracker
For anyone who has completed Lessons 1 to 4 and now wants to run one complete digital colour and material library tracker end to end. Lessons 1 to 4 are required preparation. The figures reuse Order A's own facts alongside a domestic hybrid style for Cedar & Co.
BuyerCedar & Co.
FactoryDelta Garments
StyleT-shirt, forecast-booked then confirmed batch
Business modelHybrid (forecast booking, confirmed quantity), domestic
ToolDigital colour and material library tracker, all four sheets
Records coveredColour standards, dye lot approvals, material library, version approvals
02Opening

This page teaches how to run one complete digital colour and material library tracker end to end, so a colour standard, its tolerance, its library record and its approved version are all managed as one connected record rather than four separate ones

Lessons 1 to 4 each taught one part of managing a digital colour or material record: setting a digital colour standard, checking a dye lot against a tolerance, building a reusable material library, and tracking which version an order approved. This final lesson brings all four parts together into one working tracker, using a Cedar & Co. hybrid batch as the example.

Handled separately, these four parts can drift out of sync with each other. This lesson shows how running them as one connected tracker keeps a colour standard, its tolerance, its library record and its approved version consistent with each other from set-up through to production.

03Before you start

What you need, and what this lesson does not cover

You need: all four ideas from Lessons 1 to 4: digital colour standard, colour tolerance, digital material library, and material version.

By the end of this lesson you can:

  • explain how the four tracker sheets connect to follow one order end to end;
  • fill in a complete tracker record for a new hybrid batch;
  • identify which sheet to check first when a colour or material question comes up;
  • decide what to do when two sheets in the same tracker disagree.

Not covered here: any single part of the tracker in isolation; Lessons 1 to 4 each cover one part in depth. This lesson only teaches how the four parts work together as one tracker.

04Key terms

Words you will meet in this lesson

TermMeaning
Digital colour standardA colour standard recorded as a numeric colour value inside a shared digital file, in addition to any physical swatch, so every party can check the same reference without relying on the physical swatch's own condition or the light it is viewed under.
Colour toleranceThe maximum acceptable numeric difference between a digital colour standard's own colour value and a measured dye lot's colour value, before the dye lot is judged not to match.
Digital material libraryA shared digital collection of approved colour standards and fabric records, organised so a design team can find and reuse an existing approval instead of starting a new approval from scratch.
Material versionOne specific saved state of a material record at a point in time, distinct from any later edit made to the same record.
Version mismatchA difference between the material version a specific order approved and the version currently held in the shared library, caused by an edit made after that order's own approval.
Material recordOne entry in a digital material library, holding one colour standard or one fabric specification's own approved details.
05Teaching
The rule

A complete tracker connects a colour standard, its tolerance, its library record and its approved version into one workflow, so a person checking any one of the four always sees how it relates to the other three

Each of the four sheets built in Lessons 1 to 4 answers a different question: what is the colour (colour standard), does a real dye lot match it (tolerance), can this colour or fabric be reused (material library), and which version did this order actually approve (version approvals). Run separately, a change in one sheet, such as an edited colour standard, can silently affect another, such as a version an order already approved. A complete tracker links the four sheets by a shared reference, such as the order and the material record's own ID, so a change in one is visible from the others.

Colour standards sheetWhat is the colourDye lot approvals sheetDoes a real lot match itMaterial library sheetCan it be reusedVersion approvals sheetWhich version was approvedShared order and material-record reference
All four sheets share the same order and material-record reference. This is what lets a person move between them and see one consistent picture, instead of four disconnected records.
What you meet in real life

How the four connected sheets are used changes with the business model, the market and how many parties touch the same record

What can differThe shapes you meetWhy it matters to you
Business modelA single Make to Order export order, like Order A, typically fills all four sheets once, at set-up. A hybrid or Make to Stock domestic style, like Cedar & Co.'s repeat batches, revisits the material library and version approval sheets many times as it repeats over seasons.A hybrid or repeat business model puts more weight on the material library and version sheets staying accurate over time, not just at set-up.
MarketAn export order with multiple parties, Northline, Delta Garments, Colorline Dyeing and an agent like Meridian Sourcing, needs all four sheets visible to every party who touches the record. A domestic order between Cedar & Co. and Delta Garments has fewer parties needing shared visibility.The more parties involved, the more valuable it is that the four sheets stay connected by a shared reference rather than living in separate files.
Product familyA garment brand's tracker links colour standards and fabric records the way this course has shown; a hosiery or home-textiles brand's tracker links the same four sheets around its own yarn or sheeting fabric records instead.The specific material changes by product family, but the same four-sheet structure and shared-reference principle applies.
When a disagreement surfacesA colour tolerance failure (Lesson 2) surfaces at the dyeing stage; a version mismatch (Lesson 4) can surface earlier, before dyeing even starts, if checked. Checking the version approvals sheet before the tolerance sheet catches a problem earlier in the order's own timeline.Checking sheets in this order, version first, then tolerance, catches problems as early as possible rather than only once dyeing has already happened.
The case we follow

Cedar & Co. runs a complete tracker record for a new hybrid batch, checking all four sheets before confirming production

Cedar & Co. plans a new T-shirt batch that starts as a forecast-based fabric booking with Delta Garments, later confirmed as a fixed quantity once its own shops' sales data firms up, a hybrid arrangement. Before confirming production, Cedar & Co.'s merchandiser checks all four tracker sheets in order: the colour standard's own colour value, whether any dye lots already run for this batch pass their tolerance check, whether the material library's fabric record still matches this batch's own weight and cut, and which version of the colour standard this batch's own approval actually references.

Running through all four sheets together, rather than checking only the one most relevant to the immediate question, is what lets Cedar & Co.'s merchandiser confirm the whole record is consistent before committing to full production.

The worked number

Checking all four sheets before confirming production catches a stale material-library reference that a single-sheet check would have missed

Cedar & Co.'s new batch: 250 pieces, using Order A's own fabric consumption standard, 0.205 kg per piece
Fabric requirement for this batch: 250 × 0.205 = 51.25 kg
Colour standard sheet: version 2, approved 15-Jan
Version approvals sheet: this batch's own approval references version 1, approved 20-Nov, one version older
Cost of proceeding on the mismatched version 1, if only the colour standard sheet had been checked: risk of dyeing the full 51.25 kg fabric requirement to an outdated colour value
Cost of catching it by checking the version approvals sheet before production: USD 0, corrected before any fabric is dyed

Checking every sheet, not only the one that seems most relevant, is what catches a mismatch like this one before it costs anything.

Colour standardVersion approvalsDye lot approvalsMaterial libraryConfirm and produce
Checking all four sheets in sequence catches a mismatch anywhere in the chain. Skipping any one sheet leaves a gap the others cannot cover on their own.
The method

Run a complete tracker check in four steps

  1. Confirm the colour standard sheet's own current colour value for the order or batch in question.
  2. Confirm the version approvals sheet shows this order's own approval referencing the same version as the current colour standard, not an earlier one.
  3. Check the dye lot approvals sheet for any lots already run, confirming each passed its own tolerance check.
  4. Confirm the material library sheet's fabric or colour record still matches this batch's own weight, cut or construction, reusing it only if it genuinely does.
The trap

A common mistake is checking only the one tracker sheet that seems most relevant to the immediate question, assuming the other three are automatically consistent with it

Because the four sheets are connected by a shared reference, a change in one, such as an edited colour standard, does not automatically update or flag the others. The cost of this mistake, as in the worked number above, is proceeding on a stale or mismatched reference in one sheet that a full check across all four would have caught before it reached production.

06In plain words

A complete digital colour and material library tracker connects four sheets, colour standards, dye lot approvals, material library and version approvals, around a shared order and material-record reference. Checking all four together, rather than only the one that seems most relevant, is what catches a mismatch anywhere in the chain before it reaches production. Cedar & Co. runs through all four sheets for a new hybrid batch, catching a version mismatch that a single-sheet check would have missed, at no cost since it was caught before any fabric was dyed.

07Quick check
  • A complete tracker links four sheets by a shared order and material-record reference.
  • A change in one sheet does not automatically update or flag the other three.
  • Checking version approvals before dye lot approvals catches a problem earlier in an order's own timeline.
  • A hybrid or repeat business model revisits the material library and version sheets more often than a single confirmed order.
  • Checking only the sheet that seems most relevant risks missing a mismatch the other sheets would have caught.
08Workplace scenario

Omar, the owner of Cedar & Co., asks the merchandiser to confirm production can start immediately since the colour standard sheet already shows a passing dye lot

Omar sees the dye lot approvals sheet showing a pass and wants to move straight to production without checking the other tracker sheets.

  • The dye lot approvals sheet shows a passing result for a lot dyed against colour standard version 2.
  • The version approvals sheet has not yet been checked to confirm this batch's own approval references version 2, not an earlier version.
  • Confirming production without checking the version approvals sheet risks producing against a version this batch never actually approved.

Should the merchandiser confirm production based on the passing dye lot alone, or check the version approvals sheet first? Decide before opening the answer.

Show decision

The merchandiser should check the version approvals sheet first, before confirming production based on the passing dye lot alone.

1. A passing dye lot only confirms that particular lot matched the colour standard it was measured against; it does not confirm which version this batch's own approval actually references. 2. If the batch's own approval references an earlier version than the one the dye lot was measured against, production would proceed on a colour this batch never approved, the same risk shown in Lesson 4's own worked number. 3. Checking the version approvals sheet first costs only a short check, far less than the cost of an unapproved version reaching production.

The merchandiser's decision keeps the full tracker consistent by checking every sheet that could affect the decision, not only the one that already shows a pass.

09What it costs

Running a complete four-sheet check protects Order A's own value and every repeat batch built on the same records, at the cost of a few minutes per check

Order A carries a FOB price of USD 3.20 per piece on 15,000 pieces, giving:

15,000 pieces × USD 3.20 = USD 48,000 total FOB value for Order A

Each individual mismatch shown across Lessons 1 to 4, an aged swatch, a failed dye lot, a mismatched fabric record, an unapproved version, carries its own recoverable cost, from USD 2,250 up to the full fabric requirement's own risk. A complete four-sheet tracker check costs only a few minutes per order or batch, and is what catches any one of these mismatches before it reaches production, protecting Order A's own USD 48,000 value and every domestic repeat batch built on the same digital colour and material records.

10Working template

Digital colour and material library tracker: the complete four-sheet workbook

Use the T25-C03 Digital colour and material library tracker workbook in full: "Colour standards," "Dye lot approvals," "Material library," and "Version approvals." Confirm every sheet references the same order or material-record ID before treating a batch as ready for production. Start with Order A's and Cedar & Co.'s own records built across Lessons 1 to 4, then add your own.

[Download the Digital colour and material library tracker workbook](../../templates/T25-C03-digital-colour-and-material-library-tracker.xlsx)

Download the Digital colour and material library tracker (Excel)

11Check yourself

1. Why does a complete tracker need all four sheets checked together, rather than just the one sheet most relevant to a specific question?

2. A batch's dye lot approvals sheet shows a pass, but the version approvals sheet has not been checked. What risk does this leave uncovered?

12Glossary
ENARFRTRMeaning
Digital colour standardمعيار اللون الرقميÉtalon de couleur numériqueDijital renk standardıA colour standard recorded as a numeric colour value inside a shared digital file, in addition to any physical swatch, so every party can check the same reference without relying on the physical swatch's own condition or the light it is viewed under.
Colour toleranceهامش تفاوت اللونTolérance de couleurRenk toleransıThe maximum acceptable numeric difference between a digital colour standard's own colour value and a measured dye lot's colour value, before the dye lot is judged not to match.
Digital material libraryمكتبة الخامات الرقميةBibliothèque numérique de matièresDijital malzeme kütüphanesiA shared digital collection of approved colour standards and fabric records, organised so a design team can find and reuse an existing approval instead of starting a new approval from scratch.
Material versionإصدار الخامةVersion de matièreMalzeme sürümüOne specific saved state of a material record at a point in time, distinct from any later edit made to the same record.
Version mismatchعدم تطابق الإصدارÉcart de versionSürüm uyumsuzluğuA difference between the material version a specific order approved and the version currently held in the shared library, caused by an edit made after that order's own approval.
Material recordسجل الخامةFiche matièreMalzeme kaydıOne entry in a digital material library, holding one colour standard or one fabric specification's own approved details.
13Next

Course 4, Lesson 1

This is the last lesson of Course 3. Course 4 continues the Digital Product Creation track with the next stage of digital tools, building on the colour and material discipline this course has already covered across its five lessons. Back to the course map

14Ladder

RecognizeTell four connected tracker sheets apart from four separate, unconnected records.
ConnectSee why a change in one sheet does not automatically update or flag the other three.
CompareJudge which of the four sheets to check first for a given colour or material question.
DecideChoose to check all four sheets before confirming production, rather than relying on the one sheet that seems most relevant.