Hello,

I am using zen cart 1.5. Have an unusual request.

I have a client who has this site http://www.domo-online.com/Outboard-...oil-ezp-1.html

They sell oil. In drums and gallons.

Currently they are setup with the UPS XML module. It works great. BUT if the customer orders a Drum they want the website to use the table rates (which I can setup) so that it will charge them freight based on the state and product they ordered. Each drum has a different rate to ship to states.

The challenge is that I need to account for people ordering drums and gallons--so combine the two totals. I know I can check to see if they ordered an item from the "drum" category but they also have the 'drums' listed under other categories--linked.

I think I would need to check if they ordered a certain "product number" and if so then get the table rate (based on which product they ordered) then add it to the UPS total

any help would be great, not really sure how to do this. I understand the logic.