UK based — serving UK & international B2B sellersOne-off projects only — never a subscriptionAny catalogue size — no fixed upper limitLive editable Excel margin sheet includedFree custom eBay description template (eligible projects)eBay import into your own account included3–5 working days standard deliveryPlan confirmed in writing before work startsUK based — serving UK & international B2B sellersOne-off projects only — never a subscriptionAny catalogue size — no fixed upper limitLive editable Excel margin sheet includedFree custom eBay description template (eligible projects)eBay import into your own account included3–5 working days standard deliveryPlan confirmed in writing before work starts
CPLProCar Parts Listing

Guide · Catalogue data

Car parts product data cleansing, stage by stage

How a messy supplier spreadsheet becomes listing-ready catalogue data: brands, part numbers, barcodes, OE references, categories, fitment and pricing.

UK based · Updated August 2026

Why supplier data is never listing-ready

Supplier files are built for internal purchasing systems. They carry internal category codes, abbreviated descriptions, inconsistent brand spellings, mixed reference formats and price columns that mean different things in different rows.

Marketplaces need the opposite: strictly structured, consistently populated attribute data. Cleansing is the bridge between the two, and it is the single biggest determinant of whether a catalogue performs once live.

The cleansing stages

Each stage is applied as a repeatable rule set so the whole catalogue behaves the same way.

StageWhat happens
AuditRow counts, column meaning, gaps and duplicate detection
Brand normalisationOne canonical brand value per manufacturer
Reference validationMPN kept exact; EAN checked; OE references preserved
DeduplicationSuperseded and duplicated references resolved
Category mappingInternal codes mapped to marketplace automotive categories
Attribute buildCategory-required item specifics populated per part type
Fitment structuringCompatibility rows built from licensed or supplied data
Image handlingImages matched to SKUs; placeholders flagged for later swap
Pricing layerCost, rebate, net cost, margin and sell price in a live Excel sheet

What good automotive data looks like

The test is simple: could a buyer filter to their exact vehicle, find the part, cross-reference the OE number and be confident it fits — without contacting you first?

  • Every SKU has brand, MPN and product type populated.
  • Barcodes present wherever the supplier provides them.
  • OE cross-references retained and searchable, not discarded during import.
  • Fitment carries make, model, engine and year range — not model alone.
  • Titles built from one formula, so the catalogue reads as one professional range.
  • New-to-range items clearly handled, with placeholder images replaced once authorised images arrive.

Cleansing feeds your margin control

Clean data is what makes pricing decisions possible. Once cost, rebate and net cost are reliable per SKU, a live editable Excel margin sheet with rebate filters lets you set target margins and see sell prices update across the catalogue before anything goes live.

You supply the cost price files, rebate terms and target margins. The sheet remains yours to edit as supplier terms change.

How CPL PRO handles it

CPL PRO is a done-for-you automotive eBay listing and catalogue service — not software, SaaS, an AI tool or a self-service platform. You send your supplier or product data; we clean and structure the catalogue, build professional listings and import the agreed products into your own eBay account.

Projects are one-off and quoted per catalogue with no fixed upper size limit. Planning takes 1–2 working days and is confirmed in writing with our team, with typical delivery in 3–5 working days unless project size dictates otherwise, in which case we confirm timings up front.

Frequently asked questions

What is product data cleansing for car parts?

It is the process of turning supplier files into consistent, listing-ready records: one brand value per manufacturer, unmodified manufacturer part numbers, validated barcodes, preserved OE cross-references, mapped categories, resolved duplicates and structured vehicle fitment.

What data do I need to send?

Whatever you have — supplier price files, product lists, images, fitment files and rebate terms, in Excel or CSV. Cost price files, rebate terms and target margins are needed for the margin sheet.

What about TecDoc or licensed fitment data?

Vehicle compatibility work is produced from client-supplied or properly licensed data. We do not fabricate fitment, and we do not supply third-party licensed datasets you are not entitled to use.

Is my supplier data kept confidential?

Yes. Client catalogues, cost prices and supplier terms are handled as confidential commercial data and are never published as examples in identifiable form.