Vendor Pricelist Features in Odoo 18
by Muhammad Kamran
Effectively managing vendor pricing is essential for enhancing procurement efficiency and maximizing profitability. Without a centralized system to manage vendor pricing, businesses risk paying inconsistent prices, missing out on bulk discounts, or facing delays in receiving products on time. Odoo 18's Purchase module enables businesses to create vendor pricelists. These pricelists allow for setting specific pricing for a product from a vendor based on quantity, time period, and applicable discounts. This article explores how Odoo 18’s Vendor Pricelist Management solves these common procurement issues, ensuring consistent pricing and efficient workflows.
Let’s explore the key features of Vendor Pricelist Management in Odoo 18, including vendor pricelist creation, lead time settings, managing multiple pricelists for a single product, and applying discounts.
Navigate to Vendor Pricelists
- Go to Purchase Module > Configuration > Vendor Pricelists.
- Here, you can view existing pricelists or create a new one by clicking Create.
Creating a New Pricelist
Vendor
Select the vendor for whom you’re creating the pricelist.
Vendor Product Name
If the vendor uses a different product name, specify it here. This name will appear on the RFQ (Request for Quotation). Leave it blank to use your internal product name.
Vendor Product Code
Enter the vendor's product code if it differs from your internal code. This field is crucial when each party uses unique codes.
Delivery Lead Time
Set the delivery time in days after order confirmation.
Product
Select the product for which the pricelist is created.
Product Variant
Choose a specific variant if the pricelist applies to one.
Quantity
Specify the minimum quantity required to apply this pricing.
Unit Price
Enter the vendor’s price for the product.
Discount
Configure any vendor discounts for bulk purchases or special deals.
Validity
Define the period during which the pricelist is active.
Company
Choose the relevant company if multi-company functionality is enabled.
Example of Creating a Vendor Pricelist
Let’s say you want to create a pricelist for Abigail Peterson with the product "Large Cabinet." Follow these steps:
1. Go to Purchase Module > Configuration > Vendor Pricelists.
2. Click Create to add a new pricelist.
3. Fill in the Pricelist Details:
- Vendor: Select Abigail Peterson.
- Product: Choose a Large Cabinet.
- Quantity: Set to 1.
- Unit Price: Enter $500.
4. After entering all details, click Save to complete the process.
This will set up a specific pricelist for Abigail Peterson for the "Large Cabinet" at a unit price of $500.
How to Generate a Purchase Order Using the Configured Pricelist
As you have set up a pricelist for Abigail Peterson, let’s say you now want to generate a purchase order for her using the configured pricelist. Follow these steps:
1. Navigate to Purchase Orders
Go to Purchase Module > Purchase Orders and click Create.
2. Select the Vendor
Choose Abigail Peterson as the vendor.
3. Add Product
- In the order line, add the product Large Cabinet.
- The price will automatically update to $500, based on the configured pricelist for this product and vendor.
4. Review and Confirm
Verify the order details, ensuring the price reflects the pricelist amount of $500.
5. Save and Confirm
Click Save, then Confirm Order to complete the purchase order. The purchase order is now set with the correct pricing from the vendor pricelist, simplifying the procurement process.
Lead Time Applicability in Vendor Pricelist
Odoo 18 allows you to configure Vendor Lead Times directly within the pricelist, ensuring accurate calculation of expected delivery dates in purchase orders.
Vendor Lead Time
Specifies the number of days required for a product to arrive after the order is placed and confirmed.
By setting the Delivery Lead Time in the pricelist, the purchase order’s expected arrival date updates automatically.
For instance, if you set a lead time of 3 days, Odoo will schedule the product receipt three days after the purchase order confirmation. This lead time can be tailored for each product in the vendor pricelist, ensuring that delivery schedules align with the procurement workflow accurately.
With the delivery lead time set to three days, the expected arrival date on the purchase order is scheduled three days after the order deadline.
Once the receipt is verified and the item is received, the planned date will be updated according to the vendor lead time specified below.
Handling Multiple Vendor Pricelists for One Product
Managing multiple vendor pricelists for a product can be challenging, especially when different vendors offer various terms and pricing structures. In Odoo 18's Purchase module, a product can be associated with multiple vendor pricelists, with each vendor offering different prices, quantities, and delivery terms. Odoo streamlines this process by automatically selecting a vendor when a purchase order is created.
If multiple vendors are listed under a product’s Purchase tab, Odoo will prioritize the topmost vendor in the list when generating a purchase order. Therefore, if no vendor is manually selected during purchase order creation, the system will default to the top-listed vendor and apply their pricing and terms to the order.
For example, in the product configuration for Chair floor protection, there are three vendors: Aka Foster, Abigail Peterson, and Wood Corner. Aka Foster is listed first, offering a price of $5.00 per unit for a minimum quantity of 10 units.
When a purchase order is created for the product 'Chair Floor Protection' in Odoo, and no vendor is specified in the RFQ, Odoo automatically applies the pricing and terms of the top vendor from the vendor pricelist. Since Aka Foster is listed first, their pricing and terms are applied by default when the product is selected.
Prioritizing Vendor Pricing in Purchase Orders
When a product has multiple vendors, Odoo prioritizes the vendor listed at the top of the vendor list, making them the default supplier for the product. The system automatically selects this vendor for replenishment, ensuring the highest-priority vendor is chosen unless specified otherwise.
Evaluating Prices from a Single Vendor
If a single vendor offers different prices for the same product, such as based on quantity breaks or other conditions, Odoo will select the lowest available price. The system evaluates the pricing structure, considering factors like the ordered quantity, and automatically chooses the most cost-effective price for the replenishment order.
Applying Discounts in Vendor Pricelists
In Odoo 18, vendor pricelists support discount options, allowing businesses to take advantage of promotions or bulk purchase agreements from suppliers.
Discount Configuration
When creating or editing a vendor pricelist, you can specify a discount percentage for specific products or product categories. This feature is useful for applying seasonal discounts or quantity-based promotions offered by the vendor.
Automatic Application
When a purchase order meets the conditions specified in the pricelist (e.g., quantity or time period), the discount is automatically applied to the unit price. The discount will appear directly on the RFQ or Purchase Order, making it easy to track savings.
Set the quantity to 50 units and apply a 50% discount for the Cabinet with Doors in the vendor pricelist. After saving the pricelist, go to Purchase > RFQ and create a new Request for Quotation. Select the same vendor and choose the product Large Cabinet with Doors. Enter 100 as the quantity.
Once the product and quantity are added, the pricelist will automatically apply. You’ll notice that the 50% discount is reflected in the order line, and the product price will be adjusted accordingly.
Wrap-Up
This way you can manage vendor pricelists and lead times in Odoo 18. You can streamline procurement, ensure accurate pricing, and take advantage of vendor discounts by effectively managing vendor pricelists. This results in more efficient purchasing processes.
Looking to Enhance Your Odoo Experience?
Let Numla help streamline your operations with customised Odoo solutions.