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(39)

Waste Containers & Accessories(30)

Printer/Fax Stands(27)

Stools & Drafting Chairs(23)

Adjustable Worksurfaces(21)

Desktop Organizers(20)

Mobile File Carts & Cabinets(16)

Utility/Service Carts(16)

Workstations/Computer Desks(16)

Training Room Tables(15)

Wall Sorters/Racks(15)

Coat/Garment Hooks(14)

Folding/Stacking Chairs & Carts(14)

Smoking Receptacles(14)

Floor Organizers/Sorters(13)

Wire Shelving(13)

Big & Tall Chairs(13)

Active Seating(12)

Recycling Bins(11)

Hand Trucks & Dollies(10)

Lockers(10)

Metal Bookcases(10)

Coat/Garment Racks(9)

Task Chairs(9)

Industrial & Commercial Shelving(8)

Lamps(8)

Lecterns(7)

Wall Files, Pockets & Accessories(7)

Roll Files(7)

Compact & Student Desks(7)

Reception, Side & Guest Chairs(6)

Flat/Plan Files(6)

Suggestion Boxes & Cards(6)

Desktop File Sorters(6)

Tabletop Sorters/Racks(5)

Art & Drafting Tables(5)

Foot Rests(5)

Wood Veneer Bookcases(5)

Arm Sets(5)

Utility & Breakroom Tables(4)

Laminate Bookcases(4)

Reception Area & Accent Tables(4)

Letter Trays(4)

Mailroom Sorters & Tables(4)

Executive/High Back Chairs(4)

Backrests & Seat Cushions(3)

Hooks & Hangers(3)

Signs & Sign Holders(3)

Drawer Organizers(3)

Dry-Erase Boards(3)

TV/VCR Stands & Mounts(2)

Panels/Partitions(2)

Traditional - Laminate(2)

Contemporary - Laminate(2)

Mail Carts(2)

Telephone Stands & Holders(2)

Cubicle / Partition Organizers & Accessories(2)

Mobile Racks(2)

Catalog Racks(2)

Projector Stands & Carts(1)

Mouse & Keyboard Wrist Rests(1)

Desk Center Drawers(1)

Storage Boxes & Containers(1)

Portable Storage Files & Bins(1)

Wall Racks(1)

Casters(1)

Mobile Pedestals(1)

Multimedia Carts(1)

Extension Cords(1)

Anti-Fatigue Mats(1)

Business Card Holders(1)

Legs(1)

Brand

Safco(548)

Focal(4)

Onyx it!(1)

Color

Black(216)

Gray(51)

Silver(30)

Cherry(16)

Mahogany(14)

Clear(14)

White(13)

Tropic Sand(11)

Tan(10)

Medium Oak(9)

Black Base(5)

Stainless Steel(5)

Dark Gray(5)

Blue(4)

Putty(4)

Mahogany Base(3)

Sand(3)

Pewter(3)

Black Speckle(3)

Charcoal(3)

Wood Grain(2)

Silver Frame(2)

Chrome Hook(2)

Red(2)

Hook(2)

Matte Black(1)

Light Gray(1)

Black Powder Coat(1)

Chrome(1)

Oak(1)

Champagne(1)

Black Vinyl(1)

Aluminum(1)

Pocket(1)

Light Oak(1)

Baltic(1)

Grass(1)

Cream(1)

Wine(1)

Recycled

No(329)

Yes(34)

Price Range

$0-$499.99(503)

$500-$999.99(43)

$1000-$1499.99(5)

$1500-$1999.99(2)

To  GO

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

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