php - Magento - 更新 sales_flat_order_item 表中的发票数量

Question

我需要更改 sales_flat_order_item 表中特定订单的 qty_invoiced 列的值，但遗憾的是没有任何反应。

这是我的代码:

$allOrders = Mage::getModel('sales/order')->getCollection()
    ->addFieldToFilter('status', 'complete');

foreach ($allOrders as $value) {
  $order = Mage::getModel('sales/order')->load($value->getId());
  if($order->getincrementId() == '100000003'){
    foreach ($order->getAllItems() as $item) {
      $qtyOrdered = $item->getQtyOrdered();
      $item->setQtyInvoiced($qtyOrdered);
    }
  }
}

Answer 1

我认为您需要在设置新数量后保存商品和订单。

foreach ($allOrders as $value) {
    $order = Mage::getModel('sales/order')->load($value->getId());
    if($order->getincrementId() == '100000003'){
        /** @var $item Mage_Sales_Model_Order_Item */
        foreach ($order->getAllItems() as $item) {
            $qtyOrdered = $item->getQtyOrdered();
            $item->setQtyInvoiced($qtyOrdered);
            $item->save();

        }
    }
    $order->save();
}