Home > SI5 Documentation > User Guide > Product Data > MMPD > Product Grid

Product Grid

Table of contents

Product Grid

product grid tab.jpg

One way to manage the Products in your database is through the Product Grid screen.  This screen allows you to see multiple Products in your database in a grid format.  From this screen you can add, edit, copy, and delete any Product in your database.

You cannot manage Packages on this interface.  Use the Product Explorer interface to edit Packages.

You can filter your Products using the Manufacturer, Category, Type, Phase and Search tabs on the left-hand side of the screen.  You also have the options “Display discontinued products” and “Display only unapproved products”. 

product grid filtering.jpg

File:Si5Wiki/SI5/05Product_Data/2MMPD/1Product_Grid/product_grid_filtering2.jpg

Along the top of the grid you have the following option buttons: [Add Product], [Edit Product], [Copy Product], [Delete Product], [Add and Remove Columns, Groups], [Sort], [Print], [Export], [Update Price], and [Open in I/O Studio], [Google Product Search].

File:Si5Wiki/SI5/05Product_Data/2MMPD/1Product_Grid/product_grid_buttons.jpg

 

File:Manage_My_Product_Data/Product_/image004.png...... Add a new Product to your MasterTable database

PDM Edit Selected Product - Package...... Edit an existing Product

MMPD Copy Product...... Copy an existing Product

PDM Delete Products - Packages...... Delete an existing Product

PDM Refresh Groups...... Refreshes the Groups displayed in the grid.  This button is inactive until you choose to group the products in your grid, see the next option.

PDM Add or Remove Columns and Groups...... Add and Remove Columns, Groups - this option allows you to modify the grid layout.  This opens a form:

File:Manage_My_Product_Data/Product_/image010.png

PDM Sort...... Sort - you can sort up to three levels deep, ascending or descending

You can also access the Columns/Grouping, Refresh Groups, and  Sort options by right-clicking any column heading.  When you right-click a column heading, you will see some additional functions:

File:Manage_My_Product_Data/Product_/image013.png

 

Right Click Command

Description

AutoFit Column

Resizes the selected column to the width of the longest string

AutoFit Rows

Resizes all rows to the same height

Sort Ascending

Sorts the selected column by value: lowest to highest (alternative = left mouse click once in a column heading)

Sort Descending

Sorts the selected column by value: highest to lowest (alternative = left mouse click once in a column heading)

Print...... Print - prints the contents of the Product Grid

PDM Export to Excel...... Export - this allows you to export the contents of the Product Grid to an Excel spreadsheet.

MMPD - update price...... Update Price - this option allows you to update multiple Products at one time

Example: You want to change the markup on all of your Sonance outdoor speakers to 40%.

Use the tabs to select: Manufacturer = Sonance, Category = Speakers, Type = Outdoor.  The Product Grid will filter based on the criteria.

File:Manage_My_Product_Data/Product_/image017.jpg

Our MVP data partners have asked that we not show cost data if possible.

Select the products you want to update.  To select multiple products use standard Windows selection controls by holding down <Shift> or <Ctrl> on your keyboard while selecting with the mouse.

File:Manage_My_Product_Data/Product_/image018.jpg 

Click MMPD - update price.  The Update Price form will open:

File:Manage_My_Product_Data/Product_/image019.png

Select what Price Type you are updating and enter a Markup as a percentage (40 = 40%) then click [Update]. See Product Price for more information.

File:Manage_My_Product_Data/Product_/image020.png...... Open in I/O Studio – this will launch the I/O Studio for one or multiple products selected in the grid.

File:Si5Wiki/SI5/05Product_Data/2MMPD/1Product_Grid/google_button.jpg...... Opens a browser and runs a Google Product Search on the selected products.

 

You can also access many of the functions described above by right-clicking any row in the Product Grid.  When you right-click a row, you will see some additional functions:

File:Si5Wiki/SI5/05Product_Data/2MMPD/1Product_Grid/pg_right-click.jpg

 

Right Click Command

Description

View Extended Data

Resizes the selected column to the width of the longest string

Web Specs

Resizes all rows to the same height

Expand All

This expands all [+] symbols displayed in the PDM (groupings)

Collapse All

This collapses all [+] symbols displayed in the PDM (groupings)

 

 

 

Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.