Import vendor pricelist

Estimated reading: 2 minutes 13 views

Introduction

Want to avoid manually typing vendor prices every time you create a Request for Quotation (RFQ) or Purchase Order (PO)?
Odoo’s Vendor Pricelist Import feature makes this easy.

By uploading a simple spreadsheet, you can bulk import vendor pricing details. This ensures that product prices auto-fill whenever added to RFQs or POs—helping your team reduce mistakes and streamline purchasing.

Step-by-Step: How to Import Vendor Pricelists in Odoo

You can manually add vendor prices to a product or import them in bulk. Let’s explore both.

1. Add Vendor Prices on the Product Form

To manually set a vendor price:

Go to Purchase app → Products → Products
Click on the product you want to update
Go to the Purchase tab
Add:
- Vendor Name
- Price
- Lead Time (optional)

2. Prepare Your Import File (XLSX or CSV)

Before importing, create a clean template:

Go to Purchase app → Configuration → Vendor Pricelists
Select some existing records (if available)
Click Actions → Export
In the export window:
- Choose the fields you want (see “Common Fields” below)
- Tick “I want to update data” to include External ID (for updating prices)
- Select Export Format (XLSX or CSV)
- Click Export

Use this exported file as a template for your import.

3. Edit the File

Fill or update the vendor pricelist data using the correct field values.
Here’s a sample structure:

External ID	Company	Delay	Price	Product	Sequence	Vendor
product.product_supplierinfo_3	My Company (San Francisco)	3	13.00	[E-COM08] Storage Box	4	Wood Corner
		3	14.00	[E-COM08] Storage Box	5	Ready Mat
		2	1299.00	[E-COM09] Large Desk	6	Wood Corner
		4	1399.00	[E-COM09] Large Desk	7	Azure Interior

4. Import the File

Once your file is ready:

Go to Purchase app → Configuration → Vendor Pricelists
Click the ⚙️ gear icon → Import Records
Click Upload File, choose your edited file
Match the columns (Odoo may do this automatically)
Click Import

That’s it! Your vendor pricelist is now part of your system.

Tips for a Smooth Import

Always export first to get the correct template
Use External ID when updating existing vendor prices
Lead Time = Days it takes the vendor to deliver after PO confirmation
Use XLSX format for better readability when editing

Common Fields for Vendor Pricelist Import

Field Name	Purpose	Technical Name
Vendor	The supplier providing the product	partner_id
Product	Product linked to the vendor pricelist	product_tmpl_id
Quantity	Minimum quantity to apply the given price	min_qty
Unit Price	Price per unit charged by the vendor	price
Lead Time	Days for delivery after PO confirmation	delay
Sequence	Order priority of vendors when multiple exist	sequence
Company	The company using the pricelist	company_id
External ID	Unique ID used to update existing records	id

Import vendor pricelist

Introduction

Step-by-Step: How to Import Vendor Pricelists in Odoo

1. Add Vendor Prices on the Product Form

2. Prepare Your Import File (XLSX or CSV)

3. Edit the File

4. Import the File

Tips for a Smooth Import

Common Fields for Vendor Pricelist Import

Related Articles