The state of Michigan puts a file on the internet with state minimum pricing for all liquor items sold in the state. The problem is that they don't do a very good job on this file. Specifically they will have more than one record for an item. What we've seen is that the holiday items that come with a gift attached to the bottle will be listed under the same UPC as the regular item. So what ends up happening when we import this file is that the system processes the first record, programs the item correctly, then when it hits the gift item it overwrites the good programming with the gift item's data. This causes problems. 

Our solution to this problem is that we have created a system that blacklists items and skips them when we run the import. Instead of getting the file directly from the state of Michigan, your system will talk to a GLDS server, and grab the file from us. The file that we maintain is updated and all blacklisted items are removed before we run the import. 

This gives us another problem to deal with, which items are the right ones, and which items are the bad items? We don't know 100%. We took the state's item file and weeded out as much of the garbage as we could, but there may still be items that are not correct. 

This item is bad what do I do? 

Report the bad item to us. 

Click the "Other" button in the MI Liquor Management tool, then click the button that says "Report Bad Item". 

This will pull up a form that you fill out. Tell us exactly which item is bad, why it's bad, and fill in the contact information. This will send us an email telling us there's a bad item. We may contact you to get some more information about the item, then we'll add it to the blacklist of items we want to remove from the file. With the help of retailers we should be able to whittle out the bad items completely over time. We appreciate your help with this.