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 (`pinfo`.`sku` IN ('MMMR440YWSS','MMMR440FFSS','MMMR440AQSS','MMMR350YW','MMMR335YW','MMMR330YW','MMMR330UALT','MMMR330RP6AP','MMMR330RP12YW','MMMR330RP12AP','MMMR330NALT','MMMR330AU','MMMR330AP','MMMR330AN','MMMR3306SSUC','MMMR3306SST','MMMR3306SSMIA','MMMR3306SSAN','MMMR33024VAD','MMMR33018SSAUCP','MMMR33018CP','MMMR33018AUCP','MMMR33014YWM','MMMR330144B','MMMR33012SSCY','MMMR33012AU','MMMR33012AP','MMMR33012AN','MMMR33010SST','MMMR33010SSMIA','MMMR33010SSAU','MMMR33010SSAN','MMMF3304SSY','MMMF3304SSFM','MMMF3304SSAU','MMMF3304SSAL','MMMF33016SSAU','MMMF33012SSY','MMMF33012SSFM','MMMF33012SSAU','MMMF33012SSAL','MMMF2208SSFM','MMMF2208SSAU','MMMBP22B','MMMBP15P','MMMBP11Y','MMM76794SS','MMM766212SS','MMM7366OFF3','MMM6845SSPL','MMM6845SSP','MMM675YL','MMM6756SSUC','MMM6756SST','MMM6756SSNRP','MMM6756SSMIA','MMM6756SSCY','MMM6756SSAN','MMM67512SSCP','MMM663YW','MMM660YW','MMM660SSGRID','MMM660RPYW','MMM660RPA','MMM6609YW','MMM6609RP','MMM6605SSCY','MMM6605PKAST','MMM6605PK','MMM6603SSUC','MMM6603SST','MMM6603SSNRP','MMM6603SSMIA','MMM6603SSAN','MMM6603AU','MMM6603AN','MMM659YW','MMM655YW','MMM655RPYW','MMM655RPA','MMM655AST','MMM6559YW','MMM6559RP','MMM6555UC','MMM6555PK','MMM65524VADB','MMM65518CP','MMM65512SSCY','MMM654YW','MMM654RPYW','MMM654RPA','MMM654RP24YW','MMM654RP24AP','MMM654R24CPCY','MMM654R24CPAP','MMM654CYP24VA','MMM654AST','MMM6549YW','MMM6549RP','MMM6549PUY','MMM6549PUB','MMM6549PUA','MMM6549B','MMM6549A','MMM654918PK','MMM6545UC','MMM6545SSUC','MMM6545SST','MMM6545SSMIA','MMM6545SSAN','MMM6545PK','MMM65436VAD90','MMM65424VADB','MMM65424SSTCP','MMM65424SSMIACP','MMM65424SSCYN','MMM65424SSCYM','MMM65424SSCY','MMM65424SSCP','MMM65424SSAUCP','MMM65424SSAU','MMM65424SSANCP','MMM65424NHCP','MMM65424APVAD','MMM65418CP','MMM65418BRCP','MMM65414YWM','MMM65414AU','MMM65414AN','MMM654144B','MMM65412SSUC','MMM65412SST','MMM65412SSNRP','MMM65412SSMIA','MMM65412SSCY','MMM65412SSAN','MMM653YW','MMM653RPYW','MMM653RPA','MMM653AU','MMM653AST','MMM653AN','MMM6539YW','MMM6539RP','MMM65324VADB','MMM65324APVAD','MMM6445SSP','MMM635YW','MMM6355AU','MMM6355AN','MMM6306PK','MMM6306AN','MMM6228SSMIA','MMM6228SSAU','MMM6228SSAN','MMM62210SSCY','MMM5845SSUC','MMM5845SSAN','MMM4622SSAN','MMM2056RC','MMM2056PP','MMM2056FP','MMM2053SPVAD','MMM20513PK','MMM2027RCR','')) 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 '%PostItNotes' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('PostItNotes' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+PostItNotes' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"PostItNotes"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"PostItNotes"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"PostItNotes"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"PostItNotes"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+PostItNotes' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='PostItNotes',`category_4` ='PostItNotes') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'PostItNotes,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('PostItNotes', `pinfo`.`desc_title`)) DESC

Currently Filtered by

PostItNotes

PostItNotes

Refine Search

  GO
 
Category Filter

Self-Stick Pads(148)

 
Brand

Post-it Notes Super Sticky(51)

Post-it Notes(41)

Post-it Pop-up Notes(16)

Post-it Greener Notes(15)

Highland(14)

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

 
Color(s)

Canary Yellow(34)

Rio de Janeiro Collection(18)

Cape Town Collection(10)

Jaipur Collection(10)

Yellow(10)

Miami Collection(9)

Marseille Collection(9)

Marrakesh Collection(9)

Helsinki Collection(8)

Bora Bora Collection(8)

Canary Yellow; Cape Town Collection(5)

Bali Collection(4)

Assorted Bright(2)

Assorted Pastel(2)

Pink(1)

White(1)

Assorted Designs(1)

Electric Yellow(1)

Canary Yellow; Marrakesh Collection(1)

Canary Yellow; Green Wave(1)

Seafoam Wave(1)

Blue Wave(1)

Aqua Wave(1)

Pink Wave(1)

 
Refillable

No(4)

 
 
 
 
 

© 2019-2020 Office 8, All Rights Reserved