DATA PREPARATION GUIDE
Prepare your CSV
for production labels.
A spreadsheet can look correct while the exported values are wrong. Start with the expected file structure, preserve identifiers as text and check one representative order.
Updated · Current manufacturing CSV profile
1. Start with the sample structure
Download the manufacturing example CSV and keep its complete set of 31 column headings. The importer accepts those named columns in any order, but rejects missing, extra or duplicate headings.
Use UTF-8 text with comma-separated fields. Keep optional columns even when their values are blank. A product name containing a comma must be quoted; spreadsheet CSV export normally handles that quoting for you.
SmartFACT currently imports CSV rather than native Excel workbooks. Export the relevant sheet and check the resulting text file. Regional spreadsheet settings can change the delimiter, so verify that fields are separated by commas. See Microsoft’s guidance on CSV import and export.
The sample shows the complete shape
It includes source and job references, customer and destination fields, line and product details, and batch values. The worked CSV example explains how selected fields appear on the label.
2. Preserve product codes as text
A reference such as 000017 is an identifier. If a spreadsheet converts it to the number 17, the original value has already been changed before SmartFACT sees the file.
In Excel, import through Data → From Text/CSV and set identifier columns to Text in the transformation steps before loading. Check that an earlier automatic type-conversion step has not already removed zeros. If it has, return to the original source. Applying a display format afterwards cannot recover lost digits. Microsoft explains this in its leading zeros and large numbers guide.
Check internal product codes, customer identifiers, product identifiers and any GTIN values. A saved customer mapping resolves the customer product code separately; customer_sku is not an extra CSV column to add.
3. Check quantities, dates and decimals
Use plain values in the exported file. Currency signs, thousands separators and locale-specific date formats do not belong in these fields.
Scroll across to see the field formats
| Field | Example | Check |
|---|---|---|
quantity | 3 | A positive whole number, without decimal places or leading zeros. |
job_due_at | 2026-09-28T16:00:00Z | A UTC timestamp in this exact format. |
batch_manufactured_on | 2026-09-24 | A calendar date using year, month and day. |
product_length_mm | 120.00 | A non-negative value with two decimal places. |
product_net_weight_kg | 0.250 | A non-negative value with three decimal places. |
Leave a permitted optional value empty when it is unknown. Do not invent a date or product code to get past a validation error.
4. Keep an order’s identity consistent
Rows belonging to the same source, job and revision must agree on shared job, customer and destination values. Give each line in that order a distinct line_id.
Customer mappings use customer_id and product_id. A familiar customer name or a matching-looking internal SKU does not replace those keys. Check the identifiers against the saved mapping, particularly when moving data from another system.
An identical repeat import under the same configuration reuses its saved snapshot. Changed data needs a new source revision. A revised source does not grant another original print run: extra copies belong in the reprint workflow.
5. Review the result before printing
An administrator imports the file. The importer validates the complete CSV before saving its results; a malformed row is not silently skipped. Current file limits are 10 MB and 10,000 data rows, with further limits applied by the selected profile.
Importing does not print. Review the imported order, resolved customer code, selected layout, quantity and actual label preview. A required customer code that cannot be resolved holds the Acme label until corrected.
Once the data and preview are right, use the attended printing workflow on a qualified station. The file check and the physical label check answer different questions.
Before you import
- All 31 sample headings are present exactly once.
- The exported file uses UTF-8 and commas.
- Identifier text, including leading zeros, matches the original source.
- Quantities, timestamps, dates and decimals use the expected formats.
- Job fields agree across lines, and line identifiers are unique within the order.
- The customer and product identifiers match the intended configuration.