Our butcher shop has had an ecommerce store since 2010. As our site is ancient we need to update. We have an IT freelancer working on a magento site for us but have run into a snag on the shipping.
All of our orders need to be shipped with 48 hours or less time in transit as the product is perishable.
We have a database of all destination zip codes that UPS can deliver to from our origination zip code within 48 hours using UPS Ground service. Our old website would check the shipping zip code against the previously mentioned database. If there was a match the website would ask UPS for a "Ground" quote and if not then would ask for "2nd day air" service quote.
The new magento based site returns shipping quotes for both ground and 2nd day air. We need to figure out how to restrict the shipping option to one or the other based on matching the zip code database or not. Any ides on how to accomplish this?