Example workflow Manufacturing

How a Window Workshop Can Record Which Components Went Into Each Production Order

Scan the order sheet once, then the label of every glass unit, profile and fitting that goes into it. The export lists each component next to its order, ready for your ERP import or your quality records.

This page shows how DataScan can be set up for this task. It is an illustration, not a report about a specific customer. All codes and values on it are examples.

Download and Start Free Trial
7-Day Free Trial • iPhone, iPad & Android • Cancel Anytime
Worker in a high-visibility vest scanning a barcode label on a grey parts crate with a phone at a workshop bench

The problem

A window leaves the workshop, and months later a glass unit shows a fault. Then the questions are simple: which serial number went into which order, and which other windows got glass from the same batch? The answer depends on what was written down at the assembly station.

Often nothing was, or it was written by hand: serial numbers copied from labels onto the order sheet and typed into a spreadsheet later. Long numbers get copied wrong, sheets get lost, and on a busy day nobody types them up.

If the order sheet carries a barcode and the components arrive with their serial or batch number on a barcode label, a phone at the assembly station can do the writing. DataScan links every component you scan to the order scanned before it and exports the list as a CSV or Excel file for import into your ERP or for your quality records.

The setup

One-to-Many Scan links one primary barcode with every barcode scanned after it. Here the primary is the production order and the secondaries are its components. Rename the labels and columns so the screen and the file use your words.

Scan mode One-to-Many Scan, sub-mode One-to-Many (Groups)
Primary Barcode Label, Secondary Barcode Label Order and Component, so the scan screen asks for the order first and then for its components
Primary Column Header, Secondary Column Header The column names your ERP import or quality sheet expects, for example Order and Component
Flip Primary and Secondary Column on Export On if your import wants the component first
Preferred Export Format CSV (Comma Separated Values) for an ERP import, with the delimiter and encoding it needs; Excel (.xls format) for a sheet in your quality records, where every cell is stored as text, so serial numbers keep their leading zeros
Barcodes A Code 128, QR or Data Matrix code with the order number on every production order sheet; the serial or batch labels on the glass units, profiles and fittings

Step by step

  1. Put a barcode on the order sheet Print the production order number as a barcode on the order sheet or job ticket that travels with the window through the workshop.
  2. Scan the order at the assembly station Open One-to-Many Scan, tap Start New Scan and scan the order sheet. The scan screen shows the order number and then asks for the next component.
  3. Scan each component as it goes in Scan the label of every glass unit, profile bar and fitting set that goes into this window. Each one is saved with the order number and a timestamp. A label the camera cannot read can be typed in with Manual Input.
  4. Move on to the next order When the next order reaches the station, tap New Order and scan its order sheet. The components that follow belong to that order.
  5. Check and send At the end of the shift, open View Scanned Pairs to check the list and swipe to delete a wrong scan. Send the file with Share Data or Send Email. Once it has arrived, tap Clear Data so the next shift starts with an empty list.
  6. Import it or file it Import the CSV into your ERP, or add the file to your quality records. To find where a component went, filter the Component column for its serial or batch number: the row shows the order.

What you get out

Each component scan becomes one row, so an order with twelve components gives twelve rows. With the headers renamed, a row looks like this:

Column Example value What it holds
Order FA-2611-0042 The production order scanned first
Component IGU-4471902 The serial or batch number of a component that went into that order
Timestamp 2026-11-09 08:14:00 When the component was scanned

With Flip Primary and Secondary Column on Export on, the Component column comes first. Delimiter, encoding and header row can be set to match your import.

Fits well if…

  • Your production orders have a number that can be printed as a barcode on the order sheet.
  • The components you need to trace carry a label with their serial or batch number as a barcode.
  • Components are fitted at a few assembly stations where a phone can stay at hand.
  • Your ERP or your quality records take in a CSV or Excel file.
  • You want to know later which serial or batch numbers went into which order, without retyping labels.

Scan Your First Production Order

Scan one order sheet and a few component labels, then open the export. The free trial includes every feature.

Start Free Trial
7-Day Free Trial • iPhone, iPad & Android • Cancel Anytime