Skip to content
Admin & Security Extensions

Ordered Items Column for Magento 2 Admin Sales Grid

Adds an Order Items column to the Magento 2 admin order grid with thumbnails, SKUs, quantities, prices, options like size and colour, and a status badge per item. Long orders show 3 items and a show more button.

  • Free
  • Themes listed: Hyvä + Luma
Free $0.00, in stock
Check requirementsSee the versions and themes listed for this package. Details Ask about setupInclude the package name and your Magento and PHP versions. Ask
$0.00
In stock
SKU
panth-ordered-items
Links
composer require mage2kishan/module-ordered-items
SKU
panth-ordered-items
  • Package requirementsRead the source documentation
  • Developer profileView Upwork profile
  • Themes listedHyvä + Luma
  • PHP versions listed8.1, 8.2, 8.3, 8.4
  • Installation questionsDiscuss your store setup

What it does for your store

The main features, as listed in the module documentation.

  • Product Thumbnails

    A 32 pixel thumbnail per item, so you can see what was ordered without opening it.

  • Linked Product Names

    Name and thumbnail can open the product edit page in a new tab.

  • SKU and Options

    SKU plus configurable options and bundle selections, up to four lines per item.

  • Quantity and Prices

    Ordered quantity, unit price and row total in the order currency.

  • Status Badges

    Invoiced, Shipped, Refunded, Canceled or Pending per item, with quantities.

  • Popup for Big Orders

    More than 10 items opens a paged popup with 10, 20, 50 or all per page.

Installation

Example commands from the Magento root. Follow the package instructions and your staging and deployment process.

  1. 1Check the releaseMatch Magento, PHP, theme and dependency requirements.
  2. 2Install on stagingReview Composer changes and follow the package instructions.
  3. 3Configure and verifyUse the documented settings and test the affected features.
magento-root
$ composer require mage2kishan/module-ordered-items
$ bin/magento setup:upgrade
$ bin/magento setup:di:compile
$ bin/magento setup:static-content:deploy -f
$ bin/magento cache:clean

Listed requirements

These are the details supplied in this listing. Confirm the selected release supports your Magento edition, PHP and storefront.

Magento versions listed2.4.6, 2.4.7, 2.4.8
PHP versions listed8.1, 8.2, 8.3, 8.4
Themes listedHyvä, Luma
Composer packagemage2kishan/module-ordered-items

Read package requirements and license

Documentation

Product details and setup guidance. Check the package repository for release-specific instructions.

See what is in each order from the order grid

Ordered Items adds an Order Items column to the Magento 2 admin order grid under Sales, Orders. For every row it lists the ordered products with a small thumbnail, name, SKU, selected options, quantity, unit price, row total and a status badge, so you can check what an order contains without opening it. It changes only the admin grid; the storefront, checkout and customer account are not touched, so it works with any storefront theme.

What each item shows

  • A 32 by 32 pixel thumbnail, or the placeholder image when the product has none.
  • Product name and SKU. The name and thumbnail can link to the product edit page in a new tab.
  • Configurable options such as size and colour, and bundle selections, up to four lines per item.
  • Quantity, unit price and row total in the order currency.
  • Badges for Invoiced, Shipped, Refunded and Canceled with the quantity in each state, or Pending when nothing has been processed.

A summary line at the top of the cell shows the number of distinct items and the total units.

Large orders

By default the cell shows the first 3 items with a + N more items button that expands the rest in place. When an order has more than 10 items, a View all button opens a popup with 10, 20, 50 or all items per page, previous and next buttons and a header with the order number, item count, unit count and grand total. The popup is a proper dialog: focus moves into it, Tab stays inside it and Escape closes it. Both numbers can be changed in the configuration.

Grid speed and export

For all rows on the current grid page the module reads the order items with one query, the orders with one query and, when thumbnails are on, the products with one query, so the number of queries does not grow with the number of rows. A smaller page size or turning thumbnails off reduces the work further. The column is also written to the grid's CSV and Excel XML export as plain text, such as Name (SKU) x 2 per item.

Settings

Settings are under Stores, Configuration, Panth Extensions, Ordered Items Grid, at default scope only. You can switch the whole column off, or turn off thumbnails, SKU, price, quantity, options, status badges, the summary and the product link one by one. The column can also be hidden from the grid's own Columns control.

Requirements and install

The README lists Magento Open Source and Adobe Commerce 2.4.4 to 2.4.8. Composer requires PHP 8.1, 8.2, 8.3 or 8.4 and mage2kishan/module-core, which it installs for you. Install with composer require mage2kishan/module-ordered-items, then run setup:upgrade, static content deploy for the admin CSS and JavaScript, and a cache refresh. The module adds no database tables, observers, cron jobs or console commands.

Ordered Items is free and open source under the MIT License. See the package README for every setting and the changelog for each release.

Developer notes

These names are from release 1.0.12 of the package.

  • Module Panth_OrderedItems, namespace Panth\OrderedItems. Loads after Panth_Core, Magento_Sales and Magento_Catalog. No preferences, routes, controllers, web API endpoints or widgets are declared.
  • Column class: Panth\OrderedItems\Ui\Component\Listing\Column\OrderItems. prepareDataSource() builds the cell HTML; rendering, option, thumbnail and fulfillment badge helpers are private.
  • view/adminhtml/ui_component/sales_order_grid.xml adds column order_items with body template ui/grid/cells/html and sortOrder 200.
  • Panth\OrderedItems\Plugin\Export\MetadataProviderPlugin on Magento\Ui\Model\Export\MetadataProvider, admin area only, fills order_items with plain text on export and removes the column from the export when the module setting is off.
  • With the module setting off, the column is prepared with componentDisabled, so it is not rendered and not offered in the column picker.
  • ACL resource: Panth_OrderedItems::config.
More information
Module Category Admin Tools
Best For All Sizes

FAQ

Does this slow down the order grid?

Not much. For all rows on the current grid page it runs one order item query, one order query and, when thumbnails are on, one product query, so the count does not grow per row. A smaller grid page size or turning thumbnails off reduces the work further.

Does it work with configurable, bundle, and grouped products?

Configurable items show their selected options, such as size and colour, and bundle items show their selections, up to four lines per item. Grouped products are ordered as their simple items, so each one shows as its own line.

Can I disable specific elements like prices or SKUs?

Yes. Thumbnails, SKU, price, quantity, options, status badges, the summary and the product link each have their own switch, and the whole column can be turned off.

Does it modify the sales_order_grid database table?

No. The module has no database schema and changes no tables. The cell is built when the grid page loads, from the order item, order and product collections.

Does it work with third-party order management extensions?

It only reads order, order item and product data and writes nothing, so it does not change orders handled by other modules. It reads Magento collections directly rather than the order repository.

Will it conflict with other grid customization extensions?

It adds one column to the sales_order_grid listing and one admin plugin that fills the column in exports. Existing columns are not changed. Test it on staging with other grid modules, especially ones that also change export data.

Kishan Savaliya

Questions before you install?

Send me your composer.json and I will check for conflicts first. Free. Installation is +$45, custom work is quoted first.

Ask on WhatsApp