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)

Exercise Balls(2)

Paint(2)

Cocoa(2)

Sand & Water(2)

Incentive Charts(1)

Dice(1)

Cassettes(1)

Calculators(1)

CDs/DVDs(1)

Card Games(1)

Index Cards(1)

Highlighters(1)

Adhesives(1)

Dry Erase Boards(1)

Math(1)

File Jackets/Sleeves/Wallets(1)

Stack Chairs(1)

Ice Pack(1)

Agility(1)

Appointment Book Refills(1)

Stickers(1)

Playground/Gymnasium Sets(1)

Balls(1)

Safety Headgear Accessories(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)

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

© 2018-2019 United Supply Corp, All Rights Reserved