[FEAT] Add Inventory and Qty Columns to Products Grids for Better Stock Visibility

[addison74]

Is there an existing issue for this?

• I have searched the existing issues

Description

Currently, product grids like Related Products, Up-sells, Cross-sells, do not provide clear information about the stock. Specifically, it does not show the Inventory status (in stock, out of stock) and the Quantity (Qty). This lack of stock information can create confusion when adding such of products, and they do not appear in the Frontend, because of the store settings.

Navigate to the Catalog > Products section in the Admin panel. Open a product that has related products. Under the Related Products tab, observe that the grid currently includes columns such as ID, Name, Type, Attrib. Set Name, Status, Visibility, SKU, Price, Position. There are no columns displaying the Inventory and the Quantity (Qty) available for each related product.

Proposed Solution:
Add two new columns to all product grids (except the Associated Product grid for configurable products which I will report separately):

Inventory: This column should indicate the stock status of each product (In Stock, Out of Stock) the same behavior like in the Associated Products grid.

Qty: This column should display the available stock quantity for each related product.

Edit Action (except the one in the category page): for changing a product information right away.

Use Cases and Benefits:
Improved Stock Visibility: Store admins will have a better overview of product availability, which is crucial for ensuring accurate product listings and avoiding issues with products that are out of stock even they are enabled.

Faster Product Management: Admins can quickly spot which related products need to be restocked or are available for backorder, reducing errors in product availability and order fulfillment.

Better Customer Experience: Ensures that the correct product availability is reflected in the admin interface, ultimately improving the accuracy of what is shown to customers on the frontend.

Conclusion:
Adding these two columns (Inventory and Qty) to the product grids would significantly improve the management of related products, allowing admins to make better-informed decisions regarding stock levels and product availability. This change will also eliminate confusion regarding products that are enabled but out of stock or available for backorder, improving both backend efficiency and frontend accuracy.

Expected Behavior

Two more columns and the Edit action for each product in the grids.

Benefits

No response

Anything else?

No response