SELECT p.*,oc.*, IF(p.url_custom='',p.url_default,p.url_custom) AS product_url, AS cat_name, IF(c.url_custom='',c.url_default,c.url_custom) AS cat_url, SUM(oc.admin_price * oc.admin_quantity) AS product_amount, SUM(oc.admin_quantity) AS product_quantity, SUM(oc.admin_price * oc.admin_quantity * o.gift_cert_amount / o.total_amount) AS gift_cert_amount, SUM(oc.admin_price * oc.admin_quantity * (1 - o.gift_cert_amount / o.total_amount)) AS total_amount FROM orders_content oc INNER JOIN orders o ON o.oid = oc.oid INNER JOIN products p ON = INNER JOIN catalog c ON c.cid = p.cid AND c.is_visible='Yes' WHERE c.key_name <> 'gift_cert' AND p.is_visible='Yes' AND DATE_ADD(o.placed_date, INTERVAL 2 MONTH)>NOW() and o.removed='No' AND o.status='Completed' AND o.payment_status='Received' GROUP BY ORDER BY product_amount DESC LIMIT 12 Purple Pumps - Midwest Bottles

New Arrivals

Secure Site

Product Updates

Purple Pumps

Purple plastic lotion pumps, treatment pumps, saddle head pumps, palm head pumps in different sizes.  New items are being added on a regular basis.

24-410 Purple Plastic Ribbed Lotion-Soap Pump w/ Lock-Down Head, 6 1/4 in Dip Tube & 2 cc Output

More Information

Surplus Item
Product ID : pp24-410-purp
Unit Price: $0.50 $0.30
Quantity in Stock : 1,632
24-415 Lavender Pearl Plastic Lotion Pump w/ Lock-Down Head, 2 cc Output & 6 9/16 in. dip tube

More Information

Surplus Item
Product ID : pp24-415-lav
Unit Price: $0.44 $0.33
Quantity in Stock : 3,055