Allow for the bulk update of a secondary specification in PIM V12

Thanks for the call Jyothi.

As discussed, I've created another idea to allow bulk editing using import templates, without the need to include attributes into Bulk Edit view.

MDMCE-I-372

Hi Omar,

We had a call today with Vipul and checked the environment. The issue seems to be resolved now. The secondary specs are now showing up correctly. The Laptops/Notebooks is showing up only those attributes which are mapped specifically to the category, and they are not showing up any other additional attributes from other specs.

Also as mentioned earlier, now you can go ahead and use the existing Import/Export feature for the bulk update.

Additionally I have also guided Vipul on the various ways the bulk update can be performed.

Let me know if you need any further assistance.

Thanks,

Jyothi P

Hi Jyothi,

Looks like you have updated the status to Functionality already exists!

From memory, I believe Vipul from Persistent has taken you through this already. If not, I am happy to take you through this myself in our dev environment.

We cannot use Find & Replace or Bulk Edit Export/Import to modify these secondary specs. The reason behind that is because they are over 300 secondary specs. Should we enable all these attributes (Attribute Collection) to be included in Bulk Edit (From Catalog Console), the loading of the Collaboration Items would take too long. The performance decreases dramatically.

Is there any way to bulk edit or replace attributes that are not included in the attribute collection - collaboration items view?

Hi Jyothi,

I would like to clarify more on this enhancement request please.

In terms of secondary specs:-

We can see in the below screenshot1, All the items are belonging to the category "Laptops & Notebooks". The secondary spec "Laptops & Notebooks" is attached to the category "Laptops & Notebooks"(screenshot2).

But, in the bulk edit screen we can see the attributes from other secondary spec i.e. "HANDHELD MIXERS"(screenshot1).

In this case, in the Persona UI, these different secondary specs will be loaded upfront which would take too long and cause performance issue.

Please let me know if you require additional clarification, we can always jump into a call to review this one. And It is very urgent and demanding for the business to have a fix ASAP.

Thanks,
Omar

Hi Omar,

Even if there are multiple secondary specs mapped to the categories, the bulk edit grid will have only those secondary spec attributes which are applicable for the items present in the gird

So for example if I have 300 secondary specs mapped across say 100 categories, so each category say has 3 secondary specs each. Now if I have items belonging to only 1 category present in the grid, then I see the attributes available for the 3 secondary specs. If I have items belonging to multiple categories then the grid will have the attributes that are available for each of those items.

Hence your below statement is not correct and the system is actually taking care of loading only relevant secondary specs attributes for the items

"Here we are looking for some solution in out of the box bulk edit screen so that it will load/update only those secondary specs which are related to items displayed in bulk edit screen."

Thanks

Jyothi

Hi Jyothi,

I think there is understanding gap on this issue. I would like to mention that this issue is related to viewing/editing data in bulk edit screen. As there are almost 300 secondary specs attached with bulk edit view and while loading/updating data in bulk edit view takes huge time because it works with those secondary specs.

Here we are looking for some solution in out of the box bulk edit screen so that it will load/update only those secondary specs which are related to items displayed in bulk edit screen.

Please let me know the time to have a call on this if you have further queries on the same.

Thanks.

• By design, “Find & Replace” is meant to work on bulk data and hence we create a job which runs in the background so as to avoid any degradation in user experience. While dealing with bulk data, selecting large number of records is not a very good experience for users. Hence while designing, it was made in such a way so that it is not related to the selections made by user on screen. It works on the complete data set returned irrespective of what is selected.

As of now, we do not have any plans to change this design in near future as it may impact other customer's as well.

If user want to do replace selectively then the right way to do that is to first apply filter (using grid filter) on the items within grid and then you can do “Find & Replace”. Alternatively, user can export the data to excel, update the items in Excel and re-import them.

• Import/Export Feature : In order to achieve selective record update, you can do any of the following

  • Export the entire content into excel(Say total 50 records). Open the generated file and remove the items you are not interested in(Say 30 records). Update the remaining records that you are interested in(20 records). And then re-import the updated excel file, and the changes will be reflected only to the interested records(20 records)

  • Alternatively, you can select some of the records present on the UI, using the check box, click on export to export the selected records to generate the excel. The generated excel will have only the limited records which were selected at the time of export. Update the records and re-import the excel and changes will be reflected

This feature is already available since IPM 12.0 FP04 release.

Please check these features and let us know if it resolves your purpose.