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

Currently Filtered by

Category

Dollies

Refine Search

  GO
 
Brand

Rubbermaid Commercial(6)

NPS(5)

Bostitch(1)

Boardwalk(1)

Impact(1)

 
For Use With

Bostitch BMUELG2P(1)

Boardwalk 32GLWRGRA, 44GLWRGRA(1)

Impact 77553, 7720GRA, 7732GRE(1)

NPS 1100 Series Chairs(1)

NPS 8100 and 9000 Series Chairs(1)

Slim Jim 16 and 23-Gallon Vented Trash Cans(1)

Brute 20-Gallon, 32-Gallon, 44-Gallon, and 55-Gallon Round Waste Containers(1)

Brute 32-Gallon, 44-Gallon, and 55-Gallon Round Waste Containers(1)

Brute 20-, 32-, 44- and 55-gal Round Containers(1)

Rubbermaid Commercial 2655(1)

Rubbermaid Commercial 3526, 3536(1)

 
Country of Origin

US(8)

CN(6)

 
Color(s)

Black(8)

Brown(3)

Silver(1)

Gray(1)

Black/Green(1)

 
Material(s)

Plastic(7)

Steel(5)

 
Caster/Glide/Wheel Type

Swivel Casters(2)

Four 3" TPR Swivel Casters(2)

Four 3" Nonmarking Casters(1)

Five 3" Nonmarking Swivel Casters(1)

Two Fixed Wheel Casters; Two Swivel Nylon Casters(1)

Two Swivel Casters; Two Stationary Hard Rubber Casters(1)

Four Polypropylene Casters(1)

Four Hard Rubber Casters(1)

Two Locking Swivel Hard Rubber Casters; Two Non-Locking Swivel Hard Rubber Casters(1)

Two 8" TPR Fixed Wheels; Four 4" TPR Swivel Casters(1)

 
Number of Wheels

4(10)

5(2)

6(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved