Magento get list of item SKUs from orders

Magento get list of item SKUs from orders

July 7, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento get list of item SKUs from orders

Extracting Order Data in Magento: A Comprehensive Guide

As an experienced e-commerce developer, I often encounter clients seeking specific data from their Magento orders to optimize inventory management or improve marketing strategies. One of the most common requests is to retrieve a list of item SKUs from orders along with other relevant details such as purchase date, individual item costs, and discounts applied.

Understanding the Magento Order Collection

Magento provides a robust way to fetch order collections using the Mage::getResourceModel('sales/order_collection') method. However, this returns only basic order information, and you’ll need to dig deeper into each order record to access the item-level details you require.

$orders = Mage::getResourceModel('sales/order_collection');

Accessing Order Items: The items Collection

Each Magento order contains a collection of items associated with it. To access this collection, you can use the following approach:

  1. First, load your specific order by its ID using the Mage::getModel('sales/order')->load($orderId) method.

  2. Once loaded, access the items property to retrieve the item collection for that particular order.

$order = Mage::getModel('sales/order')->load($orderId);
$items = $order->getItems();

Extracting Relevant Item Details

The $items collection contains objects representing each individual item in the order. You can iterate through this collection to extract the required information:

  • To get the SKU, use the sku property of each item object.
  • The price_incl_tax property provides the total cost of the item including tax.
  • For discounts applied at the item level, check the discount_amount property.

Here’s a sample code snippet demonstrating how to extract and display this information:

foreach ($items as $item) {
    echo "SKU: " . $item->getSku() . "\n";
    echo "Price (including tax): $" . $item->getPriceInclTax() . "\n";
    echo "Discount Amount: $" . $item->getDiscountAmount() . "\n\n";
}

Optimizing Performance for Large Orders

When dealing with a large number of orders, it’s essential to optimize the performance of your queries. Magento allows you to apply filters and sorting to the order collection before loading the data.

For example, if you want to fetch only paid orders placed within the last 30 days, you can use the following code:

$orders = Mage::getResourceModel('sales/order_collection')
    ->addFieldToFilter('status', 'paid')
    ->addAttributeToFilter('created_at', array(
        'from' => date('Y-m-d H:i:s', strtotime('-30 days')),
        'to'   => now()
    ))
    ->setOrder('created_at', 'DESC');

Enhancing Order Data with Extensions

While Magento’s core functionality provides a solid foundation, you might need to extend its capabilities for more complex data analysis. Consider exploring extensions like the Advanced Reports module or customizing your order models to store additional attributes.

For a deeper dive into Magento extension development and best practices, I recommend checking out our comprehensive guide on Magento Extension Development.

Conclusion

Extracting specific item-level data from Magento orders requires a combination of understanding the order collection structure and applying appropriate filters. By following the steps outlined above, you can efficiently retrieve SKUs, prices, discounts, and other relevant information for each order in your system.

Remember to optimize your queries for performance when dealing with large datasets, and don’t hesitate to explore extensions or customizations if your requirements extend beyond Magento’s core functionality.

Happy coding, and feel free to reach out if you have any further questions about Magento data extraction or need assistance with your e-commerce development projects!

Performance Orders Pricing CLI

Our network