Recently, I received the following request from a client…
How can I get an export of all the options for a given attribute in Magento?
There are several attributes I need to do this for…
Looking at the Magento admin panel, it quickly became evident that there was no self-serve way for the client to export the data.
Here I’ll document my approach, which ultimately led me to the Table Capture Chrome extension.
The first thing I tried was to simply copy / paste the data from the web page into Excel.
As you can see below, that didn’t work out too well…
I did some quick Googling and found a script published by Peter Jaap that would generate an export of all attributes and attribute options in a given Magento system. While this was nice, this script would set me down one of the following paths…
Neither of these solutions seemed ideal.
Then, I had another idea - I wonder if there’s a browser extension that could be installed to do exactly this?
Another quick round Googling later I found the “Table Capture” Chrome extension. I did some quick testing and found that it could do exactly what the client was asking. It works something like this…
<table>element on the page.
I sent the client these instructions along with some screenshots demonstrating how to use the tool. I heard back shortly thereafter from the client this solution worked perfectly for their needs.
Request resolved, no coding required. Mission accomplished
Hi, I'm Max!
If you'd like to get in touch with me the best way is on Twitter.