Skip to main content

Item Master: The Fields a Wholesaler's Article Master Needs

What an ERP item master holds, the article master fields a wholesaler needs per unit and packaging level, and who maintains them next to a PIM.

Diego Nijboer

Item Master: The Fields a Wholesaler's Article Master Needs

An item master is the central record an ERP keeps for every article a business buys, stocks or sells. Each record sits under one item number and holds that article's identifiers, units of measure, packaging levels, weights and dimensions, purchasing and sales parameters and status. Purchase orders, goods receipts, picks, invoices and price lists all point to it, so one wrong field travels into every one of those documents.

German teams call it the Artikelstamm and its contents Artikelstammdaten; keeping them correct is Stammdatenpflege. Dutch teams say artikelstam. For a wholesaler, the item master is the operational half of product data. The other half, the content customers read (descriptions, features, images, classifications for webshops and catalog files), often lives in a PIM. The two systems complement each other, and they work best when every field has exactly one owner.

What belongs in the item master and what sits beside it

Microsoft's documentation for Dynamics 365 Supply Chain Management defines a product by its number, name and description plus categories, attributes, images, units of measure with their conversions and translations, and notes that the definition can also be imported from PLM, PDM or PIM systems (Microsoft Learn). The same page calls keeping product data accurate "a critical business process on its own". That is the job most wholesalers underestimate.

Three kinds of data are often mixed up with the item master, but most ERPs keep them in their own records:

  • Stock. The item master defines the article. Inventory records hold the quantity per warehouse, location and batch.
  • Supplier relations. In SAP, the purchasing info record holds the data on the relationship between a material and a supplier: the supplier's material number, prices and conditions, the planned delivery time and delivery tolerances (SAP Learning). German SAP users know it as the Einkaufsinfosatz. Other ERPs use a vendor item table or a supplier price list for the same job.
  • Customer prices. Contract prices, customer group discounts and volume tiers usually live in price lists or condition records, not on the item itself.

The split matters as soon as you design fields. A wholesaler that buys the same cable tie from two suppliers needs two supplier article numbers, two purchase prices and two lead times for one item number. Squeezing them into the item record as "supplier number 1" and "supplier number 2" works until the third supplier arrives, and then the purchase price on the item no longer says which supplier it came from.

Article master fields for a wholesaler, group by group

The table below lists the field groups a technical wholesaler typically maintains. The example is an illustrative black cable tie, 4.8 x 300 mm, sold per bag of 100 and bought per case of 20 bags. The values show the shape of the data, not a standard, and the GTINs use GS1's demonstration number.

Item master fields for one cable tie, by field group

IdentificationItem numberCT-4830-BKERPEvery order line and invoice refers to it, so a reused number mixes two articles' history
IdentificationGTIN of the sales unit9506000134352 (bag of 100)ERP, checked in the PIMA wrong check digit fails at the scanner and in marketplace listings
ManufacturerBrand and manufacturer part numberExample Fixings, CT4830BERP or PIMInstallers search by part number; spelling variants hide duplicates
Supplier relationSupplier article number, purchase price, lead timeA-77120, USD 9.10 per bag, 10 daysERP purchasing recordOne item can have several suppliers, each with its own number
UnitsBase unit, sales unit, purchase unit, conversionsPiece; bag = 100 pieces; case = 20 bagsERPA case price read as a piece price is off by a factor of 2,000
Packaging levelsGTIN, content and dimensions per levelCase: 19506000134359, 20 bags, 40 x 30 x 25 cmERPSlotting, freight quotes and pallet plans use these values
LogisticsGross weight and dimensions with unitsBag: 0.26 kg, 30 x 12 x 3 cmERP or PIMMixed millimeters and centimeters break freight and feeds
ClassificationETIM class and features, internal product groupETIM class for cable ties; group FIX-CTPIMTechnical customers filter and compare on these features
Trade and complianceHS code, country of origin, dangerous goods flagHeading 3926, CN, noERPCustoms declarations and carrier bookings read them
PricesList price, purchase price, VAT groupUSD 12.40 per bagERPPrice lists and margin reports start here
LifecycleStatus and successor itemActive; successor CT-4830-BK2ERP, mirrored in the PIMDiscontinued items stay orderable online when the status is not passed on
Showing 11 of 11 rows
Illustrative values: notice how many fields depend on the unit or packaging level they describe.

Two notes on the example. The HS code shown is the four-digit heading for other articles of plastics (HS 3926); your customs broker confirms the full code for your own article. Classification works the same way at the level above: our ETIM classification walkthrough shows how a supplier catalog gets its ETIM classes and features.

Units and packaging levels: where item master errors start

Most item master errors in wholesale are unit errors. The supplier quotes per case, the webshop sells per bag, the installer counts pieces. The item master therefore holds one base unit, usually the smallest unit you count in stock, and a conversion factor for every other unit used in buying, selling and storing. Our unit of measure guide goes deeper into unit codes and conversions.

A unit code set with conversion factors: the base unit has factor 1 and every other unit states how many base units it equals.

Packaging levels bring their own GTINs. GS1's GTIN Management Standard assigns a unique GTIN at every level of the packaging hierarchy above the base unit, and a change in the number of items in a case, or of cases on a predefined pallet, requires a new GTIN (GS1). So when a supplier moves from 20 to 25 bags per case, the case gets a new GTIN, and your item master needs a new packaging level rather than an edited quantity on the old one.

Three unit failures show up again and again in supplier files:

  • Case price on the piece unit. The supplier lists USD 182.00 per case of 2,000 pieces. Loaded against the piece, every order line is wrong by a factor of 2,000.
  • GTIN on the wrong level. The case GTIN 19506000134359 typed into the field for the bag means the scanner at the trade counter matches nothing, and the bag's own GTIN 9506000134352 is missing from every feed.
  • Dimensions without a unit. One supplier sends millimeters, another centimeters, a third inches. A bag of 300 x 120 x 30 read as centimeters becomes three meters long in your freight calculation.

From supplier price file to orderable item in six steps

New items rarely start in the ERP. They start as rows in a supplier's price file or new-products sheet. A repeatable intake keeps the item master clean from day one:

  1. Match before you create. Look up each row's GTIN and manufacturer part number in the existing item master. A match means a new supplier relation for an existing item, not a new item.
  2. Fix the units first. Read which unit the supplier's price refers to (piece, bag, case) and which unit its GTIN identifies. Write both down per row before importing anything.
  3. Create the item from the product group template. Issue the item number, set the base unit and add every sales and purchase unit with its conversion factor.
  4. Add the packaging levels. One level per GTIN in the file, each with content, gross weight and dimensions in your house units.
  5. Attach the supplier relation. Supplier article number, purchase price per purchase unit, minimum order quantity and lead time go on the relation, not on the item.
  6. Release it. Set the status to active only when the required fields for that product group are filled, so the item cannot be ordered or published half-finished.

Steps 1 and 2 catch most problems. A supplier file that mixes piece and case GTINs in one column, or prices some rows per 100, is far cheaper to correct before import than after the first wrong delivery.

ERP item master and PIM: who writes which field

Our PIM vs ERP guide compares the systems. At field level the split is usually simple. The ERP owns what makes a transaction correct: item number, units and conversions, packaging levels, supplier relations, purchase and list prices, stock and status. The PIM owns what makes an article findable and understandable outside the company: marketing name, descriptions, classification features, images, documents, translations and channel-specific content.

A handful of fields sit on the border. GTIN, brand, manufacturer part number, weight and dimensions are entered in the ERP when the item is created, but every channel needs and checks them. Let them flow from the ERP to the PIM, and when the PIM finds an error, correct it at the source instead of fixing it twice. Pick one writer per field and make the other system read-only for it.

Who writes which item data

Loading diagram
The ERP creates the item and owns units, prices and supplier data; the PIM adds content and sends corrections back to the source.

Write the split down per field, with a named role rather than a department, and say who checks each field after it is entered. A table like this one, agreed once with purchasing, the warehouse and e-business, settles most later arguments about who should have fixed what.

Field ownership in a wholesale item master

Item number and statusERPMaster data teamPurchasing and sales
Base unit and conversion factorsERPMaster data teamWarehouse at goods receipt
Packaging levels and their GTINsERPMaster data teamWarehouse at goods receipt
Supplier article number, purchase price, lead timeERP supplier relationPurchasingFinance through price variances on invoices
List price and price listsERPPricing or sales managementSales
Sales unit GTIN, brand, manufacturer part numberERPMaster data teamPIM checks before every channel
Weight and dimensionsERPMaster data team, measured by the warehousePIM and carrier invoices
Descriptions, images, documents, translationsPIMProduct content teamCategory manager
ETIM class and featuresPIMProduct content teamCustomers' catalog imports
Channel assortment and channel contentPIME-businessChannel error reports
Showing 10 of 10 rows
An example split for a technical wholesaler: adapt the roles to your team, but keep one system of record per field.

Code lists such as units, countries and product groups are reference data. They change rarely, but when they do, every item that uses them is affected. The reference data guide explains how to keep those lists apart from the items that use them.

Change control for fields that change what an order means

Most fields can change any day: a better description or a new image breaks nothing. A handful change what an order line means: base unit, conversion factors, case quantity, GTIN, purchase unit and status. Edit one of those on a live item and open orders, stock and price lists suddenly describe something else. Changes to them go through a short routine:

  1. Request with a reason and a date. Item, field, old and new value, and the date it applies, usually the day the supplier's new pack arrives.
  2. Check what is open. Open purchase and sales orders, stock on hand and price lists in the old unit or pack. A conversion change with stock on hand needs a stock correction on the same day.
  3. Decide: edit or new record. A typo is an edit. A changed case quantity is a new packaging level with a new GTIN, per the GS1 rule above. A different article is a new item number with a successor link.
  4. Approve by the field owner. The master data team for units and packaging, purchasing for supplier data.
  5. Apply on the date and pass it on. ERP first, then the PIM, webshop, feeds and customers' catalog files on their next run.
  6. Log it. Old value, new value, date and approver. When a customer disputes an invoice three months later, the log is the answer.

A Stammdatenpflege routine for a small master data team

Item masters decay through small edits: a buyer who overwrites a price, a new item copied from an old one with the wrong case quantity, a discontinued article nobody blocks. The routine below suits a team of one to three people who own item creation and maintenance next to their other work.

Item master maintenance checks

0 of 8 done0%

Most of these checks fail first in a supplier file, before anything reaches the item master. The supplier onboarding guide covers the data delivery spec and first-file triage for a new supplier. If one supplier's delivery keeps causing them, the free data readiness check has a person go through one of your supplier files with you on a call.

Lifecycle statuses that stop wrong orders

A status field only helps when everyone agrees what each value allows. Many wholesalers work with four: in preparation (visible to purchasing only), active (orderable and published), phase-out (sell remaining stock, no new purchase orders) and blocked (no sales, no purchasing, kept for history). Add a successor item to phase-out and blocked items, so sales staff and the webshop can point customers to the replacement instead of a dead end.

Item master vocabulary in English, German and Dutch

Wholesalers in the Netherlands, Belgium and Germany often work with suppliers, ERP consultants and software in all three languages. These are the terms you will meet; the German ones marked SAP are the names SAP itself uses in its German documentation, for example in its glossary.

  • Item master: Artikelstamm (German), artikelstam (Dutch)
  • Item master data: Artikelstammdaten, artikelstamgegevens
  • Master data maintenance: Stammdatenpflege, stamgegevensbeheer
  • Base unit of measure: Basismengeneinheit (SAP), basiseenheid
  • Purchase order unit: Bestellmengeneinheit (SAP), besteleenheid
  • Purchasing info record: Einkaufsinfosatz (SAP); Dutch has no fixed term, so describe it as inkoopgegevens per leverancier
  • Packaging hierarchy: Verpackungshierarchie, verpakkingshiërarchie

Where the ERP item master ends and WISEPIM picks up

WISEPIM is a PIM, not an ERP, and it does not replace your item master. Its product record covers the item fields that channels need: GTIN with the check digit enforced when you save, brand or manufacturer, manufacturer part number, UPC, cost, weight and dimensions with explicit units, HS code and country of origin. Units are code sets with conversion factors, ETIM classes are assigned per product family in the optional Classification module, and products can follow lifecycle stages you define.

Lifecycle stages in WISEPIM track content work such as enrichment and review; the commercial item status stays in the ERP.

Several item master jobs stay with the ERP on purpose. WISEPIM has one free-text supplier field per product: no list of suppliers per product, no dedicated supplier article number field and no packaging-level records. Pack size or order unit for a BMEcat export can be stored as attributes. The practical setup is the ERP for identifiers, units, packaging and supplier relations, and WISEPIM for content, classification and the checks on top, such as a Quality Guard rule that keeps products without a valid GTIN out of a channel. See how that works for distributors on the PIM for wholesalers page.

Diego Nijboer

CTO and Co-Founder at WISEPIM, building AI-powered solutions that transform product data management for e-commerce businesses. Over 10 years of experience solving complex technical challenges in e-commerce and PIM systems.

Frequently asked questions

Still have questions?

Can't find the answer you're looking for? Please get in touch with our team.

Contact Support

They are the same concept under different names. SAP calls the record a material master; Microsoft Dynamics, Infor and most wholesale ERPs call it an item, article or product. In every case it is the one record per article that holds identifiers, units, packaging, logistic data and status, and that orders, receipts and invoices refer to.

An item master file is an export or import of item master records, usually a CSV or Excel sheet with one row per item and one column per field. Wholesalers use it to migrate between ERPs, to onboard a supplier's range in bulk and to audit fields such as GTIN, weight or classification across the whole catalog.

Store them on the relationship between the item and the supplier, not as a field on the item. One item can come from several suppliers, each with its own article number, purchase price and lead time. SAP keeps this in the purchasing info record; other ERPs use a vendor item table or supplier price list.

Give every field one owner. Purchasing or a master data team usually owns item creation, units, packaging and supplier data in the ERP. Product content managers own descriptions, features, images and classification in the PIM. Shared fields such as GTIN and weight get one writer, and the other system only reads them.

Stammdatenpflege is the German term for maintaining master data: creating, correcting, completing and retiring master records such as items, customers and suppliers. For articles it covers new item creation, unit and packaging changes, price file loads, duplicate checks and blocking discontinued items, ideally as a fixed routine with clear owners.

Keep exploring

Hand-picked next steps to go deeper.

Better product data, better results.Get more sales.

4.7