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

Get Quote fixed at Live Price

  • Product: Postmanbag Shoulder Bag

Live price deal
£ 1.53 each
Min. 2500 per order
For info or to order call 0844 8117 566 or email: sales@ideasbynet.com

Product Information

Practical non-woven (120 g/m) shoulder bag in a convenient format. Super-light and strong. With a large main compartment, compartments for pens and a shoulder strap with velcro flap.

                                                		
Quantity 5010025050010002500
1 colour 1 position£2.47£1.59£1.57£1.55£1.53£1.51
2 colours 1 position£2.81£1.85£1.81£1.77£1.73£1.69
3 colours 1 position£2.35£2.11£2.05£1.99£1.93£1.87
4 colours 1 position£2.69£2.37£2.29£2.21£2.13£2.05

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

Technical Specification
Product size: 36 x 27 x 6cm
Print area: 220 x 150mm
Product colours: white, green, orange, red, purple, blue, dark blue, black, grey, yellow