magento2 orders – How to Get the Ordered Size of a Product in Magento 2

magento2order-itemsorderssales-order

I tried to get the size of a product/products that was ordered.

So let's say a product has 5 sizes: S, M, L, XL,XLL and when i made the order the product x was bought with the size M.

When i load the order i want to get this "M" size in my code.

This is how i load my order:

$order = $_objectManager->create('Magento\Sales\Model\Order')->load($orderID);

 foreach ($order->getAllItems() as $item) {
      $product = $_objectManager->create('Magento\Catalog\Model\Product')->load($item->getProductId());
... here i want to get the size
}

Does anyone know how to do that? because i didn't find nothing relevant.

Thank you!

Best Answer

You can try:

$order = $_objectManager->create('Magento\Sales\Model\Order')->load($orderID);

$items = $order->getAllVisibleItems();
// $items = $order->getAllItems(); // all items


foreach ($items as $item) {
    $options = $item->getProductOptions(); // all product options       
 }

EDIT:

If you can try not to use ObjectManager directly. It defeats the purpose of dependency injection.

Related Solutions

Magento – Is it possible to get the QuoteId that was used once an OrderId has been created

For the purpose of my question I was wanting to get the quoteId on the success page, with that in mind the quoteId is stored in the order object and can be accessed via the following

$order = Mage::getModel('sales/order')->loadByIncrementId(Mage::getSingleton('checkout/session')->getLastRealOrderId());
$quoteId = $order['quote_id'];

Magento – Find out how many times a product was ordered

Let's start with thinking about the SQL, not Magento (we'll get there later). I would write it as such (ignoring timezones for simplicity):

SELECT sku,SUM(qty_ordered) FROM sales_flat_order_item
WHERE created_at BETWEEN NOW()-INTERVAL 2 WEEK AND NOW()
GROUP BY sku

That query works (I tested). So, how would we go about writing this query in Magento?

Firstly, we see that it's entirely based on sales_flat_order_item - Magento has a special resource collection for this table; we can make use of that.
We see that it uses a SUM in one of the columns
WHERE has a BETWEEN clause - we can probably use Zend_Db_Expr to output our custom rolling 2-weeks timeframe.
Finally, it has a GROUP

Let's see if we can't put it together, then, with a quick call to reset to make sure that we only get the columns we define, and nothing else:

$query = Mage::getResourceModel('sales/order_item_collection');
$query->getSelect()->reset(Zend_Db_Select::COLUMNS)
        ->columns(array('sku','SUM(row_total)'))
        ->where(new Zend_Db_Expr('created_at BETWEEN NOW()-INTERVAL 2 WEEK AND NOW()'))
        ->group(array('sku'));

A simple echo of $query->getSelect() shows us that the query is formatted quite well:

SELECT `main_table`.`sku`, SUM(qty_ordered) FROM `sales_flat_order_item` AS `main_table` WHERE (created_at BETWEEN NOW()-INTERVAL 2 WEEK AND NOW()) GROUP BY `sku`

Other considerations:

In the future you may want to filter this report based on order status (joining to another table) or you may want to make sure that the time zones are accurate (right now it's reporting based on GMT).

Joining is simple:

->join(array('e' => 'sales_flat_order'),'main_table.order_id = e.entity_id')

But adding time zones can get complicated. Look into Mage_Core_Model_Date for some methods that convert timestamps to and from GMT. Also look into the the sales reports collection.

Hope that helps! Best of luck.

Best Answer

Related Solutions

Magento – Is it possible to get the QuoteId that was used once an OrderId has been created

Magento – Find out how many times a product was ordered

Related Topic