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

Currently Filtered by

Manufacturer

GEORGIA PACIFIC

Refine Search

  GO
 
Category Filter

Towels & Wipes(85)

Toilet Tissues(30)

Towel Dispensers(13)

Napkins(11)

Facial Tissues(11)

Toilet Paper Dispensers(10)

Office Paper(10)

Napkin Dispensers(5)

Personal Soaps(1)

Soap Dispensers(1)

Toilet Seat Cover Dispensers(1)

 
Brand

Georgia Pacific Professional(137)

Georgia Pacific(18)

Brawny(6)

Brawny Industrial(5)

Angel Soft(4)

Sparkle(2)

Interstate(1)

Brawny Dine-A-Max(1)

Pacific Garden(1)

Quilted Northern(1)

Quilted Northern Soft and Strong(1)

Vanity Fair(1)

 
Height

10 1/2"(3)

7 1/8"(3)

16 7/10"(2)

16"(2)

11 1/2"(2)

18"(1)

12 1/4"(1)

11 3/10"(1)

9 3/8"(1)

11 3/4"(1)

13 1/2"(1)

7 3/8 in(1)

13"(1)

10 3/4"(1)

7 1/2"(1)

15 2/5"(1)

10.6 in(1)

14 3/4"(1)

28 25/32"(1)

6 16/25"(1)

7 1/4"(1)

14 1/4"(1)

13 1/4"(1)

 
Color(s)

White(122)

Translucent Smoke(15)

Brown(12)

Black(7)

Stainless Steel(3)

Orange(2)

Blue(1)

Green;White(1)

Yellow(1)

Blue/Gray/Black(1)

Smoke Gray(1)

 
Depth

9 7/8"(4)

6 3/4"(4)

12"(2)

9 3/10"(2)

5 1/4"(2)

9 3/4"(2)

6 3/5"(2)

15"(1)

2 1/2"(1)

9 1/2"(1)

10"(1)

5 2/5"(1)

5 39/100"(1)

12 1/8"(1)

8 3/4"(1)

10 3/8"(1)

6 9/10"(1)

6 1/2"(1)

5 1/2"(1)

16"(1)

13 7/8"(1)

8 1/2 in(1)

9"(1)

8 7/64"(1)

7 12/25"(1)

13 5/8"(1)

12 3/4"(1)

4 3/8 in(1)

13 1/2"(1)

17"(1)

 
Quantity

1 each(21)

5,000 per carton(3)

1,500 per carton(2)

1 per carton(1)

1 per kit(1)

2,400 per carton(1)

500 per ream(1)

200,000 per pallet(1)

2,500 per carton(1)

 
Size

8 1/2 x 11(7)

8 1/2 x 14(2)

11 x 17(1)

 
Packing Type

Roll(7)

Box(4)

Poly Wrap(3)

Flat Box(3)

Cube Box(2)

Carton(2)

Pack(1)

Case(1)

box(1)

Bag(1)

 
Diameter

5 2/5"(2)

5 4/5"(1)

4 4/5"(1)

 
Paper Color(s)

White(10)

 
Hole-Punched

3-Hole Punched(1)

 
 
 

© 2020-2021 Onestop, Inc., All Rights Reserved