- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2021
04:14 AM
06-03-2021
04:14 AM
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 ;-)
Solved! Go to Solution.
Labels:
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2021
09:30 PM
06-03-2021
09:30 PM
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.
200+ Magento 2 Extensions for Enhanced Shopping Experience.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2021
09:30 PM
06-03-2021
09:30 PM
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.
200+ Magento 2 Extensions for Enhanced Shopping Experience.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2021
04:40 AM
06-04-2021
04:40 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2021
05:32 AM
06-04-2021
05:32 AM
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.
200+ Magento 2 Extensions for Enhanced Shopping Experience.