Clearance Items

user warning: Unknown column 'n.vid' in 'on clause' query test : pager_query SELECT COUNT(*) FROM node as n, ec_product as p left join clearance_info as c on c.product_id = n.vid WHERE n.vid = p.vid AND n.status = 1 AND c.active =1 in /var/www/html/includes/database.mysql.inc on line 121.
user warning: Unknown column 'n.vid' in 'on clause' query test : pager_query SELECT n.nid, n.title, p.*,c.* FROM node as n, ec_product as p left join clearance_info as c on c.product_id = n.vid WHERE n.vid = p.vid AND n.status = 1 AND c.active =1 ORDER BY p.sku ASC LIMIT 0, 50 in /var/www/html/includes/database.mysql.inc on line 121.

Clearance Items:

Clearance items are also listed in red in the Product Directory

Products in PDF format:


A507-282-B02 SUN Hydraulic Circuit Manifold Assembly	Clearance Electric Motors - Walnut

There are no clearance products to view.

Search