- query
- The Gemplers URL you submitted, echoed back. Populated on all three of our rows, including the two the service rejected - which is what lets you match a result set against your input list.
- sku_code
- The Gemplers item number. Populated, and identical to
sku on our row. The same number appears two dozen times in the live page's markup, so a row can be checked against the listing it came from. - product_url
- The canonical product page. Populated, and equal to both
query and url on our row, because we submitted a product page rather than a collection. - name
- The product title as the listing states it - maker, model and kit contents in one string. Populated, and it matches the page title on the live listing.
- description
- The product copy. Populated, and a real paragraph rather than a repeat of the name - a specification sentence with measurement ranges and features. That makes this one of the few catalogues in this family where
description is worth importing. - parsed_price
- The price as a bare number. Populated. This is the one to compute on, and on our row it is byte-identical to
price. - price
- The same figure - and here it arrives without a currency symbol, which is not true of every service on this schema. Read
currency rather than inferring the denomination from the string. - currency
- The currency the price is quoted in,
USD on our row and confirmed by the offer record on the live page. - availability
- The stock status. Populated on our row as an in-stock value, and the live page's structured data says the same. This column is not always present on supplier catalogues, so it is worth having here.
- rating
- Empty on our row. One of only two columns that came back without a value.
- reviews
- Empty on our row, with the same caveat as
rating. Plan around a supplier listing that carries specifications rather than consumer review furniture. - images
- The listing's images. Populated with a URL on the store's own image host. Our row carried a single image, so no string splitting was needed.
- brand
- The manufacturer, in its own column. Populated - and distinct from the retailer, which matters here because Gemplers carries third-party makers alongside its own line. This is the column our Uline page does not have.
- sku
- The item number again. Same value as
sku_code on our row. Use either; keep both if you are writing one importer across several of our catalogue services, where they sometimes differ. - url
- The address the row was produced from. Equal to
product_url on our row. - image
- The primary image on its own, so the common case needs no string splitting. Identical to
images on our row. - status
- A per-row flag written by our exporter, not by Gemplers. Across our three runs it took two values:
ok on the real product URL, and unsupported URL (use a /collections/ or /products/ URL) on the two placeholder submissions. Read it first - it is the column that tells you your input was the wrong shape.
Two practical notes and one piece of good news. The good news first: this is the fullest row we hold from any supplier catalogue on this schema. Fifteen of seventeen columns carried values, and a direct fetch of the same listing confirms every one of them - the page ships three structured-data blocks, one of which is a complete product record whose offer node states the same price, currency and stock status our export holds. Now the caveats. First, price arrives as a bare number here rather than a formatted string, so an importer that strips a currency symbol will strip nothing, and one that expects a symbol will not find it; read currency instead. Second, and easier to miss, the column order is not stable between exports. Our July run and our later runs list the same seventeen names in different sequences. Read by header name, never by position, or a Gemplers file will load cleanly into the wrong fields.