Needed to retrieve all the Meta Titles, Descriptions & Keywords from Magento’s vanilla install. There is no method to importing SEO Data for Categories in Magento 2 without a Third Party plugin. Hopefully this query will help those extract the …Continue reading
Quick lill’ snippet to fetch the Category Tree of your Store by a given Store name, in MySQL.
Had to discover the current list of SEO keywords & titles for Magento. This is the native Category Meta Titles & Descriptions, excluding any SEO plugins or modules.
Had to query the Database directly for a Attribute Value of a SKU – which was quicker than writing an entire module to pick out a single value. Replace SKU_NAME with the SKU you’re attempting to find, and the ATTR_NAME is …Continue reading
I had this appearing when attempting to restart an the MySQL service after upgrading to MySQL 5.7 from 5.5 on Ubuntu. After some research, it was the system /etc/passwd file had ultimately changed after the install. Whereas :/nonexistent should appear …Continue reading