Panth Advanced Product Grid

What you get

See It In Action

Key Features

Inline Edit Every Column

• Text / number / URL key / SKU, type and tab between cells, just like a spreadsheet
• Select / Yes-No, dropdown that resolves option labels (including option values containing commas, e.g. INDEX,FOLLOW)
• Multiselect, searchable modal with checkboxes and clear-all
• Date / datetime, calendar picker with locale-aware formatting
• Price / cost / special price / weight, plain numeric input (no $ prefix in the editor)
• Textarea, full-height modal editor instead of a cramped inline field
• Image (base / small / thumbnail / swatch), modal with upload, preview, and "view on storefront" link
• Tier price, full modal with website + customer-group scoping
• Multi-row mass edit, banner-based Save / Cancel for editing multiple rows at once

Auto-Discover EAV Attributes

• Every product attribute flagged is_used_in_grid = 1 shows up automatically
• Brand-new attributes you enable via the Columns panel get a real UI component (filter, options, editor) created on the fly
• The AttributeSetAssigner quietly attaches an attribute to a product's set on first inline edit, so writes never silently no-op at the EAV layer

20+ Extra Columns

Tabbed Manage Columns Panel

• Five tabs, Standard, Pricing, Inventory, SEO, Attributes, Extras
• Per-column toggles: Visible, Editable, Filterable, In Export, sort order
• Inline rename, set a custom label per column without touching XML
• Drag-and-drop reorder that persists into the bookmark
• "Reset all overrides" button to wipe per-column customizations in one click

Smart Filters for Every Data Type

• Text / textarea → substring match
• Select / boolean → dropdown of option labels
• Multiselect → automatic FIND_IN_SET lookup so picking one option matches rows storing many
• Date / datetime → date-range picker
• Price / weight / quantity → from/to numeric range
• Custom virtual filters, Categories ("No Categories" sentinel), Availability (manage-stock aware), Qty Sold range, Thumbnail (added / missing)

Performance Engineering

• Bookmark-aware select, the data provider walks the user's current bookmark and only loads the EAV attributes that are actually visible
• Batched queries, categories, stock, tier prices, qty sold, and image data are loaded in single queries keyed by the page's row IDs (never row-by-row)
• Indexed qty sold, panth_product_grid_qty_sold mview keeps a denormalized total
• Constructor-only DI, zero ObjectManager calls, MEQP-compliant

Unsaved-Changes Guard

• Every grid navigation (paging, sizes, sorting, filtering, mass actions, exports, bookmarks) checks for in-progress edits and prompts before discarding them
• Synchronous fast-path when nothing is dirty so the grid never feels laggy

Export Aware of Visible Columns

• CSV / XML export respects the bookmark's column order and visibility
• Option labels are resolved (no raw 12,34,56 in the output)
• Per-column "In Export" toggle in the Manage Columns panel

Extra Columns Reference

Thumbnail

Renders the product's base image (or small_image / thumbnail / swatch_image if available) with a hover overlay that exposes View (storefront link) and Edit (modal upload) actions.

Categories

Colored chips, one per assigned category, with the full path resolved (e.g. Bags › Travel › Duffles). Click a chip × to remove the category from the product directly from the grid.

Availability

A tri-state derived from manage_stock, use_config_manage_stock, and is_in_stock:

• In Stock, manage_stock=1 and is_in_stock=1
• Out of Stock, manage_stock=1 and is_in_stock=0
• Manage Stock Disabled, manage_stock=0 (always considered available)

Backorders

Standard backorders attribute exposed as a select column with editable options: No Backorders / Allow Qty Below 0 / Allow Qty Below 0 and Notify Customer.

Low Stock

Boolean derived from the configurable threshold. Quick filter to surface near-empty SKUs without writing a report.

Qty Sold (Indexed)

Total units sold over the configured window. Uses an mview-indexed table (panth_product_grid_qty_sold), even on stores with hundreds of thousands of orders the column loads in milliseconds.

Storefront URL

Computed <base>/<url_key> link that opens in a new tab. Resolves correctly under multi-store and category-aware URL setups.

Tier Prices

Shows the count of active tier-price rows ("4 tiers"). Clicking opens a modal where the admin can add / remove tiers, switch between Fixed Price and Discount Percentage, and assign each tier to a specific website + customer group.

Inline Edit Strategies

Each attribute type routes through a dedicated strategy class in Model/InlineEdit/Strategy/:

All saves go through Model/InlineEdit/Processor which:

1. Force-reloads the product in edit mode (so every EAV attribute is in _origData and writes always persist).
2. Calls AttributeSetAssigner to ensure the attribute is bound to the product's set.
3. Dispatches to the right strategy.
4. Saves via the standard ProductRepository.
5. Verifies, then optionally refreshes URL rewrites.

Manage Columns Panel

Click the Columns button (top-right of the grid) to open the centered popup. Inside:

• Tabs group columns into Standard, Pricing, Inventory, SEO, Attributes, Extras.
• Toggle switch on the left controls visibility.
• Text input lets you rename the column (e.g. rename "manufacturer" to "Brand").
• Type badge shows the data type (text / select / multiselect / date / price / image / textarea).
• Edit / Filter / Sort Order / Width / Marker Color chips control per-column behavior.
• Apply Changes persists overrides into panth_product_grid_column_config and reloads the grid.
• Reset all overrides clears every saved customization in one click.

Double-clicking a column header in the grid also opens a quick-rename prompt for that single column.

Smart Filters

Filtering works automatically for every column the data provider knows about:

• The filter UI rewrites condition types based on the underlying EAV frontend_input so multiselect attributes use FIND_IN_SET (otherwise picking "Red" on a multi-color attribute would never match rows storing 12,34,57).
• Custom virtual filters add features Magento doesn't ship with: panth_categories (with a "No Categories" sentinel), panth_availability (manage-stock aware), panth_qty_sold (numeric range), panth_thumbnail (added / missing).
• All filters honor the column's Filterable toggle in the Manage Columns panel, turn it off to hide the filter from the toolbar.

Export Behavior

When Export Visible Columns Only is enabled (default), CSV / XML exports:

• Include only the columns currently visible in the user's bookmark
• Preserve the visual column order
• Resolve option labels (so an INDEX,FOLLOW value exports as INDEX,FOLLOW, not 15)
• Honor the per-column In Export toggle so you can hide internal-only columns from the file

Disable the toggle in Stores → Configuration to fall back to Magento's stock export behavior.

ACL & Permissions

Use these in System → User Roles to give catalog managers exactly the privileges they need without giving away the whole admin.

Troubleshooting

Compatibility

Installation

Composer Installation (Recommended)

composer require mage2kishan/module-advanced-product-grid
bin/magento module:enable Panth_Core Panth_AdvancedProductGrid
bin/magento setup:upgrade
bin/magento setup:di:compile
bin/magento setup:static-content:deploy -f
bin/magento cache:flush
bin/magento indexer:reindex panth_product_grid_qty_sold

Manual Installation via ZIP

1. Download the latest release ZIP from Packagist or the Adobe Commerce Marketplace
2. Extract the contents to app/code/Panth/AdvancedProductGrid/ in your Magento installation
3. Ensure Panth_Core is installed (required dependency)
4. Run the same commands as above starting from bin/magento module:enable

Verify Installation

bin/magento module:status Panth_AdvancedProductGrid
# Expected output: Module is enabled

Configuration

Navigate to Admin → Stores → Configuration → Panth Extensions → Product Grid to configure the module.

License

Panth Advanced Product Grid is licensed under a proprietary license, see LICENSE.txt. One license per Magento installation.

Architecture

Magento product_listing UI overlay
 ├─ Ui/Component/Listing/Columns ← extends Magento_Ui Columns, auto-discovers EAV attributes
 ├─ Ui/Component/Listing/ColumnFactory ← builds a Column from an attribute (type, filter, options, editor)
 ├─ Ui/Component/Listing/AttributeRepository ← caches is_used_in_grid attributes + on-demand lookups
 ├─ Plugin/Catalog/Ui/DataProvider/
 │ ProductDataProviderPlugin ← bookmark-aware addAttributeToSelect + row enrichment
 │ ProductDataProviderFilterPlugin ← rewrites condition types per frontend_input
 └─ Model/InlineEdit/
 Processor ← per-product save loop
 StrategyResolver ← attribute_code → strategy
 AttributeSetAssigner ← auto-binds attribute to product's set
 Strategy/* ← one class per non-trivial attribute

view/adminhtml/
 ├─ ui_component/product_listing.xml ← overlay (no class replacement on existing columns)
 ├─ templates/rename-header-init.phtml ← inline JS bootstrap for Manage Columns + popup editors
 ├─ web/js/mixin/*-mixin.js ← Magento UI mixins for unsaved-changes guard
 └─ web/js/grid/columns/select-no-split.js ← legacy fallback for old browsers

• All cross-module integrations (MSI, ConfigurableProduct) are guarded by isTableExists() / module-list checks, disabling sibling modules is safe.
• The qty-sold mview subscription auto-switches to the sales DB connection on split-DB deployments via Plugin/Mview/SalesConnectionPlugin.
• Every controller is gated by an ACL resource (see below).