We have over 5000 items in our item master list. It does not seem logical to manually input them directly into the BoM or using excel to clean up the items and import them. There is simply just too much items in the master list. What are some solutions to this?