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.
*

IvanChepurnyi

#!/bin/bash

magentodir=$1

cd $magentodir

read -d '' script << PHP
<?php
\$composer = json_decode(file_get_contents('composer.json'), true);
if (!is_array(\$composer['autoload']['psr-0'][''])) {

pronto2000

<?php
require_once 'abstract.php';

class Mage_Shell_Products extends Mage_Shell_Abstract
{
  private function execution_time($start, $current)
  {
    return date("H:i:s", $current - $start);
  }

bh-ref

<?php

namespace Vendor\ModuleName\Options;

use Magento\Eav\Setup\EavSetupFactory;
use Magento\Framework\Setup\ModuleDataSetupInterface;
use Magento\Catalog\Model\ResourceModel\Eav\AttributeFactory;

class RemoveOptions
{

piotrekkaminski

1) First you need to generate download token. Login to your account on magento.com and generate it in Account Settings->Downloads Access Token
2) You will need your MAGEID as well. It is shown at the top-left in your account page.
3) curl -k https://MAGEID:TOKEN@www.magentocommerce.com/products/downloads/info/help
4) Profit!

adilbaig

#!/bin/bash

# This is required for `notify-send` to work from within a cron.
# http://askubuntu.com/questions/298608/notify-send-doesnt-work-from-crontab/346580#346580
eval "export $(egrep -z DBUS_SESSION_BUS_ADDRESS /proc/$(pgrep -u $LOGNAME gnome-session)/environ)";

# syncAndWink
#
# Syncs all remotely-tracked branches on a git repo passed as first argument ($1). It also pulls any new branches
# and tags attached to the repo.

avoelkl

MageStackDay notes & queries

Some notes from the MageStackDay chat:

• save your votes. Marius can close unlimited nrs of questions so he'll do that, just vote / flag once is enough!
• If you can clean up the spelling and grammar on the question, feel free to do so, as it would be easier for non-english speakers
• use your votes

Queries

Questions to work on

jonathansayag

<?php
$attribute_code = 'ATTRIBUTE_NAME';
$attribute = Mage::getModel('eav/config')->getAttribute('catalog_product', $attribute_code);
$options = $attribute->getSource()->getAllOptions();

$optionsDelete = array();

foreach($options as $option) {
    if ($option['value'] != "") {
        $optionsDelete['delete'][$option['value']] = true;

GianlucaGuarini

#/usr/bin/env bash
# MIT © Sindre Sorhus - sindresorhus.com
# forked by Gianluca Guarini

changed_files="$(git diff-tree -r --name-only --no-commit-id ORIG_HEAD HEAD)"

check_run() {
  echo "$changed_files" | grep -E --quiet "$1" && eval "$2"
}

MagePsycho

<?php

/**
 * Generates data with ready-to-edit CSV for magento translation
 * 
 * A handy tool that generates CSV data for magento theme translation
 * You can set the $mode to:
 *  a) either write that data to translate.csv at path you specify,
 *  b) or just to dump that data in browser for you to copy and use (default). 
 * In the write mode it appends new data to translate.csv thus you dont