- query
- The WB Mason URL you submitted, echoed back. Populated on all five of our rows, including the two the service rejected - which is what lets you match a result set against your input list.
- name
- The product title as the storefront states it, leading with a size. Populated, and it matches the page. Note that it disagrees with
sizes; see the note below. - item_number
- The supplier's catalogue number, with a letter prefix. Populated, and it appears on both the storefront page and the supplier's own page - so a row can be checked against either.
- description
- The product copy. Populated, but a single short sentence rather than a specification block. Useful as a label, thin as a description.
- categories
- A comma-separated list of the merchandising categories the item sits in. Populated with three on our row, ending in a generic one - so expect to filter rather than group on this directly.
- colors
- The stock colourways, comma-separated. Populated with eight two-tone combinations on our row. This is the item's available colours, not the imprint colours, which have their own column.
- sizes
- The size field. Populated - and this is the value that does not agree with the name. The number here is roughly double the one in the title, and we do not know which measurement it describes. See the note below and do not build on it unchecked.
- materials
- What the item is made of. Populated. The capitalisation is unusual, and we verified it is the page's own rather than something our exporter did to it - so normalise it if you are grouping.
- price_from
- A single price with a currency symbol. Populated - and it is the cheapest rung of the ladder in
pricing, the one that applies only at the largest quantity. It is a floor, not a starting price. - pricing
- The quantity ladder, as one string: quantity and unit price, separated by semicolons. Populated with five breaks on our row, the unit price falling at each step. This is the column that makes this service different from every other catalogue we run, and it needs splitting on two delimiters before it is usable.
- imprint_methods
- How the item can be decorated, comma-separated. Populated on our row with an undecorated option and a printed one.
- imprint_colors
- The decoration colours available, comma-separated. Populated with fifteen entries on our row, most of them a code and a name in one token - so splitting on the comma leaves you a second parse to do.
- imprint_sizes
- The printable areas, comma-separated. Populated with three on our row, in mixed notation - a diameter, a single-colour rectangle and a multi-colour one. Free text rather than numbers.
- full_color_process
- Empty on our row. One of only two columns that came back without a value. On an item that supports full-colour decoration this would presumably carry the terms; ours does not support it.
- personalization
- Empty on our row, with the same caveat. Read it as an absence of the option rather than as missing data - but that is an inference, and one row cannot settle it.
- sold_unimprinted
- Whether the item can be bought undecorated. Populated, and this is the one field in the whole file that arrives as a real boolean rather than a string. Do not write a loader that expects the word.
- production_time
- The lead time as free text, a range of business days on our row. Populated. A string, not a number - parse it if you need to sort on it.
- origin
- The country of manufacture, upper-case on our row. Populated.
- shipping_weight
- Populated, and the worst-formed field in the export. Instead of a weight it holds a stringified object, quoted in a style that is not valid JSON, containing two nested descriptions and a trailing unit word. A usable figure is inside it; getting it out means a regular expression rather than a parse.
- shipping_dimensions
- The carton dimensions as free text with inch marks. Populated on our row. Three numbers, but a string - and the spacing around the inch marks is irregular.
- image
- Populated with a relative path rather than an absolute URL. It needs a base prepended before it will resolve, which is not true of any other catalogue service we run.
- url
- Populated - and it is not a WB Mason address. It points at the supplier's own website, a different domain from the one you submitted. We confirmed the supplier is named on the storefront page, so this is deliberate rather than a mix-up. Do not assume this column links back to where you queried.
- status
- A per-row flag written by our exporter, not by WB Mason. Across our five runs it took two values:
ok on the real storefront URL and http 404 on the two placeholder submissions, which is what a fictional address returns. Read it first.