Skip to Content
This question has been flagged
pospricingwebshopvariantsdiscounts
3 Replies
1072 Views
Avatar
Stefan Capiau

We have a shop with about 5000 different products. Each product can have 5-50+ colour variants. 

Some of the variant colours are discontinued by the manufacturer.

On these variants we want to offer a certain discount %


We now mark the discontinued colours with a specific tag (on the variant). 


How can we define a rule to give x% discounts on the variants with tag y linked to it ? 
The discounted price should be available in POS, webshop and manual order entry. 

I appreciate all help on this topic.


(we are using V17)

Avatar
Discard
Avatar
Stefan Capiau
Author Best Answer

Thanks Anaghan,

Option 1 is not feasable because the category is also used to direct the financial transactions in our accountancy and therefor does not offer much flexibility. 

Option 2 we tried and it calculates the discount on the webshop on the checkout page, but it does not show the prices with a discount on the product page. 
We also noticed that in POS the entered discount is shown on all products and not only on the selection we made. 


Avatar
Discard
Avatar
Anaghan Heri
Best Answer

Hi, you have two options in Odoo that can fit your requirements. You can choose the one that benefits you the most:

  1. POS Pricelist: Allows you to set different product pricing based on product category or by selecting specific products.
  2. POS Discount & Loyalty: Provides features for applying discounts and offering loyalty programs to customers. here is the option product tag.

Please check the picture below to see the details and let me know if you have any questions.

Avatar
Discard
Avatar
Pablo Lozano
Best Answer

Hello, one solution maybe is Server action, where modified with python code. In this server action you should search the products with the tags are you interested and modify the field discount.



This solution is easily to programming in odoo with python. You don t need to use a IDE, you con programming in Odoo, in Settings> Technical> Server Action

Code example in comment.

Avatar
Discard
Pablo Lozano

Code Example:

# Create discount value for products with tag 'Discontinued'
discount_percentage = 20 # 20% discount

# Search for the tag 'Discontinued'
discontinued_tag = env["product.tag"].search([("name", "=", "Discontinued")], limit=1)
if discontinued_tag:

discontinued_products = env["product.product"].search(
[("tag_ids", "in", discontinued_tag.id)]
)

# Apply discount to all products with the 'Discontinued' tag
for product in discontinued_products:
original_price = product.lst_price
discounted_price = original_price * (1 - discount_percentage / 100)
product.lst_price = discounted_price

else:
raise UserError("Tag 'Discontinued' not found")

Related Posts Replies Views Activity
Group product variants in POS / Point of Sale screen
pos variants
Avatar
Avatar
Avatar
Avatar
3
Jan 21
10759
Use Product (Consumable/Service) as a global discount / Coupon
pos discounts
Avatar
Avatar
1
Mar 18
3510
Odoo V10 POS - regroup products with variants in one with options
pos variants
Avatar
0
Feb 17
2599
POS Button for Discount or Fee on Total Ticket
pos discounts
Avatar
0
Aug 15
3687
How to "hide" variants/attributes but still show products in POS odoo17 Solved
pos variants attributes
Avatar
Avatar
Avatar
2
Nov 24
2281