how to export sku and price from databse to xml

[RockMariska]

Hi,

I'm hoping someone can help me out,

I would need an export from the magento 2 database with the tables sku and prices into a xml.

I'm on magento 2.3.6 and have a multistore.

While searching in the database I'm really getting lost in there...

Thank You ;-)

[Sanjay Jethva · Accepted solution]

@RockMariska  

Pass the below SQL query in phpmyadmin.

SELECT catalog_product_entity.sku , catalog_product_entity_decimal.value
FROM catalog_product_entity
INNER JOIN catalog_product_entity_decimal ON catalog_product_entity.entity_id=catalog_product_entity_decimal.entity_id where catalog_product_entity_decimal.attribute_id=77;

https://drops.meetanshi.com/OFlVEs

[RockMariska]

@Sanjay Jethva Awesome!

Thank you so much for your time and help!

That really makes my life way easier :-)

wishing you a great weekend, kind regards

[Sanjay Jethva]

I’m glad that you find the required solution! 🙂