Skip to Content

Contributors

Manage Product Recall

Hello!
I was wondering if there is a way (in standard Odoo or with OCA modules) to manage products recall.

The use case is the following : 
I produce and sell food products tracked by lot.
I notice that a lot has a problem and we need to contact all customers that have this product for a recall.

So I need to be able to :
- Identify the customers who have bought this lot of this product.
- Identify the quantity sold to the customer

I know that I can access some information such as the SO linked to a lot but in this case, I cannot access easily the quantity sold so I would need to go over each Sales Orde to find the information.

I can see the quantity in the Product Moves smart button in the product form but if I want to have the customer information, I would need to export the info.

Note that in this case, we use Odoo community V14.

Thank you in advance for your help!
 
Julie LeBrun
Formatrice & Analyste en applications de gestion intégrée
+1 514-317-7944
LinkedIn Twitter Facebook YouTube
 
  Nouveau
Le nouveau site des Numigiens est WAW 🤩
  Découvrir

by Julie LeBrun - 03:46 - 15 Oct 2024

Follow-Ups

  • Re: Manage Product Recall
    Le jeudi 17 octobre 2024, 11:32:24 CEST Holger Brunn a écrit :
    
    > > price and other fields. With this module, it is not necessary, right ?
    
    > 
    
    > exactly, it's very versatile. All kudos to https://github.com/legalsylvain
    
    > for coming up with this in the first place
    
    Anyway, thanks for the tip!
    Have a good day
    

    by "Xavier Brochard" <zaz@chezlesenfants.fr> - 11:45 - 17 Oct 2024
  • Re: Manage Product Recall
    > price and other fields. With this module, it is not necessary, right ?
    
    exactly, it's very versatile. All kudos to https://github.com/legalsylvain for 
    coming up with this in the first place

    by "Holger Brunn" <holger@brunn.email> - 11:31 - 17 Oct 2024
  • Re: Manage Product Recall
    Le mardi 15 octobre 2024, 16:37:19 CEST Holger Brunn a écrit :
    
    > https://github.com/OCA/server-backend/tree/14.0/server_action_navigate
    
    > (very underappreciated module imho)
    
    > on top of it that allows you to switch from a selection of SOLs to the
    
    > partners of the orders in question, and from there you can do all the Odoo
    
    > partner goodness re messaging/tagging/etc
    
    Nice module ! Quick question : I was thinking to add a kanban view of products 
    in PO so that users could easily browse products to check cost, price and 
    other fields. With this module,  it is not necessary, right ?
    
    Regards
    Xavier

    by "Xavier Brochard" <zaz@chezlesenfants.fr> - 11:11 - 17 Oct 2024
  • Re: Manage Product Recall
    Thank you @David Vidal. I know this is a possibility but I was looking for modules that are made to address this kind of use case.

     
    Julie LeBrun
    Formatrice & Analyste en applications de gestion intégrée
    +1 514-317-7944
    LinkedIn Twitter Facebook YouTube
     
      Nouveau
    Le nouveau site des Numigiens est WAW 🤩
      Découvrir


    Le mar. 15 oct. 2024 à 11:57, David Vidal <notifications@odoo-community.org> a écrit :
    Hi, Julie.

    As a quick solution, you can export those product moves to Excel and in the exportation configuration follow the relation until obtaining the sales data. The relation goes like this:

    stock.move.line (this is where the lot is registered and where the real delivered quantities for each one will be) => stock.move => sale.order.line => sale.order => res.partner

    I think you'll be able to use the same approach with Holger's module proposal.

    ..
    David Vidal

    El mar, 15 oct 2024 a las 15:47, Julie LeBrun (<notifications@odoo-community.org>) escribió:
    Hello!
    I was wondering if there is a way (in standard Odoo or with OCA modules) to manage products recall.

    The use case is the following : 
    I produce and sell food products tracked by lot.
    I notice that a lot has a problem and we need to contact all customers that have this product for a recall.

    So I need to be able to :
    - Identify the customers who have bought this lot of this product.
    - Identify the quantity sold to the customer

    I know that I can access some information such as the SO linked to a lot but in this case, I cannot access easily the quantity sold so I would need to go over each Sales Orde to find the information.

    I can see the quantity in the Product Moves smart button in the product form but if I want to have the customer information, I would need to export the info.

    Note that in this case, we use Odoo community V14.

    Thank you in advance for your help!
     
    Julie LeBrun
    Formatrice & Analyste en applications de gestion intégrée
    +1 514-317-7944
    LinkedIn Twitter Facebook YouTube
     
      Nouveau
    Le nouveau site des Numigiens est WAW 🤩
      Découvrir

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by Julie LeBrun - 07:10 - 15 Oct 2024
  • Re: Manage Product Recall
    Hi, Julie.

    As a quick solution, you can export those product moves to Excel and in the exportation configuration follow the relation until obtaining the sales data. The relation goes like this:

    stock.move.line (this is where the lot is registered and where the real delivered quantities for each one will be) => stock.move => sale.order.line => sale.order => res.partner

    I think you'll be able to use the same approach with Holger's module proposal.

    ..
    David Vidal

    El mar, 15 oct 2024 a las 15:47, Julie LeBrun (<notifications@odoo-community.org>) escribió:
    Hello!
    I was wondering if there is a way (in standard Odoo or with OCA modules) to manage products recall.

    The use case is the following : 
    I produce and sell food products tracked by lot.
    I notice that a lot has a problem and we need to contact all customers that have this product for a recall.

    So I need to be able to :
    - Identify the customers who have bought this lot of this product.
    - Identify the quantity sold to the customer

    I know that I can access some information such as the SO linked to a lot but in this case, I cannot access easily the quantity sold so I would need to go over each Sales Orde to find the information.

    I can see the quantity in the Product Moves smart button in the product form but if I want to have the customer information, I would need to export the info.

    Note that in this case, we use Odoo community V14.

    Thank you in advance for your help!
     
    Julie LeBrun
    Formatrice & Analyste en applications de gestion intégrée
    +1 514-317-7944
    LinkedIn Twitter Facebook YouTube
     
      Nouveau
    Le nouveau site des Numigiens est WAW 🤩
      Découvrir

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by David Vidal - 05:56 - 15 Oct 2024