The second issue is that you don't have item types for some of your items. That won't cause issues with searching, but it will cause errors when you try to check the items in or out. The item numbers are given in the error messages, and you can use sql to find the barcodes.