cancel
Showing results for 
Search instead for 
Did you mean: 

Get custom attribute text via MySQL

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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!

3 REPLIES 3

Re: Get custom attribute text via MySQL

I recommend to implement it as a Magento 2 extension, which is executed by Cron.

Re: Get custom attribute text via MySQL

I've looked but I can't find any Smiley Sad

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