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

Literature Organizers/Sorters(34)

Waste Containers & Accessories(33)

Stools & Drafting Chairs(26)

Adjustable Worksurfaces(25)

Printer/Fax Stands(23)

Desktop Organizers(19)

Training Room Tables(19)

Coat/Garment Hooks(16)

Mobile File Carts & Cabinets(16)

Big & Tall Chairs(15)

Utility/Service Carts(15)

Folding/Stacking Chairs & Carts(14)

Wall Sorters/Racks(13)

Active Seating(12)

Desktop File Sorters(11)

Workstations/Computer Desks(11)

Reception, Side & Guest Chairs(10)

Hand Trucks & Dollies(10)

Floor Organizers/Sorters(9)

Smoking Receptacles(9)

Lamps(8)

Compact & Student Desks(7)

Roll Files(7)

Lecterns(7)

Wall Files, Pockets & Accessories(7)

Industrial & Commercial Shelving(7)

Coat/Garment Racks(7)

Lockers(6)

Wire Shelving(6)

Suggestion Boxes & Cards(6)

Task Chairs(6)

Flat/Plan Files(6)

Panels/Partitions(6)

Art & Drafting Tables(5)

Mailroom Sorters & Tables(5)

Arm Sets(5)

Foot Rests(5)

Utility & Breakroom Tables(4)

Laminate Bookcases(4)

Letter Trays(4)

Recycling Bins(4)

Hooks & Hangers(4)

Backrests & Seat Cushions(3)

Dry-Erase Boards(3)

Cubicle / Partition Organizers & Accessories(3)

Executive/High Back Chairs(3)

Tabletop Sorters/Racks(3)

Drawer Organizers(3)

Signs & Sign Holders(3)

Traditional - Laminate(2)

Mail Carts(2)

Mobile Racks(2)

Monitor Stands/Risers(2)

Projector Stands & Carts(2)

Contemporary - Laminate(2)

Business Card Holders(1)

Casters(1)

Wood Veneer Bookcases(1)

Mouse & Keyboard Wrist Rests(1)

TV/VCR Stands & Mounts(1)

Desk Center Drawers(1)

Reception Area & Accent Tables(1)

Portable Storage Files & Bins(1)

Telephone Stands & Holders(1)

Laptop Stands & Pads(1)

Pencil Holders(1)

Storage Boxes & Containers(1)

Strength/Sports Training Equipment(1)

Key Boxes & Cabinets(1)

Legs(1)

Power Strips(1)

Mobile Pedestals(1)

Wall Racks(1)

Anti-Fatigue Mats(1)

Extension Cords(1)

Brand

Safco(513)

Focal(4)

Onyx it!(2)

Color

Black(202)

Gray(40)

Silver(28)

White(18)

Clear(14)

Mahogany(10)

Cherry(10)

Medium Oak(9)

Tan(9)

Tropic Sand(7)

Stainless Steel(5)

Charcoal(5)

Blue(5)

Dark Gray(4)

Black Base(4)

Sand(3)

Mahogany Base(3)

Putty(3)

Pewter(3)

Chrome Hook(2)

Red(2)

Black Speckle(2)

Charcoal Gray(2)

Wood Grain(2)

Hook(2)

Chrome(1)

Aluminum(1)

Champagne(1)

Matte Black(1)

Wine(1)

Oak(1)

Silver Frame(1)

Black Powder Coat(1)

Light Gray(1)

Baltic(1)

Cream(1)

Grass(1)

Black Vinyl(1)

Recycled

No(358)

Yes(26)

Price Range

$0-$499.99(465)

$500-$999.99(47)

$1000-$1499.99(4)

$1500-$1999.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

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