White Cap Scraper for Construction Supply Prices

White Cap data fields: SKU, list price and availability

White Cap gives every product two numbers of its own. SKU# is the distributor's code and closes the product address; MFG# is the manufacturer's part number, the one that lets you match the row to any other seller of the same item. Both come in every record.

• Identity - SKU, MFG number, product name, brand with its brand page, product address and the breadcrumb from department to subcategory.
• Unit list price - the dollar figure a guest sees and the unit printed after the slash: each, kit, pail, package and so on. A pail price and an each price are different facts, so the unit of measure is its own column.
• Promotions - the badge on deal items, in the site's words: a dollar or percentage saving, Free Product with Purchase, Buy 2, Get 1 Free.
• Delivery stock - the quantity ready to deliver to the ZIP code set for the crawl, the arrival window in business days where the site gives one, and the notice shown when an item cannot be delivered.
• Branch stock - the quantity under Buy in Branch with the name and number of the branch it is quoted for, which is not always the one set in the header. Large quantities are printed as a floor with a plus sign, and we keep them that way.
• Specifications - the General table as attribute and value pairs: colour and colour family, container size, volume capacity, package dimensions, whatever that product family lists.
• Compliance and Restrictions - the Hazardous Material delivery note and the California Proposition 65 warning where the page shows them.
• Content - description, the Key Features list and gallery image addresses.

Listing cards do not always print a price, so we read it on the product page and deliver one row per SKU with everything above.

White Cap categories, brands, Top Deals and price history

The product page is where the detail sits; coverage comes from the layers around it.

• Categories. The menu runs from Anchoring Systems and Concrete Accessories through Fasteners, Forming Systems and Power Tools and Accessories to Wood Products. Each listing states its result count and narrows through the Filter Products panel - Brand first, then attributes that change with the category, such as Material or Container Size.
• Brands. Every manufacturer has a brand page with its own result count and category shortcuts, which makes a brand-wide extract a natural unit of work.
• Top Deals. Specials and Deals groups promoted items into collections, brand deals and seasonal campaigns among them. Read weekly, it becomes a record of which SKUs were promoted, with which badge and at what price.
• Availability by branch. A panel on each product lists branches within a chosen radius with the quantity each one holds, and can show only those holding the item. Repeating the crawl for several branches or ZIP codes gives a stock map per SKU.
• Branch Locator. Branch pages give the branch number, address, phone and hours for each weekday - business data we collect as is.
• Price history. The site shows the current list price only. Scheduled runs keyed on SKU and unit keep every earlier figure, so price changes and stock-outs can be dated.