One up, one down traceability: linking what came in to what went out
Updated
One up, one down traceability means recording, for every lot, the supplier it came from and the customer it went to, and keeping the link between the two. TraceBench shows that link free in your browser, from one or two CSV exports of your own records: it follows only the links your rows state or you confirm, shows the row behind each one and names every gap.
Free to use. No account, email address or trial. Your files are never uploaded.
The batch link you confirmed carries the trace from production to the shipments.
One step back: the supplier lot
One step back means knowing which supplier lot went into each of your batches. In TraceBench that comes from a production file: choose Production: input into output, then the column that holds the supplier's lot number as the input, and give it a numbering name such as supplier lots. That numbering stays separate from your own batch numbers, so a supplier's lot is never joined to one of yours because the codes look alike.
The column that holds the supplier's lot number.
One step forward: the customer shipment
One step forward means knowing which shipment, and so which customer, each batch went to. That comes from a despatch file: choose Despatch: item in a shipment, then the batch column and the shipment column. TraceBench keeps no customer list of its own, so keep the customer in the despatch row: each link shows the whole row, exactly as written. A shipment number can also be the starting point, traced backwards to the batches in it.
A shipment number from the despatch records as the starting point.
The link inside your business
The link between what came in and what went out is your own production record: this supplier lot went into this batch, and this batch went into that shipment. When production and despatch are separate files, a batch number in both is only a possible link until you say so: confirm one exact pair, or declare that the two batch columns use the same numbering, each with a reason. The link is then labelled Your confirmation or Your declaration, and withdrawing it is recorded too.
One exact pair confirmed, with the reason for it.
Following it beyond one step
Each business in a supply chain keeps its own one up, one down records. Inside your business, the same records go further than one step: a supplier lot traced forwards reaches every batch made from it, through up to 20 manufacturing steps, and, once the two files are linked, every shipment recorded for those batches. Traced backwards, a shipment reaches the batches in it and the supplier lots behind them.
Inside your business the same records go further: every batch and shipment recorded for the supplier lot.
What TraceBench does not do
TraceBench reads the records you load; it does not tell you which rules apply to your business or whether your records meet them. It reads two current CSV files at a time, has no connection to your ERP or to your suppliers' and customers' systems, and links records only where your rows state the link or you confirm it. It shows quantities as written without balancing them, and it has no recall, hold or customer-notification actions.
MADE FOR THE FLOOR
For quality, technical and supply chain staff at small food and engineering manufacturers who need to show which supplier each lot came from and which customer it went to.
A USEFUL STARTING POINT
The link in the middle is the hard part
Most businesses know their suppliers and their customers. The harder part is the link between them: which supplier lots went into which batch, and which batch went to which customer. TraceBench follows that link through the production and despatch records you already keep, shows the row behind each step and says where the records stop.
FROM QUESTION TO EVIDENCE
Three steps to a useful result.
01
Load production and despatch
Export the production records that say which supplier lot went into each batch, and the despatch records that say which batch went into each shipment. Load them as CSV and say what each column means.
02
Connect the two files
Confirm one exact pair, or declare that the batch columns in both files use the same numbering, with your reason.
03
Trace one up and one down
Trace a supplier lot forwards to its shipments, or a shipment backwards to its supplier lots, and download the result as a PDF or CSV.
A CONCRETE EXAMPLE
From supplier lot to shipment
In the built-in example, the production file records supplier lot SL-0042 going into batches B-1001 and B-1002, and the despatch file records B-1001 in shipments S-501 and S-502 and B-1002 in S-503. With the batch numbering declared as shared, SL-0042 traced forwards reaches all three shipments, each link showing its row. The answer is Partial, because a production record within the declared sequence range is missing, and TraceBench names it.
USED IN PRODUCTION
When tracing becomes quality work for a team.
TraceBench answers one question at a time, from files you load on one device. When traces become regular work for a quality team, LotTrail keeps the declared sources, reviewed identity links and evidence together. LotTrail is an invited trial, with scope agreed with you.
Invited trial
LotTrail
LotTrail follows a lot or serial number through the records your factory already keeps, with the source of each link and the gaps shown. Sources are declared, mappings are reviewed, identity links are approved by a supervisor and the evidence is retained for quality work. The invited trial covers two declared sources at one site.
One up, one down is a common baseline in food and supply-chain rules, but what applies to you depends on your products, your markets and your customers, so check with your trade body, certification scheme or adviser. TraceBench does not give legal advice; it shows, from your own records, whether each lot links to its supplier and to its customer.
Is one up, one down the same as a traceability exercise?
No. One up, one down is what your records should hold; a traceability exercise tests whether they do, by following a lot both ways against the clock. See /traceability-exercise/.
Do I need both files?
For both steps, yes: the production file gives the supplier lot in each batch, and the despatch file gives the shipment for each batch. A production file alone shows one step back.
What are the current limits?
TraceBench is a reading of the records you load, not a recall decision or proof of what physically happened. It has no recall, hold, stock or customer-notification actions, does not allocate or reconcile quantities, and never links records because their codes, times, descriptions or row order look alike. Two current files at a time, each UTF-8 CSV with column names in the first row, up to 5 MiB, 5,000 data records and 40 columns, and 10,000 recorded facts across both. A trace follows up to 20 manufacturing steps and stops at its limits with a stated reason. XLSX files are not read, and there is no connection to your ERP or any other system.
What happens to my data?
Your files stay in this browser. Work is held in memory until you choose Save on this device, which keeps the whole project, original files included, in this browser. Files are read and fingerprinted on your device and never uploaded, and there is no account or email step. Reports and backups contain your records and file names, so check them before sharing. Google Analytics is optional and loads only after you accept; it never receives codes, rows, file names or results. Use Analytics settings to change your choice; see /privacy/.
ONE SMALL JOB, DONE WELL
Put TraceBench to work.
Open the free tool and start with one known example.
Practical tools. Useful on their own. Better around the same floor.
Automate factory decisions with rules you describe in plain English. Explore focused SmartFACT services, plus free tools for everyday checks.
Invited trialSuggested next step
LotTrail
Follow a lot or serial number through the records your factory already keeps, with the source of each link and the gaps shown. Explore an invited trial with two declared sources.
Bring data in from uploaded sheets or the Shopify, WooCommerce and PrestaShop connectors, check each change and deliver it to the products that use it.
Scan an empty container to send the right refill request to stores. Approved plain English rules set the stores queue, priority, ticket printer and escalation.
Label each offcut, find a suitable length before cutting new stock and record what you used. Approved plain English rules decide what to keep and where it goes.
Check a shared tool before handover, record who has it and keep damaged or overdue tools out of the next issue. Explore an invited trial for one factory crib.
Receive, put away, reserve and issue stores material with barcode checks, keeping held, reserved and available stock apart. Explore an invited trial for one stockroom.
Load one or two CSV exports and follow a lot or serial forwards or backwards, with the row behind every link. No account needed.
You are here
Help
SmartFACT Help
Step-by-step guides and interactive demonstrations for the SmartFACT suite. Read the instructions, watch a task or practise with real product screens and sample data.