mokanfar

#!/usr/bin/env bash
echo "filename 1 (file that has more rows):"
read file1
echo "filename 2:"
read file2
echo "common field name:"
read fieldname
#echo "file1: ${file1}.csv  file2: ${file2}.csv  common field name: ${fieldname}"

if [ -f $PWD/temp.db ]; then

mokanfar

<?php 
require_once 'app/Mage.php';
Mage::app();
//to overwrite limit but you need first to increase your memory limit
 $collection = Mage::getModel('catalog/product')->getCollection()
->addAttributeToSelect('*') // select all attributes
->setPageSize(5000) // limit number of results returned
->setCurPage(1); // set the offset (useful for pagination)

// we iterate through the list of products to get attribute values

mokanfar

<?php
require_once 'app/Mage.php';
Mage::app();
$skus = array("LIST OF SKUS HERE");

foreach($skus as $item) {

	$product = Mage::getModel('catalog/product')->loadByAttribute('sku', $item)->getId();
	
	$gallery_images = Mage::getModel('catalog/product')->load($product)->getMediaGalleryImages();

mokanfar

<?php
require_once 'app/Mage.php';
Mage::app();
$skus = array("ARRAY OF SKUS HERE");
$n=array();

foreach ($skus as $item) {
	$product = Mage::getModel('catalog/product')->loadByAttribute('sku', $item)->getId();
	array_push($n, $product);
}

mokanfar

git clone https://github.com/OpenMage/magento-mirror.git
cd public_html/shop
curl https://raw.githubusercontent.com/github/gitignore/master/Magento.gitignore > .gitignore
git init
git add --all
git commit -m 'backup'
git status
rsync
cd ..
ls

mokanfar

#read xlsx
in2csv a.xlsx

#convert xlsx to csv (also works for xls)
in2csv a.xlsx > data.csv

#pretty print stdout spreadsheet
csvlook data.csv | less -S

#display column names

mokanfar

magento product phtml data sku attribute get data 
<?php echo $_product->getProductUrl() ?>
<?php echo $_product->getId() ?>
<?php echo $_product->getSku() ?>
###Customer ID Final Price Customer Group
<?php 
require_once 'app/Mage.php';
Mage::app();
//to overwrite limit but you need first to increase your memory limit
 $collection = Mage::getModel('catalog/product')->getCollection()

mokanfar

//===========
jQuery.noConflict();
(function ($) {
   $(this).remove();
})(jQuery);
//===========



//===========

mokanfar

#!/bin/bash
########## MAGENTO CONFIG VARIABLES #############
globalMagDir='/var/www/html/****'
globalScriptDir="${globalMagDir}/dev/stock-sync"
globalMagFeedDir="${globalMagDir}/media/amfeed/feeds"
amfeedF3='export_3'
amfeedF4='export_4'

########## MAGMI CONFIG VARIABLES ##############
magmiCLI="${globalMagDir}/magmi/magmi/cli/magmi.cli.php"

mokanfar

 cd ~
 git clone https://github.com/OpenMage/magento-mirror.git
 cd public_html 
 git init
 curl https://raw.githubusercontent.com/github/gitignore/master/Magento.gitignore > .gitignore
 git add --all
 git commit -m 'backup'
 cd ../magento-mirror
 rsync -chavzP --exclude='./var/cache' --exclude='./.git' --exclude='./media/catalog/product/cache' --exclude='./var/tmp' --exclude='./var/session' --exclude='./var/report' --stats ./ ../public_html