cancel
Showing results for 
Search instead for 
Did you mean: 

how to export sku and price from databse to xml

SOLVED

how to export sku and price from databse to xml

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 ;-)

1 ACCEPTED SOLUTION

Accepted Solutions

Re: how to export sku and price from databse to xml

@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
 
Problem solved? Click Kudos and "Accept as Solution".
200+ Magento 2 Extensions for Enhanced Shopping Experience.

View solution in original post

3 REPLIES 3

Re: how to export sku and price from databse to xml

@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
 
Problem solved? Click Kudos and "Accept as Solution".
200+ Magento 2 Extensions for Enhanced Shopping Experience.

Re: how to export sku and price from databse to xml

@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

Re: how to export sku and price from databse to xml

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

 

Problem solved? Click Kudos and "Accept as Solution".
200+ Magento 2 Extensions for Enhanced Shopping Experience.