Darren Felton dfelton

Anatomy of Magento 2: Layered Navigation

Points for investigation

Generate high-level overview of all the main components
How are the total item counts for each option generated?
How is the catalog updated to display the matching products?
How are options rendered?
What are the customisation points?
What events are dispatched?

Adding trusted root certificates to the server

Mac OS X

sudo security add-trusted-cert -d -r trustRoot -k /Library/Keychains/System.keychain ~/new-root-certificate.crt
sudo security delete-certificate -c "<name of existing certificate>"

Windows

certutil -addstore -f "ROOT" new-root-certificate.crt

Purpose

The purpose of this SQL script is to clean up a Magento 1.x database by deleting orphaned records from database tables which cause foreign key contraint failures. This happens when at some point in time records where deleted from the database while FOREIGN_KEY_CHECKS = 0 and the person performing the delete operations failed to delete all related records pertaining to related tables of the primary table.

This script can be helpful when encountering foreign key constraint failures using the Data Migration Tool to migrate your

Quick Reference Guide for creating new attributes via an installer script for EAV and flat table entity types.

Image
Yes/No
Select
WYSIWYG
[Default Values Reference](https://gist.github.com/dfelton/8ca84c94ee0b57e346a3e7469d814214#file-

Numerous SQL snippets to reference for pulling data straight from Magento's database.

All SQL snippets assume there is no database table name prefix configured. In the event that your database does have a table nameprefix, you should be able to simply update the original table names found in the "FROM" and "LEFT JOIN" declarations. All table names are aliased therefore a full revision of the SQL snippets would not be necessary.

Scripts for synching a development Magento database database with it's live counterpart.

	# Git
	git_branch() {
	git branch 2> /dev/null \| sed -e '/^[^]/d' -e 's/ \(.*\)/(\1)/'
	}
	export PS1="\u@\[\033[32m\]\w\[\033[33m\]\$(git_branch)\[\033[00m\]\$ "

	# Aliases
	alias la='ls -la'

	grep CDATA <srcdom>/httpdocs/shop/app/etc/local.xml
	grep CDATA <dstdom>/httpdocs/shop/app/etc/local.xml
	mysqldump -u <srcdb> -p --no-data -h <dbhost> <srcdb> \| mysql -u <dstdb> -p -h <dbhost> <dstdb>
	mysqldump -u <srcdb> -p --ignore-table=<srcdb>.dataflow_batch_export --ignore-table=<srcdb>.dataflow_batch_import --ignore-table=<srcdb>.log_customer --ignore-table=<srcdb>.log_quote --ignore-table=<srcdb>.log_summary --ignore-table=<srcdb>.log_summary_type --ignore-table=<srcdb>.log_url --ignore-table=<srcdb>.log_url_info --ignore-table=<srcdb>.log_visitor --ignore-table=<srcdb>.log_visitor_info --ignore-table=<srcdb>.log_visitor_online --ignore-table=<srcdb>.report_viewed_product_index --ignore-table=<srcdb>.report_compared_product_index --ignore-table=<srcdb>.report_event -h <dbhost> <srcdb> \| mysql -u <dstdb> -p -h <dbhost> <dstdb>

	Adyen Test Card Numbers
	These cards are only valid on our TEST system and they will never involve any actual transaction or transfer of funds. The TEST card numbers will not work on the Adyen LIVE Platform.

	For all cards use the following expiration and CVV2/CVC2/or CID for Amex.

	For all cards:

	Expiration Dates CVV2 / CVC3 CID (American Express)
	08/2018 OR 10/2020 737 7373

	#! /usr/bin/env python
	# -- coding: utf-8 --

	import os
	import re
	import subprocess
	import sys

	from ansible.callbacks import display, banner