SELECT products.*, IF(products.url_custom='',products.url_default,products.url_custom) AS product_url, catalog.name AS cat_name, IF(catalog.url_custom='',catalog.url_default,catalog.url_custom) AS cat_url, SUM(orders_content.admin_quantity) AS product_quantity,SUM(orders_content.admin_price * orders_content.admin_quantity) AS product_amount FROM orders_content INNER JOIN orders ON orders.oid=orders_content.oid INNER JOIN products ON products.pid = orders_content.pid INNER JOIN catalog ON catalog.cid = products.cid AND catalog.is_visible='Yes' WHERE catalog.key_name <> 'gift_cert' AND products.is_visible='Yes' AND DATE_ADD(orders.placed_date, INTERVAL 2 MONTH)>NOW() AND orders.status='Completed' AND orders.payment_status='Received' GROUP BY orders_content.pid ORDER BY product_amount DESC LIMIT 12 4 oz. Clear Plastic Single Wall 58-400 PET Jar w/ Colored Lids 35% OFF

New Arrivals

Secure Site

Product Updates

4 oz. Clear Plastic Single Wall 58-400 PET Jar w/ Colored Lids 35% OFF

4 oz. Clear Plastic Single Wall 58-400 PET Jar w/ Colored Lids 35% OFF
Hover over image to zoom
Our Price: $0.56
Compared at: $0.85
You Save: $0.29
Product ID : pjclearset4a
Manufacturer: King
Stock: 4,710

Continuous Stock
E-mail to a friend | Add To Wish List

Order

Description

4 oz. Clear 58-400 plastic single walled, straight sided PET round base jar. Plastic cosmetic jar is 2 3/8 in high including neck x 2 1/8 in wide.  Caps are included.  Packed 567 to case.  Jar is also sold in an 2 oz & 8 oz.

Label area is 1 5/8 in. high x 7 1/4 in. wide

Caps are included. 

Product Reviews

Login or Register to write the first review.