I am very new to magento. What is the query to to know who was the user who updated the price of a product?

I just want to know the query, not the code.

Thanks in advance.

1 Answer 1


If you're talking about which admin user updates a product via the admin, this info will only exist if you're using the Commerce version. If you're using the community version I'm afraid this data won't exist in Magento. There are lots of custom modules that will log this info from the admin.

If you are using Commerce, you can run:

SELECT e.*,JSON_EXTRACT(info,'$.general') FROM magento.magento_logging_event e
where event_code = 'catalog_products'
and JSON_EXTRACT(info,'$.general') = "<ID of the product>"

This will show you who has saved that product and when, but it doesn't have the data to show what specifically was updated.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.