SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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` 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 WHERE `pinfo`.`sku` IN (SELECT `sku` FROM `dealer_best_seller` `dsp` WHERE `dsp`.`type`='suggested') 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_cost`=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 `best_seller` DESC

Currently Filtered by

Suggested

Refine Search

  GO
Category Filter

Office Paper(3)

Paint(2)

Cocoa(2)

Sand & Water(2)

Dice(1)

Calculators(1)

Incentive Charts(1)

CDs/DVDs(1)

Index Cards(1)

Highlighters(1)

Hard Hats(1)

Card Games(1)

Cassettes(1)

Adhesives(1)

Dry Erase Boards(1)

Math(1)

File Jackets/Sleeves/Wallets(1)

Stack Chairs(1)

Ice Pack(1)

Agility(1)

Playground/Gymnasium Sets(1)

Chairs/Stools(1)

Balls(1)

Exercise Balls(1)

Appointment Book Refills(1)

Brand

Champion Sports(6)

SARGENT ART(2)

HP Papers(2)

PapaNicholas Coffee(1)

Nestlé(1)

Universal(1)

Verbatim(1)

HP(1)

Angeles(1)

Advantus(1)

Fibre-Metal by Honeywell(1)

AT-A-GLANCE(1)

Maxell(1)

Color

Blue(1)

Color(s)

Gray(1)

Transparent(1)

Quantity

24 per carton(1)

50 per box(1)

Size

8 1/2 x 11(2)

5 x 3 1/8(1)

8 1/2 x 14(1)

Letter(1)

3 1/4 x 6 1/4(1)

Packing Type

Packet(2)

Jewel Case(1)

Flavor

Dutch Chocolate(1)

Rich Chocolate(1)

Base Color

Blue(1)

Beverage Type

Hot Cocoa(1)

Hot Chocolate(1)

Paper Color(s)

White(2)

Blue(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor Wildcard SSL Certificates

© 2019-2020 United Supply Corp, All Rights Reserved