A Canadian Company
filters
Select pa.*,
b.title bnm, b.title_seo bnmseo, b.discount bdiscount,
c.title cnm, c.title_seo cnmseo, c.discount cdiscount,
c1.title scnm, c1.title_seo scnmseo, c1.discount scdiscount
from pa
LEFT JOIN brands b ON pa.brand_id = b.id and b.visible=0
LEFT JOIN categories c ON pa.category_id = c.id and c.visible=0
LEFT JOIN categories c1 ON pa.subcategory_id = c1.id and c1.visible=0
where pa.visible=0 and pa.delflag=0 and pa.category_id=4817 and pa.subcategory_id=4982 order by pa.featured desc,pa.sort_order,FIELD(status,1,3,6,5,1,4,2)
Showing 1 to x of xx results
| # | name | brand | price | category | stock | sale | OilType | OilVol | OilGrade | |
|---|---|---|---|---|---|---|---|---|---|---|
| Synthetic SAE 15W40 CK-4 Truck Oil/6x1/Quart/946 mL | lucas-oil | 18.71 | CAT4982XZ |
C$ 18.71
In Stock
| Yes | No | ||||
| 1 | Synthetic SAE 15W40 CK-4 Truck Oil/4x1/Gallon/3.786 L | lucas-oil | 54.92 | CAT4982XZ |
C$ 54.92
In Stock
| Yes | No | |||
| 2 | Synthetic Blend SAE 10W30 CK-4 Truck Oil/4x1/Gallon/3.786 L | lucas-oil | 41.21 | CAT4982XZ |
C$ 41.21
In Stock
| Yes | No | |||
| 3 | Synthetic SAE 5W40 CK-4 Truck Oil/4x1/Gallon/3.79L | lucas-oil | 65.93 | CAT4982XZ |
C$ 65.93
In Stock
| Yes | No | |||
| 4 | 10W30 CK-4 SYN BLEND 18.9L | purezone-east | 138.65 | CAT4982XZ |
C$ 138.65
In Stock
| Yes | No | |||
| 5 | 10W30 CK-4 SYN BLEND 205L | purezone-east | 1447.76 | CAT4982XZ |
C$ 1,447.76
In Stock
| Yes | No | |||
| 6 | 10W30 CK-4 SYN BLEND 5L | purezone-east | 37.22 | CAT4982XZ |
C$ 37.22
In Stock
| Yes | No | |||
| 7 | 10W30 CK-4 SYN BLEND 946ML | purezone-east | 7.32 | CAT4982XZ |
C$ 7.32
In Stock
| Yes | No | |||
| 8 | CK4 SYN 5W40 18.9L | purezone-east | 357.66 | CAT4982XZ |
C$ 357.66
In Stock
| Yes | No | |||
| 9 | CK4 SYN 5W40 5L | purezone-east | 94.91 | CAT4982XZ |
C$ 94.91
In Stock
| Yes | No | |||
| 10 | CK4 SYN 5W40 0.946L | purezone-east | 19.08 | CAT4982XZ |
C$ 19.08
In Stock
| Yes | No | |||
| 11 | Rotella T5 10W30 (CK-4) | shell | 71.87 | CAT4982XZ |
C$ 71.87
In Stock
| Yes | No | |||
| 12 | Rotella T5 10W30 (CK-4) | shell | 247.07 | CAT4982XZ |
C$ 247.07
In Stock
| Yes | No | |||
| 13 | Rotella T5 15W40 (CK-4) | shell | 71.87 | CAT4982XZ |
C$ 71.87
In Stock
| Yes | No | |||
| 14 | Rotella T6 5W40 (CK-4) | shell | 88.57 | CAT4982XZ |
C$ 88.57
In Stock
| Yes | No | |||
| 15 | Rotella T6 5W40 (CK-4) | shell | 350.39 | CAT4982XZ |
C$ 350.39
In Stock
| Yes | No | |||
| 16 | Rotella T6 0W40 (CK-4) | shell | 102.72 | CAT4982XZ |
C$ 102.72
In Stock
| Yes | No | |||
| 17 | RUBIA OPT.1500 0W40 - 3B5L TOT CA | total-energies | 124.84 | CAT4982XZ |
C$ 124.84
In Stock
| Yes | No | |||
| 18 | RUBIA OPT.2100 XFE 10W30 - 3B5L TOT CA | total-energies | 81.96 | CAT4982XZ |
C$ 81.96
In Stock
| Yes | No | |||
| 19 | RUBIA OPT.1500 5W40 - 3B5L TOT 1CA | total-energies | 110.94 | CAT4982XZ |
C$ 110.94
In Stock
| Yes | No | |||
| 20 | RUBIA OPT.1300 FE 10W30 - 12B1L TOT CA | total-energies | 16.51 | CAT4982XZ |
C$ 16.51
In Stock
| Yes | No | |||
| 21 | VAL PB EXTREME FULL SYNTHETIC 5W40 4 L | valvoline | 101.87 | CAT4982XZ |
C$ 101.87
In Stock
| Yes | No | |||
| 22 | Synthetic SAE 15W40 CK-4 Truck Oil/1x1/5 Gallon/18.9 L Pail | lucas-oil | 215.1 | CAT4982XZ |
C$ 215.10
| No | No | |||
| 23 | RUBIA OPT.1500 5W40 - 19L TOT CA | total-energies | 410.11 | CAT4982XZ |
C$ 410.11
| No | No | |||
| 24 | RUBIA OPT.1300 FE 10W30 - 19L TOT CA | total-energies | 266.71 | CAT4982XZ |
C$ 266.71
| No | No | |||
| 25 | RUBIA OPT.1300 FE 10W30 - 3B5L TOT CA | total-energies | 74.87 | CAT4982XZ |
C$ 74.87
| No | No | |||
| 26 | VECTON Long Drain 5W30 Bulk | castrol | 12.64 | CAT4982XZ |
C$ 12.64
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | VECTON Long Drain 5W30 208L | castrol | 2959.31 | CAT4982XZ |
C$ 2,959.31
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | VECTON Long Drain 5W30 5L | castrol | 77.38 | CAT4982XZ |
C$ 77.38
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | VECTON Long Drain 5W30 984L | castrol | 12950.71 | CAT4982XZ |
C$ 12,950.71
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 30 | Synthetic Blend SAE 10W30 CK-4 Truck Oil/1x1/5 Gallon/18.9 L Pail | lucas-oil | 186.28 | CAT4982XZ |
C$ 186.28
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 31 | Synthetic Blend SAE 10W30 CK-4 Truck Oil/1x1/55 Gallon/208.2 L Drum | lucas-oil | 1925.5 | CAT4982XZ |
C$ 1,925.50
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 32 | Synthetic Blend SAE 10W30 CK-4 Truck Oil/1x1/330 Gallon Tote | lucas-oil | 11297.24 | CAT4982XZ |
C$ 11,297.24
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 33 | Synthetic SAE 15W40 Marine CK-4 Oil/4x1/Gallon/3.786 L | lucas-oil | 45.84 | CAT4982XZ |
C$ 45.84
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 34 | Synthetic SAE 5W40 CK-4 Truck Oil/1x1/5 Gallon/18.9 L Pail | lucas-oil | 320.32 | CAT4982XZ |
C$ 320.32
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 35 | Synthetic SAE 5W40 CK-4 Truck Oil/1x1/55 Gallon/208.2 L Drum | lucas-oil | 3456.08 | CAT4982XZ |
C$ 3,456.08
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 36 | Synthetic SAE 5W40 CK-4 Truck Oil/1x1/Per Gallon Tote | lucas-oil | 20241.23 | CAT4982XZ |
C$ 20,241.23
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 37 | Synthetic SAE 15W40 CK-4 Truck Oil/1x1/55 Gallon/208.2 L Drum | lucas-oil | 2264.86 | CAT4982XZ |
C$ 2,264.86
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 38 | Synthetic SAE 15W40 CK-4 Truck Oil/1x1/Per Gallon Tote | lucas-oil | 12366.22 | CAT4982XZ |
C$ 12,366.22
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 39 | Synthetic Blend SAE 10W30 FA-4 Truck Oil/1x1/6 Gallon/22.7 L Box | lucas-oil | 224.35 | CAT4982XZ |
C$ 224.35
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 40 | Synthetic SAE 5W40 CK-4 Truck Oil/1x1/6 Gallon/22.7 L Box | lucas-oil | 384.36 | CAT4982XZ |
C$ 384.36
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 41 | Synthetic Blend SAE 10W30 CK-4 Truck Oil/1x1/6 Gallon/22.7 L Box | lucas-oil | 223.46 | CAT4982XZ |
C$ 223.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 42 | Synthetic SAE 15W40 CK-4 Truck Oil/1x1/6 Gallon/22.7 L Box | lucas-oil | 258.72 | CAT4982XZ |
C$ 258.72
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 43 | CK4 SYN 5W40 205L | purezone-east | 3861.64 | CAT4982XZ |
C$ 3,861.64
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 44 | Rotella T5 NG 15W40 | shell | 3541.38 | CAT4982XZ |
C$ 3,541.38
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 45 | Rotella T5 10W30 (CK-4) | shell | 2664.47 | CAT4982XZ |
C$ 2,664.47
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 46 | Rotella T6 5W40 (CK-4) | shell | 282.77 | CAT4982XZ |
C$ 282.77
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 47 | Rotella T6 5W40 (CK-4) | shell | 3658.75 | CAT4982XZ |
C$ 3,658.75
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 48 | Rotella T5 Ultra 10W30 (FA-4) | shell | 3153.08 | CAT4982XZ |
C$ 3,153.08
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 49 | Rotella T5 Ultra 10W30 (FA-4) | shell | 77.16 | CAT4982XZ |
C$ 77.16
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 50 | Rotella T6 Multi Vehicle 5W30 (CK-4) | shell | 3635.75 | CAT4982XZ |
C$ 3,635.75
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 51 | Rotella T6 5W40 (CK-4) | shell | 12442.75 | CAT4982XZ |
C$ 12,442.75
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 52 | Rotella T6 5W40 (CK-4) | shell | 17.46 | CAT4982XZ |
C$ 17.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 53 | Rotella Gas Truck 0W20 (SP-GF/6A dexos1) | shell | 452.62 | CAT4982XZ |
C$ 452.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 54 | Rotella Gas Truck 0W20 (SP-GF/6A dexos1) | shell | 108.01 | CAT4982XZ |
C$ 108.01
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 55 | Rotella Gas Truck 5W20 (SP-GF/6A dexos1) | shell | 452.62 | CAT4982XZ |
C$ 452.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 56 | Rotella Gas Truck 5W20 (SP-GF/6A dexos1) | shell | 108.01 | CAT4982XZ |
C$ 108.01
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 57 | Rotella Gas Truck 5W30 (SP-GF/6A dexos1) | shell | 452.62 | CAT4982XZ |
C$ 452.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 58 | Rotella Gas Truck 5W30 (SP-GF/6A dexos1) | shell | 108.01 | CAT4982XZ |
C$ 108.01
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 59 | Rotella T6 0W40 (CK-4) | shell | 3908.81 | CAT4982XZ |
C$ 3,908.81
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 60 | Rotella T6 0W40 (CK-4) | shell | 375.47 | CAT4982XZ |
C$ 375.47
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 61 | Rotella T5 15W40 (CK-4) | shell | 2692.42 | CAT4982XZ |
C$ 2,692.42
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 62 | Rotella T5 15W40 (CK-4) | shell | 249.71 | CAT4982XZ |
C$ 249.71
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 63 | RUBIA OPT.2100 XFE - 10W30 19L TOT CA | total-energies | 293.68 | CAT4982XZ |
C$ 293.68
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 64 | RUBIA OPT.2100 XFE - 10W30 208L TOT CA | total-energies | 3089.39 | CAT4982XZ |
C$ 3,089.39
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 65 | RUBIA OPT.1500 5W40 - 208L TOT CA | total-energies | 4458.26 | CAT4982XZ |
C$ 4,458.26
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 66 | RUBIA WORKS 4000 FE10W30 - 19L TOT CA | total-energies | 278.76 | CAT4982XZ |
C$ 278.76
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 67 | RUBIA WORKS 4000 FE10W30 - 208L TOT CA | total-energies | 2919.85 | CAT4982XZ |
C$ 2,919.85
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 68 | RUBIA OPT.1300 15W40 - 19L TOT CA | total-energies | 266.71 | CAT4982XZ |
C$ 266.71
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 69 | RUBIA OPT.1300 15W40 - 208L TOT CA | total-energies | 2794.26 | CAT4982XZ |
C$ 2,794.26
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 70 | RUBIA OPT.1300 FE 10W30 - 208L TOT CA | total-energies | 2794.26 | CAT4982XZ |
C$ 2,794.26
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 71 | RUBIA OPT.1500 0W40 - 208L TOT CA | total-energies | 4872.7 | CAT4982XZ |
C$ 4,872.70
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 72 | RUBIA OPT.1500 0W40 - 19L TOT CA | total-energies | 421.58 | CAT4982XZ |
C$ 421.58
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 73 | RUBIA OPT.1500 FE 5W30 - 3B5L TOT CA | total-energies | 116.23 | CAT4982XZ |
C$ 116.23
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 74 | RUBIA OPT.1300 15W40 - 3B5L TOT CA | total-energies | 74.87 | CAT4982XZ |
C$ 74.87
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 75 | RUBIA OPT.2100 XFE 10W30 - 12B1L TOT 1CA | total-energies | 16.85 | CAT4982XZ |
C$ 16.85
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 76 | RUBIA OPT.1300 15W40 - BULK TOT CA | total-energies | 0 | CAT4982XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 77 | RUBIA OPT.1300 FE 10W30 - BULK TOT CA | total-energies | 0 | CAT4982XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 78 | RUBIA OPT.1500 0W40 - BULK TOT CA | total-energies | 0 | CAT4982XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 79 | VAL PB EXTREME FULL SYNTHETIC 5W40 ABB 18.9L | valvoline | 449.52 | CAT4982XZ |
C$ 449.52
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 80 | VAL PB ONE SOLUTION GEN2 15W40 ABB 18.9L | valvoline | 289.62 | CAT4982XZ |
C$ 289.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 81 | VAL PB ONE SOLUTION GEN2 15W40 4 L | valvoline | 65.38 | CAT4982XZ |
C$ 65.38
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 82 | VAL PB ONE SOLUTION GEN2 15W40 208 L | valvoline | 2885.38 | CAT4982XZ |
C$ 2,885.38
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 83 | VAL PB ONE SOLUTION GEN2 10W30 19 L | valvoline | 299.82 | CAT4982XZ |
C$ 299.82
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 84 | VAL PB ONE SOLUTION GEN2 10W30 208 L | valvoline | 2885.38 | CAT4982XZ |
C$ 2,885.38
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 85 | VAL PB ONE SOLUTION GEN2 15W40 19 L | valvoline | 289.33 | CAT4982XZ |
C$ 289.33
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 86 | VAL PB EXTREME FULL SYNTHETIC 5W40 208L | valvoline | 4824.77 | CAT4982XZ |
C$ 4,824.77
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |