quantity_and_stock_status display result is wrong in product listing(Grid).

[karangar]

Preconditions

I have added product attribute(quantity_and_stock_status) column in catalog product admin grid for the filtering the "In Stock" and "Out of Stock" products list.

1.Magento 2.2.4

Steps to reproduce

1. Go to Magento 2 admin => Stores => Attributes => Product => Search attribute code "quantity_and_stock_status".
2. Change "Advanced Attribute Properties" settings Scope => "Store view/Global", "Add to Column Options" to "Yes" and set "Use in Filter Options" to "Yes".
3. Now product attribute Quantity(quantity_and_stock_status) will be visible in to the catalog product settings Columns section and checked it to yes.
4. Make Product "Out of Stock" and Save it Flush/Refresh the Cache And also re-indexing it.
5. Check quantity_and_stock_status display result in product Grid and edit this product and check stock status.

Expected result

1. quantity_and_stock_status display result "Out of stock" if product is Stock status "Out of stock" in product Grid.

Actual result

1. Check product grid Screen shot.
   
2. check same product edit page into product is out stock
   

[karangar]

This issue is already generated in #15201

[karangar]

Any update ?

[ghost]

Hello @karangar, thank you for your report.
We've acknowledged the issue and added to our backlog.

[sylvainraye]

I confirm the issue. We have the same by a merchant. Investigation in progress on our side for a fix

[sylvainraye]

Here is a statement of my first analyzes regarding "quantity_and_stock_status" attribute:

1. the attribute is not supposed to be used in grid, however that's the only way to have the column "Quantity" (in fact "Stock") and view "In Stock"/"Out of Stock" in grid view
2. the attribute is in fact used internally to set an array of "is_in_stock" and "qty" to be used in product edit form. That's why it's not supposed to be used in grid. Why ? No clue at the moment
3. in Standard in can't be used as a filter because the value "1" is always saved in the database because that's the default value when the attribute is missing while saving a product due to an observer which remove it before save event \Magento\CatalogInventory\Observer\ProcessInventoryDataObserver
4. The only way to fix that easily looks like to change the logic of the observer "\Magento\CatalogInventory\Observer\ProcessInventoryDataObserver" and set a 0 or 1 value to the attribute if the product is in stock

I give a try to see if it's working

[vteofilo]

This worked for me:

As I have a specific function to update inventory that extends \Magento\CatalogInventory\Model\StockRegistry, I called inside it, but if you use Magento itself you should create a plugin to be called after you have run the function Magento\CatalogInventory\Model\StockRegistry::updateStockItemBySku(). At each inventory update, this function updates the is_in_stock status of the parent product by adding the items of the child products:

`

public function syncProductStock(int $productId)
{
    $product = $this->productFactory->create();
    $product->load($productId);

    $productParent= $this->productFactory->create();
    $productParent->load(
        $this->objectManager->get(\Magento\ConfigurableProduct\Model\ResourceModel\Product\Type\Configurable::class)
            ->getParentIdsByChild($productId)
    );

    $childrenIds = array_values(
        $this->objectManager->get(\Magento\ConfigurableProduct\Model\ResourceModel\Product\Type\Configurable::class)
            ->getChildrenIds($productParent->getId())[0]
    );
    $sumQuantity = 0;
    foreach ($childrenIds as $childrenId) {
        $productChildren = $this->productFactory->create();
        $productChildren->load($childrenId);
        $sumQuantity += $this->objectManager->get(\Magento\CatalogInventory\Model\StockRegistry::class)
            ->getStockItem($childrenId)->getQty();
    }

    $isInStock = $sumQuantity > 0 ? 1 : 0;
    $product->addAttributeUpdate('quantity_and_stock_status', $this->getStockItem($productId)->getIsInStock(), $product->getStoreId());
    $productParent->addAttributeUpdate('quantity_and_stock_status', $isInStock, $product->getStoreId());

    $parentStockItem = $this->getStockItem($productParent->getId());
    $parentStockItem->setIsInStock($isInStock);
    $this->stockItemRepository->save($parentStockItem);
}`

Hope this helps! Thank you!

[krotus]

#SQUASHTOBERFEST

[magento-engcom-team]

@krotus thank you for joining. Please accept team invitation here and self-assign the issue.

[magento-engcom-team]

Hi @krotus. Thank you for working on this issue.
Looks like this issue is already verified and confirmed. But if your want to validate it one more time, please, go though the following instruction:

• 1. Add/Edit Component: XXXXX label(s) to the ticket, indicating the components it may be related to.

• 2. Verify that the issue is reproducible on 2.3-develop branch

  Details

  - Add the comment @magento-engcom-team give me 2.3-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.3-develop branch, please, add the label Reproduced on 2.3.x.
  - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!

• 3. Verify that the issue is reproducible on 2.2-develop branch.

  Details

  - Add the comment @magento-engcom-team give me 2.2-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.2-develop branch, please add the label Reproduced on 2.2.x

• 4. If the issue is not relevant or is not reproducible any more, feel free to close it.

[magento-engcom-team]

Hi @XxXgeoXxX. Thank you for working on this issue.
Looks like this issue is already verified and confirmed. But if your want to validate it one more time, please, go though the following instruction:

• 1. Add/Edit Component: XXXXX label(s) to the ticket, indicating the components it may be related to.

• 2. Verify that the issue is reproducible on 2.3-develop branch

  Details

  - Add the comment @magento-engcom-team give me 2.3-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.3-develop branch, please, add the label Reproduced on 2.3.x.
  - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!

• 3. Verify that the issue is reproducible on 2.2-develop branch.

  Details

  - Add the comment @magento-engcom-team give me 2.2-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.2-develop branch, please add the label Reproduced on 2.2.x

• 4. If the issue is not relevant or is not reproducible any more, feel free to close it.

[github-jira-sync-bot]

✅ Jira issue https://jira.corp.magento.com/browse/AC-1031 is successfully created for this GitHub issue.

[m2-assistant]

✅ Confirmed by @engcom-Alfa. Thank you for verifying the issue.
Issue Available: @engcom-Alfa, You will be automatically unassigned. Contributors/Maintainers can claim this issue to continue. To reclaim and continue work, reassign the ticket to yourself.

[engcom-Bravo]

HI @karangar,

Thanks for your reporting and collaboration.

We have verified the issue in Latest 2.4-develop instance and the issue is no more reproducible.

Hence We are closing this issue.

Thanks.