You say there is something for:
SHIP_METHOD can be Individual Shipping, UPS RATES, or Free Shipping
Is that a field in the table:
products

that holds this information?