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.

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.

FieldValue for the cited boardMeaning in the catalogue
Marketed size230 mm smooth weatherboardSearchable product label
Stated dimensions4,200 mm long, 230 mm wide, 7.5 mm thickManufacturer dimensions, subject to tolerances
Actual measured sizeSeparate measurement if suppliedNever implied by the marketed label
Surface textureSmoothVariant selection
Effective width205 mmInstalled cover with the specified overlap
Effective coverage0.86 m² per boardPublished rounded coverage
Pieces per full pack120Physical quantity supplied
Published full-pack coverage103.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.

InformationAuthoritative systemHow the storefront uses it
Dimensions, finish and technical documentsPIMRenders approved product content
Branch stock and reservationsInventory or enterprise resource planning systemShows availability for the selected branch
Account price and quantity breaksPricing or account systemQuotes for the signed-in customer
Minimum order and order incrementsOrder-management systemValidates the basket quantity
Delivery area and service availabilityFulfilment systemChecks 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 questionSheet A recordSheet B recordAnswer 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 onlyExternal wall cladding under its installation guidePreserve each limit beside the comparison
Which accessories fit?Approved fixing list for AApproved fixing list for BUse the relevant documented relationship
What finish is supplied?Unfinished surfaceFactory-primed surfaceKeep required final coating instructions visible
How many sheets arrive?One sheet per order unitTen sheets per order unitCompare 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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.

See it in actionFree trial · Simple setup