# The customer part number mapping workbook

A customer's part number only helps if it points to the right catalogue item and selling unit. Use this workbook to find the gaps and give each one an owner.

Updated 15 October 2026 . 5 min read . Alexey Shurov

## The short answer

Before order entry can be automated, each customer code needs a confirmed link to your catalogue item, its selling unit and the evidence behind that choice. The customer account belongs in that link because different customers can use the same code. Fill the blank sheet from recent orders, then mark anything that still needs a decision. Give catalogue changes to a catalogue owner and customer code changes to an account owner. An unresolved match stays with the order team.

### 1. Choose one customer and collect the evidence

Open recent orders beside the current catalogue and the customer's agreed product list. Include corrected orders and unfamiliar descriptions. Copy customer codes exactly, including leading zeroes. Keep codes as text in the spreadsheet. Save a reference to the source document so another person can check the choice without searching a mailbox. A previous order is evidence to examine, not automatic approval.

### 2. Fill the mapping sheet using the dictionary

Use one row for each customer code and agreed ordering unit. The field dictionary shows what each column must contain. Record the conversion explicitly when the customer orders boxes but the system records individual pieces. Check the box size against an agreed source. Keep the original description even after a match is approved. It may reveal a later change in size or material.

### 3. Give changes an owner and an approver

The account owner confirms what the customer means. The catalogue owner confirms the internal item, selling unit and whether it is still available. A nominated order supervisor approves the complete link before use. Put a person's name and approval status in the sheet. Nominate cover for absences. Keep the earlier row in a change record with who changed it, when and why.

### 4. Test the unclear matches before using the links

Use the made up cases to practise the stop rules, then try your own difficult orders. A similar description can suggest candidates but cannot settle an unknown unit or product revision. Send the order line and the missing fact to the named owner. Pause an approved link when the description, pack size or customer instructions change. Review it again before allowing another automatic match.

## The blank mapping sheet

Enter one customer code and ordering unit per row, using the dictionary to record evidence and approval.

| Customer account | Customer item | Customer description | Catalogue item | Order unit and conversion | Evidence | Approval and owner | Review date |
|---|---|---|---|---|---|---|---|
|  |  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |  |

[Download this sheet as a file for Excel](data:text/csv;charset=utf-8,%EF%BB%BFCustomer%20account%2CCustomer%20item%2CCustomer%20description%2CCatalogue%20item%2COrder%20unit%20and%20conversion%2CEvidence%2CApproval%20and%20owner%2CReview%20date%0D%0A%2C%2C%2C%2C%2C%2C%2C%0D%0A%2C%2C%2C%2C%2C%2C%2C%0D%0A%2C%2C%2C%2C%2C%2C%2C%0D%0A)

## The field dictionary with made up values

**Made up example.** Every row here is made up to show the method, including the sample values and approval evidence.

| Field | Meaning | Sample value | Who confirms | Stop rule | Review trigger |
|---|---|---|---|---|---|
| Customer account | Account in the order system | Customer A account C001 | Account owner | Account missing or disputed | Account changes |
| Customer item | Customer code kept as text | 00127 | Account owner | Code has lost leading zeroes | Customer changes its code list |
| Customer description | Original wording from agreed list | M8 zinc washer box of 100 | Account owner | Order wording contradicts agreed item | Size or material changes |
| Catalogue item | Exact active internal item code | W008Z | Catalogue owner | Item is retired or has two candidates | Catalogue revision |
| Order unit and conversion | How ordered quantity becomes system quantity | 1 box equals 100 each in the order system | Catalogue owner | Pack size has no agreed evidence | Supplier changes pack size |
| Evidence | Reference to confirmed product and unit | Customer A agreed list dated 2026-10-05 row 7 | Account owner | Source missing or contradicted | New customer list arrives |
| Approval and owner | Status plus named approver and maintainer | Approved by Person A on 2026-10-12; maintained by Person B | Order supervisor | Pending approval or no named cover | Any linked field changes |
| Review date | Next review under your agreed review schedule | 2026-11-12 | Order supervisor | Review overdue under your agreed rule | Due date or earlier change notification |

[Download this sheet as a file for Excel](data:text/csv;charset=utf-8,%EF%BB%BFField%2CMeaning%2CSample%20value%2CWho%20confirms%2CStop%20rule%2CReview%20trigger%0D%0ACustomer%20account%2CAccount%20in%20the%20order%20system%2CCustomer%20A%20account%20C001%2CAccount%20owner%2CAccount%20missing%20or%20disputed%2CAccount%20changes%0D%0ACustomer%20item%2CCustomer%20code%20kept%20as%20text%2C00127%2CAccount%20owner%2CCode%20has%20lost%20leading%20zeroes%2CCustomer%20changes%20its%20code%20list%0D%0ACustomer%20description%2COriginal%20wording%20from%20agreed%20list%2CM8%20zinc%20washer%20box%20of%20100%2CAccount%20owner%2COrder%20wording%20contradicts%20agreed%20item%2CSize%20or%20material%20changes%0D%0ACatalogue%20item%2CExact%20active%20internal%20item%20code%2CW008Z%2CCatalogue%20owner%2CItem%20is%20retired%20or%20has%20two%20candidates%2CCatalogue%20revision%0D%0AOrder%20unit%20and%20conversion%2CHow%20ordered%20quantity%20becomes%20system%20quantity%2C1%20box%20equals%20100%20each%20in%20the%20order%20system%2CCatalogue%20owner%2CPack%20size%20has%20no%20agreed%20evidence%2CSupplier%20changes%20pack%20size%0D%0AEvidence%2CReference%20to%20confirmed%20product%20and%20unit%2CCustomer%20A%20agreed%20list%20dated%202026-10-05%20row%207%2CAccount%20owner%2CSource%20missing%20or%20contradicted%2CNew%20customer%20list%20arrives%0D%0AApproval%20and%20owner%2CStatus%20plus%20named%20approver%20and%20maintainer%2CApproved%20by%20Person%20A%20on%202026-10-12%3B%20maintained%20by%20Person%20B%2COrder%20supervisor%2CPending%20approval%20or%20no%20named%20cover%2CAny%20linked%20field%20changes%0D%0AReview%20date%2CNext%20review%20under%20your%20agreed%20review%20schedule%2C2026-11-12%2COrder%20supervisor%2CReview%20overdue%20under%20your%20agreed%20rule%2CDue%20date%20or%20earlier%20change%20notification%0D%0A)

## Unclear matches to work through

**Made up example.** Every row here is made up to show the method.

| Customer | Customer item | Order text | Candidate items | Missing fact | Decision | Who checks | Evidence needed |
|---|---|---|---|---|---|---|---|
| Customer A | 00127 | M8 washer | W008Z or W008S | Zinc or stainless steel | Hold line | Account owner | Customer confirms material |
| Customer A | B200 | Bolts box | B200 pack of 50 or 100 | Pieces per box | Hold line | Catalogue owner | Agreed pack size |
| Customer B | 00127 | M6 nut | N006 | Customer B link is unapproved | Do not reuse Customer A link | Account owner | Customer B product list |
| Customer A | H010 | Hose old type | H010 retired; H011 suggested | Substitute acceptance | Hold line | Account owner | Customer accepts substitute |
| Customer C | No code supplied | Seal standard | S020 or S030 | Seal dimensions | Hold line | Order team | Drawing or confirmed dimensions |
| Customer A | P040 | Plate revision C | P040 revision B | Approved revision C item | Pause existing link | Catalogue owner | Current drawing and item approval |

[Download this sheet as a file for Excel](data:text/csv;charset=utf-8,%EF%BB%BFCustomer%2CCustomer%20item%2COrder%20text%2CCandidate%20items%2CMissing%20fact%2CDecision%2CWho%20checks%2CEvidence%20needed%0D%0ACustomer%20A%2C00127%2CM8%20washer%2CW008Z%20or%20W008S%2CZinc%20or%20stainless%20steel%2CHold%20line%2CAccount%20owner%2CCustomer%20confirms%20material%0D%0ACustomer%20A%2CB200%2CBolts%20box%2CB200%20pack%20of%2050%20or%20100%2CPieces%20per%20box%2CHold%20line%2CCatalogue%20owner%2CAgreed%20pack%20size%0D%0ACustomer%20B%2C00127%2CM6%20nut%2CN006%2CCustomer%20B%20link%20is%20unapproved%2CDo%20not%20reuse%20Customer%20A%20link%2CAccount%20owner%2CCustomer%20B%20product%20list%0D%0ACustomer%20A%2CH010%2CHose%20old%20type%2CH010%20retired%3B%20H011%20suggested%2CSubstitute%20acceptance%2CHold%20line%2CAccount%20owner%2CCustomer%20accepts%20substitute%0D%0ACustomer%20C%2CNo%20code%20supplied%2CSeal%20standard%2CS020%20or%20S030%2CSeal%20dimensions%2CHold%20line%2COrder%20team%2CDrawing%20or%20confirmed%20dimensions%0D%0ACustomer%20A%2CP040%2CPlate%20revision%20C%2CP040%20revision%20B%2CApproved%20revision%20C%20item%2CPause%20existing%20link%2CCatalogue%20owner%2CCurrent%20drawing%20and%20item%20approval%0D%0A)

## What can change the answer

A supplier can change a pack size while keeping a familiar description. A customer can reuse an old code for a revised drawing. Decide how these notices reach the catalogue owner. Record a review date, but do not wait for it when new evidence conflicts with the sheet. The change itself is a reason to stop using the link.

## When this is the wrong tool

This workbook is for repeat items with a catalogue match. It cannot define a new engineered part from an incomplete drawing. If every order needs design work, record the missing specification and route it to an engineer. Credit checks, customer prices, stock decisions and delivery promises also remain separate checks even when the item match is clear.

## What to do with the result

Count approved links separately from lines awaiting evidence, unit checks or catalogue repairs. Assign each open line to a person and a review date. Start any order entry test with the approved subset and compare its output with a checked order. Keep unclear lines visible in a review queue. A complete workbook supports item matching, but does not by itself authorise orders to be placed.[

Client result . Distribution

10 → 1

About 90 percent less manual work, over 95 percent line accuracy

People needed for order entry at a wholesale distributor, client-confirmed.

Read how the system works](https://shurco.ai/solutions/sales-order-entry-automation/)

## Common questions

### Can two customers use the same part number?

Yes. Store the customer account with the customer part number and ordering unit. Look up the combination, not the code alone. If the account cannot be confirmed, hold the order until someone identifies the customer and checks the right link.

### Who should keep the workbook up to date?

Give customer wording and codes to the account owner, and internal items and units to the catalogue owner. Name an order supervisor who approves the full link. Record named cover so an absence does not leave unresolved orders without a decision.

### Can a description be enough to approve a match?

Only when the description identifies the item and unit without unresolved alternatives, and an owner confirms the evidence. Similar wording is not enough. Keep the original text and the approval record so later orders can be checked for changes.

### What should happen to a retired catalogue item?

Pause its approved links and ask the catalogue owner to identify any replacement. The account owner must confirm whether the customer accepts that replacement. Do not silently transfer a customer code to a new item because its description looks close.

## Useful next[Free toolWhat to automate first, a scoring toolPick a task your team repeats every week and answer five quick questions. You get a plain answer on whether it is worth automating, what helps and what to watch. Score up to four tasks and it tells you where to start, and you can keep the result as a private plan page.](https://shurco.ai/tools/what-to-automate-first/)[PlaybookHow to build a business case for AI automationA finance director does not approve AI. They approve a measured task, an honest cost and a way to tell whether it worked. Here is the one page that gets a yes, and the numbers to put on it.](https://shurco.ai/guides/business-case-for-ai-automation/)

## More guides[GuideAI agent pricing in 2026, what vendors actually chargeVendors now charge for agents by the conversation, the outcome, the action or the credit. Here are the published prices, what each unit really means, and how to compare them on your own workload.](https://shurco.ai/guides/ai-agent-pricing/)[ServiceA monthly test for your customer facing AI assistantOnce a month, I ask your website or phone assistant ordinary customer questions. You get what it got wrong, its exact words and what to change. The first test is free.](https://shurco.ai/guides/ai-assistant-monthly-test/)[PlaybookHow to automate daily site reports across many sitesThe report takes days because the data lives in many places and someone has to chase it. Here is how to gather it in parallel, catch the numbers that disagree and produce a report a manager can check.](https://shurco.ai/guides/automate-daily-site-reports/)[PlaybookHow to automate quoting for a manufacturer or distributorSlow quotes lose work. There are three quite different kinds of quoting automation, and most buying mistakes come from picking the wrong kind. Here is how to tell which one your quotes need.](https://shurco.ai/guides/automate-quoting-for-manufacturers/)[PlaybookHow to automate sales order entry in Business CentralCustomers email orders as PDFs, spreadsheets and free text, and someone keys each line into Business Central. Here are the three ways to take that work away, with what Microsoft's own agent does and where it stops.](https://shurco.ai/guides/automate-sales-order-entry-business-central/)[PlaybookHow to automate timesheet processing for payrollTimesheets arrive as spreadsheets, PDFs, photos and scans, and payroll has a deadline that does not move. This is the order to automate it in, and the checks that stop a wrong payslip.](https://shurco.ai/guides/automate-timesheet-processing-for-payroll/)

## Check your own customer orders in two minutes

Five questions about how the work reaches you and how it is checked. You get a plain answer on whether it is worth automating, with no sign up. [Start with question one.](https://shurco.ai/tools/what-to-automate-first/?k=orders) Or [tell me about the work](https://shurco.ai/#contact) and I will reply myself.

Web version https://shurco.ai/guides/customer-part-number-mapping-workbook/