Metadata-Version: 2.1
Name: odoo12-addon-product-active-propagate
Version: 12.0.1.0.1.99.dev4
Summary: Propagate active value from product variants to product templates.
Home-page: https://github.com/OCA/product-attribute
Author: GRAP,Odoo Community Association (OCA)
Author-email: support@odoo-community.org
License: AGPL-3
Platform: UNKNOWN
Classifier: Programming Language :: Python
Classifier: Framework :: Odoo
Classifier: Framework :: Odoo :: 12.0
Classifier: License :: OSI Approved :: GNU Affero General Public License v3
Requires-Python: >=3.5
Requires-Dist: odoo <12.1dev,>=12.0a

================================
Product - Propagate Active Value
================================

.. 
   !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
   !! This file is generated by oca-gen-addon-readme !!
   !! changes will be overwritten.                   !!
   !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
   !! source digest: sha256:40e2cf966e7d249dc652f227b1067bf1b02fac9311466fd69f34782ad51eac89
   !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

.. |badge1| image:: https://img.shields.io/badge/maturity-Beta-yellow.png
    :target: https://odoo-community.org/page/development-status
    :alt: Beta
.. |badge2| image:: https://img.shields.io/badge/licence-AGPL--3-blue.png
    :target: http://www.gnu.org/licenses/agpl-3.0-standalone.html
    :alt: License: AGPL-3
.. |badge3| image:: https://img.shields.io/badge/github-OCA%2Fproduct--attribute-lightgray.png?logo=github
    :target: https://github.com/OCA/product-attribute/tree/12.0/product_active_propagate
    :alt: OCA/product-attribute
.. |badge4| image:: https://img.shields.io/badge/weblate-Translate%20me-F47D42.png
    :target: https://translation.odoo-community.org/projects/product-attribute-12-0/product-attribute-12-0-product_active_propagate
    :alt: Translate me on Weblate
.. |badge5| image:: https://img.shields.io/badge/runboat-Try%20me-875A7B.png
    :target: https://runboat.odoo-community.org/builds?repo=OCA/product-attribute&target_branch=12.0
    :alt: Try me on Runboat

|badge1| |badge2| |badge3| |badge4| |badge5|

This module extends the functionnaly of Odoo Product module.

By default, in Odoo,
- when a user disable a template, it will disable the related variants.
- when a user enable a template, it will enable the related variants.

But if a user disables all the variants of a template, the related template
will still remain active, what doesn't make sense in many case,
and which will force the user to disable the template as well,
to avoid seeing the obsolete template.

This module avoids having inconsistent states between the active field of the varinats
and the active field of the template.

Once installed:

- if a user disables a variant, it will disable the template, if all the variants
  are disabled.

- if a user enables a variant, it will enable the template.

**Table of contents**

.. contents::
   :local:

Installation
============

If you are installing this module on a database with existing data, you could want
to execute the two following SQL requests, to fix some inconsistent data.


* Disable templates that do not have a single variant active

.. code-block:: sql

    UPDATE product_template pt
    SET active = false
    WHERE id in (
        SELECT pt.id
        FROM product_template pt
        INNER JOIN product_product pp on pp.product_tmpl_id = pt.id
        WHERE pt.active = true
        GROUP BY pt.id
        HAVING sum((pp.active)::int) = 0
    );


* Enable templates that have at least one active variant

.. code-block:: sql

    UPDATE product_template pt
    SET active = true
    WHERE id in (
        SELECT pt.id
        FROM product_template pt
        INNER JOIN product_product pp on pp.product_tmpl_id = pt.id
        WHERE pt.active = false
        GROUP BY pt.id
        HAVING sum((pp.active)::int) != 0
    );

Development
===========

* This module fixes a current limitation mentionned here : https://github.com/odoo/odoo/pull/60648
* Do not port this module in V13, as it seems to be fixed here : https://github.com/odoo/odoo/pull/60536

Bug Tracker
===========

Bugs are tracked on `GitHub Issues <https://github.com/OCA/product-attribute/issues>`_.
In case of trouble, please check there if your issue has already been reported.
If you spotted it first, help us to smash it by providing a detailed and welcomed
`feedback <https://github.com/OCA/product-attribute/issues/new?body=module:%20product_active_propagate%0Aversion:%2012.0%0A%0A**Steps%20to%20reproduce**%0A-%20...%0A%0A**Current%20behavior**%0A%0A**Expected%20behavior**>`_.

Do not contact contributors directly about support or help with technical issues.

Credits
=======

Authors
~~~~~~~

* GRAP

Contributors
~~~~~~~~~~~~

* Sylvain LE GAL (https://www.twitter.com/legalsylvain)

Maintainers
~~~~~~~~~~~

This module is maintained by the OCA.

.. image:: https://odoo-community.org/logo.png
   :alt: Odoo Community Association
   :target: https://odoo-community.org

OCA, or the Odoo Community Association, is a nonprofit organization whose
mission is to support the collaborative development of Odoo features and
promote its widespread use.

This module is part of the `OCA/product-attribute <https://github.com/OCA/product-attribute/tree/12.0/product_active_propagate>`_ project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.


