BMS Imports | Product import fails when using Import data function

Issue

Data import fails when importing products to BMS using Admin > Import data.

Error message: Products Product Name is required!. Products Product Number is required!

Cause: When you copy-paste or import data from databases or other file formats, the column formats get modified. To fix this make use of  Text to Columns in excel and re-try the import. 

Solution

Select a Column to convert. On the Data tab, click Text to Columns. This opens the Convert Text to columns Wizard. Choose the following options. 

Step 1: Select Delimited, Click Next 

Step 2: Select Tab as the delimiter, Click Next

Step 3:  In Column data format, select Text. Click Finish  

Use the above steps on the following columns and attempt to import the products again.