Ir al contenido
Odoo Menú
  • Identificarse
  • Pruébalo gratis
  • Aplicaciones
    Finanzas
    • Contabilidad
    • Facturación
    • Gastos
    • Hoja de cálculo (BI)
    • Documentos
    • Firma electrónica
    Ventas
    • CRM
    • Ventas
    • TPV para tiendas
    • TPV para restaurantes
    • Suscripciones
    • Alquiler
    Sitios web
    • Creador de sitios web
    • Comercio electrónico
    • Blog
    • Foro
    • Chat en directo
    • e-learning
    Cadena de suministro
    • Inventario
    • Fabricación
    • PLM
    • Compra
    • Mantenimiento
    • Calidad
    Recursos Humanos
    • Empleados
    • Reclutamiento
    • Ausencias
    • Evaluación
    • Referencias
    • Flota
    Marketing
    • Marketing social
    • Marketing por correo electrónico
    • Marketing por SMS
    • Eventos
    • Automatización de marketing
    • Encuestas
    Servicios
    • Proyecto
    • Partes de horas
    • Servicio de campo
    • Servicio de asistencia
    • Planificación
    • Citas
    Productividad
    • Conversaciones
    • Aprobaciones
    • IoT
    • VoIP
    • Conocimientos
    • WhatsApp
    Aplicaciones de terceros Studio de Odoo Plataforma de Odoo Cloud
  • Industrias
    Comercio al por menor
    • Librería
    • Tienda de ropa
    • Tienda de muebles
    • Tienda de ultramarinos
    • Ferretería
    • Juguetería
    Alimentación y hostelería
    • Bar y pub
    • Restaurante
    • Comida rápida
    • Casa de huéspedes
    • Distribuidor de bebidas
    • Hotel
    Inmueble
    • Agencia inmobiliaria
    • Estudio de arquitectura
    • Construcción
    • Gestión inmobiliaria
    • Jardinería
    • Asociación de propietarios
    Consultoría
    • Empresa contable
    • Partner de Odoo
    • Agencia de marketing
    • Bufete de abogados
    • Adquisición de talentos
    • Auditorías y certificaciones
    Fabricación
    • Textil
    • Metal
    • Muebles
    • Alimentos
    • Cervecería
    • Regalos de empresas
    Salud y bienestar
    • Club deportivo
    • Óptica
    • Gimnasio
    • Terapeutas
    • Farmacia
    • Peluquería
    Oficios
    • Handyman
    • Hardware y soporte técnico
    • Sistemas de energía solar
    • Zapatero
    • Servicios de limpieza
    • Servicios de calefacción, ventilación y aire acondicionado
    Otros
    • Organización sin ánimo de lucro
    • Agencia de protección del medio ambiente
    • Alquiler de paneles publicitarios
    • Estudio fotográfico
    • Alquiler de bicicletas
    • Distribuidor de software
    Explorar todos los sectores
  • Comunidad
    Aprender
    • Tutoriales
    • Documentación
    • Certificaciones
    • Formación
    • Blog
    • Podcast
    Potenciar la educación
    • Programa de formación
    • Scale Up! El juego empresarial
    • Visita Odoo
    Obtener el software
    • Descargar
    • Comparar ediciones
    • Versiones
    Colaborar
    • GitHub
    • Foro
    • Eventos
    • Traducciones
    • Convertirse en partner
    • Servicios para partners
    • Registrar tu empresa contable
    Obtener servicios
    • Encontrar un partner
    • Encontrar un asesor fiscal
    • Contacta con un experto
    • Servicios de implementación
    • Referencias de clientes
    • Ayuda
    • Actualizaciones
    GitHub YouTube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Solicitar una demostración
  • Precios
  • Ayuda

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Contabilidad
  • Inventario
  • PoS
  • Proyecto
  • MRP
All apps
Debe estar registrado para interactuar con la comunidad.
Todas las publicaciones Personas Insignias
Etiquetas (Ver todo)
odoo accounting v14 pos v15
Acerca de este foro
Debe estar registrado para interactuar con la comunidad.
Todas las publicaciones Personas Insignias
Etiquetas (Ver todo)
odoo accounting v14 pos v15
Acerca de este foro
Ayuda

How can i show the variant prices of a product in the shop list on the website shop using price list and NOT product template price?

Suscribirse

Reciba una notificación cuando haya actividad en esta publicación

Se marcó esta pregunta
variantecommercepricelistwebsite
7 Respuestas
4701 Vistas
Avatar
Jan Hanna

How can I show the variant prices of a product in the website shop (all products shown under the "shop" link) on the ecommerce website? The price has been set by a price list and NOT the product template.

I can only make it show the price set by the product template (default 1 USD).


Here is the product template price




Here are two variants created




Here are the prices set of the two variants using price list



Here is the price of the product on the product list "all products under shop" which is totally wrong! The price here is the product template price.



When clicking the product, you enter the product detail page. The prices here is correct!


0
Avatar
Descartar
Jan Hanna
Autor

I would appreciate it if someone could help me out here.
I really need this working.

Jan Hanna
Autor

I think this is a bug. Maybe someone can confirm it.

Because if i remove all variants, then the product price under the product grid (products under "shop") shows the price that is set by the price list and NOT the product template price. Exactly how i want it.

If there is any variant created, then the prices on the product grid will be the product template price.


Now i need to find a workaround if this is a bug. I guess i have to create a product for each variant (and hide these from the product grid) and link it from the main product page. 

Avatar
Jan Hanna
Autor Mejor respuesta

Yes I also thought that was the case that it was intentional. But that would make it even worse if that’s the case. Let me show you why:

 

Here is my product and the variants with different pricing for different price lists:

 

Let's take the phone 128gb as an example. It's 12500 kr or 1250 euro with VAT.

 

I can make it show correctly in Price list 1 in SEK. Here is the price in the product grid with VAT.

Here is the price in the product page, 12 500 kr. Same as product grid, all is Correct.

 

 

But check out what happens when i change price list to Price list 2 EUR in the product grid. It shows the currency conversion price of 1101.76 Euro.


 

And here is the Product page which shows the price i want to sell it at of 1250 Euro including VAT:

 

 

And check out the extra price for the next variant. It’s written in currency SEK, kr.

 

The product grid uses currency conversion rate, not something i want to show.

I have no clue how to solve this.

0
Avatar
Descartar
Avatar
Anaghan Heri
Mejor respuesta

Hello, 


This is not an Odoo bug. You have set the product variant to price, but on the shop page, the product template is displayed. Product templates and product variants are handled separately.


In the shop page's grid view, it shows the product template, which considers the template's sale price. However, when you go inside the product page, you can select a variant, and the price will automatically change according to the selected variant + Price list.


If you want the shop page to display the variant and its price by default, you'll need to customize the shop page so that the product variant appears first, along with its corresponding price.

0
Avatar
Descartar
Jan Hanna
Autor

I just answered as a main answer as i couldn't answer your replay with pictures.
Please check my answer.

Avatar
Michal Kolasinski
Mejor respuesta

We do experience the same behaviour. The web grid always shows the product template price. Clicking on the product in the webshop and selecting product variants will show correct pricelist prices. 

I have opened a support ticket and i got this answer: 

OFFICIAL ODOO SUPPORT ANSWER:

"I would like to inform you that the grid view of the website shows the 
price set on the base product and after the selection of the variant the
 price will be updated based on the price list. So if you have set the 
price on the base product to 1 Euro it will be displayed as 1 Euro on 
the website before any variant is being selected." 
I understand your issue here but unfortunately, I will not be able to 
help you further with this as it is the standard behavior of Odoo that 
it will display the price that is set on the product form of the base 
product. 

In other words: No pricelist price will ever appear in the shop grid view. This makes odoo useless for B2B eCommerce. We do have ~500 B2B clients, each having separate pricelists. Since we can only set one price in the product template/base ~499 clients will see a wrong price. Thats PITA. We will have to try to adapt the code ourselves..

0
Avatar
Descartar
Jan Hanna
Autor

We were going to start using Odoo last year but this bug killed it. I still haven't hopped on. I tried odoo 17.4 online last week to see if there was any fix but it's still the same. I did open a ticket but they said it was normal behavior which i find is extremely illogical. The way the price is shown doesn't make sense to me.

There is a github ticket for this but they won't acknowledge it.
https://github.com/odoo/odoo/issues/133270#issuecomment-1835698975

We have to hop on an ERP very soon but might have to look elsewhere.

Jan Hanna
Autor

Please update me on this ticket.

Jan Hanna
Autor

I see the response from support now. I got the same previously. Unbelievable that you cannot choose what price to show on the product grid. Have you solved it somehow?

Avatar
Shen
Mejor respuesta

I encountered the same problem.

I set up a fixed-price price list for 200 products/product variations. After entering it, I found that it could not be displayed on the store page.


In addition, in the price list, I only have one selectable price list, but there will be two selectable price lists in the web page options, one of which will use the sales price in the product attributes. How to remove this price list?

Maybe removing this one will show the correct price.

0
Avatar
Descartar
Jan Hanna
Autor

Can you show me pictures of what you mean with the selectable price lists?
Maybe I can figure it out.

Shen

I don't have permission to post pictures yet.

Avatar
Wolfgang Hall
Mejor respuesta

Hi JH001,

Even if you have Variants, the all product grid list on the shopping site seems to only show only the base product price (based on product.template).

If you apply a filter (e.g on demo.odoo.com select "Aluminum") the customizable desk is show with a base price of $750 (in the USA) .  Only when you click on it, the price changes to the correct $800.40

Maybe this is worthwhile pointing out in a ticket to the Odoo team.  Most shoppers would expect a price range for all filtered variants if multiple options, or a single correct variant price if it is just a single product option based on the filters.




0
Avatar
Descartar
Jan Hanna
Autor

Thanks.

What i would like to know if this is intentional.
Because if this is intentional, then i cannot really use Odoo.
I'm going to be totally stunned if this is intentional.

I guess i need to open a ticket.

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Inscribirse
Publicaciones relacionadas Respuestas Vistas Actividad
Add variant price to multiple quantities also on pricelists
variant ecommerce pricelist
Avatar
0
feb 25
1886
Can i remove the added extra price bubble for each variant in the ecommerce website?
variant ecommerce website
Avatar
Avatar
1
nov 24
12889
V14 Help E-commerce do not Apply Pricelist on a product varient?
variant ecommerce pricelist
Avatar
Avatar
2
jun 22
1996
Display Price Ranges or ‘From’ Price for Products with Pricelists on Odoo Website
pricelist website
Avatar
Avatar
Avatar
3
jul 25
2158
Website in Odoo
pricelist website
Avatar
Avatar
1
may 25
2015
Comunidad
  • Tutoriales
  • Documentación
  • Foro
Código abierto
  • Descargar
  • GitHub
  • Runbot
  • Traducciones
Servicios
  • Alojamiento Odoo.sh
  • Ayuda
  • Actualizar
  • Desarrollos personalizados
  • Educación
  • Encontrar un asesor fiscal
  • Encontrar un partner
  • Convertirse en partner
Sobre nosotros
  • Nuestra empresa
  • Activos de marca
  • Contacta con nosotros
  • Puestos de trabajo
  • Eventos
  • Podcast
  • Blog
  • Clientes
  • Información legal • Privacidad
  • Seguridad
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo es un conjunto de aplicaciones empresariales de código abierto que cubre todas las necesidades de tu empresa: CRM, comercio electrónico, contabilidad, inventario, punto de venta, gestión de proyectos, etc.

La propuesta única de valor de Odoo es ser muy fácil de usar y estar totalmente integrado.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now