Ferguson Scraper for Product, Price and Branch Stock Data

Ferguson prices, part numbers and specifications we collect

Three codes sit on one line under the product name, and they are not interchangeable. Item # is the number Ferguson assigns, and the product address ends with it. Part # is Ferguson's catalogue code - often the maker's number with a brand prefix in front. Manufacturer Part # is the maker's own, the key that joins a row to another distributor's catalogue or to your item master. Fields in a Ferguson dataset:

• Identity - item number, part number, manufacturer part number, UPC where the page lists one, the page address and the category path from All Products down to the leaf category.
• Product - brand, name, the Product Description bullets, image addresses, the selected size and the other sizes in the selector.
• Price - the dollar amount and the unit of measure printed beside it: EACH, per 10 FOOT, per 20 FOOT. A computed price per single unit lets a ten-foot length and a twenty-foot length compare by the foot.
• Price status - what stands in the price position: a figure, the Log in or Create Account button, the words Call for Pricing, or Unavailable. Without a figure the price column stays empty; nothing is estimated.
• Availability - from the How to get it block: the Pick Up quantity at the store being shopped, the number of stores nearby that hold the item, and the Shipping line. Where a guest is asked to log in to see availability, the row says so.
• Branch - the store set for the run, as the Store Selector writes it: city, state, ZIP code and type, for example Seattle, WA 98106 - Ferguson Plumbing/PVF.
• Specifications - up to four tables, each kept as rows of attribute and value: Dimensions & Measurements, Characteristics & Features, Electrical & Operational Information, Warranty & Product Information. The last one holds what a specifier looks for - ANSI, ASTM, NSF, UL Listed, IAPMO Listed and the lead law compliance level.
• Documents and rating - links to the specification sheet, the warranty and the installation instructions where the page offers them; the customer rating out of five and the number of reviews.

When a page carries the notice This product has been replaced by, the replacement's name, brand and manufacturer part number are stored beside the retired item.

A Ferguson price list by branch, category and brand

A product page answers for one item at one store. Categories, filters, promotions and the branch network are what turn those answers into a Ferguson price list.

• Categories. All Products opens the departments, from Bathroom and Heating & Cooling to Pipe & Tubing, Pipe Fittings, Valves and Water Heaters, with more under Additional Categories. Each listing states its product count and offers two sort orders, Best Match and Best Selling.
• Filters. In Stock at Branch comes first, then Brand and attributes that follow the category - Valve Size, End Connections, Material and Pressure Class for ball valves. Filter values carry counts, which makes them an assortment table in their own right.
• Listing cards. A card repeats the three part numbers, the customer rating, the price with its unit where a guest is shown one, and the Pick Up and Shipping lines.
• Branches. Repeating the pass for each branch or ZIP code on your list puts availability side by side. Branch pages add the location type, address, phone and opening hours by weekday.
• Price history. Only today's figure is on the page. Scheduled runs that key each row on item number and branch keep the earlier ones, so a new price, an empty shelf or a switch from a printed price to the login button gets a date.
• Promotions and Shop by Job. Each campaign in the Promotions menu opens the list of items it covers. A job page, such as Residential Gas Water Heater Replacement, lists under What You'll Need the product categories that one task calls for.