- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Get custom attribute text via MySQL
I'm currently writing a PHP script (outside of my Magento 2 installation) that I will run on cron. This script sends orders to a supplier in a JSON format. I've managed to get most of the data I need but I'm struggling to get my custom attribute values of "size" and "colour". Does anybody know exactly which tables and ID's link to each other so that I can get the data? I've been trying to work it out for hours and I'm really struggling!
I hate to have to write a dirty script to do it this way, but I have no idea how to use the API to do this request and following the docs didn't really make it any clearer for me.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Get custom attribute text via MySQL
I recommend to implement it as a Magento 2 extension, which is executed by Cron.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Get custom attribute text via MySQL
I've looked but I can't find any
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Get custom attribute text via MySQL
How can a Magento 2 extension schedule a cron job with a crontab.xml file: https://mage2.pro/t/576