Help Documentation

Excel Mode in a Product Information Management (PIM) system provides users with a familiar interface similar to working with spreadsheets in Excel. It offers various features that facilitate efficient editing and management of product information. 

Edit a product using Excel Mode in a PIM system

1. Access the Products section.
2. Customizing Attribute Display
   1. Locate the Columns section on the Product Listing page.
   2. To add attributes, checkmark the corresponding checkboxes next to the desired attributes.
   3. To remove attributes, uncheck the checkboxes next to the attributes you wish to exclude.
3. Entering Attribute Values
   1. Identify the attributes for which you need to enter specific values.
   2. Click on the empty fields corresponding to the relevant attributes.
   3. Enter the desired values directly into the fields.
4. Dragging Attribute Values (Optional)
   1. If the same value applies to all products for a particular attribute, you can utilize the dragging feature.
   2. Locate the attribute field that contains the desired value.
   3. Click and hold the value, then drag it to the corresponding fields of other products.
   4. Release the mouse button to apply the value to the selected products.
5. Attribute Group Name
   1. The Product Listing page header displays the name of the attribute group.
   2. The attribute group name serves as a visual indicator to help users understand the context and purpose of the displayed attributes.
   3. When on the Product Display Page, click the Edit option, typically located in the top-right corner of the screen or within the product details view.
6. Bulk Delete the attributes from the product listing page
   1. Select the attributes
   2. Click Delete from the keyboard.

     7. Attribute Column

1. 1. Pin Column
      1. No Pin-Does not pin the column in the Product Listing Page; it should remain in its current position without any horizontal movement, neither to the left nor to the right
      2. Pin Left-Pinning to the left allows the attribute to be displayed on the left side
      3. Pin Right-Pinning to the right allows the attribute to be displayed on the right side
   2. Autosize this column-Enabling ‘Autosize columns’ adjusts the width of the selected column in the PLP based on the length of the entire text, ensuring that we can view the complete text without it being truncated.
   3. Autosize all column-Enabling ‘Autosize all columns’ adjusts the width of all columns in the PLP based on the length of the entire text, ensuring that we can view the complete text without it being truncated.
   4. Reset columns-The ‘Reset columns’ feature ensures that all columns have uniform width.

  8. Downloading Product Information in a CSV/Excel format

1. Change the Pagination size according to how many product information you want to download[Default is 50 ] and choose the Product Listing Page by clicking on left or right wrt to need.
2. Left-click on the screen
3. Click on Export
4. Choose CSV, Excel.

This action downloads up to 50 products Product Information.

Note: To export the entire data, simply navigate to the last page, right-click, and select ‘Export.