PIM for building materials and trade catalogues
Keep building product dimensions, pack sizes and technical documents consistent. Plan a PIM model that helps trade buyers compare the right materials.
- Published
- Last updated
Product information management (PIM) for building materials needs separate records for dimensional variants and sellable packs, plus technical documents tied to their exact application. Keep physical dimensions, coverage and order quantity in different fields. A customer buying one pack must see how many pieces arrive and which installation limits apply.
The catalogue model must also distinguish product facts from branch stock and trade-account prices. That separation lets you correct a supplier specification without overwriting the commercial terms used at checkout.
Model the product and the sellable pack
Model the product family, each dimensional variant and every sellable packaging level with stable identifiers. A family groups related products. A variant specifies the physical product, while a sales unit states what the customer orders.
Use an internal family ID and variant ID alongside the supplier’s product code. Give each orderable pack its own stock-keeping unit (SKU). Record the contained variant and pieces per pack. A pallet record needs its pack count and contained pack ID, whether the pallet is orderable or used only for transport.
GS1 Australia’s trade-item guidance explains that a Global Trade Item Number (GTIN) can identify products at different packaging levels. Preserve the supplier’s identifiers for each level. Don’t copy a board’s GTIN into its pack record as though both identify the same trade item.
A board record with separate size and coverage fields
A board’s marketed size, physical dimensions and installed cover can describe different measurements. Store a nominal size label separately from the manufacturer’s stated physical dimensions. Add measured actual dimensions only with their source and tolerance context. Never derive an actual size by subtracting a standard allowance from every board.
For a real example, James Hardie’s Hardie Plank specifications list the smooth 230 mm board under product code 400265. The record needs these distinct fields.
| Field | Value for the cited board | Meaning in the catalogue |
|---|---|---|
| Marketed size | 230 mm smooth weatherboard | Searchable product label |
| Stated dimensions | 4,200 mm long, 230 mm wide, 7.5 mm thick | Manufacturer dimensions, subject to tolerances |
| Actual measured size | Separate measurement if supplied | Never implied by the marketed label |
| Surface texture | Smooth | Variant selection |
| Effective width | 205 mm | Installed cover with the specified overlap |
| Effective coverage | 0.86 m² per board | Published rounded coverage |
| Pieces per full pack | 120 | Physical quantity supplied |
| Published full-pack coverage | 103.2 m² | Coverage on the manufacturer’s stated basis |
The external-cladding technical specification gives 25 mm overlap for this width. It also says effective cover is guidance based on maximum manufactured widths, with actual cover measured on site.
Keep that qualifier beside the coverage fields. The 230 mm width is not 230 mm of installed cover. A merchant selling individual lengths and full packs needs separate sales-unit records connected to the same board variant.
Organise technical and application data
Store material, grade, treatment and permitted use as defined fields backed by supplier documents. Keep internal or external use separate from surface finish. A colour or texture does not establish where a product can be installed.
For each variant, record the material specification and any applicable grade or treatment designation. Include the supplier’s application wording and restrictions. Use an explicit “not applicable” value where a field genuinely doesn’t apply, so reviewers can distinguish it from missing information.
Documents need their own records, with document type, issuer, revision and source URL. Add the covered product codes, applicable sizes, status and any expiry or review date. Document types can include installation guides, technical data sheets, safety data sheets and test reports. Certificates need the same precise product mapping.
The Australian Building Codes Board’s evidence-of-suitability handbook describes documentary evidence that identifies its subject, conditions and limitations. Build your document relationships to retain those details. A stored certificate or a completed catalogue field does not establish suitability for every building application.
Attach a document to a family only when its scope covers every relevant variant. If a report applies to one thickness or system assembly, link it to that selection. Keep superseded versions available internally and remove them from the current-document export.
Assign a person to approve technical changes before they reach a channel. Use the guide to product data governance to define who resolves conflicting supplier files and who approves application claims.
Validate units and supplier claims
Validate both the measurement unit and what that measurement describes before accepting a supplier import. A value of 120 might mean boards per pack, millimetres of width or packs on a pallet. The number alone cannot tell you which field it belongs in.
Use one storage unit per dimension and preserve the supplier’s original value for traceability. Convert millimetres to metres by dividing by 1,000. For a hypothetical rectangular sheet measuring 2,400 by 1,200 mm, gross area is 2.4 × 1.2 = 2.88 m². Ten sheets have 28.8 m² of gross area before cuts, overlaps or waste.
Keep gross area separate from effective installed coverage. For a hypothetical solid rectangular board, 2.4 m × 0.09 m × 0.019 m gives 0.004104 m³. Profiled or hollow products need their own supported volume basis. Bulk material sold by cubic metre also needs a sales-unit definition independent of its delivery vehicle.
Create validation rules that send faulty records to a named reviewer.
- Reject zero or negative physical dimensions and non-numeric measurement values.
- Flag dimensions outside the product family’s documented ranges, including likely metre-to-millimetre import errors.
- Compare pack coverage with piece coverage and piece count using a stated rounding tolerance.
- Stop a dimension value from entering a quantity field, or a pack quantity from entering a unit field.
- Flag expired, withdrawn or superseded documents before channel export.
- Hold application claims that have no traceable supplier document or extend beyond its stated scope.
Incorrect: label the hypothetical ten-sheet pack “2.88 m² per pack”. Correct: store 2.88 m² per sheet and 28.8 m² gross area per ten-sheet pack. Installation losses remain a separate estimate with explicit assumptions.
Keep transactional information in the right system
Keep approved specifications in the PIM and obtain stock and commercial terms from their operational systems. Branch stock changes independently of a product’s dimensions. Trade-account pricing depends on the customer and order context.
| Information | Authoritative system | How the storefront uses it |
|---|---|---|
| Dimensions, finish and technical documents | PIM | Renders approved product content |
| Branch stock and reservations | Inventory or enterprise resource planning system | Shows availability for the selected branch |
| Account price and quantity breaks | Pricing or account system | Quotes for the signed-in customer |
| Minimum order and order increments | Order-management system | Validates the basket quantity |
| Delivery area and service availability | Fulfilment system | Checks the destination and requested service |
Join these records using the exact sellable SKU and packaging level. The storefront can then show one pack’s contents beside its account price and branch availability. Keep the PIM’s physical pack quantity distinct from a commercial minimum order of two packs.
Define what happens when a source fails. For example, keep approved dimensions visible during a stock-service failure, but mark availability unavailable. Don’t substitute an old catalogue stock value for a live reservation check.
Answer trade buying questions
Map trade buying questions to explicit fields and document relationships so the answer preserves the product’s limits. Sheet-coverage questions need dimensions and the relevant coverage basis. “What arrives if I order one?” needs the sales unit and its contained quantity.
Accessory questions need an approved relationship between product codes, with conditions such as size or substrate. A shared category name is insufficient. Finish questions need both the surface texture and any required site-finishing instruction.
Consider this hypothetical comparison of two sheet records. The application labels are example supplier restrictions, not claims about real products.
| Buyer question | Sheet A record | Sheet B record | Answer rule |
|---|---|---|---|
| What is the gross area? | 2,400 × 1,200 mm, 2.88 m² | 3,000 × 1,200 mm, 3.6 m² | State per-sheet area and exclude waste |
| What is the permitted application? | Internal dry-area lining only | External wall cladding under its installation guide | Preserve each limit beside the comparison |
| Which accessories fit? | Approved fixing list for A | Approved fixing list for B | Use the relevant documented relationship |
| What finish is supplied? | Unfinished surface | Factory-primed surface | Keep required final coating instructions visible |
| How many sheets arrive? | One sheet per order unit | Ten sheets per order unit | Compare supplied quantities before prices |
A larger sheet is not automatically an acceptable substitute. Route questions about structural adequacy or an installation outside the documented scope to qualified technical staff. Keep the selected product code and installation document with that enquiry so the person receives the same facts the buyer saw.
Test the model before selecting a PIM
Test a small catalogue sample against written outcomes before choosing a PIM. Include a sheet product, a bulk material sold by volume and a family with several sizes. Add a pack variation and a document that covers only some variants.
Run the same sample through each candidate system in this order.
- Import the supplier file. Confirm each size becomes the right variant and each pack retains its contained product and quantity. A repeat import must update those records without creating duplicates.
- Convert the measurement units. Confirm the hypothetical sheet exports as 2.88 m² per sheet and 28.8 m² per ten-sheet pack. Introduce a mistaken unit and confirm it enters the review queue.
- Replace a technical document. Confirm the new revision reaches only the covered variants. The old revision must leave the public export while remaining traceable internally.
- Export to a test channel. Confirm its product page shows the correct finish and pack contents, with working document links. Combine it with test stock and account prices using the same sellable SKU.
- Ask the buying questions from the comparison. Confirm the answers retain application restrictions and send out-of-scope installation questions to staff.
Choose the PIM that preserves those relationships through import, correction and export. Keep the sample and its expected results as your acceptance test when a supplier changes its file format or pack configuration.
Give your store its own shopping agent
Customers ask in their own words. Your agent finds, compares and checks out from your catalogue, right on your site.