YETI Hopper M20 Backpack Soft Cooler
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '18050125002' AND (upper(f.web_text) = 'YETI COOLERS' or upper(f.orig_text) = 'YETI COOLERS' or upper(a.brand) = 'YETI COOLERS') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
The Hopper M20 Soft Cooler allows you to put the day on your back - literally. This hands-free cooler comfortably straps on like a backpack to keep you mobile, while a strip of ultra-strong magnets keeps the cold locked in. The new MagShield Access opens wide so you can easily load in beer, ice or your favorite sandwiches. Attach accessories such as the Rambler Bottle Sling or Sidekick Dry Gear Case to the HitchPoint Grid to keep useful gear at your fingertips. The Hopper M20 is the cooler that goes where other coolers can't.
Part backpack, part cooler, all YETI. Hands-freed hauling and a comfortable fit lets you take cold provisions well past the trailhead.
MagShield Access uses powerful magnets to create an ultra leak-resistant shield that stays open when you need it an seals closed with a gentle push.
Out DryHide Shell is made from a high-density fabric that withstands punctures and UV rays. To help extend the life of the cooler, both the interior and exterior materials are treated to be mildew resistant.
ColdCell Insulation uses closed-cell foam technology to lock the cold in and keep your refreshments fresh.
Please note: Do not leave the cooler propped open and unattended in the presence of children and animals.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$29.97 to $40.00
$375.00 to $399.99