Special Offers

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `at_special_price`.`value` AS `special_price`, IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) AS `special_from_date`, `at_special_to_date`.`value` AS `special_to_date`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id IN ('3') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '567') AND (`at_special_price`.`store_id` = 0) LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date_default` ON (`at_special_from_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date_default`.`attribute_id` = '568') AND `at_special_from_date_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_datetime` AS `at_special_from_date` ON (`at_special_from_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_from_date`.`attribute_id` = '568') AND (`at_special_from_date`.`store_id` = 1) LEFT JOIN `catalog_product_entity_datetime` AS `at_special_to_date` ON (`at_special_to_date`.`entity_id` = `e`.`entity_id`) AND (`at_special_to_date`.`attribute_id` = '569') AND (`at_special_to_date`.`store_id` = 0) LEFT JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '96') AND `at_name_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '96') AND (`at_name`.`store_id` = 1) WHERE (at_special_price.value > 0) AND (((((IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) <= '2020-12-05 23:59:59') OR (IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) IS null))))) AND (((((at_special_to_date.value >= '2020-12-05 00:00:00') OR (at_special_to_date.value IS null))))) AND ((IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) IS not null) OR (at_special_to_date.value IS not null)) ORDER BY IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) desc, `name` ASC LIMIT 32

Save 21% Hot Deal
PEERLESS Gold Series 3hp 100Ltr Belt Drive Air Compressor

Regular Price: $1,399.00

Special Price $1,099.00

wtp_bonus_end_date:

Great Value For Money Compressor For Home Workshop!!!...
Save 11%
Panasonic EY74A2 Dual Voltage 14.4v/18v Brushless Drill Driver Cordless Kit-18v 5ah

Regular Price: $639.00

Special Price $569.00
Save 17% Hot Deal
ABBOTT & ASHBY Bench Grinder Linishing Attachment-50mm x 900mm (2" x 36") (Attachment Only,Excl. Bench Grinder)-AA362

Regular Price: $299.00

Special Price $249.00

wtp_bonus_end_date:

All In 1 Attachment With 3year Warranty!!!...
Save 14%
BOSS Multi Process Inverter MST 180amp Welder-Mig,Stick & Tig-XSeries-188X

Regular Price: $729.00

Special Price $629.00

Save 19% Hot Deal
IMEX Premium Tilers Square Laser Green Beam LX11GP

Regular Price: $359.00

Special Price $289.00

wtp_bonus_end_date:

With Hi Vis Green Laser beam
Save 26%
OX Tools Stainless Steel Tradie 8m & 5m Tape Measure Combo OX-P504858AU

Regular Price: $39.00

Special Price $29.00
As low as: $27.00

wtp_bonus_end_date:

Perfect Christmas Gift Idea!!!...
Save 21% Limited Stock
Unimig Synergic 120 Mig Welder Bundle Kit With BONUS Gloves, Starter Kit & Auto Darkening Welding Helmet-PK11001

Regular Price: $499.00

Special Price $395.00

wtp_bonus_end_date:

Christmas Gift Idea!!..Grab One Before There All Gone!!!...
Save 17%
TECMEN Auto Darkening Flip Face Welding & Grinding Helmet

Regular Price: $599.00

Special Price $499.00

Save 30% Limited Stock
MAKITA 18V Mobile Brushless Hammer Drill bare unit Skin-DHP485

Regular Price: $199.00

Special Price $139.00

wtp_bonus_end_date:

Black Friday Deal!!..Grab One Before There All Gone!!!...
Save 31%
LEICA DISTO Laser Distance Measurer Tape-D2NEW

Regular Price: $359.00

Special Price $249.00
Save 62% Hot Deal
Dewalt dcf885BARE 18v XR Lithium Cordless Impact Driver Skin-DCD885

Regular Price: $259.00

Special Price $99.00

wtp_bonus_end_date:

Christmas Gift Idea!!..Grab One Before There All Gone!!!...
Save 54%
Festool Winkelfix Classic 600mm Angle Finder-Sold Out !!

Regular Price: $299.00

Special Price $139.00

wtp_bonus_end_date:

Sold Out!!!....Sold Out!!!...

Save 22%
Genius AC234161S Socket Set Tool Kit In Blow Mould Case-161pce

Regular Price: $499.00

Special Price $389.00
Save 26%
MATSON 12V / 24V Jump Starter Power Pack MA3400

Regular Price: $999.00

Special Price $739.00
Save 50%
MATSON Digital Batery & SystemTester

Regular Price: $199.00

Special Price $99.00

wtp_bonus_end_date:

Black Friday Deal!!!....Limited Stock!!!...
Save 53%
Panasonic EYOL82B Universal 14.4v, 18v, 21.6v, 28.8v Battery Charger EY0L82B

Regular Price: $189.00

Special Price $89.00

Save 42% Limited Stock
IMPACTA Industrial Lace Up Safety Boots-Black ISBLU3203B

Regular Price: $119.00

Special Price $69.00

wtp_bonus_end_date:

Christmas Gift Idea!!..Grab One Before There All Gone!!!...
Save 29%
STABILA 02501 Torpedo Spirit Level + Belt Pouch 81S/25 + H 25cm (10″)

Regular Price: $69.00

Special Price $49.00
Save 18%
TREND Adjustable Door Hinge Template Jig H/JIG/B

Regular Price: $599.00

Special Price $489.00
Save 24% Limited Stock
HITACHI 10.8v / 12v 2pce Cordless Combo Kit KC10DFL

Regular Price: $249.00

Special Price $189.00

wtp_bonus_end_date:

Christmas Gift Idea!!..Grab One Before There All Gone!!!...

Save 50%
Milwaukee C12PDBARE M12 12V Cordless Hammer Drill-Bare Unit

Regular Price: $199.00

Special Price $99.00
Save 23%
RUPES LHR21E/BAS BigFoot Random Orbital Polisher Buff-LHR21E

Regular Price: $789.00

Special Price $609.00
Save 42% Hot Deal
DIADORA Glove Tech Low Pro Unisex Work Shoes Black-173528

Regular Price: $289.00

Special Price $169.00

wtp_bonus_end_date:

Christmas Gift Idea!!..Grab One Before There All Gone!!!...
Save 35%
Hikoki Hitachi 18v/36v 2.5/5Ah Li-Ion Brushless Cordless Slide 2pce Combo Kit-KC18DBFD

Regular Price: $459.00

Special Price $299.00

wtp_bonus_end_date:

Christmas Gift Idea!!..Grab One Before There All Gone!!!...

Save 50% Hot Deal
FIXMAN Mobile Technicians/Diagnostics Super Trolley F5SRP7B

Regular Price: $1,599.00

Special Price $799.00

wtp_bonus_end_date:

Christmas Gift Idea!!..Grab One Before There All Gone!!!...
Save 22%
ITM XLITE Oil Free Silent Aluminium Direct Drive Air Compressor-1hp 10ltr-Replaces Maxus

Regular Price: $599.00

Special Price $469.00
Save 13%
OX Tools Superior Super Fast Cut Diamond Blade-14"/350mm OX14MPSS

Regular Price: $299.00

Special Price $259.00
As low as: $229.00
Save 15%
RUPES HR81ML-DLX Ibrid Bigfoot Nano Polishing Combo Deluxe Kit-Long Neck

Regular Price: $1,299.00

Special Price $1,099.00

Save 20%
BOLLE Tracker 2 Series Safety Welding Shade 5 Glasses-1652017

Regular Price: $49.00

Special Price $39.00
As low as: $35.00

wtp_bonus_end_date:

Perfect For OXY Welding!!!....
Save 13% New
KINCROME Tradecentre Mobile Parts Cabinet Trolley-6Drawer-K7368

Regular Price: $459.00

Special Price $399.00
Save 30%
Metabo 18v Brushless Angle Grinder Cordless Combo

Regular Price: $399.00

Special Price $279.00

wtp_bonus_end_date:

Christmas Gift Idea!!..Grab One Before There All Gone!!!....Hurry Limited Stock!!!..
Save 20%
Panasonic ey75a7x Dual Voltage 14.4v/18v Brushless Impact Driver Cordless Skin

Regular Price: $299.00

Special Price $239.00

Special Offers

What's this?