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

Currently Filtered by

Category

Cable Management

Refine Search

  GO
Brand

Dotz(12)

D-Line(10)

Softalk(9)

Cord Away(6)

Tatco(6)

Command(5)

Kensington(2)

Belkin(2)

Case Logic(1)

HON(1)

Height

1"(5)

1/2"(4)

5/8"(3)

3 3/5"(2)

4 1/2"(2)

5 9/10"(1)

3 1/4"(1)

Assorted(1)

5 1/4"(1)

2 1/4"(1)

Color(s)

Black(23)

Clear(6)

White(5)

Natural(3)

Assorted(2)

Ivory(2)

Gray(2)

Clear/Ash(1)

Clear/Black(1)

Pink(1)

Almond(1)

20 of each: Blue, Gray, Lime, Orange, Yellow(1)

Gray/White(1)

Assorted Colors(1)

Brights: Blue; Green; Orange; Red; Yellow(1)

2 of each: Blue, Clear, Gray, Lime, Orange, Yellow(1)

Blue(1)

Emerald(1)

Depth

3/4"(2)

1/2"(2)

1"(2)

1 2/5"(2)

5/8"(1)

1(1)

3/5"(1)

3/8"(1)

1 1/4"(1)

5"(1)

6 1/2"(1)

Assorted(1)

2 2/5"(1)

1 3/4"(1)

6"(1)

Closure

Click-Lock(4)

Locking Latch(3)

Tamper resistant(2)

Hook and Loop Repositionable Fastener(1)

Diameter

2"(1)

2 3/8"(1)

3"(1)

Assorted(1)

1 1/4"(1)

1/4" to 2"(1)

1"(1)

Manufacturer Part Number

WID34MCE(1)

WID34MCBL(1)

WID34MCK(1)

WID34MCPK(1)

03201(1)

MCW32MCW(1)

MCW32MCK(1)

DCI101COCB(1)

DCG42MCK(1)

DCI131HEKC(1)

DCI151M(1)

DCI171M(1)

03205(1)

03215(1)

22300(1)

22200(1)

22500(1)

22600(1)

22700(1)

22100(1)

21002(1)

1501(1)

1500(1)

1505(1)

21000(1)

21001(1)

DCC40MCK(1)

17305CLRES(1)

FC68B(1)

CTW25B(1)

IDKIT1(1)

R5FT3015W(1)

R5FT5025W(1)

CTUSMLB(1)

CTULGEB(1)

CT-6(1)

F8B024(1)

CC1(1)

CTT1125B(1)

CTT11B(1)

GRMTACX(1)

64612(1)

17017CLRES(1)

00208(1)

17301CLRES(1)

17302CLRES(1)

17304ES(1)

00207(1)

00205(1)

64613(1)

00201(1)

00202(1)

00204(1)

F8B023(1)

Country of Origin

CN(24)

US(15)

GB(9)

TW(4)

MX(2)

Width

1"(4)

3/16"(4)

1/2"(4)

3/4"(2)

3 3/4"(2)

1/16"(2)

2 1/2"(2)

1 1/2"(2)

1 1/4"(2)

4 1/4"(1)

4 1/3"(1)

12 3/4"(1)

1(1)

16 1/2"(1)

3 1/4"(1)

2 3/4"(1)

3 1/2"(1)

2"(1)

Assorted(1)

5/8"(1)

3 4/5"(1)

Length

1 1/2"(3)

1 5/8"(3)

25 ft(3)

48"(3)

8"(3)

1 1/4"(2)

43"(2)

3-3/4"-Wrap up to 5 ft.(2)

60"(2)

11"(2)

4"(2)

72"(1)

6 3/4"(1)

3/4 "(1)

6 ft(1)

98"(1)

Assorted(1)

6ft(1)

3 5/8"(1)

1 3/4"(1)

Tensile Strength

50 lb(4)

18 lb(2)

Cable Management Type

Cord and Cable(10)

Cord Concealer(9)

Tie(8)

Detangler(6)

Clip(5)

Detangler with Phone Cord(3)

Grommet(3)

Anchor(2)

Wrap(1)

Identification Labels(1)

1 1/2" Locking Channel(1)

Non-Locking J Channel(1)

1" Locking Channel(1)

Strap(1)

Price Range

$0-$49.99(50)

$50-$99.99(3)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved