Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('113109')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%FoodStorageBagsWraps' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('FoodStorageBagsWraps' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+FoodStorageBagsWraps' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"FoodStorageBagsWraps"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"FoodStorageBagsWraps"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"FoodStorageBagsWraps"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"FoodStorageBagsWraps"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+FoodStorageBagsWraps' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='FoodStorageBagsWraps',`category_4` ='FoodStorageBagsWraps') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'FoodStorageBagsWraps,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('FoodStorageBagsWraps', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Food Storage Bags Wraps

Refine Search

  GO
 
Brand

Ziploc®(25)

Genuine Joe(16)

Rubbermaid Commercial(11)

Dart(5)

CRYOVAC(4)

Pactiv(4)

Webster(3)

SKILCRAFT(3)

Reynolds Food Packaging(2)

Heritage(2)

Dixie(2)

Genpak(1)

Rubbermaid(1)

Hefty(1)

Solo(1)

Ziploc® Brand(1)

Sparco(1)

 
Color

Clear(55)

White(19)

Silver(5)

Gray(2)

Blue(1)

 
Recycled

No(42)

 
Packaged Quantity

200 / Carton(8)

1 Each(8)

6 / Carton(7)

12 / Carton(5)

250 / Carton(5)

500 / Carton(3)

100 / Carton(3)

1 / Carton(2)

250 / Box(2)

48 / Box(2)

1 Carton(2)

1000 / Carton(2)

500 / Box(2)

90 / Box(2)

432 / Carton(1)

1080 / Carton(1)

684 / Carton(1)

76 / Box(1)

3 / Pack(1)

612 / Carton(1)

68 / Box(1)

2 / Pack(1)

42 / Carton(1)

38 / Box(1)

7 / Pack(1)

342 / Carton(1)

18 / Carton(1)

100 / Pack(1)

50 / Carton(1)

68 Each(1)

50 / Box(1)

50 / Pack(1)

125 / Pack(1)

300 / Carton(1)

150 / Pack(1)

400 / Carton(1)

1500 / Carton(1)

2000 / Carton(1)

4000 / Carton(1)

6000 / Carton(1)

360 / Carton(1)

40 / Box(1)

450 / Carton(1)

315 / Carton(1)

 
Assembly Required

No(1)

 
Limited Warranty

1 Year(14)

 
Compatibility

Rubbermaid BPA-Free Food/Tote Box(1)

 
Exterior Material

Polycarbonate(1)

 
Bag Width

7"(6)

5.88"(4)

6"(2)

10.50"(1)

12"(1)

13"(1)

9.49"(1)

10.56"(1)

6.50"(1)

11"(1)

10.75"(1)

 
Bag Length

6.50"(5)

7.44"(3)

7.94"(2)

10.94"(1)

18"(1)

15.60"(1)

8"(1)

10.55"(1)

9.50"(1)

3.25"(1)

10.50"(1)

10.56"(1)

11"(1)

 
Case Style

Container(1)

 
Bag Thickness

1.75 mil (44 Micron)(13)

2.70 mil (69 Micron)(5)

1.15 mil (29 Micron)(3)

2.50 mil (63 Micron)(2)

1.68 mil (43 Micron)(2)

0.75 mil (19 Micron)(1)

1.20 mil (30 Micron)(1)

 
Volume Capacity

1 gal(13)

1 quart(10)

2 gal(2)

2 quart(1)

 
Kitchenware Details

1 x Food Container(12)

1 x Food Container - 9" Diameter(3)

1 x Lid(3)

1 x Food Container - 34 quart(2)

1 x Food Container - 9" Length x 9" Width(2)

1 x Food Container - 86 quart(2)

1 x Food Container - 8 fl oz - 21.90" Length x 15.60" Width(1)

2 x Food Container - 2.3 quart(1)

7 x Lid(1)

1 x Food Container - 1.2 quart(1)

1 x Food Container - 24 fl oz(1)

2 x Food Container - 8 fl oz(1)

3 x Food Container - 4 fl oz(1)

3 x Lid(1)

3 x Food Container - 1.3 quart(1)

1 x Food Container - 9.30" Length x 6.40" Width(1)

1 x Food Container - 2 quart(1)

1 x Utility Box - 28.5 quart(1)

1 x Utility Box - 18.4 quart(1)

1 x Utility Box - 20 quart(1)

1 x Food Container - 20 quart(1)

1 x Food Container - 50 quart(1)

1 x Food Container - 6" Length x 6" Width(1)

1 x Pan - 8.8 quart(1)

1 x Pan - 4 quart - 0.50" Diameter(1)

1 x Food Container - 7" Diameter(1)

2 x Lid(1)

 
Density

Low(2)

 
Kitchenware Type

Food Container(31)

Utility Box(3)

Pan(2)

 
Quantity Per Container

500(4)

250(3)

90(3)

300(1)

50(1)

1500(1)

35(1)

48(1)

432(1)

38(1)

342(1)

100(1)

 
Disposable

Yes(7)

 
Microwave Safe

Yes(8)

 
Number of Wraps

1(2)

 
Dishwasher Safe

Yes(12)

 
Manufacturer Part Number

205HT1(1)

314469(1)

650989(1)

650872CT(1)

650872(1)

650862CT(1)

650862(1)

316489(1)

315885(1)

VS608(1)

651305(1)

R82235CT(1)

630200CLRCT(1)

630200CLR(1)

3508WHICT(1)

3502- WHI(1)

3501WHICT(1)

3351GRACT(1)

3349GRACT(1)

650989CT(1)

651305CT(1)

3306- CLE(1)

682253(1)

30550200(1)

30550000(1)

99828(1)

682258(1)

682257(1)

682256(1)

682255(1)

665016CT(1)

662102(1)

665016(1)

665015CT(1)

665015(1)

664545CT(1)

664545(1)

664542CT(1)

664434CT(1)

662102CT(1)

3308CLECT(1)

3304CLECT(1)

85HT1(1)

10700(1)

11574CT(1)

11574(1)

11573CT(1)

11573(1)

10703(1)

10702(1)

10701(1)

ES9CSCOMPCT(1)

11575CT(1)

ES9CSCOMP(1)

100946910(1)

100946909(1)

100946908(1)

100946905(1)

90HT3R(1)

90HT1R(1)

85HT3(1)

11575(1)

11576(1)

3301CLECT(1)

6646907(1)

3300CLECT(1)

YTH10080CT(1)

YTH10080(1)

YTD18801CT(1)

YTD18801(1)

910(1)

611(1)

6646906(1)

11576CT(1)

6646905(1)

J1315WC(1)

F1218RC(1)

25300(1)

11579CT(1)

11579(1)

11577CT(1)

11577(1)

30550400(1)

 
Country of Origin

United States(60)

China(17)

Thailand(1)

 
Material

Plastic(17)

Foam(10)

Aluminum(4)

Poly(4)

Wood Pulp(3)

Molded Fiber(2)

Polyethylene(2)

Polystyrene(1)

Linear Low-Density Polyethylene (LLDPE)(1)

Resin(1)

Polycarbonate(1)

Paper(1)

Polyvinyl Chloride (PVC)(1)

 
Height

9.4"(2)

3.3"(2)

2.9"(1)

2.7"(1)

19.4"(1)

 
Width

7.9"(2)

9.4"(2)

18"(1)

8.3"(1)

 
Shape

Rectangular(1)

 
Length

28"(1)

8.8"(1)

 
Container Type

Carton(11)

Box(8)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved