product -excel export/import

[SAPSupport]

Hi, team in product level we created a custom item with one to many relation. We want the same item to be a part of excel import/ export. Can u please help how to show this custom attribute as a part of excel import and export .

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Out-of-the-box, Backoffice supports attributes of the following types: String, Number, Date, Boolean, and all enums, which extend de.hybris.platform.core.model.enumeration.EnumerationMetaTypeModel. To export or import attribute, which is a reference to another type, you need to provide appropriate translator and validators.

Therefore, I would recommend you to implement your own com.hybris.backoffice.excel.translators.ExcelValueTranslator and then registering it in excelTranslators bean.

For details, see Excel Translators in Backoffice and Excel Validators in Backoffice topics.

Besides, this thread should be helpful: https://answers.sap.com/questions/12771144/how-to-export-relational-attribute-to-excel-sheet-.html