SAP Knowledge Base Article - Preview

3060059 - Excel Import Failed in Backoffice with validation error "Column \{0\} is required for sheet \{1\}"

Symptom

After implemented customization on type system localization, users want to use Excel Import feature to import Products in Backoffice, but it failed with error notification "Column \{0\} is required for sheet \{1\}".

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

SAP Commerce with below versions:

  • SAP Commerce 1808.0 - 1808.39
  • SAP Commerce 1811.0 - 1811.37
  • SAP Commerce 1905.0 - 1905.29
  • SAP Commerce 2005.0 - 2005.13
  • SAP Commerce 2011.0 - 2011.8

Product

SAP Commerce 1811 ; SAP Commerce 1905 ; SAP Commerce 2005 ; SAP Commerce 2011

Keywords

excel import, excel export, backoffice, validation error, locale label, localization, space, trim , KBA , CEC-SCC-CDM-BO-FRW , Framework , CEC-COM-ADM-BO , Backoffice , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.