Managing an Auto Parts Catalog in Odoo: Variants, Vendor Pricelists and Bulk Imports
Illustration: the people shown are AI-generated and fictional.
An auto parts catalog grows fast: thousands of part numbers, several suppliers for the same item, and price files that change every quarter. Without a clear structure, the same part ends up entered twice, buyers order from the wrong supplier, and the counter can’t trust what the system says is in stock.
This guide covers the three Odoo tools that keep a large parts catalog manageable in Odoo 19: product variants, vendor pricelists and bulk imports, and when to use each.
Auto Parts Catalogs in Odoo at a Glance
- One record per part. Duplicate parts are the root of most stock and ordering errors, so clean the catalog first.
- Variants for real variations. Use attributes when parts share one description and differ only by size, finish or similar.
- Vendor prices drive purchasing. They fill in RFQ and PO prices, and the top vendor is used for replenishment.
- Supplier files can be imported. Export a vendor pricelist, edit it, and import it back as XLSX or CSV.
- Fitment needs a plan. Make-model-year fitment isn’t standard Odoo; add it with attributes, fields or an integration.
Product Variants: When They Help and When They Don’t
In Odoo, a product template can have variants built from attributes and values. Each combination is its own variant, with its own inventory count and sales records. Turn on Variants in Sales › Configuration › Settings, then create attributes in Sales › Configuration › Attributes.
- Good fit: the same part offered in several sizes, lengths or finishes, sold under one description.
- Poor fit: parts that differ in function, supplier or vehicle fitment, which are clearer as separate products.
- Watch the numbers: variants multiply. Four values of one attribute and five of another already make twenty variants.
Vendor Pricelists: Buying From the Right Supplier
Vendor prices sit on each product’s Purchase tab. They fill in the unit price automatically on requests for quotation and purchase orders, which removes a common source of buying errors. When reordering rules trigger, Odoo uses the vendor at the top of the list, so the order of vendors matters.
Put your preferred supplier first on every part. If the top vendor is out of date, automatic replenishment quietly sends orders to the wrong supplier.
Bulk Imports: Loading Supplier Price Files
- Export first. Go to Purchase › Configuration › Vendor Pricelists, select a few lines and export them, so you have a file with the right columns.
- Map the supplier’s file. Copy the supplier’s part numbers and prices into that template, matched to your products.
- Import as XLSX or CSV. Then spot-check a sample of parts on a test RFQ.
- Repeat each price change. Keep the template, so each new supplier file is a quick update.
Once the catalog is clean, the warehouse side matters next; see barcode receiving and picking for parts distributors. For more, see Odoo for auto parts distributors.
Auto Parts Catalogs in Odoo: FAQ
What are product variants in Odoo?
Variants are versions of one product template that differ by attributes, such as size or finish. Each combination of attribute values is its own variant, with its own inventory count and sales records.
When should a part be a variant rather than its own product?
Use variants when parts genuinely share one description and differ only by a few attributes. Parts that differ in function, supplier or fitment are usually clearer as separate products with their own internal reference.
How do vendor prices work in Odoo Purchase?
Vendor prices are added on the product’s Purchase tab, or imported in bulk. They fill in the unit price automatically on requests for quotation and purchase orders, and the vendor at the top of the list is used for automatic replenishment.
Can I import a supplier’s price file into Odoo?
Yes. Vendor pricelists can be imported from an XLSX or CSV file. Odoo recommends exporting an existing vendor pricelist first, so the file has the right columns, editing it, and importing it back.
Does Odoo handle vehicle fitment out of the box?
Fitment (which part fits which make, model and year) isn’t a standard Odoo feature. Distributors usually add it with product attributes, custom fields or an integration with a catalog data provider, depending on how deep the data needs to go.
Is your parts catalog holding you back?
Our Odoo migration team can clean, structure and import your catalog and supplier price files.
Talk to Our Odoo Team