A bulk buyer needs to know what parts you have, how many are available, and what condition they are in before evaluating a surplus lot. A useful auto parts inventory spreadsheet answers those questions without requiring the buyer to decode warehouse shorthand or guess whether a quantity means pieces, pairs, or cases.
Use the following structure to prepare dealership, distributor, manufacturer, or repair-shop inventory for review. The goal is a clear, traceable list—not a complicated workbook.
Keep an untouched copy of the original export. Create a separate buyer-facing file, label it with the inventory date, and remove stock that is reserved, already sold, or not included in the proposed lot. If availability changes while the list is being reviewed, issue a dated revision instead of silently replacing quantities.
Assign one row to each distinct combination of brand, part number, condition, and location. Two identical part numbers may need separate rows if one group is sealed and another consists of uninspected returns.
Treat part-number columns as text when importing or entering data. Review the exported file to make sure identifiers have not lost leading zeros or been displayed as dates or scientific notation. Keep the original label value in its own column even if you also provide a cleaned search version.
A suffix or brand difference may matter. Flag possible duplicates for review rather than combining them solely because their descriptions match. If you include an interchange number or vehicle application, identify its source and leave uncertain information blank. A spreadsheet description is not proof of compatibility.
Consider an illustrative example: you have eight kits, each containing two components. Record eight kits, with a separate note describing the contents. Listing sixteen pieces without explaining the packaging could make the offer look different from what will actually ship.
If you offer full cases only, identify the case quantity and whether partial cases are excluded. Keep counted quantities distinct from estimates. Where a sealed case has not been opened, say that the quantity is based on its label rather than implying an individual count.
A condition label should tell a buyer what you observed, not promise more than you checked. A simple written key might include:
Do not describe every item as new merely because the lot originated as unused stock. Separate unknowns from verified observations, and do not treat intact packaging as confirmation of functionality.
Before sharing the workbook, check selected rows against shelf labels and available units. Prioritize rows with large quantities, mixed conditions, or previous discrepancies. Record the date and scope of any count so the buyer understands whether the entire lot or only selected items were checked.
If inventory is moving between buildings, keep the original and current location references until the move is reconciled. Our guide to selling auto parts after a warehouse consolidation covers the broader process of separating stock during a relocation.
Use a row ID or lot ID in photo filenames. Include readable label photos, representative packaging images, and close-ups of disclosed exceptions. Clearly distinguish sample photos from images of every item.
Put estimated pallet counts, loading access, and availability dates on a separate lot-summary sheet. Label dimensions and weights as estimates until verified. Avoid packing these details into the part-number field. For staging considerations, see our bulk auto parts liquidation warehouse preparation guide.
Use one header row and consistent column names. Avoid merged cells within the inventory list, decorative blank rows, and color-only condition codes. Include important notes as text so they remain understandable if someone sorts or exports the list.
Remove customer information, employee details, passwords, and unrelated internal records. If you include an asking price, state whether it applies per unit, per case, or to the complete lot. Keep price expectations separate from the factual stock description.
Ask the buyer which format they prefer. A spreadsheet or CSV can be easier to sort and filter, while a PDF can accompany it as a fixed summary. Review a CSV after export because formatting and multiple workbook tabs will not carry over in the same way.
Yes, provided every row has a clear location reference and quantities are not counted twice. Use a separate lot-summary section for pickup details that differ by location.
No. It supports review, but a buyer still needs to assess the specific inventory, condition, quantities, and transaction requirements. A clean file should make uncertainties visible rather than hide them.
Ready to discuss available stock? Visit JBR's Sell Auto Parts page to start the conversation. If you are sourcing inventory, use the Buy Auto Parts page to outline what you need. For questions about presenting a mixed lot, contact JBR Surplus Auto Parts with your inventory summary.