This guide is written for business buyers. Confirm product applications, technical data, commercial terms and market requirements with the selected supplier before ordering.
A quotation can only be as accurate as the product list behind it. For an importer buying 20, 100 or 500 automotive filter references, a spreadsheet containing only part numbers may be enough to start a conversation—but it often leaves important questions unanswered: Which reference is the original OE number? Is the proposed substitute fully verified? What quantity is required for each SKU? Does the buyer want its own brand on the box?
A well-prepared OE-number list helps a supplier identify the intended products, flag ambiguous references, and quote against consistent commercial assumptions. It does not prove interchangeability by itself. This guide shows a practical RFQ format for distributors, wholesalers and private-label aftermarket buyers.
In brief: Keep the original identifier unchanged, put one requested SKU on each row, separate confirmed facts from unverified references, include quantities and packaging requirements, and send uncertain applications for verification rather than guessing.
What to include in your automotive filter RFQ spreadsheet
You do not need a complicated database export. A straightforward Excel or CSV file with the following columns is a useful starting point.
| Column | What the buyer should enter | Why it matters |
|---|---|---|
| Line ID | Your unique row number, e.g. RFQ-001 |
Makes questions and revisions traceable |
| Filter category | Oil, air, fuel or cabin air | Directs the reference to the right product group |
| Reference type | OE, aftermarket, supplier SKU or unknown | Prevents one number from being treated as another kind |
| Original reference | Exact number shown in your source | Preserves the identifier for matching |
| Reference source | OE catalog, customer list, box label, sample, etc. | Shows how reliable the initial reference may be |
| Brand / application | Vehicle make, model, engine, year and market if known | Helps resolve variants and avoid false cross-references |
| Buyer-required quantity | Pieces per SKU, not just the total order | Supports meaningful per-line pricing and MOQ discussion |
| Packaging | Neutral box, buyer's private label, bulk carton, etc. | Affects preparation, labeling and cost |
| Target market | Country or region of sale | Helps clarify market-specific application and labeling questions |
| Verification status | Confirmed by buyer / needs checking / sample available | Keeps uncertainty visible before ordering |
| Notes or attachments | Photo ID, drawing filename, dimensions if verified | Gives supporting information without guessing |
Useful minimum for a first inquiry: filter category, exact original reference, quantity per SKU, destination market and an email contact. Additional application and packaging details can be resolved during the quotation process.
An example: three lines, three different levels of certainty
The following is a fictional formatting example, not a verified fitment or product-availability list. Its reference labels are placeholders, deliberately not real OE claims.
| Line ID | Category | Original reference | Reference type | Quantity | Status | Buyer note |
|---|---|---|---|---|---|---|
| RFQ-001 | Oil filter | OE-EXAMPLE-001 |
OE (unverified) | 500 | Needs application check | Customer supplied the number; no vehicle data |
| RFQ-002 | Air filter | AF-SAMPLE-002 |
Aftermarket | 300 | Sample available | Photo and dimensions in separate file |
| RFQ-003 | Cabin air filter | REF-003A |
Unknown | 200 | Source unclear | Ask supplier to identify before quoting |
This format allows the supplier to reply by line ID and explain which entries can be identified, which need a sample, and which cannot yet be responsibly quoted. It is safer than turning every cross-reference into a confirmed application automatically.
Six formatting rules that prevent avoidable quotation errors
Preserve leading zeros and complete suffixes
An OE number is an identifier, not a mathematical value. If Excel converts a reference such as 001234 to 1234, the original identifier has been changed. Set the reference column to Text before pasting or importing, and check the result before sending. Keep meaningful dashes, suffixes and letter case as received from the source.
Keep the original and normalized versions separate
Some systems search with spaces or hyphens removed. If you make a normalized search column, retain the untouched original in another column. Do not overwrite the source value or assume a normalized match confirms interchangeability.
Avoid merged cells and multiple part numbers in one cell
One row should describe one purchasing line. Put alternative references in a separate clearly labeled column or attachment. This makes it easier to compare quotes and identify missing lines.
Distinguish references from verified applications
A cross-reference, a photograph and a vehicle application are different forms of evidence. Record what the buyer actually knows. If only a box label is available, say so; do not present fitment as confirmed.
Keep units and quantities explicit
Specify whether your quantity means individual filters, sets or cartons. For a trial order, show the requested quantity per SKU and note whether the quantities are flexible around the supplier's MOQ.
Version the file when requirements change
Use a clear filename, for example Filter_RFQ_BuyerName_2026-10-24_v1.xlsx. Keep the line IDs stable between revisions and identify updated quantities, references or packaging instructions. A clear revision record reduces the chance of quoting an outdated list.
Add enough detail for pricing—not invented technical specifications
Technical details matter, but buyers should not fill unknown fields with estimates. Depending on the filter category, the supplier may need to confirm:
- Oil filters: thread or cartridge dimensions, gasket geometry, applicable valve configuration and application evidence.
- Air filters: dimensions, sealing shape, media and housing compatibility.
- Fuel filters: connection type, dimensions and application-specific construction.
- Cabin air filters: dimensions, airflow orientation and any requested media option.
These are examples of verification topics, not a universal list of specifications. If a dimension or performance claim is important to your buying decision, request the corresponding product drawing, verified specification or approved sample. A cross-reference alone does not establish technical equivalence.
For the technical checks specific to oil-filter interchange, see our Oil Filter Cross-Reference Guide.
Include commercial details in the same RFQ
A technically identifiable part can still produce an unusable quotation if the commercial assumptions are missing. Alongside your spreadsheet, include your destination country, requested quantities, preferred packaging, private-label artwork availability, desired shipping terms and any timing requirements. Ask suppliers to state which of those assumptions their quotation actually covers.
For a multi-SKU program, compare replies against the same line IDs and quantity units. If a supplier proposes a substitute, request the proposed supplier part number and supporting identification information before approving the line. Keep quoted, sample approved and approved for purchase as separate decisions.
How to send the list to Haolincfilter
There are two straightforward routes:
- For individual references, use the Filter Finder to check whether an existing product record matches your identifier. If no result is shown, preserve the original number and proceed to an inquiry rather than treating a suggested substitute as confirmed.
- For multiple lines, send your spreadsheet through Request a Quote. The form accepts common spreadsheet and document file types, including XLS, XLSX, CSV and PDF, subject to the site's upload limits. Include your company details, destination, per-SKU quantities and packaging requirements.
Haolincfilter can then review the supplied references and clarify uncertain items during the quotation discussion. Submitting a number is a request for identification and quotation, not proof of product availability, fitment or quoted price.
Before you press Send
Use this quick final check on your spreadsheet:
- Every row has a stable line ID and one requested purchasing item.
- Original OE/aftermarket references are stored as text, with leading zeros intact.
- The reference type and source are identified where known.
- Quantities are specified per SKU and the units are clear.
- Unknown applications or dimensions are marked unverified, not guessed.
- Destination market and packaging/private-label requirements are included.
- Attachments use filenames that can be matched to the correct line ID.
- The version/date is clear and contact information is current.
Ready to request a multi-SKU quote? Send your OE-number list and packaging brief to Haolincfilter. A clean list gives both teams a practical starting point for confirming products and preparing a comparable quotation.
