This article covers: How to use Excel VLooup function to compare columns in two spreadsheets, then return value if there are matched fields between the two columns. A Common Scenario: You have two spreadsheets: one has columns such as ID, Name and Phone Number, the other has ID, Name and Email Address; and you would […]
Author: Ethan
To many, a business is a lifetime commitment. It's easy to start one yet difficult to make it successful. Attitude, skills, experiences and dedication help hone the craft along the way, but it's often the great vision and resilience to remain focused wins the game. Read more about me here
This article covers: How to upgrade from http/1.1 to http/2 on a web server. The Server Environment: Sever OS – Ubuntu 18.0.4 PHP Version – 7.1 Apache Version – 2.4.33 Apache MPM (Multi-Processing Module) prefork is used by PHP Steps If you’re running Apache 2.4, most likely you will have http2 module already installed, all […]
This article covers: The building blocks and data processing methods of Google Analytics, such as: Scope Segments Filters Dimensions Metrics Scope Scope defines the way how data is collected. As it’s clearly define in Google Analytics, Scope has 4 types: User data Session data Hit data Product Data A hit is single action users perform […]
This article covers: How to access your Google Cloud VM instance when SSH login fails? How to use GCP Serial Console to address your SSH connection issues? We had an issue with GC VM instance denied our SSH access even with the web console. It turned out to be a mistake made when editing Now […]
This article covers: How to add new SSH user to your Google Cloud VPS This article is suitable for: Google Cloud VM Instance OS: Ubuntu 18.04 SSH clients: Putty, Pageant Step 1 – Generate Public/Private Key Pair Step 2 – Add Public Key Download your public and private pair to your PC. Open public key, […]
This article covers: How to perform SEO audits for information websites? Introduce some of the commonly used technical SEO audit techniques This article’s target audiences: Business owners who want to improve their website’s search ranking This article’s scope: Information websites Google Search Engine We all agree that top ranking is a good thing because it […]
This article covers: How to delete a large number of products in Magento 1.9 How to delete Magento products by attribute set The server environment: Apache 2.4, PHP 7.1 Magento 1.9.3.7 These days most Magento stores would have some sort of integration with third-party inventory solutions, and sometimes unwanted products get accidentally pushed from inventory […]
This article covers: How to add website switcher in a multi-website environment How to extend the default Magento Store module The server environment: Apache 2.4, Ubuntu 18.04 Magento 2.3.0 Multi-website configuration, in this case each website has one store view Point it out if incorrect: it appears to us that up until 2.3 there is […]
This article covers: How to change default product image sizes in Magento 2 product image cache How to resolve Magento 2’s aggressive image compression The server environment: Apache 2.4, Ubuntu 18.04 Magento 2.2.6 upgraded to 2.3.0 Used imagemagick instead of GD2 After realising Magento 2 has such an aggressive image compression method, I’ve spent quite […]
This article covers: How to generate CSR (certificate signing request), which is required before when you purchase an SSL. How to install SSL in a shared hosting environment How to redirect http to https The server environment: Apache 2.4, Ubuntu 18.04 Certificate purchased from RapidSSL Online and issued by GeoTrust. Website platform can be either […]