From RFQ to PIM: Structuring Wheel Specs for E-commerce and ERP
News Details
Problems arise when each team keeps a different version. A quote may show one offset, while a product page shows another. A warehouse may track stock by design name, even though that design comes in several sizes and finishes.
A clear data structure helps prevent these gaps. For wheel importers, distributors, and private label brands, the goal is simple: carry approved product details from the first request for quotation through to the final customer order.
Start Wheel Product Information Management at the RFQ Stage
An RFQ, or request for quotation, should collect more than a wheel image and target price. It should establish the core fields that will follow the product throughout its life.
Ask the supplier to confirm:
- Design reference and drawing revision.
- Diameter and width.
- Bolt count and pitch circle diameter, or PCD.
- Offset, often shown as ET.
- Center bore.
- Material and construction.
- Finish code and approved color reference.
- Load rating and supporting documents.
- Center cap, valve, and hardware requirements.
- Order quantity and packaging needs.
Also, mark each value as requested, proposed, or approved. A requested specification should not become a published claim before technical review.
This early structure makes wheel product information management easier as the range grows.
Build Wheel PIM Data Around Each Sellable Variant
PIM means product information management. It brings together the details, descriptions, and assets needed to present products across sales channels.
For wheels, one design often has many sellable variants. Each combination of size, bolt pattern, offset, center bore, and finish needs a clear identity.
Use a parent record for shared design information. Then create a separate SKU for each stock-controlled variant.
For example, two wheels may share the same design and matte black finish but have different offsets. They should remain distinct records if they are ordered, stocked, or sold separately.
Likewise, distinguish a single wheel from a four-wheel set. If a set combines different front and rear sizes, record its component SKUs and quantities.
Never rely on a product title alone to identify stock.
Standardize Wheel Specs Before Importing Data
A product title such as “18x9 6x139.7 ET12 Black” may be useful for display. However, systems work better when each value has its own field.
The following structure shows how to organize wheel PIM data:
| Field | Recommended structure | Main purpose |
|---|---|---|
| Internal SKU | Unique, stable text code | Links records across systems |
| Supplier part number | Separate text field | Matches quotes and orders |
| Diameter | Numeric value in inches | Supports product filters |
| Width | Numeric value in inches | Supports product filters |
| Bolt count | Whole number | Defines bolt pattern |
| PCD | Numeric value in millimeters | Defines bolt pattern |
| Offset | Signed numeric value in millimeters | Preserves positive or negative ET |
| Center bore | Numeric value in millimeters | Supports fitment review |
| Finish | Controlled code plus display name | Prevents naming drift |
| Load rating | Value, unit, and document reference | Supports technical review |
| Sales unit | Each, pair, or defined set | Prevents quantity errors |
Keep units consistent. Also, distinguish unknown values from zero. A blank offset means information is missing; zero is a specific offset.
For dual-drilled wheels, store both bolt patterns as structured entries rather than mixing them into one unclear text field.
Keep Wheel ERP Product Data Aligned with Sales Records
ERP means enterprise resource planning. It commonly manages purchasing, inventory, orders, and financial records.
While PIM focuses on product content, wheel ERP product data supports business transactions. Both systems should use the same stable product identifier.
Useful ERP fields include:
- Internal SKU and supplier part number.
- Purchase and sales units.
- Unit conversion rules.
- Carton quantity and packed dimensions.
- Net and gross weight.
- Supplier, order status, and lead time.
- Warehouse location and batch reference, where used.
Define which system owns each field. For example, engineering may approve dimensions, PIM may manage descriptions, and ERP may control available stock.
Then map shared fields between systems. This avoids separate teams overwriting the same data with conflicting values.
Build a Fitment Data Workflow with Evidence
Matching a bolt pattern does not prove that a wheel fits a vehicle.
A sound fitment data workflow also considers center bore, offset, width, brake clearance, mounting hardware, load requirements, and vehicle configuration.
Keep vehicle applications in linked records rather than placing a long list inside the product description. Depending on the market, those records may need make, model, year, trim, axle position, and brake package.Each fitment record should include its source, review date, approval status, and any conditions. These may cover required hub rings, specified hardware, or installation limits.
A practical review sequence is:
- Collect the vehicle and wheel requirements.
Link Images and Documents to the Correct Wheel SKU
Clear specifications lose value if the listing shows the wrong wheel.
Link images to the correct design, finish, and variant where appearance differs. Changes in width or offset can affect face shape and lip depth, so a shared image may need a clear representative-image note.
Maintain asset records for:
- Main product and detail photos.
Validate Wheel PIM Data Before Publishing
Before importing a catalog, check for duplicate SKUs, missing units, invalid formats, and broken image links.
Next, compare a sample of records against approved drawings and purchase specifications. Check especially for missing negative signs in offsets, incorrect finish codes, and confusion between individual wheels and sets.
Use release states such as draft, technical review, approved, and published. Record who approved changes and when.
If a key specification changes, assess whether it requires a new SKU or a controlled revision. Also, identify existing stock so older and newer versions remain traceable.
Prepare a Clear Data Brief for Wheelman
When starting a project with
Wheelman
, share your RFQ template alongside the fields required by your store and ERP system. Include your SKU rules, units, image requirements, fitment review process, and preferred exchange format. Ask which data and documents are available, and agree on how missing information will be resolved.With one approved structure, wheel specifications can move from quote to purchase order, warehouse, and online listing with fewer manual edits. That gives every team a clearer view of what it is buying, stocking, and selling.