A supplier pricelist records which supplier you can order a product from and the price that supplier charges. You import it in the Purchase module.
Download: Supplier pricelist import template (XLSX)
Go to Purchase -> Configuration -> Vendor Pricelists and start the import there.
Template
Use our example template Prijslijst leverancier (product.supplierinfo).xlsx as the basis for your import file. Each column header carries extra guidance.
Ask us for the latest template if you do not have it - we will send it straight over.
Preparation
Two things must be in place before you import:
- The products are entered.
- The suppliers are entered, with names that match your import file exactly.
If a name does not match precisely, Odoo will not link the row to the right supplier or product.
Working with external IDs and product template IDs
The template uses the external ID. That makes this import a little more involved than most, because a supplier pricelist works with product template IDs, not product IDs.
Those product template IDs appear once you enable variants. To export the right list, temporarily switch variants on under Inventory -> Configuration -> Settings -> Variants.
Then export the product list. Odoo automatically includes the product template IDs, which you use in the import file. After that, you can switch variants back off - it has no further effect as long as you do not use it.
Alternative: by product name
You can also work with product names via the Product Template / Name column. Only do this if you are 100% certain the names match exactly. The smallest difference breaks the link, so the product template ID route is safer.
Need a hand with your import?
Stuck on the supplier pricelist or the product template IDs? Book an Odoo scan or get in touch - we will take a look with you.