What you get backSeventeen columns, five of them populated once.
Read from a real export, in sheet order. Where this says a column carried a value, it is describing the single row that returned ok - a row we have reason to distrust, for the reason set out in the note below.
- query
- The GlobalIndustrial URL you submitted, echoed back. Populated on all four of our rows, including the three that were blocked, which is what lets you re-run exactly the inputs that failed.
- sku_code
- Intended to carry GlobalIndustrial's own item number. Empty on our ok row. Its absence is part of why we read that row as a search page rather than a product.
- product_url
- Intended to carry the canonical product page. Empty on our ok row - the address stayed in
url and nothing resolved to a product. - name
- The product title. On our ok row this is the URL slug, hyphens intact, rather than a retail title. Treat a hyphenated lowercase value here as a signal that the run did not reach a product page.
- description
- Intended to carry the product copy. Empty on our ok row.
- parsed_price
- The price as a bare number. Populated on our ok row - but see the note below before you use it. The figure appears on the search page the URL redirects to; it is not established as the price of the item the slug names.
- price
- The same figure with a currency symbol. Populated on our ok row, with the same caveat.
- currency
- The currency the price is quoted in. Populated as a US dollar value on our ok row.
- availability
- Intended to carry stock status. Empty on our ok row.
- rating
- Intended to carry an average rating. Empty on our ok row.
- reviews
- Intended to carry the review count. Empty on our ok row.
- images
- Intended to carry the listing's images. Empty on our ok row - a further sign that no product page was reached.
- brand
- Intended to carry the manufacturer. Empty on our ok row.
- sku
- Intended to carry a second identifier. Empty on our ok row, so we cannot tell you whether this site fills it differently from
sku_code. - url
- The address the row was produced from. Populated on all four rows, because it is what we submitted.
- image
- Intended to carry the primary image on its own. Empty on our ok row.
- status
- A per-row flag written by our exporter, not by GlobalIndustrial - and the most informative column on this service. Across four runs it took three values:
ok once, blocked (needs residential proxy) once, and blocked (intermittent - retry) twice. The last of those is an instruction, and the eleven-minute experiment above says it is a good one.
Seventeen columns per row · CSV, JSON or Excel
The single most useful thing on this page is a warning about its own data. Our one successful row carries a name that is the URL slug, a price, a currency - and ten empty columns. We checked why, and the answer is that the address we submitted is not a product page: it answers with a permanent redirect to a search results page for the same slug. A search page has no single product title, which is why the name fell back to the slug, and no single identifier, description, brand, stock value or image, which is why those columns are empty. The price figure does appear on that search page, but a search page lists many products, so nothing establishes it as the price of the machine the slug names - and this page therefore never presents it as one. There is a second, related caution: the site's robots.txt allows the product path and disallows the search path, so the URL you are permitted to fetch redirects onto one you are asked not to crawl. The example input recorded in our own service catalogue is that search URL. Submit real product URLs, read status first, and retry anything blocked.