Import vendor pricelist

Odoo Purchase can auto-fill vendor prices on requests for quotation (RFQs) and purchase orders once they are set up. Prices can be added one product at a time, or imported in bulk from a spreadsheet, which is quicker when updating many products at once.

Add a vendor price on one product

1. Go to Purchase > Products > Products and open the product to update.
2. In the Purchase tab, click Add a line and enter the Vendor, Price and an optional Delivery Lead Time.

Import vendor pricelists in bulk

1. Prepare a template

1. Go to Purchase > Configuration > Vendor Pricelists and tick any existing records.
2. Click the Actions menu, then Export.
3. Choose the fields to include, such as Vendor, Product Template, Quantity, Unit Price and Delivery Lead Time. Tick I want to update data (import-compatible export) to include the External ID, which is needed to update existing records rather than create duplicates.
4. Choose XLSX or CSV as the export format, then click Export.

2. Edit the file

Fill in or update the pricelist rows using the exported column headings, keeping the External ID for any row that should update an existing price rather than add a new one.

3. Import the file

1. Go back to Purchase > Configuration > Vendor Pricelists.
2. Click the gear icon and select Import records.
3. Click Upload File, choose the edited file, confirm the field mapping, and click Import.

Tips

• Always export a template first, so column names and the External ID match what Odoo expects.
• Leave the External ID out for genuinely new pricelist entries; include it only when updating an existing price.

Frequently asked questions

Can I add a vendor price to just one product?

Yes, open the product form, go to the Purchase tab and add a line with the vendor, price and optional lead time.

What is the External ID used for when importing?

It identifies an existing vendor pricelist record so the import updates it, instead of creating a duplicate entry.

What file formats are supported for import?

Vendor pricelists can be imported as XLSX or CSV files.

Need help?

Need help importing vendor pricelists into Odoo? Contact support@thoughtlogik.com or see our Odoo implementation services.