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

Currently Filtered by

Category

Pad Holders

Refine Search

  GO
 
Brand

Post-it®(10)

3M(2)

Lorell(2)

OIC(1)

Post-it®(1)

Post-it Pop-up Notes Super Sticky(1)

Fellowes(1)

Post-it Pop-up Notes(1)

 
Color

Black(8)

Translucent(4)

White(3)

Periwinkle(1)

Mint(1)

Yellow(1)

Bronze(1)

Dark Graphite(1)

 
Size Supported

3" Width x 3" Length Note(9)

3" Width x 3" Length(1)

1" Length Flag(1)

1" Width x 1.75" Length(1)

 
Recycled

No(11)

Yes(1)

 
Packaged Quantity

1 Each(14)

1 / Each(1)

200 / Pack(1)

1 Pack(1)

 
Assembly Required

No(11)

 
Limited Warranty

5 Year(1)

1 Year(1)

3 Year(1)

 
Weight (Approximate)

2.72 oz(1)

 
Recycled Content

0%(9)

60%(1)

 
Media Size Supported

3" x 3"(4)

 
Manufacturer Part Number

PH654BK(1)

PD654US(1)

PBL100(1)

WD330BK(1)

WD330COLMT(1)

22362(1)

WD330WH(1)

WD330COLPW(1)

GOLF330(1)

ED654W(1)

680HVSH(1)

84252(1)

84156(1)

BEAR330(1)

CAT330(1)

ED654G(1)

DS330-BK(1)

DS100(1)

7528201(1)

 
Country of Origin

China(10)

United States(5)

South Korea(2)

CN(1)

US(1)

 
Material

Plastic(13)

Steel(2)

 
Height

1.8"(2)

1.6"(2)

1.3"(1)

3.8"(1)

4.8"(1)

4.3"(1)

0.9"(1)

 
Width

3.4"(2)

3.9"(1)

4.8"(1)

5.1"(1)

4.2"(1)

3"(1)

7.6"(1)

3.6"(1)

 
Depth

4"(3)

4.1"(2)

7"(1)

4.3"(1)

2"(1)

3.4"(1)

 
Color(s)

Black(1)

Black/Silver(1)

 
Material(s)

Plastic(2)

 
Refillable

Yes(2)

 
Overall Width

8"(1)

4 3/4"(1)

 
Overall Depth

5 1/2"(1)

4 1/2"(1)

 
Paper Color(s)

Color Varies(1)

Asparagus(1)

 
Overall Height

2 3/4"(1)

3"(1)

 
Number of Sheets per Pad

45(2)

 
Sheet Size (W x H)

3" x 3"(2)

 
Accepts Pad Size (W x H)

3" x 3"(2)

 
Note Dispenser Type

Pop-Up Note & Flag(1)

Pop-Up(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved