Adding New Columns to the Orders, Invoice, and Credit Memo’s Grid in Magento 2

Published by John on January 27, 2021

One of my clients needed to be able to export orders, with just a little more information than is provided by the default order export in Magento 2. So, I added some additional columns to the grid, which in turn allowed them to export the orders.

As noted in this guide, this isn’t a great permanent solution, but if you just need a quick/temporary way of adding some additional fields to the order, invoice, and credit memo grid, this should suffice.

Read More  |  Add Comment

The Case of the Broken Magento 2 Breadcrumbs

Published by John on December 15, 2020

Recently, I ran into an odd issue, where in some cases, breadcrumbs were not working on product pages for a Magento 2.4 Ecommerce store. There didn’t seem to be much rhyme or reason to it, as some products would work, but others would not, so after playing with settings and disabling/enabling plugins, I dug into […]

Read More  |  Add Comment

Using GDAL to Convert a KAP Nautical Chart to a Zoomable MBTile File

Published by John on October 11, 2020

Recently, I wanted to convert a NOAA chart to a different format, so that I could plot one of my GPS courses on top of the chart, to create a cool looking overlay. I settled on MBTiles as the format, which stores raster or vector tilesets in a SQLite database. Initially, I attempted to convert […]

Read More  |  Add Comment

Magento 2: Fixing Mysql Triggers After Changing Database User

Published by John on October 2, 2020

While doing some testing in preparation of a Magento 2.3.2 upgrade for a client, I preformed several dry runs using their production MYSQL database on the staging site, so that I could identify and fix any bugs or issues with the upgrade process.

After doing the import, I ran into an issue saving products, because the triggers in the copied database were setup to use the production MariaDB user, but the staging site was using a different user. Next time, I will do a sed on the database prior to import, so that I can fix then, but it is also possible to dump only the triggers from the database, update the user, then re-import with the correct user.

Read More  |  Add Comment

Magento 2: Adding a Custom PHTML Template to Core Widget

Published by John on September 24, 2020

While working on a Magento 2 website, I wanted to add a custom template to an existing Magento 2 Widget, without over-riding the existing template. This is quite easy to do, by adding an entry to your widget.xml file.

Read More  |  Add Comment

Next Page »