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

Currently Filtered by

Category

Counterfeit Bill Detectors

Refine Search

  GO
 
Brand

Canon(19)

Dri-Mark(7)

Royal Sovereign(4)

MMF Industries(3)

SteelMaster(1)

 
Height

0.8"(1)

2.5"(1)

6"(1)

2.8"(1)

4.7"(1)

4.21"(1)

6.1"(1)

4.5"(1)

 
Color(s)

Black(17)

Cyan(2)

Magenta(2)

Yellow(2)

Gray(2)

Black; Cyan; Magenta; Yellow(1)

Tri-Color(1)

Pigment Black(1)

Cyan; Magenta; Pigment Black; Yellow(1)

Photo Cyan(1)

Photo Magenta(1)

Light Gray(1)

Black/Green(1)

Silver(1)

 
Depth

4.5"(1)

4"(1)

4/5"(1)

4.88"(1)

4.7"(1)

3.74"(1)

3.2"(1)

0.6"(1)

 
Manufacturer Part Number

0620B010(1)

6391B002(1)

RCD3120(1)

RCD3000(1)

RCD1000(1)

200100(1)

200045304(1)

200045112(1)

200045110(1)

351UVB(1)

351UV6(1)

351TRI(1)

351R-1(1)

351FT(1)

351B1(1)

3513B-1(1)

6390B002(1)

1509B002(1)

4548B001(1)

1511B002(1)

4530B001(1)

4530B007(1)

4530B008(1)

4546B001(1)

4547B001(1)

4549B001(1)

6389B002(1)

4550B001(1)

6384B002(1)

6385B002(1)

6386B002(1)

6387B002(1)

6388B002(1)

RCDUVP(1)

 
Country of Origin

JP(19)

CN(12)

US(3)

 
Width

2.5"(1)

7"(1)

0.8"(1)

5 1/2"(1)

10.6"(1)

7.28"(1)

5.4"(1)

2.6"(1)

 
For Use With

Canon PIXMA PRO-100(8)

Canon PIXMA iP4820, iP4920, iX6520, MG3520, MG5120, MG5220, MG6120, MG6220, MG8120, MG8220, MX882, MX892(5)

Canon PIXMA iP4820, iX6520, MG5120, MG5220, MG6120, MG8120, MX882(2)

Canon PIXMA iP1700, JX200, JX210P, MP150, MP160, MP170, MP180, MP450, MP460, MX300, MX310(1)

Canon PIXMA iP100(1)

Canon PIXMA iP100, mini260, mini320(1)

Canon PIXMA MG6120, MG6220, MG8120, MG8120B, MG8220(1)

 
Device Types

Inkjet Printer(19)

 
Supply Type

Ink(19)

 
Ink Base

Dye-Based(8)

Pigment-Based(1)

Dye-Based; Pigment-Based(1)

 
Liquid Volume

38 mL(1)

 
Counterfeit Indication Mark

Black;Dark Brown(5)

Black/Brown(3)

Black; Dark Brown(1)

Red(1)

Ultraviolet Security Strip(1)

 
Page-Yield

200(1)

100(1)

 
Counterfeit Bill Detector Type

Pen(7)

MICR; UV Light; Watermark(1)

UV Light; Watermark Detector; Color-Change Ink; Micro-Print Detector(1)

UV Light and Watermark Detector; Color Change Ink(1)

Infrared Detector; Magnetic Strip Detection; UV Light(1)

UV Light(1)

UV; Magnetic; Watermark; MicroPrint(1)

Liquid; MICR(1)

Ultraviolet(1)

 
Currency

U.S.(13)

U.S.; Canadian, Mexican;EU; UK; Chinese(1)

U.S. and most foreign currencies(1)

 
Remanufactured

No(19)

 
 
 

© 2020-2021 Meadows Office Supply, All Rights Reserved