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

Adjustable Worksurfaces(25)

Desktop Organizers(20)

Training Room Tables(19)

Big & Tall Chairs(17)

Mobile File Carts & Cabinets(16)

Utility/Service Carts(16)

Workstations/Computer Desks(16)

Wall Sorters/Racks(15)

Smoking Receptacles(14)

Folding/Stacking Chairs & Carts(14)

Coat/Garment Hooks(14)

Wire Shelving(13)

Floor Organizers/Sorters(13)

Active Seating(12)

Recycling Bins(11)

Lockers(10)

Hand Trucks & Dollies(10)

Metal Bookcases(10)

Task Chairs(9)

Coat/Garment Racks(9)

Lamps(8)

Industrial & Commercial Shelving(8)

Lecterns(7)

Wall Files, Pockets & Accessories(7)

Compact & Student Desks(7)

Roll Files(7)

Flat/Plan Files(6)

Suggestion Boxes & Cards(6)

Reception, Side & Guest Chairs(6)

Panels/Partitions(6)

Desktop File Sorters(6)

Art & Drafting Tables(5)

Foot Rests(5)

Tabletop Sorters/Racks(5)

Arm Sets(5)

Wood Veneer Bookcases(5)

Letter Trays(4)

Laminate Bookcases(4)

Mailroom Sorters & Tables(4)

Reception Area & Accent Tables(4)

Executive/High Back Chairs(4)

Utility & Breakroom Tables(4)

Dry-Erase Boards(3)

Cubicle / Partition Organizers & Accessories(3)

Hooks & Hangers(3)

Backrests & Seat Cushions(3)

Signs & Sign Holders(3)

Drawer Organizers(3)

Contemporary - Laminate(2)

TV/VCR Stands & Mounts(2)

Mail Carts(2)

Traditional - Laminate(2)

Mobile Racks(2)

Catalog Racks(2)

Monitor Stands/Risers(2)

Projector Stands & Carts(1)

Portable Storage Files & Bins(1)

Laptop Stands & Pads(1)

Mouse & Keyboard Wrist Rests(1)

Desk Center Drawers(1)

Storage Boxes & Containers(1)

Pencil Holders(1)

Telephone Stands & Holders(1)

Anti-Fatigue Mats(1)

Extension Cords(1)

Power Strips(1)

Legs(1)

Wall Racks(1)

Casters(1)

Mobile Pedestals(1)

Business Card Holders(1)

Multimedia Carts(1)

Strength/Sports Training Equipment(1)

Brand

Safco(572)

Focal(4)

Onyx it!(2)

Color

Black(222)

Gray(52)

Silver(30)

Cherry(16)

Mahogany(14)

Clear(14)

White(14)

Tan(12)

Tropic Sand(11)

Medium Oak(9)

Stainless Steel(5)

Dark Gray(5)

Blue(4)

Black Base(4)

Putty(4)

Pewter(3)

Charcoal(3)

Mahogany Base(3)

Black Speckle(3)

Sand(3)

Chrome Hook(2)

Red(2)

Hook(2)

Silver Frame(2)

Wood Grain(2)

Champagne(1)

Matte Black(1)

Chrome(1)

Black Vinyl(1)

Oak(1)

Light Gray(1)

Aluminum(1)

Light Oak(1)

Baltic(1)

Pocket(1)

Wine(1)

Cream(1)

Black Powder Coat(1)

Grass(1)

Size

36" Width(4)

Recycled

No(338)

Yes(34)

Price Range

$0-$499.99(522)

$500-$999.99(49)

$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