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

Currently Filtered by

Category

Correction Tapes

Refine Search
  GO
 
Brand

BIC(15)

Tombow(12)

Universal(8)

AbilityOne(7)

Paper Mate Liquid Paper(5)

Post-it(2)

Datacard(2)

Evolis(2)

LEE(1)

Kodak(1)

Zebra Technologies(1)

 
For Use With

Evolis Primacy 2 Printers(2)

Datacard ENTRUST SIGMA DS1 and DS2 Card Printers(1)

Datacard ENTRUST SIGMA DS2 and DS3 Card Printers(1)

Kodak ID100S, ID200S Photo ID Card Printer(1)

Zebra Technologies ZC300(1)

Tombow 68666(1)

Tombow 68665(1)

Tombow 68697(1)

Tombow 68696(1)

 
Country of Origin

VN(16)

US(10)

MX(9)

CN(8)

MY(7)

TW(2)

JP(2)

GB(2)

 
Color(s)

White(27)

Black; Cyan; Magenta; Yellow(3)

Black; Cyan; Magenta; Yellow; Topcoat Protective Layer(2)

Assorted(1)

Blue; Green; Orange; Pink; Purple; Yellow(1)

Blue(1)

Translucent Black(1)

Four-Color(1)

 
Material(s)

Plastic(14)

Paper(2)

Plastic Dispenser; Plastic Film(1)

 
OEM/Compatible

OEM(6)

 
Device Types

Printer(5)

ID Printer(1)

 
Tape Length

394"(8)

472"(8)

236"(6)

315"(4)

19.8 ft(3)

393"(2)

314.4"(2)

700"(2)

10 m(2)

335"(2)

402"(1)

5 m(1)

197"(1)

12 m(1)

6 m(1)

8 m(1)

720"(1)

26.2 ft(1)

400"(1)

314"(1)

275"(1)

 
Tape Width

0.17"(20)

0.2"(19)

0.19"(2)

0.5"(1)

0.33"(1)

1"(1)

1/5"(1)

0.25"(1)

 
Case Color(s)

Clear(6)

Randomly Assorted(5)

Transparent/Red(4)

Gray/Clear(4)

Transparent Gray/Red(3)

White/Blue(3)

Blue; Purple; Yellow(2)

Aqua; Kiwi; Lavender; Rose(2)

Green; Purple(2)

Smoke(1)

Assorted(1)

Green(1)

Blue; Purple(1)

Tinted Translucent Black(1)

Green/White(1)

Blue; Green; Orange; Purple(1)

Blue(1)

White(1)

Blue/Translucent Black(1)

Blue; Green; Orange; Turquoise(1)

Clear/White/Blue(1)

Blue; Fuchsia(1)

Blue; Orange(1)

Clear/Red(1)

 
Printing Type

Thermal(6)

 
Line Coverage

1(45)

2(1)

6(1)

 
Ribbon Type

YMCKT Full Color(1)

YMCKT 2-Sided Full Color(1)

YMCKO Color(1)

YMCKOK 2-Sided Wax Color Ribbon(1)

YMCKO 2-Sided Full Color(1)

 
Character Yield

500 Cards(1)

350 Cards(1)

200 Images(1)

300 Prints(1)

200 Prints(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander