Why do I keep receiving a Uniqueness of index message when import to BOM?

Q.   Why do I keep receiving a Uniqueness of index message when import to BOM?

A.   There are a few scenarios that could be causing this message to appear: 
  1. A same part, with different description associated with different product, will cause this message to appear upon import. 
  2. If the Auto numbering is turned OFF and user has entered the same part number to items with same description but different customer part numbers will cause this message to appear.
When loading one BOM/product at a time into the ManEx System it checks to see if the users might have the same part number,  but with different descriptions or different customer part numbers  loaded on the spreadsheet.  If found then it would display that information in an XLS spreadsheet for the users to address.