CREATE TEMPORARY TABLE IF NOT EXISTS `oc_af_temporary` (PRIMARY KEY (`product_id`)) SELECT dcp.price, afv2.value AS PriceLevelXPrice, p.product_id, p.manufacturer_id, IF(p.quantity > 0, 6, p.stock_status_id) as stock_status_id, MIN(pd2.price) as discount, MIN(ps.price) as special, tax_p.sum_rate as tax_precent, tax_f.sum_rate as tax_fixed, AVG(rating) AS rating FROM oc_product p LEFT JOIN `oc_af_tax_fixed` tax_f ON p.tax_class_id = tax_f.tax_class_id LEFT JOIN `oc_af_tax_percent` tax_p ON p.tax_class_id = tax_p.tax_class_id INNER JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) INNER JOIN oc_category_path cp ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product_discount pd2 ON (pd2.product_id = p.product_id AND pd2.quantity = '1' AND (pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()) AND pd2.customer_group_id = '1') LEFT JOIN oc_product_special ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1') LEFT JOIN oc_review r1 ON (r1.product_id = p.product_id AND r1.status = 1) INNER JOIN oc_product_to_store AS p2s ON p2s.product_id = p.product_id AND p2s.store_id = '0' LEFT JOIN dateline_customer_price dcp ON (p.product_id=dcp.product_id AND dcp.quantity=1 AND dcp.customer_id=0)LEFT JOIN oc_product_additional_field_value AS afv2 ON (p.product_id=afv2.product_id)LEFT JOIN oc_mpoints_additional_field_description AS afd2 ON (afv2.additional_field_id=afd2.additional_field_id AND afd2.name='PriceLevel1') WHERE p.date_available <= NOW() AND p.status = 1 AND cp.path_id = '459' GROUP BY p.product_id INTERIOR ACCESSORIES
Griffiths Equipment
You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today.
INTERIOR ACCESSORIES

INTERIOR ACCESSORIES

Looking after the interior of your vehicle, is just as important as looking after the exterior. We’ve got air fresheners to get your car smelling great, sunshades to keep the harsh New Zealand sun away, and plenty of gauges, gear knobs, pedals and steering wheels to customize your interior.

Refine Search

WILDCAT This car window sunshade is suitable for a great variety of vehicles and efficiently insul..

ALL BLACKS Show your support for the mighty All Blacks, with this sunshade. Not only will it help ..

WILDCAT Suction cups help to secure the sunshade to the glass. Protects, cools and blocks out UV r..

WILDCAT This sunshade actively works to reduce the natural heat levels that build-up within the in..

WILDCAT The side roller sunshade is perfect for preventing those sun rays from the window of your ..

WILDCAT The car sun shade helps you to keep your car cool and fresh without sunlight and it gives ..

WILDCAT Don't let the sun blind your vision while driving. The visor sunshade is tinted to block d..

CATERPILLAR The Official CAT licensed Merchandise sunshade is perfect for the warmer summer months..

R.M.WILLIAMS The Official R.M. Williams sunshade is perfect for the warmer summer months, reducing..

WILDCAT Boss kits are necessary for anyone planning to install an aftermarket steering wheel in th..

WILDCAT This steering wheel spline has been designed to maintain the original steering wheel posit..

WILDCAT This steering wheel spline has been designed to maintain the original steering wheel posit..

WILDCAT This steering wheel spline has been designed to maintain the original steering wheel posit..

WILDCAT Boss kits are necessary for anyone planning to install an aftermarket steering wheel in th..

WILDCAT This steering wheel spline has been designed to maintain the original steering wheel posit..

WILDCAT For all water cooled engines, this gauge can alert you about a higher or lower than normal..

WILDCAT Monitor your engine temperature with more precision with this oil pressure gauge. The gaug..

WILDCAT This oil pressure nylon tube kit gauge from Trisco consists of the tube and fittings to su..

WILDCAT This oil pressure copper tube kit gauge from Trisco consists of the tube and fittings to s..

WILDCAT The electrical fuel level gauge is used to measure the fuel level of an automobile. Featu..

WILDCAT This oil pressure gauge is engineered to provide extremely accurate readings under harsh c..

WILDCAT This water temperature gauge can be installed to measure either water or oil temperature. ..

WILDCAT The voltmeter is used to monitor the storage-battery voltage. Timely grasp the state of yo..

WILDCAT The matte black gauge cup is mounted and used to host a gauge for your vehicle bringing a ..

WILDCAT This chrome gauge dash pod is a single gauge pod designed to mount on your vehicles dashbo..

WILDCAT Give the interior of your car a more sporty look with this round black top gear knob. Cons..

WILDCAT The gear knob is designed to add style and function to the interior of your car. The shift..

WILDCAT This gear knob is designed to add style and function to the interior of your car. It is co..

WILDCAT This gear knob is designed to add style and function to the interior of your car. It is co..

WILDCAT Tired of your regular stock gear knob? Then this might be the product for you. This skull..

WILDCAT tired of your regular stock gear knob? Then this might be the product for you. This skull..

WILDCAT The gear knob is designed to add style and function to the interior of your car. The shift..

WILDCAT Looking to upgrade and enhance your car pedals? Try out these pedals for an stylish edgy l..

WILDCAT Give your automatic transmission car a more sporty and stylish feel with this pedal kit. T..

WILDCAT The combination lock security cable is easy to install and an ideal theft deterrent. Prote..

WILDCAT The steering wheel lock makes it impossible for your car to be stolen. This double hook st..

WILDCAT This easy to install steering wheel lock provides an added layer of security to protect yo..

WILDCAT This pack of two "L" plates comply to the department of transport regulations and are simp..

PROLOCK The Wildcat Prolock SS is an anti-theft device which easily locks onto your steering wheel..

PROLOCK Wildcat Prolock not only acts as a visible deterrent, it physically prevents a thief from ..

WILDCAT The oscillating automotive fan will make sure to cool off as much areas without the need t..

TYPE S The triple socket is of high quality and it's pretty durable. It's also designed with high ..

TYPE S Type S quad socket power centre converts single 12v socket into 4 sockets for added conveni..

TYPE S Ultra-compact & convenient with quick and easy installation. Simply connect the charger to ..

TYPE S This device is designed to make steering effortless. Has a heavy duty clamp with cushion in..

TWIN USB + SINGLE SOCKET POWER PLUG
New!

TYPE S Ultra-compact car charger turns unused cigarette lighter outlet into 2 powerful USB chargin..

AERPRO Aerpro AP10QI Anti-slide Wireless Charging Pad For Home or Car Use works well with Qi-enabl..

AERPRO Aerpro AP15QIW brings together charging convenience, accessibility and efficiency into one ..