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

Manufacturer

Currently Filtered by

Manufacturer

Safco

Refine Search

  GO
Category

Waste Containers & Accessories(30)

Literature Organizers/Sorters(27)

Adjustable Worksurfaces(27)

Stools & Drafting Chairs(25)

Printer/Fax Stands(22)

Desktop Organizers(19)

Training Room Tables(16)

Big & Tall Chairs(16)

Coat/Garment Hooks(16)

Folding/Stacking Chairs & Carts(15)

Active Seating(15)

Utility/Service Carts(13)

Mobile File Carts & Cabinets(13)

Wall Sorters/Racks(13)

Workstations/Computer Desks(13)

Desktop File Sorters(11)

Hand Trucks & Dollies(10)

Floor Organizers/Sorters(9)

Smoking Receptacles(9)

Task Chairs(9)

Lamps(8)

Compact & Student Desks(7)

Wall Files, Pockets & Accessories(7)

Roll Files(7)

Reception, Side & Guest Chairs(7)

Coat/Garment Racks(7)

Industrial & Commercial Shelving(7)

Lockers(6)

Lecterns(6)

Foot Rests(5)

Art & Drafting Tables(5)

Suggestion Boxes & Cards(5)

Desktop Risers(5)

Panels/Partitions(4)

Tabletop Sorters/Racks(4)

Signs & Sign Holders(4)

Hooks & Hangers(4)

Utility & Breakroom Tables(4)

Laminate Bookcases(4)

Wire Shelving(4)

Letter Trays(4)

Recycling Bins(4)

Mailroom Sorters & Tables(3)

Drawer Organizers(3)

Backrests & Seat Cushions(3)

Executive/High Back Chairs(3)

Cubicle / Partition Organizers & Accessories(3)

Dry-Erase Boards(3)

Arm Sets(3)

Pencil Holders(2)

Projector Stands & Carts(2)

Mobile Pedestals(2)

Mail Carts(2)

Traditional - Laminate(2)

Strength/Sports Training Equipment(2)

Mailboxes(2)

Mobile Racks(2)

Flat/Plan Files(2)

TV/VCR Stands & Mounts(1)

Storage Boxes & Containers(1)

Mouse & Keyboard Wrist Rests(1)

Key Boxes & Cabinets(1)

Legs(1)

Desk Center Drawers(1)

Contemporary - Laminate(1)

Extension Cords(1)

Telephone Stands & Holders(1)

Portable Storage Files & Bins(1)

Wall Racks(1)

Anti-Fatigue Mats(1)

Business Card Holders(1)

Power Strips(1)

Laptop Stands & Pads(1)

Brand

Safco(491)

Focal(6)

Onyx it!(3)

Color

Black(196)

Gray(37)

Silver(30)

White(21)

Clear(14)

Medium Oak(9)

Tan(9)

Mahogany(7)

Blue(6)

Charcoal(5)

Stainless Steel(5)

Cherry(5)

Black Base(4)

Tropic Sand(4)

Mahogany Base(3)

Pewter(3)

Dark Gray(3)

Chrome Hook(2)

Charcoal Gray(2)

Red(2)

Hook(2)

Wood Grain(2)

Putty(2)

Sand(2)

Silver Frame(2)

Black Powder Coat(2)

Black Speckle(1)

Natural(1)

Chrome(1)

Matte Black(1)

Walnut(1)

Oak(1)

Pocket(1)

Wine(1)

Light Gray(1)

Champagne(1)

Baltic(1)

Aluminum(1)

Grass(1)

Grass Green(1)

Cream(1)

Black Vinyl(1)

Recycled

No(348)

Yes(21)

Price Range

$0-$499.99(424)

$500-$999.99(73)

$1000-$1499.99(2)

$2000-$2499.99(1)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2019-2020 Granite Office, LLC, All Rights Reserved