cfaria

#################################################################
#################################################################
# ○ The number and percentage of customers who placed an order  #
# ○ VS. number and percentage of repeat customer orders         #
#                                                               #
#       +------------------+-------+------------+               #
#       | Type             | Count | Percentage |               #
#       +------------------+-------+------------+               #
#       | Total Customers  |    35 | 100.0%     |               #
#       | Single Customers |     1 | 2.9%       |               #

cfaria

#SQLs que dan una respuesta rápida a si un site esta utilizando algunas de las posibilidades SEO que da Magento o no:

#total de imagenes de producto en tu tienda
SELECT count(*) FROM catalog_product_entity_media_gallery_value;

#imagenes que NO tienen texto alternativo (y debieran)
SELECT count(*) FROM catalog_product_entity_media_gallery_value WHERE label IS NULL;

#imagenes que SI tienen texto alternativo (si son pocas...ese margen de mejora tienes)
SELECT count(*) FROM catalog_product_entity_media_gallery_value WHERE label IS NOT NULL;

cfaria

UPDATE wp_posts SET post_content= REPLACE (post_content, '/temp/', '/blog/') WHERE post_content like  '%/temp/%';

cfaria

    protected function _toHtml() {             

       $cat_id = "";

       if (Mage::registry('current_product')) {
          $product_id = Mage::registry('current_product')->getId();
          $obj = Mage::getModel('catalog/product');
          $_product = $obj->load($product_id); // Enter your Product Id in $product_id

          if ($product_id) {

cfaria

sed -n 's/.*<foo>\([^<]*\)<\/foo>.*/\1/p' filename.xml

cfaria

<?php 
//Check if block is active
$empty_category_block = Mage::getModel('cms/block')->load('block_id');
 	if($empty_category_block->getIsActive()) : 
    echo $this->getLayout()->createBlock('cms/block')->setBlockId('block_id'.$catid)->toHtml(); 
  endif;
?>

<?php
//Show static block by widget filter

cfaria

<?php
require_once 'app/Mage.php';
Mage::app();
Mage::app()->getStore()->setId(Mage_Core_Model_App::ADMIN_STORE_ID);

$products = Mage::getModel('catalog/product')->getCollection();
  //->addAttributeToFilter('entity_id', array('gt' => 14000));

$mediaApi = Mage::getModel("catalog/product_attribute_media_api");