Darren Felton dfelton

These set of scripts are for Magento 1. For Magento 2, see this Gist.

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

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.

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-

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

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

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?

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

	import os
	import re
	import subprocess
	import sys

	from ansible.callbacks import display, banner

	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

	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>