Available Views for Product Data

Default view

The default view will display all available fields in the Product Data Schema. This view will be used if you don't set the view.

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

FieldIncluded Sub-fields
asinsN/A
brandN/A
categoriesN/A
colorsN/A
countN/A
dateAddedN/A
dateUpdatedN/A
descriptionsdateSeen
sourceURLs
value
dimensionN/A
domainsN/A
eanN/A
ean13N/A
ean8N/A
featureskey
replace
value
financingAndLeasingadditionalDetails
apr
currency
dateSeen
description
disclaimers dueAtSigningMax dueAtSigningMin milesPerYear monthlyPaymentMax monthlyPaymentMin name offerStartDate offerEndDate term type securityDepositMax securityDepositMin sourceURLs`
flavorsN/A
gtinsN/A
imageURLsN/A
isbnN/A
keysN/A
manufacturerN/A
manufacturerNumberN/A
merchantsaddress
availability
city
country
dateSeen
name
phone
postalCode
province
nameN/A
pricesamountMin
amountMax
availability
color
condition
count
currency
dateSeen
flavor
isSale
merchant
offer
returnPolicy
shipping
size
sourceURLs
warranty
reviewsdate
dateSeen
didPurchase
doRecommend
numHelpful
rating
sourceURLs
text
title
userCity
username
userProvince
sdsURLsN/A
secondaryCategoriesN/A
sizesN/A
skussourceURLs
value
sourceURLsN/A
taxonomyN/A
taxonomyLevel1N/A
taxonomyLevel2N/A
taxonomyLevel3N/A
taxonomyLevel4N/A
taxonomyLevel5N/A
taxonomyLevel6N/A
taxonomyLevel7N/A
taxonomyLevel8N/A
taxonomyLevel9N/A
upcN/A
upcaN/A
upceN/A
vinN/A
websiteIDN/A
weightN/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"
}

product_all_nested

The product_all_nested view will display all available fields in the Product Data Schema. This view will be used if you don't set the view.

If using the csv format, it will group elements in multi-valued field lists into single cells.

Included Fields

FieldIncluded Sub-fields
asinsN/A
brandN/A
categoriesN/A
colorsN/A
countN/A
dateAddedN/A
dateUpdatedN/A
descriptionsdateSeen
sourceURLs
value
dimensionN/A
domainsN/A
eanN/A
ean13N/A
ean8N/A
featureskey
replace
value
flavorsN/A
gtinsN/A
imageURLsN/A
isbnN/A
keysN/A
manufacturerN/A
manufacturerNumberN/A
merchantsaddress
availability
city
country
dateSeen
name
phone
postalCode
province
nameN/A
pricesamountMin
amountMax
availability
color
condition
count
currency
dateSeen
flavor
isSale
merchant
offer
returnPolicy
shipping
size
source
sourceURLs
warranty
reviewsdate
dateSeen
didPurchase
doRecommend
numHelpful
rating
sourceURLs
text
title
userCity
username
userProvince
sdsURLsN/A
secondaryCategoriesN/A
sizesN/A
skussourceURLs
value
sourceURLsN/A
stockNumN/A
taxonomyN/A
taxonomyLevel1N/A
taxonomyLevel2N/A
taxonomyLevel3N/A
taxonomyLevel4N/A
taxonomyLevel5N/A
taxonomyLevel6N/A
taxonomyLevel7N/A
taxonomyLevel8N/A
taxonomyLevel9N/A
upcN/A
upcaN/A
upceN/A
vinN/A
websiteIDN/A
weightN/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"
}

product_flat_prices

The product_flat_prices view should be used when you want to look at individual prices for each product in your data set in a CSV format.

If using the CSV format, it will split each price for a product into its own row. All other fields will repeat in each row.

Included Fields

FieldIncluded Sub-fields
asinsN/A
brandN/A
categoriesN/A
colorsN/A
countN/A
dateAddedN/A
dateUpdatedN/A
descriptionsdateSeen
sourceURLs
value
dimensionN/A
domainsN/A
eanN/A
ean13N/A
ean8N/A
featureskey
value
flavorsN/A
gtinsN/A
imageURLsN/A
isbnN/A
keysN/A
manufacturerN/A
manufacturerNumberN/A
merchantsaddress
availability
city
country
dateSeen
name
phone
postalCode
province
nameN/A
pricesamountMin
amountMax
availability
color
condition
count
currency
dateSeen
flavor
isSale
merchant
offer
returnPolicy
shipping
size
source
sourceURLs
warranty
reviewsdate
dateSeen
didPurchase
doRecommend
numHelpful
rating
sourceURLs
text
title
userCity
username
userProvince
sdsURLsN/A
secondaryCategoriesN/A
sizesN/A
skussourceURLs
value
sourceURLsN/A
stockNumN/A
upcN/A
upcaN/A
upceN/A
vinN/A
websiteIDN/A
weightN/A

Sample CSV Output

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

product_flat_reviews

The product_flat_reviews view should be used when you want to look at individual reviews for each product in your data set in a CSV format. It will split each review for a product into its own row. All other fields will repeat in each row.

Included Fields

FieldIncluded Sub-fields
asinsN/A
brandN/A
categoriesN/A
colorsN/A
countN/A
dateAddedN/A
dateUpdatedN/A
descriptionsdateSeen
sourceURLs
value
dimensionN/A
domainsN/A
eanN/A
`ean13N/A
ean8N/A
featureskey
value
flavorsN/A
gtinsN/A
imageURLsN/A
isbnN/A
keysN/A
manufacturerN/A
manufacturerNumberN/A
merchantsaddress
availability
city
country
dateSeen
name
phone
postalCode
province
nameN/A
pricesamountMin
amountMax
availability
color
condition
count
currency
dateSeen
flavor
isSale
merchant
offer
returnPolicy
shipping
size
source
sourceURLs
warranty
reviewsdate
dateSeen
didPurchase
doRecommend
numHelpful
rating
sourceURLs
text
title
userCity
username
userProvince
sdsURLsN/A
secondaryCategoriesN/A
sizesN/A
skussourceURLs
value
sourceURLsN/A
stockNumN/A
upcN/A
upcaN/A
upceN/A
vinN/A
websiteIDN/A
weightN/A

Sample CSV Output

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