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` = 55) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC

Get Quote fixed at Live Price

  • Product: The Curvy Xtra Ballpen

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

Product Information

Our best selling promotional ballpen now with an xtra large imaging area. Available in 20 brand friendly colours in translucent and glossy finishes.

curvy-wide-bannernewtn-curvy-4newtn-curvy-1newtn-curvy-2newtn-curvy-3
                                                		
Quantity 25050010002500500010000
1 colour to barrel£0.42£0.39£0.38£0.37£0.36£0.35
2 colours to both sides£0.78£0.75£0.74£0.74£0.73£0.72
3 colours both sides£1.02£0.99£0.98£0.98£0.97£0.96
4 colours to both sides£1.26£1.23£1.22£1.22£1.21£1.20

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

Technical Specification
Product size: 140 x 15mm
Print area: 60 x 8mm
Product colours: Black, blue, caribbean blue, charcoal, green, indigo blue, lime, merlot, orange, pink, purple, red, yellow, silver/black, silver/blue, silver/green, silver/orange, silver/purple, silver/red