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 (`category_id` IN ('480')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN MATCH(`desc_short`) AGAINST ('Paints' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Paints' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Paints"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Paints"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Paints"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Paints"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Paints' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Paints',`category_4` ='Paints') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Paints,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Paints', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Paints

Refine Search

  GO
Brand

SARGENT ART(28)

Crayola(18)

Prang(15)

HYGLOSS PRODUCTS,INC.(11)

Creativity Street(2)

Creative Arts(1)

Color(s)

Assorted(11)

Green(3)

White(3)

Black(3)

Blue(3)

Brown(3)

Yellow(3)

Red(3)

Violet(2)

Orange(1)

Assorted|FFFFFF(1)

Packing Type

Bottle(14)

Oval Pans(4)

Cake(1)

Country of Origin

US(18)

MX(15)

CN(3)

For Use With

40508(1)

Capacity (Volume)

1 gal(18)

16 oz(9)

1 oz(1)

2 oz(1)

1 pt(1)

2.2 oz(1)

Chemical Compound

Water Based(19)

Tempera(11)

Calcium Carbonate; Distilled Water; Gum Acacia; Maltose; Pigment(1)

Age Recommendation

Ages 3 and Up(1)

Ages 5 and up(1)

Choking Hazard

Y(1)

Number of Colors

1(14)

8(5)

12(3)

6(3)

16(1)

Finish

Matte(11)

Water Color(1)

Opaque(1)

Color Family

Multicolor(10)

Blue(3)

Black(3)

Green(3)

Red(3)

White(3)

Yellow(3)

Brown(2)

Purple(1)

Special Features

Gallon Size(18)

16 oz. Size(6)

16-oz Size with Dispenser Cap(1)

Oval-8 Watercolor Refill Master Pack-Includes 24 Oval Pan 8-Color Sets and 12 refills.(1)

12 Color Assortment-One of each- Black, Blue, Brown,Green, Magenta, Orange, Peach, Red, Turquoise Blue, Violet, White, Yellow.(1)

16 oz Size(1)

16-Colors(1)

8-Colors(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved