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.
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.
While trying to connect to a Windows Server VPN, which was setup using L2TP VPN w/IPSEC, using the Gnome NetworkManager plugin, I ran into a few issues. Partly this was due to both the Server and Client being behind a NAT device, which is of course the most common setup for most users. However, there were a couple other settings that needed to be fixed before I was able to connect to the VPN on Linux.
While launching a website for one of our hosting clients that uses WooCommerce, it was necessary to import products and orders from their old shop to their new one.
This could have been avoided had the developers used a copy of the website database, rather than starting over with a brand new WordPress database. However, by the time they brought me in, that was no longer feasible.
I was able to import the WooCommerce products, including all variable products, using the built in product import/export tool, but needed to find a different solution to import the orders.
This process will not work in all cases, but in some instances, it is possible to do the order import and export directly from the database, rather than using a paid plugin.
While setting up a test Magento 2 website, running the latest verison of Magento 2.4, I ran into an issue logging in: Two Factor Auth.
Due to the way my development server is setup, using two factor auth is not really needed, nor feasible.
However, this can be turned off so that you can access the Magento 2 backend without using it, by disabling the Magento_TwoFactorAuth module.