$collection = $this->getProductCollection($storeId); $select =  $collection->getSelect(); $select->join(array('cat_index'=>'catalog_category_product_index'),"cat_index.product_id=e.entity_id and cat_index.store_id='$storeId' AND cat_index.category_id in ('10','17')",array('*')); $select->where("cat_index.product_id>35")                ->orWhere("cat_index.product_id<135"); $select->limit(7,2);//first param is the rows num......

1.Commercial invoice 商业发票 2.Proforma invoice形式发票 3.Received invoice收讫发票 4.Certificate invoice证实发票 5.Detailed invoice详细发票 6.Neutral invoice 中性发票 7.Manufacture invoice 厂家发票 8.Bank’s invoice 银行发票 9.Preliminary /provisional invoice 临时发票 10.Customs invoice 海关发票 11.Consular invoice 领事发票 12.Packing list 装箱单 13.Weight list 重量单 14.Measurement list 尺码单 15.Insurance poliy 保险单 16.Insurance Certificate 保险凭证 17.Combined Ins......

$collection = Mage::getModel('catalog/product')->getCollection()->setStoreId($storeId)                       ->addAttributeToSelect("*"); $collection->getSelect()->join(array('cat_index'=>'catalog_category_product_index'),"cat_index.product_id=e.entity_id and cat_index.store_id='$storeId' AND cat_index.category_id in ($catsString)",array('*'));   more details :http://stackoverflow.com/questions/3949470/how-to-select-specific-......

Microsoft Access、MySQL 以及 SQL Server 所使用的数据类型和范围。 Microsoft Access 数据类型 数据类型 描述 存储 Text 用于文本或文本与数字的组合。最多 255 个字符。   Memo Memo 用于更大数量的文本。最多存储 65,536 个字符。 注释：无法对 memo 字段进行排序。不过它们是可搜索的。   Byte 允许 0 到 255 的数字。 1 字节 Integer 允许介于 ......

Here’s short overview: / app - is where the application resides / app / etc - is global configuration den / app / code - is where modules have installed their models and controllers / app / code / core - are core team developed or certified modules / app / code / community - are community contributed modules / app / code / local - are local customizations / app / code / core / Mage - magento default namespace / app / code / core / Mage / {Module} - module root / app / code / core / Mage / {Module} / etc - module configuration / app / code / cor......

Page request flow   Preliminary core modules dependency diagram     ......

Important Paths / -Directory Root /app - This is where all the php code for the application resides /lib - The external code library. /skin - This is where css and other images reside Thats the quick overview. /app /code - Where all modules reside /design - Contains both layout xml files and template .phtml files /etc - Global configuration Mage.php - Static class Mage, where everything is held together. Before I move on to the other two directories (/lib, /skin) I’ll explain the directories......

from ： http://www.magentocommerce.com/wiki/index/categories Wiki Articles   1 - Installation And Configuration 2 - Magento Concepts And Architecture 3 - Store Setup And Management 4 - Themes And Template Customization 5 - Modules And Development 6 - Magento Mobile 7 - Magento Connect 7 - Modules And Development Bienvenido A La Guia De Usuario De Magento Doc Groups How-to How To How To Restore Admin Access For Failed Tls Import-export A......

http://www.wemvc.com/category/php/magento ......

第一步：找到Directory模块，在sql下创建新的升级脚本，版本号只要比之前的大就好，例如我的是mysql4-upgrade-0.8.10-0.8.11.php。   文件内容： < ?php /** * Magento * * NOTICE OF LICENSE * * This source file is subject to the Open Software License (OSL 3.0) * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/osl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web,......