vasilii-b

The bellow Fastly recv ACL rule will allow to redirect the users to a custom maintenance page (even a CMS page if you like) for a specific domain.

It will still allow the /media and static content (themes) files to be viewed - which allows to build custom maintenance pages right in the admin area with CMS Pages.

Also, it's taking into account the list of IPs to whitelist from the redirect using the Fastly Edge ACL - in this example the name is maint_allowlist.

This comes in hand when you've got an Adobe Commerce/ Magento 2 instance powering multiple websites. That's because with the

vasilii-b

I logged into each node on Staging and Production ( 3 nodes each, but might be different for you) and ran the following command to gather the public IP of the node:

curl -4 icanhazip.com

vasilii-b

What is this about

• Remove all the products from the Adobe Commerce / Magento 2
• Remove the product's assigned inventory (MSI)
• Remove the product's custom attributes
• Remove the URL Rewrites for the products

⚠️ Disclaimer

• This is only steps executed on certain instance, not take it for granted it will work smooth for you

vasilii-b

select ea.attribute_code, eaov.value
from eav_attribute as ea
left join eav_attribute_option as eao on ea.attribute_id = eao.attribute_id
join eav_attribute_option_value eaov on eao.`option_id` = eaov.option_id
where ea.attribute_code like "%_range"
order by ea.attribute_code

vasilii-b

select
    cae.entity_id as "Address ID",
	cae.parent_id as "Customer ID",
	c.firstname,
	c.lastname,
	c.email,
	cae.country_id,
	cae.city,
	cae.postcode,
	cae.region as "Current Address Region",

vasilii-b

select cpe_parent.entity_id as 'Parent ID', cpe_parent.sku as 'Parent Sku', count(cpe_child.entity_id) as 'Child #', cpe_child.sku as 'Child Sku'
from catalog_product_entity cpe_parent
join catalog_product_link cpl on cpe_parent.type_id = 'grouped' and cpl.link_type_id = 3 and cpe_parent.row_id = cpl.product_id
left join catalog_product_entity cpe_child on cpl.linked_product_id = cpe_child.entity_id
group by cpe_parent.sku
order by 'Child #' DESC

vasilii-b

source: https://savedlog.com/uncategorized/letsencrypt-ssl-certificate-namecheap-hosting/

The “Positive SSL” certificate I bought along with my domain is invalid with any of my subdomains and cannot be used with wildcards. One annoying thing is that namecheap doesn’t offer auto installation of free let’s encrypt certificates, even though, they are saying “Namecheap is dedicated to data security and privacy for all internet users. We believe the movement to encrypt nearly all web traffic is a positive direction. As more sites embrace HTTPS and use of security products, providers of free SSL are beginning to come online.”

Let me show you what it needs to be done in order to “encrypt nearly all web traffic”.

First, not required but it’s helpful to enable ssh access, it is not enabled by default on the base hosting plans, just go an start a live chat and request ssh access.

vasilii-b

Magepal GA4 <> Klevu Search using JS Templating

The files mentioned in the gist are supposed to be added under a custom theme (app/design/frontend/<vendor>/theme) inside the folder Klevu_Search.

Alternatively, the same could be achieved by having the files (layouts, templates) inside a custom module.

vasilii-b

df -h | grep 'mysql\|Filesystem'

vasilii-b

SELECT table_schema "Data Base Name",
    SUM( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
    SUM( data_free )/ 1024 / 1024 "Free Space in MB"
    FROM information_schema.TABLES
    GROUP BY table_schema;