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.
Product Name | Product Number | Product UPC | SKU | Vendor Part number |