Princess Auto Scraper: Prices, Clearance and Store Stock

Scrape Princess Auto (princessauto.com), Canada's tool, equipment and parts chain. You get prices, clearance, Hot Buys and sale items, plus how many units each of the ~60 stores has and how much is in stock online. You can search by keyword, category, page URL or item number, or scrape the whole catalogue (about 38,000 product variations) in about two minutes.

No login and no browser are needed, and a small run finishes in seconds.

What you can do with it

• Hunt clearance and Hot Buys at your stores. Tick Clearance only, enter your stores (e.g. Mississauga, Scarborough) and In stock only. You get every clearance item on the shelf there, with the discount and quantity.
• Monitor prices and stock of specific items every day with Item numbers.
• Resellers and flippers: find deep discounts (discountPct) with real quantities per store before you drive there.
• Catalogue and competitor analysis: get every product with category path, brand, rating, review count, list and sale price.
• Product data: turn on Include product details to add UPC, manufacturer part number, GTIN, full specifications, weight, dimensions, country of origin, manuals and all images.

Input

Field	What it does
Search terms	Keywords, just like the site's search box (drill, air compressor, trailer hitch).
Categories	Names, paths or numbers: Hand Tools, Welding, Air and Power > Compressors, 9718.
Princess Auto URLs	Search, category, Clearance, Hot Buy, brand and product pages from princessauto.com.
Item numbers	The 7-digit item number (8634669) or product code (PA1000002512, which returns all its sizes/variations).
Max results	Total rows for the run (0 = no limit).
Clearance / Hot Buys / On sale / New arrivals only	Deal filters. With nothing else filled in, they scrape that whole deals section.
Stores	Store name, city (Calgary = both stores), province (ON, Quebec) or store number.
In stock only	Only items in stock at those stores (or anywhere, if no stores are given).
Brands, Min/Max price	Narrow further (Powerfist, DEWALT, Makita…).
Sort	Best match (default), newest, price low→high / high→low, top rated.
Store stock in each row	Stores that have it (default), every store including zeros, or counts only.
One row per variation	On (default): each size/variant is its own row with its own price and stock. Off: one row per product with a variants list.
Include product details	UPC / MPN / GTIN, description, specs, weight, dimensions, manuals, images.
Live stock check	Re-checks stock against the store inventory system at run time.
Language	English or French names, categories and URLs.

Leave search terms, categories, URLs and item numbers all empty to scrape the whole catalogue, or the whole deals section you ticked.

Example: clearance in stock at two Toronto-area stores

{
  "clearanceOnly": true,
  "stores": ["Mississauga", "Scarborough"],
  "inStockOnly": true,
  "maxItems": 0
}

Example: daily price and stock watch

{
  "skus": ["9048984", "8634669", "PA1000002512"],
  "storeInventory": "all",
  "liveInventoryCheck": true
}

Output

One row per product variation. Here is a real row (shortened), with Include product details on and three stores selected:

{
  "sku": "9048984",
  "productId": "PA0009048984",
  "name": "20V 1/2 in. Cordless Drill/Driver, Tool Only",
  "brand": "Powerfist",
  "url": "https://www.princessauto.com/en/product/20v-1-2-in-cordless-drill-driver-tool-only/PA0009048984/9048984",
  "imageUrl": "https://cdn11.bigcommerce.com/s-xq5b6wwjc4/images/stencil/original/products/53955/18221/9048984_A0CG_00_01__04848.1774825598.jpg",
  "price": 59.99,
  "listPrice": 59.99,
  "salePrice": null,
  "discountPct": null,
  "currency": "CAD",
  "isOnSale": false,
  "isClearance": false,
  "isHotBuy": false,
  "saleEndsOn": null,
  "rating": 3.75,
  "reviewCount": 4,
  "category": "Drills",
  "categoryPath": "Air and Power > Cordless Tools > Drills and Drivers > Drills",
  "onlineStock": 254,
  "storesInStockCount": 57,
  "totalStoreQty": 258,
  "selectedStoresInStockCount": 3,
  "selectedStoresQty": 12,
  "storeInventory": [
    { "storeId": "71", "storeName": "Mississauga", "city": "Mississauga", "province": "ON", "qty": 5, "status": "lowStock" },
    { "storeId": "95", "storeName": "Scarborough", "city": "Scarborough", "province": "ON", "qty": 4, "status": "lowStock" },
    { "storeId": "98", "storeName": "Markham", "city": "Markham", "province": "ON", "qty": 3, "status": "lowStock" }
  ],
  "shipToHome": true,
  "skuStatus": "A",
  "isHazardous": false,
  "mpn": "203514003002",
  "gtin": "008310",
  "description": "This cordless drill/driver features metal keyless chuck and gear construction, a 2-speed selector…",
  "specifications": { "Chuck Size (in.)": "1/2", "Voltage Rating (V DC)": "20", "No Load Speed (RPM)": "0 to 450 and 0 to 1,700" },
  "weight": { "value": 3.1, "unit": "lb" },
  "dimensions": { "height": { "value": 8.2, "unit": "in" }, "width": { "value": 3.7, "unit": "in" }, "depth": { "value": 9.1, "unit": "in" } },
  "countryOfOrigin": "CN",
  "manuals": [{ "label": "…Manual-Multilingual", "url": "https://…/9048984_manualhb_00_01_v01_manuel_enfr.pdf" }],
  "source": { "type": "sku", "input": "9048984" },
  "scrapedAt": "2026-09-24T03:11:03.097Z"
}

Stock fields

• onlineStock is the quantity at the online distribution centre.
• storesInStockCount / totalStoreQty cover all stores.
• selectedStores… fields appear when you pick stores.
• storeInventory[].status is inStock, lowStock (fewer than 10) or outOfStock.

Deal fields

• salePrice / discountPct / amountSaved are only set when the item is below its regular price.
• saleEndsOn is set when the site shows an end date.

The dataset has three views: Overview, Deals and Product details.

FAQ

How fresh is the stock? It is the same availability the website shows, refreshed throughout the day. Turn on Live stock check to re-read every row's stock from the store inventory system at run time.

Why do some rows have no brand or UPC? Princess Auto doesn't publish a brand for its surplus and house items, and many items have no UPC. The actor returns what the site has and never makes values up.

Can I get more than 10,000 results? Yes. Big categories and the whole catalogue are split automatically into sub-categories or price bands, so nothing is cut off.

How long does it take? 50 items take a few seconds, and the full catalogue about 2 minutes. Include product details opens each product page, so allow roughly 1 second per row.

Which stores are covered? All Princess Auto stores in Canada (AB, BC, MB, NB, NL, NS, ON, PE, QC, SK) and the online warehouse.

French? Set Language to Français to get French names, categories, descriptions and /fr/ URLs.

Is it legal to scrape Princess Auto? This Actor only collects publicly available data: product listings, prices, deals, product details and store stock that anyone can see on Princess Auto's website without an account. Collecting publicly available data is generally legal, but you're responsible for how you use it. You must follow privacy laws such as GDPR, PIPEDA and CCPA, as well as Princess Auto's terms. If you're unsure, check with a lawyer. More on this: Is web scraping legal?

Does it access any private data? No. Everything comes from pages Princess Auto shows to any visitor without logging in. It never uses a login, never touches private or restricted accounts, and never reaches password-protected areas.