GUIDES
Config sheet guides
Reference tables, code lists and shop data in manufacturing: what they are, how ConfigSheets in SmartFACT Data keeps them, and how they reach the SmartFACT products or your own tool.
Config sheets
What is a config sheet?
A config sheet is a table of reference values, such as product option codes or customer codes, that other systems look up. How they go wrong, and how to keep them right.
CONFIG SHEETSUse cases
Where manufacturers use config sheets: customer codes on labels, supplier option codes, EDI, kit inputs, shop SKUs and configuration behind your own tool.
Two ways to use it
Data into SmartFACT
Factory data reaches SmartFACT through each product’s own import or through SmartFACT Data. Which route suits which data, and how other systems are connected.
TWO WAYS TO USE ITEmbed in your own tool
Use ConfigSheets inside your own configurator, ERP add-on or platform: maintain option sets and parameter tables at scale, and read reviewed versions through GraphQL.
How SmartFACT Data works
Versioned reference tables
A versioned reference table keeps every saved version of a lookup table. See how SmartFACT Data checks each change, refuses stale edits and keeps every version.
HOW SMARTFACT DATA WORKSReviewed file transfers
A reviewed file transfer hands data to another system as a file the receiver checks first. See how SmartFACT Data prepares LabelRules and KitProof files from saved versions.
HOW SMARTFACT DATA WORKSWooCommerce orders into StoresFlow
A shop connection turns each WooCommerce order into the stock it uses. See how SmartFACT Data maps shop SKUs exactly and hands orders to StoresFlow for stock.
START WITH ONE TABLE
Which data do you need to bring in?
Tell us which data you need to bring in, where it is held today and which SmartFACT products need it. We agree a focused start with you.
Please describe the data without attaching confidential values.
THE SMARTFACT SUITE
One suite for the factory floor.
SmartFACT Data is part of SmartFACT, a set of focused services and free tools for manufacturers. People sign in through SmartFACT Accounts, with two-factor checks for the roles that approve and activate.
Other SmartFACT services print labels, check kits, guide work steps and keep stock. SmartFACT Data keeps the reference values and shop orders they rely on, and each of them reviews what it receives.
ConfigSheets also works outside the suite: embed it in your own tool and read reviewed sheets through its GraphQL API.
Explore SmartFACT