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-COM-ADM-BO , Backoffice , CEC-COM-CPS , SAP Commerce , How To

About this page

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

Search for additional results

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