Guide for Extended Product Grid with Editor for Magento 2

Get the advanced product grid in your Magento 2 store: add columns, edit data right in the cells, and even manage the product inventory in one handy extension. Moreover, you can create templates to save the desired grid layouts and switch between them according to your needs. Also, the module provides flexible settings to utilize its potential in the most convenient way.

• Edit product data right on the grid
• Activate additional product attributes
• Add product grid templates
• Manage product inventory by adding or deducting items
• Customize filters to easily find information
• Compatibility with Magento Enterprise splitted databases

In the General Settings section you will find three options to configure. They are:

• Editing Mode;
• Additional Grid Columns;
• Quantity Based Availability.

Now, let's find out their functionality and choose mass action to add to Magento 2 product grid.

Editing Mode — allows you to choose how you will edit the product grid:

• Single Cell — saves your modifications for each cell independently;
• Multi Cell — lets you configure multiple cells and then save them in bulk.

Crop Decimal Digits - set to Yes if you want to have all the decimal digits in the grid cropped to 2 decimal places and rounded.

If this feature is enabled, a number like 25.5678 will be displayed as 25.57 in the grid. It applies to all decimal digits in the grid, except those that have already been processed, such as prices.

Products Qty — specify the number of related products, up-sells, cross-sells to be displayed on the grid.

'Qty Sold' Date From — specify the date to count the 'Qty Sold' from.

'Qty Sold' Date To — specify the date to count the 'Qty Sold' to.

'Qty Sold' Order Statuses — select order statuses to include orders in the 'Qty Sold' column.

Quantity Based Availability — when set to 'Yes', availability will automatically change to 'In stock' when quantity is positive and to 'Out of stock“ when quantity is zero or negative. When set to 'No', availability status will not be updated automatically.

Show Quantity as Integer - select the necessary quantity display.

After configuring the extension's general settings we can proceed to the product grid.

Navigate to your product grid that is located in Products → Catalog. From here you can add columns to Magento 2 product grid for further usage.

• Click the Columns button to open the dropdown menu and configure columns;
• Select the Default tab;
• Tick the default columns that should be displayed;
• Mark them with a color to make it noticeable.

The editing of the Attribute Set column is available as a part of an active product subscription or support subscription.

Now you can add/update product images and product videos right from the grid. Enable editing of the Thumbnail column and then just click the icon in the grid and then, in a modal window, choose the thumbnail from the existing product images are upload a new one.

Moreover, you can add custom columns to the product grid.

• Select the Extra tab;
• Tick the columns that you want to display.

Also, in this dropdown menu you can make columns editable right from the grid. Tick columns under the Edit text. Hit the Save button to proceed.

Now you can easily update and assign the categories of the products right from the grid. Just click on the category of any needed product in the grid and tick required checkboxes in a dropdown

Editable columns will be marked with the special icon with a notepad.

With the module, you can add extra product attributes to the grid.

• Click the Columns button to open the dropdown menu and configure columns;
• Select the Attribute tab;
• Tick attributes that should be displayed.

Moreover, you can make any product attribute accessible from the Attribute tab of the Columns menu.

Please go to Stores → Product and choose an attribute you want to add to the grid. Then, in the Properties tab expand the Advanced Attribute Properties section. Here you need to enable the Add to Column option. Also, to make an attribute available for filtering enable the Use in Filter option.

After the grid is configured, it is displayed like this:

Hit the Filters button to configure and apply custom filters. From this menu you will have the access to custom attributes that you enabled on the previous steps. Press the Apply Filters button to activate the configured terms.

Using filters, you can find products from particular category or items that are not assigned to any. Also, it is possible to sort products by the image, e.g. you can find the ones without thumbnails.

When you finished configuring the grid's columns, product attributes, and filters, you can save the current stat of the grid as a template.

• Hit the Default View button;
• Choose the Save View As option to create a template;
• Then, you can switch between the created templates from this menu.

You may also export data placed on the particular grid view using a separate tab.

Allowed formats:

• CSV
• Excel XML

Using the Extended Product Grid with Editor for Magento 2 extension you can modify products data right on the grid. See previous steps to make columns editable.

You can edit data in columns that are marked with a special symbol. Just click the required cell to edit data. Make changes in all cells and hit the Save Edits button to apply changes. Note, that the module verifies the data you filled in. Data in the unsuitable formats will not be saved and you will be notified and asked to fill the field in correctly.

If you forget to save changes and continue catalog management, the extension will display a reminder popup to prevent data loss.

You are able to modify product quantity on the grid:

• Make the 'Quantity' column editable;
• Specify the necessary quantity;
• Alternatively, you can add or deduct product quantity (e.g. you can write ”+100“ or ”-100“ and the extension will make calculations automatically after you click the 'Save' button);
• Save changes.

Additionally, the extension supports multi-source management. If the Qty column is editable and you have more than one source, you can edit the quantity for each source separately in the appeared popup.

Modify any product info in bulk using Mass Product Actions. The combination of two extension will help you to find the necessary products and update them in a split second.

How it works:

For example, you want to add +10$ to the prices for all red women blouses in your store (prices are different for blouses, but anyway you want to rice each price by 10$). Let's see how you can do it:

Step 1. Configure the necessary grid view and activate filters. In our case, we need category, attribute set and color filters.

Step 2. Tick all or select the products that you need.

Step 3. Expand the Actions dropdown and apply 'Update Price'. Add +10$ to the each blouse price.

Step 4. Check the result!

The extension allows you to add quick product frontend links to check all the changes right in the store and product pages.

To add frontend links do the following:

• Click the Columns button;
• Navigate to the Extra tab;
• Flag the Front End Product Link column.

Now, you will have direct product links on the grid.

Rate the user guide

from 3 votes (Details)       1 visitor votes 0 visitor votes 0 visitor votes 0 visitor votes 1 visitor votes