erikhansen

[xdebug]
xdebug.profiler_enable_trigger=on
xdebug.remote_autostart=off
xdebug.remote_enable=1
xdebug.remote_host=127.0.0.1
xdebug.remote_port=9000
xdebug.remote_handler=dbgp
xdebug.idekey=ECLIPSE_XDEBUG
xdebug.collect_vars=on
xdebug.collect_params=4

erikhansen

<?php
return array (
  'backend' =>
    array (
      'frontName' => 'backend',
    ),
  'crypt' =>
    array (
      'key' => '<KEY>',
    ),

erikhansen

-- When products are added/removed from a category this table stores all the relation data
select * from catalog_category_product where product_id = '218';

-- The index that is used for presenting products in a category on the frontend
select * from catalog_category_product_index where product_id = '218';

-- The change log table used for Magento EE partial index functionality
select * from catalog_category_product_index_cl where product_id = '218';

-- The cron job that gets executed on each cron execution - check for errors

erikhansen

// /**
//  * Copyright © 2015 Magento. All rights reserved.
//  * See COPYING.txt for license details.
//  */

//
//  Responsive
//  _____________________________________________

//

erikhansen

How to create a global git commit hook by Matt Venables

1 Enable git templates (This tells git to copy everything in ~/.git-templates to your per-project .git/ directory when you run git init):

git config --global init.templatedir '~/.git-templates'

2 Create a directory to hold the global hooks:

mkdir -p ~/.git-templates/hooks

erikhansen

<?php
return array (
  'backend' =>
    array (
      'frontName' => 'backend',
    ),
  'crypt' =>
    array (
      'key' => '<KEY>',
    ),

erikhansen

# Setup local directory with braintree example and libraries
git clone git@github.com:braintree/braintree_php_example.git
cd braintree_php_example
composer install

# Create and define configuration options
echo '
BT_ENVIRONMENT=sandbox
BT_MERCHANT_ID=xxxxxxxxxxxx
BT_PUBLIC_KEY=xxxxxxxxxxxx

erikhansen

/*
* IMPORTANT: The queries below are written for Magento Enterprise. If you're going to run them on Magento Community, you need
* to replace all instances of ".row_id" with ".entity_id". See this for context: http://magento.stackexchange.com/questions/139740/magento-2-schema-changes-for-ee-catalog-staging
*
* When importing products in Magento 2, if you specify store view codes in the store_view_code column, product data will be set at 
* both the global scope as well as the specific store view scope. This is not ideal because now you have duplicate
* data at two different scopes that shouldn't actually be duplicated. The scripts below clean up this data by finding
* data set at specific store view scopes and if it's an exact match to the data set at the global store view, then it
* deletes the data set at the specific store view scope.
*

erikhansen

/*
Run the following query to get a set of queries that will purge all tables of email addresses. The queries that are output from 
this should be manually reviewed to remove queries for any unnecessary tables and can then be run manually or via a Magerun "db:query" 
to include it as a part of a scripted cloning process.
IMPORTANT: Make sure to update the @db_name variable

What the resulting query will do:
-- Replace the emails in Magento with dummy emails (unless email is one of the whitelisted domains) in order to prevent emails erroneously being sent to  customers.
-- Make all emails with @example.com and use and MD5 of the original domain of the email as the tag for the email. This is important in case we have two emails with the
-- same "local part" but different "domain part". For example, bob.smith@yahoo.com would become bob.smith+c9d12f@example.com

erikhansen

From 3523dd79d949f93e31fc675b190f17baf66f36c3 Mon Sep 17 00:00:00 2001
From: Erik Hansen <erikpallhansen@gmail.com>
Date: Wed, 1 Feb 2017 13:20:02 -0600
Subject: [PATCH] Edit the 'URL key for specified store already exists' message

---
 Model/Storage/AbstractStorage.php | 5 ++++-
 Model/Storage/DbStorage.php       | 5 ++++-
 2 files changed, 8 insertions(+), 2 deletions(-)