Magento从订单中获取物料SKU的列表 [英] Magento get list of item SKUs from orders

问题描述

我知道可以通过以下方式获得 Magento 订单 $ orders = Mage :: getResourceModel('sales/order_collection'); 但是如何获得每个订单的信息呢?每个订单最需要的信息是:SKU购买，购买日期，每件商品的花费以及折扣(如果有).

I know Magento orders can be attained with $orders = Mage::getResourceModel('sales/order_collection'); but then how can I get the information for each order? The information I need most per order is: SKUs purchased, date purchased, money spent on each item, and discounts, if any.

非常感谢所有帮助，我一直接受答案！

All help is greatly appreciated and I always accept an answer!

推荐答案

不是直接答案

Mage :: getResourceModel('sales/order_collection'); 检索订单集合( sales_flat_order )

SKU存储在sales_flat_order_item

SKU is stored in sales_flat_order_item

从订单中可以使用getAllVisibleItems方法获取订单商品(它将检索相应的 sales_flat_order_item )，请参见 Mage_Sales_Model_Order

From order you can get order items using method getAllVisibleItems (it will retrieve respective sales_flat_order_item) see the definition in Mage_Sales_Model_Order

$orders = Mage::getResourceModel('sales/order_collection');
foreach($orders as $order){
    $items = $order->getAllVisibleItems();
    foreach($items as $item){
        $sku = $item->getSku();
    }
}

问题就是这样，您必须自己修改它.对于花在每件商品上的金钱，您还可以查看 sales_flat_order_item

The point is like that, you have to modify it by yourself. For the money spent on each item, you can also take a look at sales_flat_order_item

这篇关于Magento从订单中获取物料SKU的列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！