I’m writing this because I’ve been stupid enough to buy some clothes in a shopify store after an ad I saw on Facebook. Basically: I saw the ad on Facebook, there was a beautiful and warm legging I wanted to buy for my wife I entered the site and I Read more…
Are you tired of clicking enter and enter to see the mysql processlist from command line? Now you can use watch to see the live processlist:
If you develop for Magento 2, you might have run into Catalog URL indexing issues like duplicated urls and constraints. There are many posts and answers about it on the net. After trying many free modules, this was the good one: https://github.com/karliuka/m2.IndexerUrlRewrite It adds Product, Category and Catalog reindex to Read more…
I’ve been looking for a solution that works fine in Magento 2.3 to move billing address to shipping step in Magento 2.3. There aren’t many available solution online but I’ve found one that works fine with a couple of modifications. Pull request haven’t been accepted in the original repo, but Read more…
The error: Is related to a product which doesn’t have a SKU. This might cause different issues: Indexation problems » URL Rewrites not created Product Grid sorting issues: can’t sort by sku The solution should be easy. Go to your database and check which products don’t have an SKU: Once Read more…
One of the trickiest errors I’ve found when Migrating Magento 1 to Magento 2 (2.3) has been an issue related to unserialization. There are 2 types of messages I received: Reason: in both cases, the reason is that some data that was stored serialized in the Magento 1 database, had Read more…
Noting down the errors and possible solutions I get while migrating data from Magento 1 to Magento 2. In the data integrity step we can find many type of errors. Here you have some of them, explanation and solution: Error Foreign key (FK_CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID) constraint fails on source database. Orphan records Read more…
Recently I had to modify the customer registration form from one of the websites I manage. VAT ID had to be included but only for professional customers. This meant that when a customer clicked on the «I’m a professional» field, new fields should show up and, the most important, the Read more…
One of the good security practices in Magento (either 1 or 2) is to protect your backoffice url with password using htpasswd (directly in the Apache conf or in the htaccess file). It is not the perfect solution, but it adds an extra layer of security which: Will prevent anyone Read more…
Cleaning the cache by TAG is quite easy in Magento 2. You will need to: Inject the classes in your construct function Know the exact tags you want to cache Flush the actual Cache Start creating your class injecting the classes we need: Create a function to retrieve the tags Read more…