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 ('611')) AND `pinfo`.`status` IN ('active','discontinued') 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 '%FoodWrap' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('FoodWrap' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+FoodWrap' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"FoodWrap"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"FoodWrap"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"FoodWrap"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"FoodWrap"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+FoodWrap' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='FoodWrap',`category_4` ='FoodWrap') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'FoodWrap,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('FoodWrap', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Food Wrap

Refine Search

  GO
 
Brand

Boardwalk(61)

Reynolds Wrap(35)

Bagcraft(30)

Dixie(21)

Marcal(9)

Glad(6)

Handi-Foil of America(2)

GEN(1)

Inteplast Group(1)

 
Quantity

1 roll(45)

6000 per carton(9)

6,000 per case(4)

5 pack(4)

1 per carton(4)

3,000 per case(3)

24 per carton(3)

2,000 per carton(3)

1 per case(3)

1,000 per carton(2)

12 per carton(2)

1 per box(2)

5,000 per carton(2)

2000 per carton(2)

6,000 per carton(1)

1 each(1)

50 per case(1)

24 roll(1)

20 per carton(1)

500 per box(1)

12 pack(1)

1 Roll(1)

9 per carton(1)

10,000 per carton(1)

4000 per carton(1)

5000 per carton(1)

3000 per carton(1)

3 pack(1)

10,000 per case(1)

1000 per carton(1)

 
Packing Type

Box(86)

Roll(46)

Pack(24)

Pop-Up Box(3)

Carton(3)

Dispenser(1)

Case(1)

Dispenser Box(1)

 
Manufacturer Part Number

RW126(1)

RW156(1)

S10(1)

S-15(1)

LO10(1)

KL24(1)

G15(1)

G8(1)

KL18(1)

S8(1)

SUPLOX15(1)

BR52X80(1)

5016(1)

5290(1)

1225CT(1)

1225(1)

SUPLOX18(1)

WR58(1)

PANLINER(1)

G12(1)

G10(1)

K6050612(1)

K6060510(1)

00020(1)

00020CT(1)

K6040765(1)

K4870437(1)

K3640900(1)

K4830874(1)

K4840765(1)

00022(1)

00022EA(1)

891254(1)

891255(1)

FG24(1)

862491(1)

512(1)

70441(1)

78616CT(1)

27S(1)

5291(1)

5292(1)

910SC(1)

914(1)

914M(1)

914SC(1)

910M(1)

910(1)

7534(1)

900BRF(1)

904(1)

915(1)

916(1)

SMP15(1)

SMP17(1)

SMP18(1)

F28028CT(1)

F28028(1)

916M(1)

F28015(1)

F28015CT(1)

721(1)

720(1)

611(1)

611M(1)

614(1)

614M(1)

8224(1)

8223(1)

5293(1)

5294(1)

8222(1)

615(1)

620(1)

632(1)

633(1)

711(1)

627(1)

625M(1)

624(1)

624M(1)

625(1)

K36301010(1)

K3030874(1)

300854(1)

300897(1)

300899(1)

7100(1)

300841(1)

300815(1)

300398(1)

300418(1)

300809(1)

7102(1)

7106(1)

7124(1)

7126(1)

7134(1)

7120(1)

7116(1)

7110(1)

7112(1)

7114(1)

300382(1)

145018(1)

014010(1)

016008(1)

016010(1)

016012(1)

012012(1)

012010(1)

010006(1)

011008(1)

011010(1)

030001(1)

030010(1)

057700(1)

057800(1)

057950(1)

057412(1)

057015(1)

051475(1)

057012(1)

057014(1)

7136(1)

7162(1)

DELI8(1)

F154510006M(1)

F184510006M(1)

F244510006M(1)

DELI6(1)

DELI15(1)

BL24364050(1)

DELI10(1)

DELI12(1)

K1230874(1)

K1250640(1)

K2450640(1)

K2460530(1)

K30301010(1)

K2440900(1)

K1850612(1)

K1540800(1)

K1830874(1)

K1840900(1)

B4840900(1)

B3640900(1)

7229(1)

B1540900(1)

B18401000(1)

7204(1)

7202(1)

7164(1)

7166(1)

7168(1)

B1840900(1)

B2440800(1)

B36401100(1)

B3640720(1)

B3640800(1)

B36364025(1)

B3040900(1)

B2440900(1)

B30401000(1)

B3040720(1)

010001(1)

 
Country of Origin

US(159)

CN(3)

CA(3)

FR(1)

 
Width

12"(35)

18"(24)

10 3/4"(11)

18 in(10)

24"(10)

15"(9)

36"(8)

10"(6)

14"(5)

30"(5)

48"(4)

12 in(4)

8"(4)

6"(3)

60"(3)

16 3/8"(2)

24 in(2)

10 3/4 in(2)

52"(1)

11 9/10"(1)

24 3/8"(1)

5"(1)

24 ft(1)

12 ft(1)

16"(1)

17"(1)

11 7/8"(1)

10 1/2"(1)

13"(1)

6 3/4"(1)

4 3/4"(1)

9"(1)

11 4/5"(1)

16 3/8 in(1)

5 1/2"(1)

24 1/3"(1)

10 in(1)

 
Material(s)

Paper(65)

Aluminum(37)

Plastic(23)

Wax-Coated Paper(8)

Wax Paper(5)

Dry Waxed Paper(4)

Foil/Paper(4)

Polyethylene(4)

Grease-Resistant Paper(4)

Poly-coated wax paper(2)

Aluminum Foil(2)

Quilon-Coated Paper(2)

Polyethylene Coated Paper(1)

Linear Low-Density Polyethylene(1)

Polycoated Paper(1)

Poly-coated freezer paper(1)

Grease proof paper(1)

Silicone Coated Parchment(1)

 
Length

1,000 ft(16)

10 3/4"(12)

500 ft(12)

12"(11)

900 ft(9)

10 3/4 in(8)

2,000 ft(8)

75 ft(5)

1000 ft(5)

874 ft(4)

800 ft(3)

15"(3)

14"(3)

2000 ft(3)

5000 ft(3)

10 1/2"(3)

200 ft(2)

765 ft(2)

16"(2)

25 ft(2)

300 ft(2)

12 in(2)

1,100 ft(2)

612 ft(2)

14 in(2)

8"(2)

15 in(2)

1010 ft(2)

24 3/8 in(2)

720 ft(2)

10.75''(1)

24 3/8"(1)

1100'(1)

10-3/4"(1)

16 in(1)

5"(1)

5 in(1)

3,000 ft(1)

1000'(1)

9 in(1)

18"(1)

80"(1)

7"(1)

16 3/8"(1)

5 1/2"(1)

530 ft(1)

10"(1)

640 ft(1)

6"(1)

10 1/4"(1)

640 ft.(1)

24"(1)

437 ft(1)

100 ft(1)

16 1/3"(1)

70 sq ft(1)

36"(1)

510 ft(1)

1100 ft(1)

1,000 ft.(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved