products_all

The products_all view will display all available fields in our product schema.

If using the csv format, it will split out elements in multi-valued field lists into separate rows. This means a single product will show up in multiple, contiguous rows while its categories, prices, etc fields will have one entry per row for each element in their lists.

Included Fields

Field	Included Sub-fields
`asins`	N/A
`brand`	N/A
`categories`	N/A
`colors`	N/A
`count`	N/A
`dateAdded`	N/A
`dateUpdated`	N/A
`descriptions`	`dateSeen` `sourceURLs` `value`
`dimension`	N/A
`ean`	N/A
`features`	`key` `value`
`flavors`	N/A
`imageURLs`	N/A
`isbn`	N/A
`keys`	N/A
`manufacturer`	N/A
`manufacturerNumber`	N/A
`merchants`	`address` `availability` `city` `country` `dateSeen` `name` `phone` `postalCode` `province`
`name`	N/A
`prices`	`amountMin` `amountMax` `availability` `color` `condition` `count` `currency` `dateAdded` `dateSeen` `flavor` `isSale` `merchant` `offer` `returnPolicy` `shipping` `size` `source` `sourceURLs` `warranty`
`reviews`	`date` `dateAdded` `dateSeen` `didPurchase` `doRecommend` `numHelpful` `rating` `sourceURLs` `text` `title` `userCity` `username` `userProvince`
`sizes`	N/A
`skus`	`sourceURLs` `value`
`sourceURLs`	N/A
`upc`	N/A
`vin`	N/A
`websiteID`	N/A
`weight`	N/A

Sample CSV Output

Right-click and choose "Save link as..." to download this sample so you can see it in Excel: products_all-CSV-example.csv

id,asins,brand,categories,colors,count,dateAdded,dateUpdated,descriptions.dateSeen,descriptions.sourceURLs,descriptions.value,dimension,ean,features.key,features.value,flavors,websiteID,imageURLs,isbn,keys,manufacturer,manufacturerNumber,merchants.address,merchants.availability,merchants.city,merchants.country,merchants.dateSeen,merchants.name,merchants.phone,merchants.postalCode,merchants.province,name,prices.amountMin,prices.amountMax,prices.availability,prices.color,prices.condition,prices.count,prices.currency,prices.dateAdded,prices.dateSeen,prices.flavor,prices.isSale,prices.merchant,prices.offer,prices.returnPolicy,prices.shipping,prices.size,prices.source,prices.sourceURLs,prices.warranty,reviews.date,reviews.dateAdded,reviews.dateSeen,reviews.didPurchase,reviews.doRecommend,reviews.numHelpful,reviews.rating,reviews.sourceURLs,reviews.text,reviews.title,reviews.userCity,reviews.username,reviews.userProvince,sizes,skus.sourceURLs,skus.value,sourceURLs,upc,vin,weight
"AVnjo8-lD1GB75FR6uL3",,,,,,"2015-08-17T18:43:00Z","2016-05-05T17:20:05Z",,,,,,,,,,,,,"sunville",,,,,,,,,,,"Brand New Women's Fashion Rubber Rain Boots / Bottes De Pluie",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"227 g"
"AVnjo8-lD1GB75FR6uL3","B00MKHSLP2",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,"Women",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,"Shoes",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,"Shoes & Handbags",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,"Boots",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Beige Plaid",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Fuchsia",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Black Polka Dots",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Black",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Houndstooth",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Navy Stripe",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Dk Green",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Leopard",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Camo",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Green",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Zebra",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Multi-Color Polka Dots",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,"Date first available at Amazon.ca","Jan. 15 2014",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/41-V0orNJkL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/31CXHHQarXL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/411huD5UrRL._SY395_QL70_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"https://images-na.ssl-images-amazon.com/images/I/51UcNOuZSUL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/411HlTw2geL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/41ge8ewa3TL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"https://images-na.ssl-images-amazon.com/images/I/51UcNOuZSUL._SY395_QL70_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/411huD5UrRL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/41%2BIJyHAy9L._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,"brandnewwomensfashionrubberrainbootsbottesdepluie/b00mkhslp2",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,"2016-04-29T00:00:00Z","Amazon.ca",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,26.950000762939453,26.950000762939453,,,"new",,"CAD","2015-08-17T18:43:00Z","2015-08-10T00:00:00Z",,,"Amazon.ca",,,"free",,,"http://www.amazon.ca/Brand-Womens-Rubber-Bottes-Dotted/dp/B00OMB8O7E",,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,4.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","These fit fine, made for people with skinny legs. My thicker legs/ muscular have a squishy time.","Four Stars",,"PLAINJANE",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,1.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","A cheap boot that lasted only a few weeks on our property. Mild use and these have already split the seems. Not recommended for anyone. Spend more money and get a good pair.","Cheaply made boot that doesnt last.",,"Brandon",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Excellent quality and very very cute rain boots. Very comfortable - come on rain!!!","Quality and comfort and cute too!",,"Bonnie Hallman",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,1.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Cracked within a few months where it bends for your toes. I've owned a couple of these. the same happened for both as well as the buckle breaking. I'm finally done with it. Will just spend a hit more for hunter boots.","Cracked within a few months.",,"Chiqui Mancini",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Nice boots. A bit loose for my girl friends skinny legs.","Five Stars",,"Etienne",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","very fashionable as well as comfortable","Five Stars",,"jahoody",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","These arrived very fast and are great.","Five Stars",,"Linda Findlay-Palmer",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,3.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Decent boots but one of the buckles broke a day after I received them.","Three Stars",,"Sheena Cormier",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Really like them! Great grips for working on the farm and tall enough too! Found their sizing a little bit smaller than I expected, but still fits good because it has a wide toe area. Now I can farm in style and with any color!","really like them",,"Marie",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Fits perfectly. Love the colour.","Love the colour",,"N.K.",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"https://www.amazon.ca/Brand-Womens-Rubber-Boots-Bottes/dp/B00OL26D4K",,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"http://www.amazon.ca/Brand-Womens-Rubber-Boots-Bottes/dp/B00OL26D4K",,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"http://www.amazon.ca/product-reviews/B00MKHSLP2",,,

Sample JSON Output

{
  "asins": [
    "B00MKHSLP2"
  ],
  "categories": [
    "Women",
    "Shoes",
    "Shoes & Handbags",
    "Boots"
  ],
  "colors": [
    "Beige Plaid",
    "Fuchsia",
    "Black Polka Dots",
    "Black",
    "Houndstooth",
    "Navy Stripe",
    "Dk Green",
    "Leopard",
    "Camo",
    "Green",
    "Zebra",
    "Multi-Color Polka Dots"
  ],
  "dateAdded": "2015-08-17T18:43:00Z",
  "dateUpdated": "2016-05-05T17:20:05Z",
  "features": [
    {
      "key": "Date first available at Amazon.ca",
      "value": [
        "Jan. 15 2014"
      ]
    }
  ],
  "imageURLs": [
    "http://ecx.images-amazon.com/images/I/41-V0orNJkL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/31CXHHQarXL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/411huD5UrRL._SY395_QL70_.jpg",
    "https://images-na.ssl-images-amazon.com/images/I/51UcNOuZSUL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/411HlTw2geL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/41ge8ewa3TL._US40_.jpg",
    "https://images-na.ssl-images-amazon.com/images/I/51UcNOuZSUL._SY395_QL70_.jpg",
    "http://ecx.images-amazon.com/images/I/411huD5UrRL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/41%2BIJyHAy9L._US40_.jpg"
  ],
  "keys": [
    "brandnewwomensfashionrubberrainbootsbottesdepluie/b00mkhslp2"
  ],
  "manufacturer": "sunville",
  "merchants": [
    {
      "dateSeen": [
        "2016-04-29T00:00:00Z"
      ],
      "name": "Amazon.ca"
    }
  ],
  "name": "Brand New Women's Fashion Rubber Rain Boots / Bottes De Pluie",
  "prices": [
    {
      "amountMin": 26.950000762939453,
      "amountMax": 26.950000762939453,
      "condition": "new",
      "currency": "CAD",
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-10T00:00:00Z"
      ],
      "merchant": "Amazon.ca",
      "shipping": "free",
      "sourceURLs": [
        "http://www.amazon.ca/Brand-Womens-Rubber-Bottes-Dotted/dp/B00OMB8O7E"
      ]
    }
  ],
  "reviews": [
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 4,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "These fit fine, made for people with skinny legs. My thicker legs/ muscular have a squishy time.",
      "title": "Four Stars",
      "username": "PLAINJANE"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 1,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "A cheap boot that lasted only a few weeks on our property. Mild use and these have already split the seems. Not recommended for anyone. Spend more money and get a good pair.",
      "title": "Cheaply made boot that doesnt last.",
      "username": "Brandon"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Excellent quality and very very cute rain boots. Very comfortable - come on rain!!!",
      "title": "Quality and comfort and cute too!",
      "username": "Bonnie Hallman"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 1,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Cracked within a few months where it bends for your toes. I've owned a couple of these. the same happened for both as well as the buckle breaking. I'm finally done with it. Will just spend a hit more for hunter boots.",
      "title": "Cracked within a few months.",
      "username": "Chiqui Mancini"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Nice boots. A bit loose for my girl friends skinny legs.",
      "title": "Five Stars",
      "username": "Etienne"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "very fashionable as well as comfortable",
      "title": "Five Stars",
      "username": "jahoody"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "These arrived very fast and are great.",
      "title": "Five Stars",
      "username": "Linda Findlay-Palmer"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 3,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Decent boots but one of the buckles broke a day after I received them.",
      "title": "Three Stars",
      "username": "Sheena Cormier"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Really like them! Great grips for working on the farm and tall enough too! Found their sizing a little bit smaller than I expected, but still fits good because it has a wide toe area. Now I can farm in style and with any color!",
      "title": "really like them",
      "username": "Marie"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Fits perfectly. Love the colour.",
      "title": "Love the colour",
      "username": "N.K."
    }
  ],
  "sourceURLs": [
    "https://www.amazon.ca/Brand-Womens-Rubber-Boots-Bottes/dp/B00OL26D4K",
    "http://www.amazon.ca/Brand-Womens-Rubber-Boots-Bottes/dp/B00OL26D4K",
    "http://www.amazon.ca/product-reviews/B00MKHSLP2"
  ],
  "weight": "227 g",
  "id": "AVnjo8-lD1GB75FR6uL3"
}

Was this page helpful?

Last updated 1 week ago

Built with Documentation.AI