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 CASE WHEN ds.type='hot deals' THEN `ds`.`expiration_date` >= CURDATE() else CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` END 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

Adjustable Worksurfaces(35)

Waste Containers & Accessories(35)

Literature Organizers/Sorters(31)

Training Room Tables(30)

Stools & Drafting Chairs(27)

Printer/Fax Stands(23)

Desktop Organizers(19)

Coat/Garment Hooks(16)

Big & Tall Chairs(16)

Folding/Stacking Chairs & Carts(15)

Active Seating(15)

Mobile File Carts & Cabinets(14)

Utility/Service Carts(14)

Workstations/Computer Desks(14)

Wall Sorters/Racks(13)

Desktop File Sorters(11)

Hand Trucks & Dollies(10)

Reception, Side & Guest Chairs(10)

Task Chairs(9)

Smoking Receptacles(9)

Floor Organizers/Sorters(9)

Lamps(8)

Roll Files(7)

Compact & Student Desks(7)

Wall Files, Pockets & Accessories(7)

Industrial & Commercial Shelving(7)

Coat/Garment Racks(7)

Lockers(6)

Lecterns(6)

Panels/Partitions(6)

Suggestion Boxes & Cards(6)

Flat/Plan Files(6)

Art & Drafting Tables(5)

Wire Shelving(5)

Arm Sets(5)

Foot Rests(5)

Laminate Bookcases(5)

Desktop Risers(5)

Recycling Bins(4)

Tabletop Sorters/Racks(4)

Mailroom Sorters & Tables(4)

Hooks & Hangers(4)

Signs & Sign Holders(4)

Letter Trays(4)

Utility & Breakroom Tables(4)

Executive/High Back Chairs(3)

Cubicle / Partition Organizers & Accessories(3)

Backrests & Seat Cushions(3)

Drawer Organizers(3)

Dry-Erase Boards(3)

Mail Carts(2)

Projector Stands & Carts(2)

Mobile Racks(2)

Mobile Pedestals(2)

Traditional - Laminate(2)

Legs(2)

Strength/Sports Training Equipment(2)

Mailboxes(2)

Pencil Holders(2)

Desk Center Drawers(1)

Wood Veneer Bookcases(1)

Laptop Stands & Pads(1)

TV/VCR Stands & Mounts(1)

Portable Storage Files & Bins(1)

Mouse & Keyboard Wrist Rests(1)

Storage Boxes & Containers(1)

Business Card Holders(1)

Key Boxes & Cabinets(1)

Extension Cords(1)

Power Strips(1)

Contemporary - Laminate(1)

Casters(1)

Wall Racks(1)

Anti-Fatigue Mats(1)

Telephone Stands & Holders(1)

Brand

Safco(546)

Focal(6)

Onyx it!(3)

Color

Black(208)

Gray(40)

Silver(30)

White(22)

Clear(14)

Medium Oak(9)

Mahogany(9)

Tan(9)

Cherry(8)

Blue(8)

Tropic Sand(7)

Charcoal(5)

Stainless Steel(5)

Black Base(4)

Dark Gray(4)

Putty(3)

Sand(3)

Pewter(3)

Mahogany Base(3)

Chrome Hook(2)

Charcoal Gray(2)

Black Speckle(2)

Silver Frame(2)

Black Powder Coat(2)

Red(2)

Hook(2)

Wood Grain(2)

Oak(1)

Chrome(1)

Pocket(1)

Champagne(1)

Matte Black(1)

Walnut(1)

Aluminum(1)

Natural(1)

Grass Green(1)

Cream(1)

Grass(1)

Black Vinyl(1)

Light Gray(1)

Baltic(1)

Wine(1)

Recycled

No(366)

Yes(28)

Price Range

$0-$499.99(468)

$500-$999.99(80)

$1000-$1499.99(4)

$1500-$1999.99(1)

$2000-$2499.99(1)

$2500-$2999.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