Bonus Deals
Shop Bonuses
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`, IF(at_wtp_bonus_end_date.value_id > 0, at_wtp_bonus_end_date.value, at_wtp_bonus_end_date_default.value) AS `wtp_bonus_end_date`, IF(at_wtp_bonus_start_date.value_id > 0, at_wtp_bonus_start_date.value, at_wtp_bonus_start_date_default.value) AS `wtp_bonus_start_date`, IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) AS `wtp_bonus_type`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` 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=2
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_product_entity_datetime` AS `at_wtp_bonus_end_date_default` ON (`at_wtp_bonus_end_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_end_date_default`.`attribute_id` = '193') AND `at_wtp_bonus_end_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_wtp_bonus_end_date` ON (`at_wtp_bonus_end_date`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_end_date`.`attribute_id` = '193') AND (`at_wtp_bonus_end_date`.`store_id` = 1)
INNER JOIN `catalog_product_entity_datetime` AS `at_wtp_bonus_start_date_default` ON (`at_wtp_bonus_start_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_start_date_default`.`attribute_id` = '194') AND `at_wtp_bonus_start_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_wtp_bonus_start_date` ON (`at_wtp_bonus_start_date`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_start_date`.`attribute_id` = '194') AND (`at_wtp_bonus_start_date`.`store_id` = 1)
INNER JOIN `catalog_product_entity_int` AS `at_wtp_bonus_type_default` ON (`at_wtp_bonus_type_default`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_type_default`.`attribute_id` = '196') AND `at_wtp_bonus_type_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_wtp_bonus_type` ON (`at_wtp_bonus_type`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_type`.`attribute_id` = '196') AND (`at_wtp_bonus_type`.`store_id` = 1)
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((IF(at_wtp_bonus_end_date.value_id > 0, at_wtp_bonus_end_date.value, at_wtp_bonus_end_date_default.value) >= '2024-09-08')) AND ((IF(at_wtp_bonus_start_date.value_id > 0, at_wtp_bonus_start_date.value, at_wtp_bonus_start_date_default.value) <= '2024-09-08')) AND ((IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '806') OR (IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '807') OR (IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '808') OR (IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '809') OR (IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '810')) AND (stock_status_index.stock_status = 1) ORDER BY rand() ASC, `e`.`entity_id` DESC
Count: 64
Bonuses
- Bahco 100pce Bit Set In Case-1/4" Drive Super Handy Set For Tradies!!!
- MAXSHINE Shinemaster Home Detailers Starter Combo Kit -ATD Including DA Polisher, Pressure Cleaner, Vacuum/Blower & Bucket Dolly!!!...Special Price $649.00 Regular Price $799.00
- BORDO Hand Warmer Twin Pack-7+Hours Super Handy For Tradies!!!....
- DEWALT DXPW3300 Petrol Pressure Washer 3300PSI BONUS Surface Scrubber & Turbo Nozzle -JTD-FDD Great Value For Money Package Deal!!!,,,,Special Price $1,059.00 Regular Price $1,399.00
- WARREN & BROWN External Deburring Chamfer Pro Tool 162050 Tradie Time Saver!!!...Perfect For Threaded Rod Onsite!!!//
- Genius 3/4" Drive 8pce Deep Impact Socket Set-Metric Our Biggest Selling 3/4" Impact Set!!!...Special Price $229.00 Regular Price $319.00
- ALLIANCE Air Extra Duty 3/4" Pneumatic Impact Wrench With Extended Anvil- AL-2475-6 Hot Seller For The Truck & Tyre Industries!!!...Special Price $1,099.00 Regular Price $1,199.00
- ALPHA 8pc Multi-Tool Blade Set-Fits Makita,Milwaukee,Ryobi,Bosch,Metabo, Dewalt-H8PRO Perfect Blade Set For Your Multitool!!!...Special Price $129.00 Regular Price $159.00
- GEIGER Double Sided Mobile Storage Trolley Cart-MS20020K Best Seller!!..Huge Storage Capacity!!...Special Price $1,199.00 Regular Price $1,399.00
- BIGBOI Industrial Hi Powered Blower -BlowR Mini -ATD Market Leader For The Detailing Industry!!...$299.00
- BAR Portable Electrical Space Heater -2.4kw -Workshops,Shed,Factories, Garages Great For The Factory or ShowroomSpecial Price $125.00 Regular Price $199.00
- BAR Honda Petrol Water Pressure Cleaner-3500psi @ 15LPM Made In Canada!!!...Special Price $3,499.00 Regular Price $3,899.00
- Kincrome Tool Armour 114" Superwide Workshop Tool Box With Hutch & Lockers -ATD Super Hot Limited Edition Deal!!!...$11,499.00
- BAR Honda Petrol Water Pressure Cleaner-4200psi @ 15LPM Made In USA!!!...Special Price $2,619.00 Regular Price $2,799.00
- HOT DEVIL Tradies Oxy Force Combo Kit HDOXYF Tradie Favourite!!!....Special Price $169.00 Regular Price $199.00
- SOLD OUT-KINCROME XMAS TOOL ADVENT CALENDAR 2023-REFER WERA VERSION SOLD OUT!!!...REFER WERA ADVENT CALENDAR!!!...$99.00
- T&E TOOLS The Godfather Mega Series Workstation Tool Box Combo With Side Lockers-GF76R4GR When Size Really Matters!!!...Special Price $14,799.00 Regular Price $22,999.00
- PRO KIT Twin LED Rechargeable 350Lumen Sensor Headlamp Torch & Worklight Feature Packed Head Lamp!!!$49.00 As low as $20.00
- PEERLESS Gold Series 2.5hp 100Ltr Belt Drive Air Compressor Perfect Compressor For Home Workshops!!!..Special Price $1,099.00 Regular Price $1,399.00
- KINCROME Pursuit Workshop Tool Kit Chest & Roller Combo-209pce Replaces P1930B Limited Stock Edition!!!!…Special Price $2,199.00 Regular Price $2,999.00
- Estwing Vinyl Grip Smooth Face Hammer Black Ultra Series-15oz - EB15S Hot Seller For Carpenters & Formworkers!!!....Special Price $120.00 Regular Price $149.00
- BAR Honda Petrol Water Pressure Cleaner-3000psi @ 21LPM Made In Canada!!!...Special Price $3,989.00 Regular Price $4,239.00
- Bordo 2007-M5 HSS Metric Drill Set-19pce Best Seller!!!...Great Value For Money!!!...
- SHIELD Automatic Sanitiser Disinfectant System Package With 5L Disinfectant Best Value For Money Auto Sanitizing DispenserSpecial Price $126.00 Regular Price $199.00
- GEIGER Mobile Storage Tip Out Sorting Trolley Cart-MSFO4568 Best Seller!!..Huge Storage Capacity!!...Special Price $599.00 Regular Price $699.00
- TOPTUL Tools 130Pce 1/4", 3/8" & 1/2" Metric & Imperial Socket Wrench Set Tool Kit -TOPGCAI130B Perfect All In One Boot Kit!!!...Special Price $329.00 Regular Price $349.00
- BAR Comet Electric Water Pressure Cleaner-With Reel-2175psi @ 9LPM Market Leader For Mobile Detailers!!!...Special Price $1,379.00 Regular Price $1,699.00
- BOSS Multi Process Inverter MST 250amp Welder-Mig,Stick & Tig-XSeries-MST250XT Bonus Welding Helmet & 2 x Mig Wire RollsSpecial Price $1,869.00 Regular Price $2,099.00
- LUFKIN Cross Line & Plumb Dot Laser Level Kit LCL4 - Discontinued Please Call For Alternatives Discontinued Please Call For AlternativesSpecial Price $189.00 Regular Price $259.00
-
- ARMORGARD Forma-Stor Portable Jobsite Flat Pack Container System -JTD The Perfect Jobsite Secure Solution!!!...$2,999.00
- BIGBOI Industrial Hi Powered Blower -BlowR Buddi -ATD Market Leader For The Detailing Industry!!...$129.00
- SP Tools 14Drawer Empty Tool Box Combo-Limited Edition Limited Edition Tool Tool Box Set!!... Dont Miss Out!!!...$1,699.00
- OX Tools Stainless Steel Tradie 8m & 5m Tape Measure Combo OX-P504858AU BDD Perfect Boxing Day Gift Idea!!!...
- P&N Quick-Bits Heavy Duty Drill Nibbler Attachment - 107NIB001 Super Handy!!!...Converts Drill To Cordless Nibler!!!..Special Price $99.00 Regular Price $129.00
- OX Tools Superior Super Fast Cut & Tuffcut Diamond Blade Combo-14"/350mm Limited Edition!!!....Grab Yours Before Its Too Late!!!...
- BIANCO Fire Fighting BIA-2HP15ABS - Vulcan 6.5HP Twin Stage Engine Driven Fire Pump - Powered by Briggs & StrattonSpecial Price $1,749.00 Regular Price $1,925.00
- BMI DIGITAL ANGLE FINDER LEVEL BMI714600D PRE-ORDER NOW FOR SEPTEMBER DELIVERYSpecial Price $689.00 Regular Price $749.00
- KNOG LED BILBY Hi Powered HeadLamp Torch-USB Rechargeable-Silicone Band Super Comfortable!!!...Super Powerful!!!...Great Value!!!...Special Price $99.00 Regular Price $119.00
- TREND Universal Router Pod Station-R/POD/A Ideal For All Routers!!!..
- RUPES BigFoot Random Orbital Polisher Buff Detailers Starter Combo Kit-ATD Perfect Kit For Anyone Wanting To Get Into Detailing!!!...Special Price $799.00 Regular Price $999.00
- Geiger Heavy Rider Mechanics Creeper-150kg Capacity-GCR40-ATD Steel Reinforced For Greater Strength & Capacity!!!..
- Estwing EB19S Vinyl Grip Large Smooth Face Hammer Black Ultra Series-19oz Hot Seller For Carpenters & Formworkers!!!....Special Price $120.00 Regular Price $149.00
- GEARWRENCH 26" 14Drw Tool Chest & Trolley Roller Cabinet Combo -Game Changer Limited Edition LIMITED STOCK!!!...DONT MISS OUT!!!$1,399.00
- WERA 6004 Joker Self-Setting Adjustable Spanner Set - 4pce Kit WER020110 Hot Seller!!!...Special Price $295.00 Regular Price $329.00
- CRC SmartWasher Mobile Combination Parts Washer & Brake Washer-Starter Kit CRC SmartWasher Starter Kit Includes 5 x SW-4 OzzyJuice 20L & 3 x FL-4 OzzyMatSpecial Price $3,999.00 Regular Price $4,599.00
- INDUSTRIAL XS 4d Hi Vis Green Beam Multi Line Laser Level Kit With 2 Batteries & Adjustable Platform Perfect For Electricians & Fit Out JobsSpecial Price $169.00 Regular Price $299.00
-
-
- IMEX Hi Vis Green Beam Cross Line Laser Level With Tripod- L2G -FDD Great Value For Money Bundle Deal$189.00 As low as $139.00
- BOLLE Sphere Grinding Safety Face Shield 1652501 - COVID Market Leader For Construction Industry
- Impacta Shield Aluminium Hands Free Sanitising Station Bollard-White Hurry Stock Are Selling Fast!!!...Aussie Made!!!...Special Price $399.00 Regular Price $459.00
- IMPACTA 6 in 1 BBQ Grill Multi Tool-Spatula,Fork, Tongs, Knife, Bottle Opener IMPBBQTOOL Boxing Day Gift Idea!!..Grab One Before There All Gone!!!...
- DIADORA Craze Wide Lace Up Safety Boots With Zip FU1533CT Extra Wide Extra Comfortable Wide Fitting Boot!!!...Special Price $149.00 Regular Price $199.00
-
- DIADORA Munka Ware Pro Steel Cap Safety Shoe Boots With Scotchguard Protection Great Value For Money Safety Shoe With Water & Oil Marking Protection!!...
- RANSOM Mixer Stirring Rod With M14 Male Thread Up to 5X Quicker Mixing Than Standard Mixing Rods!!!...Special Price $99.00 Regular Price $139.00
- MACK VISION SAFETY LIFESTYLE SHOES BLACK/BLACK-BOOTS MKVISION-BBF Our Hottest Seller For Tradies That Love Lifestyle Shoes For The Jobsite!!!.Special Price $169.00 Regular Price $189.00
- Industrial XS Rolling Stool Creeper Seat Perfect For Mechanics & Detailers -ATD Tools Organizer and Extra Storage TraysSpecial Price $125.00 Regular Price $139.00
- Milwaukee 49224185 Hole Dozer Hole Saw Kit 28 Pce Redeem a M18FHZ-0 18V Reciprocating Saw for FREE! Purchases valid between 01/07/2024 - 30/09/2024Special Price $345.00 Regular Price $499.00
- SP Tools 290pce Tool Kit With HDFI Insert Trays-Limited Edition Limited Edition Tool Kit!!... Dont Miss Out!!!...Special Price $1,999.00 Regular Price $2,999.00
View All
Loading...
![Loading...](https://www.vektools.com.au/static/version1725604962/frontend/Codazon/fastest_fashion/en_AU/images/loader-1.gif)