Magento学习过程中常见代码资料整理

 Magento学习过程中常见代码资料整理+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Magento 如何管理商品评论？

Magento后台->Catalog->Reviews and Ratings->Pending Reviews

OR

Magento后台->Catalog->Reviews and Ratings->All Reviews

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Magento 商品评论表：review_detail

商品总数表(qty)     cataloginventory_stock_item   

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

商品评论及发展评论表单文件位置:

F:\www\magento\app\design\frontend\default\default\template\review\product\view\list.phtml 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

栏目面包屑：

\app\design\frontend\default\default\template\page\html\breadcrumbs.phtml  

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

商品页(catalog.xml文件)调用相关内容：

 

-----------------------------------------------------------------------------------------------------

产品页显示商品评论及发表评论：

1、找到app\design\frontend\base\default\layout\catalog.xml文件

2、找到<catalog_product_view translate="label">

3、找到节点=<reference name="content">里最后位置->  添加如下代码：

+++++++++++++++++++++++++++

A：单纯商品评论调用代码：

<block type="review/product_view_list" name="product.info.product_additional_data" as="product_review" template="review/product/view/list.phtml"></block>

B:单纯调用商品评论表单代码：

<block type="review/form" name="product.review.form" as="review_form"/>

-----------------------------------------------------------------------------------------------------

商品页调用商品展示图片：

<block type="catalog/product_view_media" name="product.info.media" as="media" template="catalog/product/view/media.phtml"/>

-----------------------------------------------------------------------------------------------------

 

商品页调用Details内容

<block type="catalog/product_view_description" name="product.description" as="description" template="catalog/product/view/description.phtml">

<action method="addToParentGroup"><group>detailed_info</group></action>

</block>

<block type="catalog/product_view_attributes" name="product.attributes" as="additional" template="catalog/product/view/attributes.phtml">

<action method="addToParentGroup"><group>detailed_info</group></action>

</block>

--------------------------------------------------------

商品页调用Product Tags内容

 <block type="catalog/product_view_additional" name="product.info.additional" as="product_additional_data" />

 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

商品展示时候调用库存：

Mage::getModel('cataloginventory/stock_item')->loadByProduct($_product)->getQty();

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

批量把缺货的产品靠后显示，给其他有货的产品让出宝贵的位置（缺货商品向后调整）

update catalog_category_product set position=position+50000 where product_id in (SELECT product_id FROM `cataloginventory_stock_status` where stock_status=0) and position<50000;

 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

调用子分类产品代码：

 

$products = Mage::getModel('catalog/category')->load($category_id)

->getProductCollection()

->addAttributeToSelect('*')

->addAttributeToFilter('status', 1)

->addAttributeToFilter('visibility', 4);

 

$category_id修改为需要显示产品的分类id，该id可以在分类页面中看到。上述代码中还捎带了一些过滤，产品状态为激活，并处于可见状态。

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Magento生成Google Sitemap地图

A:Admin->Catalog->Google Sitemap

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

Magento首页显示最新商品

调用的新分类商品：

{{block type="catalog/product_list" name="home.catalog.product.list" alias="products_homepage" template="catalog/product/list.phtml"}}

调用的最新商品：

{{block type="catalog/product_new" name="home.catalog.product.new" alias="product_homepage"template="catalog/product/new.phtml"}}

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Magento商品关联表：

`catalog_product_entity_text`

`catalog_product_entity_varchar`

`catalogsearch_fulltext`

`catalog_product_flat_1`

 

http://www.php186.com/content/article/magento/23207.html