We extract MRO product listings, MPNs, branch-specific inventory levels, technical specifications, and PDF data sheets from Border States. Delivered as clean JSON, CSV, or Parquet to S3, BigQuery, or Snowflake.
Structured, schema-consistent data across all major object types — delivered clean, typed, and ready to query.
Complete list of extractable fields for Product Listings objects from borderstates.com. All fields typed and schema-versioned.
"item_id": "BSE-104928", "mpn": "HBL5262", "upc": "783585435205", "title": "Hubbell Wiring Device-Kellems HBL5262 Duplex Receptacle", "brand": "Hubbell", "manufacturer": "Hubbell Wiring Device-Kellems", "category_path": "Electrical > Wiring Devices > Receptacles", "datasheet_url": "https://borderstates.com/docs/HBL5262_spec.pdf"
| # | item_id | mpn | upc | title | brand | manufacturer |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 |
Complete list of extractable fields for Pricing & Inventory objects from borderstates.com. All fields typed and schema-versioned.
"item_id": "BSE-104928", "base_price": 14.5, "currency": "USD", "uom": "EA", "min_order_qty": 1, "branch_id": "BR-042", "branch_name": "Fargo, ND", "stock_level": 142, "in_stock": true
| # | item_id | base_price | currency | uom | min_order_qty | branch_id |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 |
Complete list of extractable fields for Technical Specs objects from borderstates.com. All fields typed and schema-versioned.
"item_id": "BSE-104928", "unspsc_code": "39121406", "voltage_rating": "125V AC", "amperage_rating": "15 A", "material": "Nylon", "colour": "Brown", "mounting_type": "Flush", "nema_rating": "5-15R"
| # | item_id | unspsc_code | voltage_rating | amperage_rating | material | colour |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 |
Complete list of extractable fields for Branch Data objects from borderstates.com. All fields typed and schema-versioned.
"branch_id": "BR-042", "branch_name": "Fargo, ND", "address_line_1": "605 25th St S", "city": "Fargo", "state": "ND", "zip_code": "58103", "phone_number": "701-232-1456", "will_call_available": true
| # | branch_id | branch_name | address_line_1 | city | state | zip_code |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 |
Complete list of extractable fields for Search Results objects from borderstates.com. All fields typed and schema-versioned.
"keyword": "duplex receptacle 15a", "position": 1, "item_id": "BSE-104928", "mpn": "HBL5262", "brand": "Hubbell", "base_price": 14.5, "stock_status": "In Stock", "scraped_at": "2026-08-14T10:12:00Z"
| # | keyword | position | item_id | mpn | title | brand |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 |
Border States maintains a complex MRO catalogue with heavy reliance on MPNs, branch-specific availability, and deeply nested categories. Our infrastructure handles session-based branch selection and large-scale catalogue traversal.
Capture Manufacturer Part Numbers, UPCs, and internal item codes to ensure exact cross-referencing with your internal ERP systems.
Simulate branch selection via session cookies to extract localized stock levels, lead times, and will-call availability across 110+ locations.
Extract URLs for technical data sheets, MSDS, and installation manuals directly from product pages for compliance documentation.
Capture base pricing tied strictly to Unit of Measure (EA, C, M, PK, RL) to prevent pricing calculation errors in downstream systems.
Navigate complex, multi-tiered taxonomy trees to map products to specific industry verticals and applications.
Scrape dynamic specification tables including voltage, amperage, material, colour, and NEMA ratings into normalised JSON keys.
Extract manufacturer alternative parts and substitute items suggested on product pages for supply chain resilience.
Extract non-authenticated list pricing and promotional discounts to monitor baseline market rates.
Run pipelines on daily or weekly cadences, delivering only changed records to minimise warehouse compute costs.
Brief in. Clean data out.
Provide target categories, manufacturer lists, or specific branch IDs. We design the extraction schema together.
We configure Scrapy / Playwright crawlers, proxy rotation, and branch-specific session handling for borderstates.com.
Schema validation, null-rate checks, UOM verification, and MPN format checks before full launch.
JSON / CSV / Parquet pushed to your S3 bucket, BigQuery dataset, or Snowflake stage on agreed cadence.
B2B distribution sites deploy specific challenges: branch-dependent state, complex catalogue rendering, and strict anti-bot measures. Here is how we build resilience.
Inventory and pricing on Border States depend on the selected branch. Our crawlers inject specific location cookies and maintain persistent sessions per worker to extract accurate, localized data without cross-contamination.
Industrial distributors often use strict WAFs to block automated catalogue scraping. We use US-based residential proxies, realistic TLS fingerprinting, and controlled concurrency to blend in with legitimate contractor traffic.
Pricing in MRO is complex, often quoted per 100 (C) or per 1000 (M). We extract both the raw price and the exact UOM, normalising the output so your ERP ingests accurate unit costs.
Category pages often cap results at 1,000 items. We automatically inject sub-category filters and brand facets to force the site to reveal the entire product depth, ensuring zero data loss.
Product specifications vary wildly between a conduit and a transformer. We use dynamic key-value extraction for spec tables rather than hardcoded selectors, ensuring all technical data is captured regardless of product type.
Distributors and contractors ingest clean MPNs, UPCs, and technical specifications to standardise their internal item masters.
Regional electrical distributors track base pricing and promotional discounts to optimise their own pricing matrices.
Procurement teams monitor branch-level stock availability across regions to identify supply constraints for critical components.
Manufacturers map their catalogue against Border States listings to audit product representation and identify missing lines.
Estimators feed base pricing and lead times into bidding software to generate accurate project quotes.
Product managers analyse category depth and brand presence to identify expansion opportunities in specific MRO verticals.
"MRO data is defined by its complexity. If you cannot accurately map MPNs and UOMs to localized inventory, the dataset is useless for procurement."
Extracting data from B2B distributors like Border States requires more than simple HTTP GET requests. It requires managing branch-specific session state, parsing complex specification tables, and normalising units of measure. DataFlirt handles this engineering overhead so your procurement and data teams receive clean, ERP-ready records.
Everything supported by our borderstates.com scraper — rendered SPA elements, auth walls, rate-limit evasion and beyond.
Open-source tooling on proven cloud infra — no vendor lock-in, full observability.
Scrapy handles crawl orchestration and deduplication. Playwright manages JavaScript execution and branch-specific cookie injection. Combined via scrapy-playwright middleware.
We maintain pools of US-based residential ISP proxies. Rotation happens per-request with sticky sessions to maintain branch state without triggering WAF blocks.
Pipelines run on AWS ECS. Airflow handles scheduling, dependency management, and SLA alerting. All state stored in managed Postgres.
Data delivered to where your team already works — no new tooling required.
About borderstates.com scraping, legality, and pipeline operations.
Ask us directly →Scraping publicly available information is generally permissible under applicable law. DataFlirt targets only public, non-authenticated product, base pricing, and inventory data. We do not circumvent authentication walls to extract account-specific pricing. Clients should review terms of service and consult legal counsel for specific use cases.
We programmatically inject the required session cookies and headers to simulate a user selecting a specific branch location. This allows us to extract localized stock levels and lead times across multiple branches in parallel.
Yes. We extract the direct URLs to PDF data sheets, MSDS, and installation manuals linked on the product pages, ensuring you have the necessary compliance documentation.
MRO pricing is heavily dependent on UOM (e.g., price per 100 vs price per each). Our schema explicitly extracts and normalises the UOM alongside the base price to ensure accurate calculations in your ERP.
Our smallest packages start at a defined manufacturer list or category subset with weekly delivery. For full catalogue extraction across multiple branches, we price based on volume and delivery frequency.
Absolutely. We provide a sample run of up to 500 products from specified categories as part of the pre-engagement scoping process to validate schema fit and data quality.
20-minute scoping call. Pilot dataset within the week. Production within two. Whether you need a one-off catalogue dump or a continuous inventory feed across 50 branches — we scope, build, and operate the pipeline. Tell us what you need.
