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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`category_name` LIKE "Post-It & Adhesive Notes") 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 MATCH(`desc_short`) AGAINST ('PostItandAdhesiveNote' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+PostItandAdhesiveNote' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"PostItandAdhesiveNote"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"PostItandAdhesiveNote"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"PostItandAdhesiveNote"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"PostItandAdhesiveNote"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+PostItandAdhesiveNote' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='PostItandAdhesiveNote',`category_4` ='PostItandAdhesiveNote') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'PostItandAdhesiveNote,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('PostItandAdhesiveNote', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Post It And Adhesive Notes

Refine Search

  GO
Brand

Post-it(128)

Business Source(22)

Redi-Tag(1)

Adams(1)

Color

Assorted(77)

Canary Yellow(43)

Yellow(14)

Pastel(3)

Pink(2)

Neon(2)

Aqua Wave(2)

Electric Yellow(2)

Neptune Blue(1)

Mulberry(1)

Limeade(1)

Periwinkle(1)

Orange(1)

Orchid(1)

Black(1)

Green(1)

Blue(1)

White(1)

Red(1)

Bright Assorted(1)

Neon Pink(1)

Translucent(1)

Electric Blue(1)

Size Supported

4" Width x 4" Length Note(1)

Recycled

No(125)

Yes(27)

Manufacturer Part Number

67512SSCP(1)

675-6SSAN(1)

675-6SSCY(1)

MMM 663(1)

MMM 660(1)

660-RP-A(1)

MMM 660RP(1)

660SSGRID(1)

675-6SSNRP(1)

6756SST(1)

7366OFF3(1)

DS330-SSVA(1)

DS440-SSVP(1)

7350SSSTR(1)

6845-SSP(1)

675-6SSUC(1)

675-YL(1)

680-RYGB2(1)

660-5SSCY(1)

660-5PK-AST(1)

655-5UC(1)

655-AST(1)

655-RP-A(1)

655-5PK(1)

65524VADB(1)

MMM 654(1)

655-12SSCY(1)

65518CP(1)

MMM 655RP(1)

MMM 655(1)

660-3SSNRP(1)

6603SST(1)

660-3SSUC(1)

660-3SSAN(1)

660-3AU(1)

659(1)

660-3AN(1)

F2208SSAU(1)

F33012SSAL(1)

R330RP-12YW(1)

R330RP6AP(1)

R330-U-ALT(1)

R330RP12AP(1)

R330-N-ALT(1)

MMM R330AN(1)

R330-AP(1)

MMM R330AU(1)

R330-YW(1)

R330YWPK(1)

R440-FFSS(1)

MMM R440-YWSS(1)

29500(1)

R440-AQSS(1)

R350YWPK(1)

MMM R335(1)

R350-YW(1)

R330-6SSUC(1)

R3306SST(1)

R330-10SSAU(1)

R330-12AN(1)

R330-12AP(1)

R330-10SSAN(1)

F33016SSAU(1)

F33012SSAU(1)

F33012SSFM(1)

F33012SSY(1)

R330-12AU(1)

R330-12SSCY(1)

R330-24VAD(1)

R3306PNK(1)

R330-6SSAN(1)

R33018CP(1)

R33018AUCP(1)

R330-14-4B(1)

R33014YWM(1)

654RP-YW(1)

654-RP-A(1)

2056-PP(1)

2056-RC(1)

5592PKBCA(1)

2056-FP(1)

2051-3PK(1)

36619(1)

36620(1)

36621(1)

5845-SSAN(1)

5845-SSUC(1)

630-6PK(1)

635-5AN(1)

635-5AU(1)

630-6AN(1)

6228SSAU(1)

622-10SSCY(1)

6228SSAN(1)

36618(1)

36617(1)

16455(1)

16493(1)

16498(1)

16454(1)

16453(1)

16450(1)

16451(1)

16452(1)

16500(1)

16501(1)

36614(1)

36615(1)

36616(1)

36613(1)

36612(1)

21459(1)

36610(1)

635(1)

6445-SSP(1)

654-24SSCYN(1)

65424SSTCP(1)

65424VADB(1)

654-24SSCP(1)

65424SSAUCP(1)

65424APVAD(1)

65424NHCP(1)

65424SSANCP(1)

654-5PK(1)

654-5SSAN(1)

654-CYP-24VA(1)

654R24CPAP(1)

654R24CPCY(1)

654-AST(1)

654-5UC(1)

6545SST(1)

6545SSUC(1)

654-18CP(1)

654-18BRCP(1)

653-RP-A(1)

653RP-YW(1)

MMM 653(1)

653-AU(1)

653-AST(1)

65324APVAD(1)

65324VADB(1)

653AN(1)

65412SSAN(1)

654-12SSCY(1)

654-14AN(1)

654-14AU(1)

65414YWM(1)

654-14-4B(1)

654-12SSUC(1)

654-12SSNRP(1)

65412SST(1)

9711NEON(1)

Binding Type

Stapled(1)

Gummed(1)

Material

Paper(122)

Plastic(1)

Paper Fibre(1)

Width

5.2"(1)

Height

1.6"(1)

Depth

5"(1)

Sheet Size

25" x 30"(1)

4" Width x 5" Length(1)

Shape

Square(95)

Rectangle(52)

Star(1)

Sheet Type

Plain(1)

Number of Sheets

30(1)

50(1)

Number of Sheets per Pad

100(58)

90(39)

25(6)

70(5)

45(4)

75(4)

50(2)

470(2)

300(1)

400(1)

490(1)

Dispenser Included

Yes(2)

No(1)

Country of Origin

United States(146)

China(6)

Price Range

$0-$49.99(151)

$50-$99.99(1)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2017-2018 Granite Office, LLC, All Rights Reserved