Magento Solution

Best Seller product magento

2017-06-06T04:32:00.002-07:00

<?php
$storeId = Mage::app()->getStore()->getId();
$products = Mage::getResourceModel('reports/product_collection')
->addOrderedQty()
->addAttributeToSelect('*')
->addAttributeToSelect(array('name', 'price', 'small_image'))
->setStoreId($storeId)
->addStoreFilter($storeId)
->setOrder('ordered_qty', 'desc');

Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($products);
Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($products);

if($categoryId=$this->getData('category_id')){
$category = Mage::getModel('catalog/category')->load($categoryId);
$products->addCategoryFilter($category);
}

//$products->setPageSize(5)->setCurPage(1); // change the Page Size to how many products you want to show per category

$this->setProductCollection($products);

?>

<?php if (($_products = $this->getProductCollection())): ?>
<div class="page-title">
<h2><?php echo $this->__('Our Top Selling Product') ?></h2>
</div>

<div class="top-products owl-carousel">
<?php foreach ($_products->getItems() as $_product): ?>
<div>
<a href="<?php echo $_product->getProductUrl() ?>" title="<?php echo $this->stripTags($this->getImageLabel($_product, 'small_image'), null, true) ?>" class="product-image"><img src="<?php echo $this->helper('catalog/image')->init($_product, 'small_image')->resize(300); ?>" width="300" height="300" alt="<?php echo $this->stripTags($this->getImageLabel($_product, 'small_image'), null, true) ?>" /></a>

</div>
<?php endforeach; ?>
</div>

<?php endif; ?>

Email test script php

2017-06-01T00:20:00.002-07:00

<?php
ini_set( 'display_errors', 1 );
error_reporting( E_ALL );
$from = "test@test.com";
$to = "test@test.com";
$subject = "PHP Mail Test script";
$message = "This is a test to check the PHP Mail functionality";
$headers = "From:" . $from;
mail($to,$subject,$message, $headers);
echo "Test email sent";
?>

create csv from array in php

2017-05-31T23:04:00.003-07:00

<?php

$myarray = array(
array(
['sku'] =>'asdfa'
)
array(
array(['sku'] =>'asdfa'
)
);

like this array

$productArray = array();
$productArray[0]['code'] = "Code";
$productArray[0]['name'] = "name";
$productArray[0]['product_group_description'] = "Product Group Description";
$productArray[0]['actual_quantity'] = "Actual Quantity";
$productArray[0]['cost'] = "Cost";

$i = 1;

foreach($myArray as $products){

$productArray[$i]['code'] = $products['sku'];
$productArray[$i]['name'] = "";
$productArray[$i]['product_group_description'] = "";
$productArray[$i]['actual_quantity'] = $products['qty'];
$productArray[$i]['cost'] = $products['price'];
$i++;

}

/* echo '<pre>';
print_r($productArray);
exit; */

$remote_file_name = 'productbody/Powerbody.csv';

$fp = fopen($remote_file_name, 'w');

foreach ($productArray as $row) {
fputcsv($fp, $row);
}
//rewind($fp);
//ftp_fput($ftp_conn, $remote_file_name, $fp, FTP_ASCII);

fclose($fp);

?>

How to Display the most recently added products first in magento

2017-05-31T22:26:00.003-07:00

Step 1: To Achieve this copy the file Toolbar.php

from app/code/core/Mage/Catalog/Block/Product/List/Toolbar.php. Create a Directory Structure in local and paste the Toolbar.php
as shown below

app/code/local/Mage/Catalog/Block/Product/List/Toolbar.php

Step 2: Around line 232 you should see the below code in setCollection

function

if ($this->getCurrentOrder()) {

$this->collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection());

}

Replace the above code with the new code given below

if ($this->getCurrentOrder()) {

if(($this->getCurrentOrder())=='position'){

$this->_collection->setOrder('entity_id','desc');

}

else {

$this->_collection->setOrder($this->getCurrentOrder(),$this->getCurrentDirection());

}

Now the newly added products will be displayed first in your magento store.

Payment Method dispaly only in admin order magento

2017-05-31T01:56:00.003-07:00

/app/code/core/Mage/Payment/Model/Method/ your file

protected $_canUseInternal = true;
protected $_canUseCheckout = false;

Magento: How to get controller, module, action and router name?

2017-05-15T23:14:00.003-07:00

You can easily get controller name, action name, router name and module name in any template file or class file.

IN TEMPLATE FILES

$this->getRequest() can be used in template (phtml) files.

Here is the code:

/**

 get Controller name

 */

$this->getRequest()->getControllerName();

/**

 * get Action name, i.e. the function inside the controller

*/

$this->getRequest()->getActionName();

/**

 * get Router name

*/

$this->getRequest()->getRouteName();

/**

 * get module name

*/

$this->getRequest()->getModuleName();

/**

 * get namespace & module name

 * for example, if you are in checkout page 

 * then, this will return Mage_Checkout

*/

$this->getRequest()->getControllerModule();

IN CLASS FILES

Here is the code:

/**

 * get Controller name

*/

Mage::app()->getRequest()->getControllerName();

/**

 * get Action name, i.e. the function inside the controller

*/

Mage::app()->getRequest()->getActionName();

/**

 * get Router name

*/

Mage::app()->getRequest()->getRouteName();

/**

 * get module name

*/

Mage::app()->getRequest()->getModuleName();

/**

 * get namespace & module name

 * for example, if you are in checkout page 

 * then, this will return Mage_Checkout

*/

Mage::app()->getRequest()->getControllerModule();

The above functions (getControllerName, getActionName, getRouteName, getModuleName) are present in the class Mage_Core_Model_Url.

You can explore all requests with print_r.

echo "<pre>"; print_r(Mage::app()->getRequest());

MAGENTO: SORT BY PRICE: LOW TO HIGH AND HIGH TO LOW

2017-05-15T23:10:00.001-07:00

/app/design/frontend/default/your-theme/template/catalog/product/list/toolbar.phtml file.

Find:
<option value="<?php echo $this->getOrderUrl($_key, 'asc') ?>"<?php if($this->isOrderCurrent($_key)): ?> selected="selected"<?php endif; ?>>    <?php echo $this->__($_order) ?>
</option>
And Replace with:

<?php if ($_order != 'Price'): ?>
<option value="<?php echo $this->getOrderUrl($_key, 'asc') ?>"<?php if($this->isOrderCurrent($_key)): ?> selected="selected"<?php endif; ?>>
  <?php echo $this->__($_order) ?>
</option>
<?php else: ?>
<option value="<?php echo $this->getOrderUrl($_key, 'asc') ?>"<?php if($this->isOrderCurrent($_key) && $this->getCurrentDirection() == 'asc'): ?> selected="selected"<?php endif; ?>>
  <?php echo $this->__($_order) . ': Low to High' ?>
</option>
<option value="<?php echo $this->getOrderUrl($_key, 'desc') ?>"<?php if($this->isOrderCurrent($_key) && $this->getCurrentDirection() == 'desc'): ?> selected="selected"<?php endif; ?>>
  <?php echo $this->__($_order) . ': High to Low' ?>
</option>
<?php endif; ?>Magento sort by special price (disounted product) on product list page dropdown (toolbar.phtml)

Create category attribute in magento

2017-05-08T06:20:00.001-07:00

require_once 'app/Mage.php';
Mage::app();

$setup = new Mage_Eav_Model_Entity_Setup('core_setup');

/*$setup->startSetup();
$setup->removeAttribute('catalog_category', 'categorytarget');
$setup->endSetup();*/

function createNewAttributeSet($name) {
Mage::app('default');
$modelSet = Mage::getModel('eav/entity_attribute_set')
->setEntityTypeId(4) // 4 == "catalog/product"
->setAttributeSetName($name);
$modelSet->save();
$modelSet->initFromSkeleton(4)->save(); // same thing
}

//Mage::app()->startSetup();
$setup->addAttribute('catalog_category', 'gemstone_image_hover', array(
'type' => 'varchar',
'label' => 'Gemstone Image Hover',
'input' => 'image',
'backend' => 'catalog/category_attribute_backend_image',
'required' => false,
'sort_order' => 99,
'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
'group' => 'General Information'
));

echo "Success";

Re-index magento via ssh / putty

2017-05-08T06:14:00.001-07:00

You are running this command from ROOT and indexer.php is located under shell directory. So try this commands instead:

php shell/indexer.php --reindex catalog_product_attribut

For re-indexing all indexes :

php -f shell/indexer.php reindexall


Listing all commands :



php shell/indexer.php --reindex catalog_product_attribute
php shell/indexer.php --reindex catalog_product_price
php shell/indexer.php --reindex catalog_url
php shell/indexer.php --reindex catalog_product_flat
php shell/indexer.php --reindex catalog_category_flat
php shell/indexer.php --reindex catalog_category_product
php shell/indexer.php --reindex catalogsearch_fulltext
php shell/indexer.php --reindex cataloginventory_stock
php shell/indexer.php --reindex tag_summary

Check how Many extention will overright into magento

2017-05-08T06:03:00.001-07:00

# Create New admin User programmatically.

require_once('./app/Mage.php');
umask(0);
Mage::app();

$folders = array('app/code/local/', 'app/code/community/');//folders to parse
$configFiles = array();
foreach ($folders as $folder){
$files = glob($folder.'*/*/etc/config.xml');//get all config.xml files in the specified folder
$configFiles = array_merge($configFiles, $files);//merge with the rest of the config files
}
$rewrites = array();//list of all rewrites

foreach ($configFiles as $file){
$dom = new DOMDocument;
$dom->loadXML(file_get_contents($file));
$xpath = new DOMXPath($dom);
$path = '//rewrite/*';//search for tags named 'rewrite'
$text = $xpath->query($path);
foreach ($text as $rewriteElement){
$type = $rewriteElement->parentNode->parentNode->parentNode->tagName;//what is overwritten (model, block, helper)
$parent = $rewriteElement->parentNode->parentNode->tagName;//module identifier that is being rewritten (core, catalog, sales, ...)
$name = $rewriteElement->tagName;//element that is rewritten (layout, product, category, order)
foreach ($rewriteElement->childNodes as $element){
$rewrites[$type][$parent.'/'.$name][] = $element->textContent;//class that rewrites it
}
}
}
echo "<pre>";print_r($rewrites);

Create magento admin username and password

2017-05-08T05:45:00.000-07:00

require_once(‘app/Mage.php’);
umask(0);
Mage::app();

try {
$user = Mage::getModel(‘admin/user’)
->setData(array(
‘username’ => ‘admin’,
‘firstname’ => ‘Admin’,
‘lastname’ => ‘Admin’,
’email’ => ‘test@test.com’,
‘password’ =>’admin@123′,
‘is_active’ => 1
))->save();

} catch (Exception $e) {
echo $e->getMessage();
exit;
}

//Assign Role Id
try {
$user->setRoleIds(array(1)) //Administrator role id is 1 ,Here you can assign other roles ids
->setRoleUserId($user->getUserId())
->saveRelations();

} catch (Exception $e) {
echo $e->getMessage();
exit;
}

echo “User created successfully”;