tem description data seems to be available on Magento db while trying to make the PUT call but not

[sonusaini9e0f7]

tem description data seems to be available on Magento db while trying to make the PUT call but not visible on GUI anywhere

We are using Magento API to update inventory of item using our middleware. However, we recently noticed that we are successfully able to update item description (among other data) on the Magento db but that change is not visible on the GUI anywhere, whether in the Magento admin or on the actual website front.

I am attaching the PUT request highlighting the changed desc that we are updating on the db, also sharing a screenshot from the Magento admin . When we make GET call from the Magento db, we get the same updated desc but it is not showing on the GUI anywhere.

curl --location --request PUT 'https://mp.simsolutionspvt.com/index.php/rest/default/V1/products/-2309899016366312333' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer xxxxxxxxxx' \
--header 'Cookie: PHPSESSID=x' \xxxxxxxxx
--data '{
    "product": {
        "price": "480000.00",
        "extension_attributes": {
            "stock_item": {
                "qty": 35,
                "manage_stock": true,
                "is_in_stock": true
            },
            "category_links": [
                {
                    "position": 1,
                    "category_id": "308"
                }
            ]
        },
        "custom_attributes": [
            {
                "attribute_code": "description",
                "value": "<p><span style=font-family: arial, helvetica, sans-serif; color: #000000;>A TESTTT white ggg floral fragrance inspired by the tragic predicament of Madame Butterfly. In honour of truth and beauty, her poetic love and sorrow echo eternally.</span></p><ul><li><span style=color: #000000; font-family: arial, helvetica, sans-serif;><strong>Top Notes:</strong>&nbsp;Pepper, Rhubarb Leaves, Coriander.</span></li><li><span style=color: #000000; font-family: arial, helvetica, sans-serif;><strong>Heart Notes:</strong>&nbsp;Jasmine, Tuberose, Gardenia, Lily of the Valley, Carnation.</span></li><li><span style=color: #000000; font-family: arial, helvetica, sans-serif;><strong>Base Notes:</strong>&nbsp;Vetiver, Frankincense, Amber, Opoponax, Leather tt</span></li></ul>"
            },
            {
                "attribute_code": "brand",
                "value": "79431"
            }
        ]
    }
}'

The word TESTTT in the desc is the addition we are making.

Below is screenshot:

[Ankit Jasani]

Hi @sonusaini9e0f7 ,

Magento uses per-store view scope for EAV fields like description. If you update the description without specifying the correct store scope, the value may be saved for a different store (e.g., Admin store = store ID 0), and won’t be visible in other store views in the Admin.

Check the catalog_product_entity_text table for attribute_id of description and store_id = 0. If the data is there but not showing in Admin, it's likely a store scope mismatch.

Problem Solved? Accept as Solution!

Thanks,

Ankit