Getting Ordered Items and their Detail from Order ID in Magento

转载于 2011-03-23 13:04:00 发布 · 1.1k 阅读

文章标签：

#magento #parameters #query #up

magento Developers 同时被 2 个专栏收录

49 篇文章

订阅专栏

Magento开发专栏

46 篇文章

订阅专栏

本文提供了一个用于获取特定订单及其商品详细信息的代码片段。该代码首先加载指定的订单ID，然后提取订单中的所有商品信息，包括名称、单价、SKU、产品ID和待开票数量。此外，作者还提及尝试通过单个查询获取所有订单和其商品详情的方法，但尚未找到解决方案。

Here is a small snippet of code, yet useful, to get ordered items and its details. I’ve deviced this code a lot before and posted in Magento Commerce’s Forum as well. But felt like writting it again, so that I can have a quick refrence to it as well. Next thing, I’ve tried a lot to get all orders and their items details by single query, but have not yet come up with a solution. If you have any method of finding order and its details by a single query, then please do response. The code below first needs an order ID as it parameters to give order details.

$order = Mage::getModel('sales/order')->load($order_id); $items = $order->getAllItems(); $itemcount=count($items); $name=array(); $unitPrice=array(); $sku=array(); $ids=array(); $qty=array(); foreach ($items as $itemId => $item) { $name[] = $item->getName(); $unitPrice[]=$item->getPrice(); $sku[]=$item->getSku(); $ids[]=$item->getProductId(); $qty[]=$item->getQtyToInvoice(); }

Hope this might “just” help somebody in need.