An auto parts order: the part number and car model on every line.
Order a part by name alone and what arrives often does not fit the car: one filter comes in dozens of sizes. The supplier needs the part number to prepare the exact one, and the car model to confirm it fits. So this template adds both columns to every line. It has sample rows for consumable parts with no brands, the numbers are examples of the format, and the costs are blank.
Sample rows: Auto parts shops
Examples only; prices are blank for you to fill.
| Item | Part no. | Car model | Qty | Unit cost | Total |
|---|---|---|---|---|---|
| Oil filter | OF-1041 | Sedan 1.6, 2015 to 2020 | 24 | ||
| Air filter | AF-2207 | Sedan 1.6, 2015 to 2020 | 12 | ||
| Fuel filter | FF-2812 | SUV 2.4, 2012 to 2018 | 10 | ||
| Front brake pads | BP-4402 | Hatchback 1.4, 2016 to 2021 | 16 | ||
| Spark plugs, set of 4 | SP-5519 | Sedan 1.6, 2015 to 2020 | 12 | ||
| Alternator belt | AB-6630 | SUV 2.4, 2012 to 2018 | 8 | ||
| Front shock absorber | SA-7120 | Sedan 1.6, 2015 to 2020 | 6 | ||
| Front wiper blades, pair | WB-7704 | Hatchback 1.4, 2016 to 2021 | 20 | ||
| Water pump | WP-8305 | SUV 2.4, 2012 to 2018 | 3 |
Common questions
What if I do not know the part number?
Take the old part or a photo of its label, or ask the supplier for the number from the car model and year. Write it on the order before sending: an order without the number is behind most wrong parts.
Why the car model if I have the part number?
Because the number can belong to a part that changed with the model year. With the car model the supplier can warn you before shipping if the number does not match the car.
Can I mix original and aftermarket parts in one order?
You can, but state which you want in the item, since price and quality differ a great deal. If you buy from more than one supplier, make a separate order for each.
More free tools
- Auto partsFor auto parts shops: a price list per workshop applied when picked at the till, credit limits, a WhatsApp statement link valid 30 days, quotes that become invoices.
- Purchase orderA ready purchase order for a supplier: item, unit, quantity, unit cost, totals computed, and a Received column for what actually arrived. Arabic, Kurdish, English. Free.
- Profit margin calculatorProfit margin and markup from cost and price, or the price for a target margin or markup.