SELECT t2.sku,t1.`value` from catalog_product_entity_decimal AS t1LEFT JOIN catalog_product_entity AS t2ON t2.entity_id = t1.entity_idWHERE t1.attribute_id=76order by t2.sku我这里 attribute_id=

$email = 'customer_email@qq.com';$customer = Mage::getModel("customer/customer");//$WebsiteId = Mage::app()->getWebsite('admin')->getId();$customer->setWebsiteId(1);//查看数据库，设置你自己的website_id$custom

/*通过分类id获取该分类下的产品*/$category_id = 49;$products = Mage::getModel('catalog/category')->load($category_id)->getProductCollection()

/*获取 头一天的订单里的产品的qty_ordered*/SELECT `main_table`.increment_id,`main_table`.`status`, `main_table`.created_at,item_table.qty_ordered,item_table.product_id,item_table.skuFROM `sales_flat_order_grid`

UPDATE catalog_product_entity_decimalSET `value`=0.09WHERE attribute_id=144 AND entity_id = (SELECT entity_id FROM catalog_product_entity WHERE sku='AP2016' LIMIT 1)比如，我们后期为商品添加了一个属性xxx，该属性是来表示商品某种

SELECT t1.period,t2.sku,t3.`value` AS price ,t1.product_name,t1.qty_orderedfrom sales_bestsellers_aggregated_daily AS t1LEFT JOIN catalog_product_entity AS t2ON t1.product_id=t2.entity_idLEFT JO

经常用的功能，比如你的促销中使用了优惠券，可是你只想让已注册用户使用，人可以使用Mage::getSingleton( 'customer/session' )->isLoggedIn()来判断用户是否已经登陆<?phpif(Mage::getSingleton( 'customer/session' )->isLoggedIn()) {echo 'You must logge

select t1.entity_id,t5.name,t1.sku,t2.Description,t3.ShortDescription,t4.Specifications,t6.value as Weightfromcatalog_product_entity as t1left join (selectentity_id,value as `Description`f

template\catalog\product\view.phtmljQuery("#checknow").click(function () {jQuery("input#return_url").val("getUrl('checkout/onepage/');

SELECT created_at,sku,name, SUM(qty_ordered) AS total_orderedFROM sales_flat_order_itemWHERE created_at >= DATE_ADD(NOW(), INTERVAL -1 MONTH)GROUP BY sku order by total_ordered desc