John,

According to your requirements, you may be missing some table(s) holding the cost of the item and bonus quantity.

Show us your query, describe all tables,...