SELECT SQL_CALC_FOUND_ROWS * ,LEAST(IF(price1_1 > 0, (price1_1 * (1-(discount/100))),9999), IF(price2_1 > 0, (price2_1 * (1-(discount/100))),9999), IF(price3_1 > 0, (price3_1 * (1-(discount/100))),9999), IF(price4_1 > 0, (price4_1 * (1-(discount/100))),9999), IF(price5_1 > 0, (price5_1 * (1-(discount/100))),9999), IF(price6_1 > 0, (price6_1 * (1-(discount/100))),9999)) AS priceMin FROM `jos_virtuemart_products_en_gb` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jos_productPrices` ON p.`virtuemart_product_id` = `jos_productPrices`.`product_id` LEFT JOIN `jos_productDetails` ON p.`virtuemart_product_id` = `jos_productDetails`.`product_id` LEFT JOIN `jos_virtuemart_product_categories` ON p.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `jos_virtuemart_product_categories`.`virtuemart_category_id` WHERE ( p.`published`="1" AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 48) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC

Get Quote fixed at Live Price

  • Product: Showroom Metal Ballpen

Live price deal
66 p each
Min. 5000 per order
For info or to order call 0844 8117 566 or email: sales@ideasbynet.com

Product Information

Combining quality craftsmanship and competitive pricing, the Showroom Metal Ballpen is the ideal promotional gift. Engrave in super-HD quality, for long lasting, pin sharp branding.

showroom-metal-banner-2015showroom-metal-ballpen-4showroom-metal-ballpen-1showroom-metal-ballpen-2showroom-metal-ballpen-3
                                                		
Quantity 100250500100025005000
Engraved to 1 position£0.72£0.69£0.68£0.67£0.66£0.65
Engraved to 2 positions£1.46£1.43£1.42£1.41£1.40£1.39

There is a screen setup cost of £42.75 per position/ imprint type.

Technical Specification
Product size: 136 x 8mm
Print area: 60 x 6mm SoP
Product colours: blue, red, black, gun metal, silver, green