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

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

domains

N/A

ean

N/A

ean13

N/A

ean8

N/A

features

key
value

flavors

N/A

gtins

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
dateSeen
flavor
isSale
merchant
offer
returnPolicy
shipping
size
source
sourceURLs
warranty

reviews

date
dateSeen
didPurchase
doRecommend
numHelpful
rating
sourceURLs
text
title
userCity
username
userProvince

sdsURLs

N/A

secondaryCategories

N/A

sizes

N/A

skus

sourceURLs
value

sourceURLs

N/A

stockNum

N/A

upc

N/A

upca

N/A

upce

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_pricesFlat-CSV-example.csv

id,asins,brand,categories,colors,count,dateAdded,dateUpdated,descriptions,dimension,ean,features,flavors,imageURLs,isbn,keys,manufacturer,manufacturerNumber,merchants,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,quantities,reviews,sizes,skus,sourceURLs,upc,vin,websiteIDs,weight
"AVpfBXYtLJeJML430pLJ",,"Hansa","Toys & Hobbies,Stuffed Animals,Hansa",,,"2015-11-01T04:15:04Z","2015-11-01T04:15:04Z",,,,"[{""key"":""Year"",""value"":[""2004""]},{""key"":""Condition"",""value"":[""New""]}]",,"http://i.ebayimg.com/images/g/EBUAAOSwWnFWBHIe/s-l300.jpg",,"stuffedhansaowl9tallnewwithtag2004/231727014821",,,"[{""dateSeen"":[""2015-10-31T00:00:00Z""],""name"":""Modprims - Ebay.com""}]","Stuffed Hansa Owl 9" Tall New With Tag 2004",12.99,12.99,,,"New",,"USD","2015-11-01T04:15:04Z","2015-10-31T00:00:00Z",,"false",,"winning bid",,"USD 7.95",,,"http://www.ebay.com/itm/Stuffed-Hansa-Owl-9-tall-new-with-tag-2004-/231727014821?hash=item35f401a3a5:g:EBUAAOSwWnFWBHIe",,,,"9","[{""sourceURLs"":[""http://www.ebay.com/itm/Stuffed-Hansa-Owl-9-tall-new-with-tag-2004-/231727014821?hash=item35f401a3a5:g:EBUAAOSwWnFWBHIe""],""value"":""231727014821""}]","http://www.ebay.com/itm/Stuffed-Hansa-Owl-9-tall-new-with-tag-2004-/231727014821?hash=item35f401a3a5:g:EBUAAOSwWnFWBHIe",,,,
"AVpe8YoN1cnluZ0-aYn7","B00NW4LUMI",,"Kitchen & Bath Fixtures",,,"2015-08-22T00:20:16Z","2015-08-22T00:20:16Z",,,,"[{""key"":""Weight"",""value"":[""41 Grams""]},{""key"":""Item Package Quantity"",""value"":[""1""]}]",,"http://ecx.images-amazon.com/images/I/31kWQk9vqdL._SX300_QL70_.jpg,http://ecx.images-amazon.com/images/I/31kWQk9vqdL._SS40_.jpg",,"macdee114plasticdomeurinalwaste/b00nw4lumi","Macdee",,"[{""dateSeen"":[""2015-08-20T00:00:00Z""],""name"":""Esda Ltd""}]","Macdee 1 1/4" Plastic Dome Urinal Waste",1.81,1.81,,,"new",,"EUR","2015-08-22T00:20:16Z","2015-08-20T00:00:00Z",,"false","ESDA Ltd",,,"EUR 2.99",,,"http://www.amazon.co.uk/Macdee-Plastic-Dome-Urinal-waste/dp/B00NW4LUMI",,,,,,"http://www.amazon.co.uk/Macdee-Plastic-Dome-Urinal-waste/dp/B00NW4LUMI",,,,"41 g"
"AVpfFEWH1cnluZ0-dcuF",,"We R Memory Keepers","Party & Occasions,Crafts,Albums","Neon Yellow,Black,Greige,Coral,Neon Purple,Neon Pink",,"2016-02-19T21:15:05Z","2016-02-19T21:15:05Z",,"6.3 in x 5.6 in x 1.8 in","0633356601081","[{""key"":""Battery Type"",""value"":[""Does Not Contain a Battery""]},{""key"":""Primary Color"",""value"":[""Pink""]},{""key"":""Product in Inches (L x W x H)"",""value"":[""6.3 x 5.6 x 1.8""]},{""key"":""Model No."",""value"":[""WRI4X4-60108""]},{""key"":""Multi Pack Indicator"",""value"":[""No""]},{""key"":""Shipping Weight (in pounds)"",""value"":[""0.55""]},{""key"":""Walmart No."",""value"":[""555207494""]}]",,"http://i5.walmartimages.com/dfw/dce07b8c-66e6/k2-_f0329218-fda6-4af6-8c20-526bc8657c98.v1.jpg",,"wermemorykeepers/wri4x460108,633356601081,0633356601081","We R Memory Keepers","WRI4X4-60108","[{""dateSeen"":[""2016-02-19T21:15:05Z""],""name"":""Walmart.com""}]","We R Instagram Ring Album, 4" X 4"",8.54,8.54,,,"new",,"USD","2016-02-19T21:15:05Z","2016-02-18T00:00:00Z",,"false",,,,"FREE shipping on orders 50 +",,,"http://www.walmart.com/ip/We-R-Instagram-Ring-Album-4-X4-Coral/48555247",,,,,,"http://www.walmart.com/ip/We-R-Instagram-Ring-Album-4-X4-Coral/48555247","633356601081",,,"0.55 lbs"
"AVpe8YooLJeJML43y3CV","B008EBXNOC","Nabeel Perfume",,,,"2015-11-06T01:58:45Z","2016-07-21T06:09:13Z",,,,,,,,"nabeelperfume/touchme,bakhoortouchmeincense40gmbynabeelperfumes/b008ebxnoc",,"Touch Me",,"Bakhoor Touch Me Incense 40 Gm By Nabeel Perfumes",6.50,6.50,,,,,"USD","2015-11-06T01:58:45Z","2015-11-03T00:00:00Z",,"false",,,,"USD 2.20 shipping",,,"http://www.amazon.com/Bakhoor-Touch-Me-Nabeel-Perfumes/dp/B008EBXNOC",,,,,,"http://www.amazon.com/Bakhoor-Touch-Me-Nabeel-Perfumes/dp/B008EBXNOC",,,,
"AVpfBXYJ1cnluZ0-cKn3",,"Dell","Computers/Tablets & Networking,Keyboards, Mice & Pointing,Mice, Trackballs & Touchpads",,,"2015-10-19T11:57:16Z","2015-10-19T11:57:16Z",,,,"[{""key"":""Connectivity"",""value"":[""Wireless""]}]",,"http://i.ebayimg.com/images/g/GxsAAOSwWnFWCqXD/s-l300.jpg",,"newdellwirelessmousewm123/321885949955",,,"[{""dateSeen"":[""2015-10-14T00:00:00Z""],""name"":""Uffdaracing - Ebay.com""}]","New Dell Wireless Mouse Wm123",14.99,14.99,,,"New",,"USD","2015-10-19T11:57:16Z","2015-10-14T00:00:00Z",,"false",,"winning bid",,"USD 4.95",,,"http://www.ebay.com/itm/NEW-DELL-Wireless-Mouse-WM123-/321885949955?hash=item4af1e5d003",,,,,"[{""sourceURLs"":[""http://www.ebay.com/itm/NEW-DELL-Wireless-Mouse-WM123-/321885949955?hash=item4af1e5d003""],""value"":""321885949955""}]","http://www.ebay.com/itm/NEW-DELL-Wireless-Mouse-WM123-/321885949955?hash=item4af1e5d003",,,,
"AVpe8YozLJeJML43y3Cb",,,"Test Auctions,Seller Category 4,Everything Else",,,"2016-03-29T23:56:36Z","2016-04-20T03:00:43Z",,,,,,"http://i.ebayimg.com/images/g/F~0AAOSwrklU-o7o/s-l64.jpg,http://i.ebayimg.com/images/g/ZsMAAOSwBLlU-o7m/s-l300.jpg,http://i.ebayimg.com/images/g/ZsMAAOSwBLlU-o7m/s-l64.jpg",,"testlisting010notbuy/121933843062",,,"[{""dateSeen"":[""2016-04-19T00:00:00Z""],""name"":""Working.man - Ebay.com""}]","Test Listing #010 -- Do Not Buy",9.95,9.95,,,,,"USD","2016-03-29T23:56:36Z","2016-04-19T00:00:00Z",,"false",,,,"USD 3.00",,,"http://www.ebay.com/itm/TEST-LISTING-010-DO-NOT-BUY-/121933843062?hash=item1c63d2ca76:g:ZsMAAOSwBLlU-o7m",,,,,"[{""sourceURLs"":[""http://www.ebay.com/itm/TEST-LISTING-010-DO-NOT-BUY-/121933843062?hash=item1c63d2ca76:g:ZsMAAOSwBLlU-o7m""],""value"":""121933843062""}]","http://www.ebay.com/itm/TEST-LISTING-010-DO-NOT-BUY-/121933843062?hash=item1c63d2ca76:g:ZsMAAOSwBLlU-o7m",,,,
"AVpfBXYyilAPnD_xTNXz",,,"Appliances,Small Kitchen Appliances,Skillets & Woks,Skillets",,,"2015-10-17T03:47:41Z","2015-10-17T03:47:41Z",,,,,,"http://pisces.bbystatic.com/image2/BestBuy_US/images/mp/products/1309/1309712/1309712113/1309712113_500x500_sa.jpg;canvasHeight=105;canvasWidth=105",,"berndessignocastskillet85inch/1309712113",,"697220",,"Berndes - Signocast Skillet, 8.5-inch",49.09,49.09,,,"New",,"USD","2015-10-17T03:47:41Z","2015-10-15T00:00:00Z",,"false","Wayfair - Bestbuy.com",,,,,,"http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113",,,,,"[{""sourceURLs"":[""http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113""],""value"":""1309712113""}]","http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113",,,,
"AVpfBXYyilAPnD_xTNXz",,,"Appliances,Small Kitchen Appliances,Skillets & Woks,Skillets",,,"2015-10-17T03:47:41Z","2015-10-17T03:47:41Z",,,,,,"http://pisces.bbystatic.com/image2/BestBuy_US/images/mp/products/1309/1309712/1309712113/1309712113_500x500_sa.jpg;canvasHeight=105;canvasWidth=105",,"berndessignocastskillet85inch/1309712113",,"697220",,"Berndes - Signocast Skillet, 8.5-inch",50.08,50.08,,,"New",,"USD","2015-10-17T03:47:41Z","2015-09-08T00:00:00Z",,"false","Wayfair - Bestbuy.com",,,"Free Shipping",,,"http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113",,,,,"[{""sourceURLs"":[""http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113""],""value"":""1309712113""}]","http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113",,,,
"AVpfAw0ailAPnD_xS_mP",,,"Jewelry & Watches,Jewelry,Stainless Steel Jewelry,Rings,Stainless Steel Rings",,,"2015-09-21T13:31:22Z","2016-03-03T05:01:32Z",,,,"[{""key"":""Gender"",""value"":[""Female""]},{""key"":""Metal"",""value"":[""Stainless Steel""]},{""key"":""Gemstone Color"",""value"":[""Silver""]},{""key"":""Country of Origin"",""value"":[""China""]},{""key"":""Model Number"",""value"":[""WCJ-SS479""]},{""key"":""Band Width"",""value"":[""2-3 mm""]},{""key"":""Stone Shape"",""value"":[""Heart""]},{""key"":""Diamond Cut"",""value"":[""Heart""]},{""key"":""Ring Style"",""value"":[""Cocktail-Cluster, Fashion, Heart"",""Cocktail-Cluster Fashion Heart""]},{""key"":""Metal Color"",""value"":[""White""]},{""key"":""material"",""value"":[""Stainless Steel""]}]",,"http://ak1.ostkcdn.com/images/products/8323493/Stainless-Steel-Heart-Center-Ring-d38a4c47-691d-421b-952f-07caf7bb2e74_80.jpg",,"stainlesssteelheartcenterring/15637248",,,,"Stainless Steel Heart Center Ring",47.99,47.99,,,,,"USD","2015-09-21T13:31:22Z","2016-03-01T00:00:00Z",,"true","Overstock.com",,,,,,"http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848",,,,,"[{""sourceURLs"":[""http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848""],""value"":""15637248""}]","http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848,http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,
"AVpfAw0ailAPnD_xS_mP",,,"Jewelry & Watches,Jewelry,Stainless Steel Jewelry,Rings,Stainless Steel Rings",,,"2015-09-21T13:31:22Z","2016-03-03T05:01:32Z",,,,"[{""key"":""Gender"",""value"":[""Female""]},{""key"":""Metal"",""value"":[""Stainless Steel""]},{""key"":""Gemstone Color"",""value"":[""Silver""]},{""key"":""Country of Origin"",""value"":[""China""]},{""key"":""Model Number"",""value"":[""WCJ-SS479""]},{""key"":""Band Width"",""value"":[""2-3 mm""]},{""key"":""Stone Shape"",""value"":[""Heart""]},{""key"":""Diamond Cut"",""value"":[""Heart""]},{""key"":""Ring Style"",""value"":[""Cocktail-Cluster, Fashion, Heart"",""Cocktail-Cluster Fashion Heart""]},{""key"":""Metal Color"",""value"":[""White""]},{""key"":""material"",""value"":[""Stainless Steel""]}]",,"http://ak1.ostkcdn.com/images/products/8323493/Stainless-Steel-Heart-Center-Ring-d38a4c47-691d-421b-952f-07caf7bb2e74_80.jpg",,"stainlesssteelheartcenterring/15637248",,,,"Stainless Steel Heart Center Ring",15.12,15.12,,,,,"USD","2015-09-21T13:31:22Z","2016-03-01T00:00:00Z",,"false","Overstock.com",,,,,,"http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848",,,,,"[{""sourceURLs"":[""http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848""],""value"":""15637248""}]","http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848,http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,
"AVpfAw0ailAPnD_xS_mP",,,"Jewelry & Watches,Jewelry,Stainless Steel Jewelry,Rings,Stainless Steel Rings",,,"2015-09-21T13:31:22Z","2016-03-03T05:01:32Z",,,,"[{""key"":""Gender"",""value"":[""Female""]},{""key"":""Metal"",""value"":[""Stainless Steel""]},{""key"":""Gemstone Color"",""value"":[""Silver""]},{""key"":""Country of Origin"",""value"":[""China""]},{""key"":""Model Number"",""value"":[""WCJ-SS479""]},{""key"":""Band Width"",""value"":[""2-3 mm""]},{""key"":""Stone Shape"",""value"":[""Heart""]},{""key"":""Diamond Cut"",""value"":[""Heart""]},{""key"":""Ring Style"",""value"":[""Cocktail-Cluster, Fashion, Heart"",""Cocktail-Cluster Fashion Heart""]},{""key"":""Metal Color"",""value"":[""White""]},{""key"":""material"",""value"":[""Stainless Steel""]}]",,"http://ak1.ostkcdn.com/images/products/8323493/Stainless-Steel-Heart-Center-Ring-d38a4c47-691d-421b-952f-07caf7bb2e74_80.jpg",,"stainlesssteelheartcenterring/15637248",,,,"Stainless Steel Heart Center Ring",16.80,16.80,,,,,"USD","2015-09-21T13:31:22Z","2015-09-15T00:00:00Z",,"false","Overstock.com",,,,,,"http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,,"[{""sourceURLs"":[""http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848""],""value"":""15637248""}]","http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848,http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,
"AVpfAw0ailAPnD_xS_mP",,,"Jewelry & Watches,Jewelry,Stainless Steel Jewelry,Rings,Stainless Steel Rings",,,"2015-09-21T13:31:22Z","2016-03-03T05:01:32Z",,,,"[{""key"":""Gender"",""value"":[""Female""]},{""key"":""Metal"",""value"":[""Stainless Steel""]},{""key"":""Gemstone Color"",""value"":[""Silver""]},{""key"":""Country of Origin"",""value"":[""China""]},{""key"":""Model Number"",""value"":[""WCJ-SS479""]},{""key"":""Band Width"",""value"":[""2-3 mm""]},{""key"":""Stone Shape"",""value"":[""Heart""]},{""key"":""Diamond Cut"",""value"":[""Heart""]},{""key"":""Ring Style"",""value"":[""Cocktail-Cluster, Fashion, Heart"",""Cocktail-Cluster Fashion Heart""]},{""key"":""Metal Color"",""value"":[""White""]},{""key"":""material"",""value"":[""Stainless Steel""]}]",,"http://ak1.ostkcdn.com/images/products/8323493/Stainless-Steel-Heart-Center-Ring-d38a4c47-691d-421b-952f-07caf7bb2e74_80.jpg",,"stainlesssteelheartcenterring/15637248",,,,"Stainless Steel Heart Center Ring",55.99,55.99,,,,,"USD","2015-09-21T13:31:22Z","2015-09-15T00:00:00Z",,"true","Overstock.com",,,,,,"http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,,"[{""sourceURLs"":[""http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848""],""value"":""15637248""}]","http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848,http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,

Sample JSON Output

{
  "asins": [
    "B00NW4LUMI"
  ],
  "categories": [
    "Kitchen & Bath Fixtures"
  ],
  "dateAdded": "2015-08-22T00:20:16Z",
  "dateUpdated": "2015-08-22T00:20:16Z",
  "features": [
    {
      "key": "Weight",
      "value": [
        "41 Grams"
      ]
    },
    {
      "key": "Item Package Quantity",
      "value": [
        "1"
      ]
    }
  ],
  "imageURLs": [
    "http://ecx.images-amazon.com/images/I/31kWQk9vqdL._SX300_QL70_.jpg",
    "http://ecx.images-amazon.com/images/I/31kWQk9vqdL._SS40_.jpg"
  ],
  "keys": [
    "macdee114plasticdomeurinalwaste/b00nw4lumi"
  ],
  "manufacturer": "Macdee",
  "merchants": [
    {
      "dateSeen": [
        "2015-08-20T00:00:00Z"
      ],
      "name": "Esda Ltd"
    }
  ],
  "name": "Macdee 1 1/4\" Plastic Dome Urinal Waste",
  "prices": [
    {
      "amountMin": 1.81,
      "amountMax": 1.81,
      "condition": "new",
      "currency": "EUR",
      "dateAdded": "2015-08-22T00:20:16Z",
      "dateSeen": [
        "2015-08-20T00:00:00Z"
      ],
      "isSale": "false",
      "merchant": "ESDA Ltd",
      "shipping": "EUR 2.99",
      "sourceURLs": [
        "http://www.amazon.co.uk/Macdee-Plastic-Dome-Urinal-waste/dp/B00NW4LUMI"
      ]
    }
  ],
  "sourceURLs": [
    "http://www.amazon.co.uk/Macdee-Plastic-Dome-Urinal-waste/dp/B00NW4LUMI"
  ],
  "weight": "41 g",
  "id": "AVpe8YoN1cnluZ0-aYn7"
}