Product wholesale_price update

[George-Cara]

Prerequisites

• I understand and accept the project's code of conduct.
• I have already searched in existing issues and found no previous report of this bug.

Describe the bug and add attachments

When changing the product wholesale price on product page (no matter what shop you're in) the wholesale_price column of ps_product table will be set to 0. The value is updated only in ps_product_shop.

Expected behavior

The wholesale_price should be updated in ps_products as well

Steps to reproduce

1. Go to a product page and update the wholesale price.
2. Go to ps_product table in your database and you will see wholesale_price set to 0
3. Alos check wholesale_price in ps_product_shop and you will see it modified as expected

PrestaShop version(s) where the bug happened

8.0.2

PHP version(s) where the bug happened

7.4

If your bug is related to a module, specify its name and its version

No response

[AureRita]

Hi @George-Cara ,

I reproduce the issue with PrestaShop versionn 8.0.1, as you can see :

Untitled_.Mar.23.2023.4_55.PM.webm

I'll add this to the backlog so it can be fixed.

Please be aware that some issues might take a very long time to be resolved. If this one is important to you and you cannot wait for it to be fixed on the project’s own time, we strongly suggest you consider contacting a professional to help you.

If you fix the issue on your end, please contribute it back to the project. Remember that the more people contribute, the better PrestaShop becomes for everyone.

Thanks

[clotairer]

Sample workarround

    public function hookActionObjectCombinationUpdateAfter($params)
    {
        /** @var \Combination $combination */
        $combination = $params['object'];
        $product = new \Product($combination->id_product);

        $sql = 'UPDATE `' . _DB_PREFIX_ . 'product` ' .
            'SET ' .
            'wholesale_price = "%s" ' .
            'WHERE id_product = %d';

        \Db::getInstance()->execute(
            sprintf(
                $sql,
                pSQL($product->wholesale_price),
                $product->id
            )
        );
    }

Tricky to fix with a Pull Request.
In fact, there is a conflict with wholesale_price set to 0 by wholesale_price by supplier in the option tab.