Download SAMPLE: Pennzoil SAMPLE.xls
Buy FULL database + FREE updates for 1 year:
Someone contacted me in 2017 to ask for an oil recommendation database, I scraped data from Pennzoil using my “universal” scraper. The customer did not replied anymore and never purchased it, and due to this reason I initially didn’t published it on website. I regret now, other people may have been interested and could do few extra sales. Pennzoil website has been redesigned meantime and the scraper was no longer working, to update it.
In March 2019 another customer needing oil database provided me 5 possible websites to scrap data from. All them are difficult to scrap, cannot do them with my universal scraper so I need to pay a programmer for a custom scraper.
By June 2019 other 5 customers contacted me interested in oil database, but we argued regarding from which is the BEST website to source data from:
Option 1: https://www.pennzoil.com/en_us/oil-selector.html#iframe=L2RvL2VuX1VTL2VxdWlwbWVudC9jYWRpbGxhY18odXMpLzIwMTkvY3RzX2x1eHVyeV8yXzB0X3Z2dF9hd2RfY3RzX0VGdDhQb2FtbA – do I need to make 1 row for Standard and 1 row for Premium, or should be separate columns? some cars have 3 or 4 oil types indicated. Give me a suggestion because my programmer need exact template how you want data to be displayed. This may be slightly easier to scrap, however personally I DON’T like this website because it have only cars sold in USA and only engine oil.
Pennzoil have also a section for oil filters: https://www.pennzoil.com/en_us/filter-selector.html but car model hierarchy is different so will require 2 different custom scrapers which will produce 2 different databases that I CANNOT combine.
Option 2: https://www.amsoil.com/lookup/auto-and-light-truck/2013/audi/a4-quattro/2-0l-4-cyl-engine-code-cpma-5-flex-turbo/us-volume/#engine1 – this one have more info than just engine oil, but the way info is displayed on website makes difficult to put each piece of information in the right column.
Option 3: https://applications.castrol.com/oilselector/en_us/c/recommendation?vehicleType=cars-and-suvs&manufacturer=bmw&model=3-series-e46-(1998-2006)&modelType=325i-(132-kw)-(2002-2005) – Castrol have cars sold in Europe and USA and also truck and motorcycles, but many cars lack oil recommendation.
Option 4: http://fuchs-eu.lubricantadvisor.com/advice.aspx?lang=eng&country=ro&type=e5167c014c627820dd5f0ce57c9a0bdb – can someone check is this is a good and reliable website to source data from? It have both cars sold in Europe and in America separated in Make list, and shows oil for more oils than just engine oil.
Option 5: https://www.bizol.com/oil-guide/##1|uk|1 this have not just cars but also trucks and motorcycles, contains cars from US, EU and China, but is again difficult to scrap data from.
Option 6: https://www.ravenol.de/en/oil-guide.html this have not just cars but also trucks and motorcycles, agricutural and construction equipment, contains cars from US, EU and China, but is again difficult to scrap data from.
Despite that personally I don’t like Pennzoil, 3 people choose it, so my programmer partner made a custom scraper for Pennzoil in July 2019. This is not enough to satisfy all customers because Pennzoil have only cars sold in USA, so we need to scrap one of other sites too.
57 makes, 34643 models – 12 July 2019
57 makes, 34782 models – 15 October 2019