Magento - 清除清空所有商店目录

TRUNCATE TABLE `catalog_category_entity`;
TRUNCATE TABLE `catalog_category_entity_datetime`;
TRUNCATE TABLE `catalog_category_entity_decimal`;
TRUNCATE TABLE `catalog_category_entity_int`;
TRUNCATE TABLE `catalog_category_entity_text`;
TRUNCATE TABLE `catalog_category_entity_varchar`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`;

INSERT INTO `catalog_category_entity`(`entity_id`,`entity_type_id`,
`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,
`POSITION`,`level`,`children_count`) VALUES (1,3,0,0,'0000-00-00 00:00:00',
'2009-02-20 00:25:34','1',1,0,1),(2,3,3,0,'2009-02-20 00:25:34','2009-02-20 00:25:34','1/2',1,1,0);

INSERT INTO `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,
`entity_id`,`value`) VALUES (1,3,32,0,2,1),(2,3,32,1,2,1);

INSERT INTO `catalog_category_entity_varchar`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,
`entity_id`,`value`) VALUES (1,3,31,0,1,'Root Catalog'),(2,3,33,0,1,'root-catalog'),(3,3,31,0,2,'Default Category'),(4,3,39,0,2,'PRODUCTS'),(5,3,33,0,2,'default-category');

执行以上SQL脚本即能从数据库中清空Magento所有的目录
(Magento1.4.0.1以前)

Magento 1.4.1.1之后清除Magento目录
可尝试:

TRUNCATE TABLE catalog_category_entity;
TRUNCATE TABLE catalog_category_entity_datetime;
TRUNCATE TABLE catalog_category_entity_decimal;
TRUNCATE TABLE catalog_category_entity_int;
TRUNCATE TABLE catalog_category_entity_text;
TRUNCATE TABLE catalog_category_entity_varchar;
TRUNCATE TABLE catalog_category_product;
TRUNCATE TABLE catalog_category_product_index;

insert into catalog_category_entity (entity_id,entity_type_id,attribute_set_id,parent_id,created_at,updated_at,path,position,level,children_count) values (’1′,’3′,’0′,’0′,’0000-00-00 00:00:00′,’2009-02-20 00:25:34′,’1′,’1′,’0′,’1′),(’2′,’3′,’3′,’0′,’2009-02-20 00:25:34′,’2009-02-20 00:25:34′,’1/2′,1,1,0);
insert into catalog_category_entity_int (value_id, entity_type_id,attribute_id,store_id,entity_id,value) values (’1′,’3′,’32′,’0′,’2′,’1′),(’2′,’3′,’32′,’1′,’2′,’1′);
insert into catalog_category_entity_varchar (value_id,entity_type_id,attribute_id,store_id,entity_id,value) values (’1′,’3′,’31′,’0′,’1′,’Root Catalog’),(’2′,’3′,’33′,’0′,’1′,’root-catalog’),(’3′,’3′,’31′,’0′,’2′,’Default Category’),(’4′,’3′,’39′,’0′,’2′,’PRODUCTS’),(’5′,’3′,’33′,’0′,’2′,’default-category’);

magento robots.txt规范文件

# Website Sitemap
Sitemap: http://www.mydomain.com/sitemap.xml
 
# Crawlers Setup
User-agent: *
Crawl-delay: 10
 
# Allowable Index
Allow: /*?p=
Allow: /catalog/seo_sitemap/category/
Allow:/catalogsearch/result/

 

 
# Directories
Disallow: /404/
Disallow: /app/
Disallow: /cgi-bin/
Disallow: /downloader/
Disallow: /includes/
Disallow: /js/
Disallow: /lib/
Disallow: /magento/
Disallow: /media/
Disallow: /pkginfo/
Disallow: /report/
Disallow: /skin/
Disallow: /stats/
Disallow: /var/
 
# Paths (clean URLs)
Disallow: /index.php/
Disallow: /catalog/product_compare/
Disallow: /catalog/category/view/
Disallow: /catalog/product/view/
Disallow: /catalogsearch/
Disallow: /checkout/
Disallow: /control/
Disallow: /contacts/
Disallow: /customer/
Disallow: /customize/
Disallow: /newsletter/
Disallow: /poll/
Disallow: /review/
Disallow: /sendfriend/
Disallow: /tag/
Disallow: /wishlist/
 
# Files
Disallow: /cron.php
Disallow: /cron.sh
Disallow: /error_log
Disallow: /install.php
Disallow: /LICENSE.html
Disallow: /LICENSE.txt
Disallow: /LICENSE_AFL.txt
Disallow: /STATUS.txt
 
# Paths (no clean URLs)
Disallow: /*.js$
Disallow: /*.css$
Disallow: /*.php$
Disallow: /*?p=*&
Disallow: /*?SID=

上面是针对magento网店写的规范性robots.txt 文件,你只需修改sitemap的路径为你的magento站点地图路径,然后保存为robots.txt上传到magento根目录即可。

P 2011.1.7更新。

记录在Rikku
看到的另一则写法。

# Website Sitemap
Sitemap: http://www.mydomain.com/sitemap.xml

# Crawlers Setup
User-agent: *
Crawl-delay: 10

# Allowable Index
Allow: /*?p=
Allow: /index.php/blog/
Allow: /catalog/seo_sitemap/category/
Allow:/catalogsearch/result/

# Directories
Disallow: /404/
Disallow: /app/
Disallow: /cgi-bin/
Disallow: /downloader/
Disallow: /includes/
Disallow: /js/
Disallow: /lib/
Disallow: /magento/
Disallow: /media/
Disallow: /pkginfo/
Disallow: /report/
Disallow: /skin/
Disallow: /stats/
Disallow: /var/

# Paths (clean URLs)
Disallow: /index.php/
Disallow: /catalog/product_compare/
Disallow: /catalog/category/view/
Disallow: /catalog/product/view/
Disallow: /catalogsearch/
Disallow: /checkout/
Disallow: /control/
Disallow: /contacts/
Disallow: /customer/
Disallow: /customize/
Disallow: /newsletter/
Disallow: /poll/
Disallow: /review/
Disallow: /sendfriend/
Disallow: /tag/
Disallow: /wishlist/

# Files
Disallow: /cron.php
Disallow: /cron.sh
Disallow: /error_log
Disallow: /install.php
Disallow: /LICENSE.html
Disallow: /LICENSE.txt
Disallow: /LICENSE_AFL.txt
Disallow: /STATUS.txt

# Paths (no clean URLs)
Disallow: /*.js$
Disallow: /*.css$
Disallow: /*.php$
Disallow: /*?p=*&
Disallow: /*?SID=
 

magento添加随机商品模块

以下代码在magento1.4.1.0中运行没有什么问题。将代码放在产品详细页的任何位置,如view.phtml或者media.phtml中。

<!--for show other product-->

<?php $categories = $_product->getCategoryIds(); ?>

    <?php

        $result = array();

        foreach($categories as $cat_id) {

            $category = Mage::getModel('catalog/category');

            $category->load($cat_id);

            $collection = $category->getProductCollection();

            foreach ($collection as $product) {

                $result[] = $product->getId();

            }

 

        }

    ?>

    <div class="box-others-also-like">

        <ul>

        <?php

        if(sizeof($result) >= 5)

        {

           $ourneed = array_rand($result,5);

           foreach($ourneed as $cc)

            {

             $thisproduct= Mage::getModel('catalog/product')->load($result[$cc]);

             ?>

             <li>

            <a href="<?php echo $thisproduct->getProductUrl(); ?>" title="<?php echo $thisproduct->getName(); ?>" ><img src="<?php echo $this->helper('catalog/image')->init($thisproduct, 'small_image')->resize(200) ?>" width="200" height="200" alt="<?php echo $thisproduct->getName(); ?>" /></a>

            </li>

            <?php } ?>

        <?php

        }else

        {

           foreach($result as $cc)

            {

             $thisproduct= Mage::getModel('catalog/product')->load($cc);

             ?>

 

                <li>

                <a href="<?php echo $thisproduct->getProductUrl(); ?>" title="<?php echo $thisproduct->getName(); ?>" ><img src="<?php echo $this->helper('catalog/image')->init($thisproduct, 'small_image')->resize(200) ?>" width="200" height="200" alt="<?php echo $thisproduct->getName(); ?>" /></a>

                </li>

            <?php

            }

            }

            ?>

        </ul>

    </div>

    <!--for show other product-->